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 : DBmanager.cs

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

/// <summary>
/// Summary description for DBmanager
/// </summary>
public class DBmanager
{
    SqlConnection con;
    public SqlCommand cmd;
    SqlDataAdapter da;
    DataTable dt;
    public string MyCmdText { get; set; }
    public SqlCommand sp_cmd { get; set; }
    public DBmanager()
    {
        con = new SqlConnection(ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString);
        cmd = new SqlCommand();
        da = new SqlDataAdapter(); 
         dt = new DataTable();
        sp_cmd = new SqlCommand();
        cmd.Connection = con;
        sp_cmd.Connection = con;
    }

public void OpenDB()
    {
        if (con.State == ConnectionState.Closed)
            con.Open();
    }
    public void CloseDB()
    {
        if (con.State == ConnectionState.Open)
            con.Close();
    }
    public bool ExecuteStoredProcedure()
    {
        try
        {
            sp_cmd.CommandType = CommandType.StoredProcedure;
            OpenDB();
            sp_cmd.ExecuteNonQuery();
            CloseDB();
            sp_cmd.Dispose();
            return true;
        }
        catch (Exception)
        {
            return false;
        }
    }

public DataTable ReadDataFromStoredProc()
    {
        try
        {
            sp_cmd.CommandType = CommandType.StoredProcedure;
            OpenDB();

DataTable dt = new DataTable();
            dt.Load(sp_cmd.ExecuteReader());

CloseDB();
            sp_cmd.Dispose();
            return dt;
        }
        catch (Exception ex)
        {
            DataTable dtNew = new DataTable();
            dtNew.Columns.Add("Error");
            DataRow dr = dtNew.NewRow();
            dr["Error"] = ex.Message.ToString();
            dtNew.Rows.Add(dr);
            return dtNew;
        }
    }

public DataSet ReadDataSetFromStoredProc()
    {
        try
        {
            sp_cmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter da = new SqlDataAdapter(sp_cmd);

OpenDB();

DataSet ds = new DataSet();
            da.Fill(ds);

CloseDB();
            sp_cmd.Dispose();
            return ds;
        }
        catch (Exception ex)
        {
            DataTable dtNew = new DataTable();
            dtNew.Columns.Add("Error");
            DataRow dr = dtNew.NewRow();
            dr["Error"] = ex.Message.ToString();
            dt.Rows.Add(dr);
            DataSet ds = new DataSet();
            ds.Tables.Add(dtNew);
            return ds;
        }
    }

public bool ExecuteInsertUpdateOrDelete()
    {
        try
        {
            cmd.CommandText = MyCmdText;
            OpenDB();

int n = cmd.ExecuteNonQuery();
            CloseDB();
            cmd.Dispose();
            return n > 0 ? true : false;
        }
        catch (Exception ex)
        {           
           return false;
        }

}

public object ReadSingleValue()
    {
        try
        {
            cmd.CommandText = MyCmdText;
            OpenDB();

object ob = cmd.ExecuteScalar();
            CloseDB();
            cmd.Dispose();
            return ob;
        }
        catch (Exception ex)
        {
            return ex.Message;
        }
    }

public DataTable ReadBulkRecord()
    {
        try
        {
            dt = new DataTable();
            cmd.CommandText = MyCmdText;
            da.SelectCommand = cmd;
            da.Fill(dt);

cmd.Dispose();
            da.Dispose();

return dt;
        }
        catch (Exception ex)
        {
            DataTable dtNew = new DataTable();
            dtNew.Columns.Add("Error");
            DataRow dr = dtNew.NewRow();
            dr["Error"] = ex.Message.ToString();
            dtNew.Rows.Add(dr);
            return dtNew;
        }
    }

public DataTable ExecuteSelect(string Query)
    {
        try
        {
            cmd.CommandText = Query;
            dt = new DataTable();
            da.SelectCommand = cmd;
            da.Fill(dt);
            return dt;
        }
        catch (Exception ex)
        {
            DataTable dtNew = new DataTable();
            dtNew.Columns.Add("Error");
            DataRow dr = dtNew.NewRow();
            dr["Error"] = ex.Message.ToString();
            dtNew.Rows.Add(dr);
            return dtNew;
        }
    }
 }

${this.title}

Code Editor : DBmanager.cs