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_2.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.IO;

public class DBManager
{

SqlConnection con;
        public SqlCommand cmd;
        SqlDataAdapter da;
        DataTable dt;
        public string MyCmdText { get; set; }
        public SqlCommand sp_cmd { get; set; }
        public void 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_2.cs