using System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Web;
using
System.Data;
using
System.Data.SqlClient;
using
System.Configuration;
using
System.Collections;
using
System.IO;
using
System.Web.UI.WebControls;
using
System.Web.UI;
///
///
Summary description for Dal
///
public class Dal
{
string ConnectionString = string.Empty;
static SqlConnection
con;
public Dal()
{
ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
con = new SqlConnection(ConnectionString);
}
public void
SetConnection()
{
if (ConnectionString == string.Empty)
{
ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
}
con = new SqlConnection(ConnectionString);
}
public DataSet
ExecuteProcudere(string procName, Hashtable parms)
{
DataSet ds = new
DataSet();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
cmd.CommandText = procName;
cmd.CommandType = CommandType.StoredProcedure;
if (con == null)
{
SetConnection();
}
cmd.Connection = con;
if (parms.Count > 0)
{
foreach
(DictionaryEntry de in
parms)
{
cmd.Parameters.AddWithValue(de.Key.ToString(), de.Value);
}
}
da.SelectCommand = cmd;
da.Fill(ds);
return ds;
}
public int
ExecuteQuery(string procName, Hashtable parms)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = procName;
if (parms.Count > 0)
{
foreach
(DictionaryEntry de in
parms)
{
cmd.Parameters.AddWithValue(de.Key.ToString(), de.Value);
}
}
if (con == null)
{
SetConnection();
}
cmd.Connection = con;
if (con.State == ConnectionState.Closed)
con.Open();
int result = cmd.ExecuteNonQuery();
return result;
}
public int
ExecuteQuerywithOutputparams(SqlCommand cmd)
{
if (con == null)
{
SetConnection();
}
cmd.Connection = con;
if (con.State == ConnectionState.Closed)
con.Open();
int result = cmd.ExecuteNonQuery();
return result;
}
public int
ExecuteQueryWithOutParam(string procName, Hashtable parms)
{
SqlCommand cmd = new SqlCommand();
SqlParameter sqlparam = new SqlParameter();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = procName;
if
(parms.Count > 0)
{
foreach
(DictionaryEntry de in
parms)
{
if
(de.Key.ToString().Contains("_out"))
{
sqlparam = new SqlParameter(de.Key.ToString(),
de.Value);
sqlparam.DbType = DbType.Int32;
sqlparam.Direction = ParameterDirection.Output;
cmd.Parameters.Add(sqlparam);
}
else
{
cmd.Parameters.AddWithValue(de.Key.ToString(),
de.Value);
}
}
}
if (con == null)
{
SetConnection();
}
cmd.Connection = con;
if (con.State == ConnectionState.Closed)
con.Open();
int result = cmd.ExecuteNonQuery();
if (sqlparam != null)
result = Convert.ToInt32(sqlparam.SqlValue.ToString());
return result;
}
}
0 comments:
Post a Comment