Gecko [ vsec.in ]

Name	Size	Permission
.mad-root	0 B	-rw-rw-rw-
BindCategories.cs	3.66 KB	-rw-rw-rw-
BindNews.cs	17.67 KB	-rw-rw-rw-
Class1.cs	2.74 KB	-rw-rw-rw-
DBManager_2.cs	5.21 KB	-rw-rw-rw-
DBmanager.cs	4.64 KB	-rw-rw-rw-
Dal_MediaType.cs	2.06 KB	-rw-rw-rw-
Dal_NewsSource.cs	3.04 KB	-rw-rw-rw-
Dal_PostNews.cs	17.14 KB	-rw-rw-rw-
Dal_Segment.cs	2.96 KB	-rw-rw-rw-
DataSetBill.xsd	15.47 KB	-rw-rw-rw-
DataSetBill.xss	859 B	-rw-rw-rw-
DataSetBill_Report.xsd	16.09 KB	-rw-rw-rw-
DataSetBill_Report.xss	859 B	-rw-rw-rw-
DataSetOnlyId.xsd	6.91 KB	-rw-rw-rw-
DataSetOnlyId.xss	854 B	-rw-rw-rw-
DataSetP_Pres.xsd	6.91 KB	-rw-rw-rw-
DataSetP_Pres.xss	3 B	-rw-rw-rw-
DataSetPatient.xsd	6.92 KB	-rw-rw-rw-
DataSetPatient.xss	3 B	-rw-rw-rw-
Emailsender.cs	1.15 KB	-rw-rw-rw-
GlobalClass.cs	495 B	-rw-rw-rw-
ManageSession.cs	1.24 KB	-rw-rw-rw-
PaymentData.cs	1.16 KB	-rw-rw-rw-
RishiMathod.cs	3.52 KB	-rw-rw-rw-
SMTPEmailSender.cs	1.56 KB	-rw-rw-rw-
ShowSlot.cs	413 B	-rw-rw-rw-
SmsSender.cs	1014 B	-rw-rw-rw-
Sql_Connection.cs	918 B	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
dbconnection.cs	1.19 KB	-rw-rw-rw-
pwnkit	10.99 KB	-rw-rw-rw-

Code Editor : Class1.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

/// <summary>
/// Summary description for Class1
/// </summary>
public class Class1
{
    public SqlConnection con = new SqlConnection();
    public SqlCommand cm = new SqlCommand();
    public SqlDataAdapter adp = new SqlDataAdapter();
    public DataSetPatient ds1 = new DataSetPatient();
    public DataSet ds = new DataSet();
    public DataSetOnlyId ds2 = new DataSetOnlyId();
    public DataSetBill ds3 = new DataSetBill();
    public DataSetP_Pres ds4 = new DataSetP_Pres();
    public DataSetBill_Report ds5 = new DataSetBill_Report();

public Class1()
    {
        con.ConnectionString = ConfigurationManager.ConnectionStrings["connection"].ConnectionString;
        con.Open();
        cm.Connection = con;
        //
        // TODO: Add constructor logic here
        //
    }
    public string autoid(string text, string table, string column)
    {

int n;
        cm.CommandText = "select max(Convert(int,substring(" + column + "," + Convert.ToInt32(text.Length + 1) + ",len(" + column + ")))) from " + table;
        if (cm.ExecuteScalar() == DBNull.Value)
        {
            n = 00001;
        }
        else
        {
            n = Convert.ToInt32(cm.ExecuteScalar());
            n = n + 1;
        }
        con.Close();
        return (text + n);
    }

public DataTable sp_select_prescription(System.Collections.ArrayList arr)
    {
        if (con.State != ConnectionState.Open)
        {
            con.Open();
        }
        cm = new SqlCommand("sp_select_prescription", con);
        cm.CommandType = CommandType.StoredProcedure;
        cm.Parameters.AddWithValue("@PatientID", arr[0].ToString());
        cm.Parameters.AddWithValue("@Mode", arr[1].ToString());
        adp = new SqlDataAdapter(cm);
        DataTable dt = new DataTable();
        adp.Fill(dt);
        con.Close();
        return dt;
    }

public bool sp_delete_prescription(System.Collections.ArrayList arr)
    {

if (con.State != ConnectionState.Open)
        {
            con.Open();
        }

try
        {

cm = new SqlCommand("sp_delete_prescription", con);
            cm.CommandType = CommandType.StoredProcedure;
            cm.Parameters.Add("@PatientID", arr[0].ToString());

cm.ExecuteNonQuery();

return true;
            //message("Data added Successfully")

}
        catch (Exception ex)
        {
            return false;
            //message(ex.Message)
        }
        finally
        {
            con.Close();
        }
    }
}

${this.title}

Code Editor : Class1.cs