//---Execute Parametered Stored Procedure new
public int Execute_Procedure(string vSPName, List <KeyValuePair <string, object> > pParams = null)
{
int strRecAffected = 0;
try
{
C_DACClass objC_DACClass = new C_DACClass();
objC_DACClass.Connection_String = c_ConnectionString;
SqlCommand SCmd = new SqlCommand();
SCmd.CommandType = CommandType.StoredProcedure;
SCmd.CommandText = vSPName;
if (pParams != null)
{
foreach (var parameter in pParams)
{
SCmd.Parameters.Add(new SqlParameter("@" + parameter.Key, parameter.Value));
}
}
strRecAffected = objC_DACClass.Exec_Int_SP(vSPName, SCmd);
strError_Message = Get_ErrorString(objC_DACClass.Error_Message);
}
catch (Exception ex)
{
strError_Message = Get_ErrorString(ex.Message);
}
finally
{
}
return(strRecAffected);
}
//---Fill DataSet By Stored Procedure New
public DataSet Read_DS_Procedure(string vSPName, List <KeyValuePair <string, object> > pParams = null)
{
DataSet ds_1 = new DataSet();
try
{
C_DACClass objC_DACClass = new C_DACClass();
objC_DACClass.Connection_String = c_ConnectionString;
SqlCommand SCmd = new SqlCommand();
SCmd.CommandType = CommandType.StoredProcedure;
SCmd.CommandText = vSPName;
if (pParams != null)
{
foreach (var parameter in pParams)
{
SCmd.Parameters.Add(new SqlParameter("@" + parameter.Key, parameter.Value));
}
}
ds_1 = objC_DACClass.Get_DS_SP(vSPName, SCmd);
strError_Message = Get_ErrorString(objC_DACClass.Error_Message);
}
catch (Exception ex)
{
strError_Message = Get_ErrorString(ex.Message);
}
finally
{
}
return(ds_1);
}
////---Execute Parametered Stored Procedure new
//public int Execute_Procedure(string vSPName, List<KeyValuePair<string, object>> pParams = null)
//{
// int strRecAffected = 0;
// try
// {
// C_DACClass objC_DACClass = new C_DACClass();
// objC_DACClass.Connection_String = c_ConnectionString;
// SqlCommand SCmd = new SqlCommand();
// SCmd.CommandType = CommandType.StoredProcedure;
// SCmd.CommandText = vSPName;
// if (pParams != null)
// {
// foreach (var parameter in pParams)
// {
// SCmd.Parameters.Add(new SqlParameter("@" + parameter.Key, parameter.Value));
// }
// }
// strRecAffected = objC_DACClass.Exec_Int_SP(vSPName, SCmd);
// strError_Message = Get_ErrorString(objC_DACClass.Error_Message);
// }
// catch (Exception ex)
// {
// strError_Message = Get_ErrorString(ex.Message);
// }
// finally
// {
// }
// return strRecAffected;
//}
//---Execute Parametered Stored Procedure with in BLL New
public int Execute_Procedure_Continue(string vSPName, SqlCommand SCmd, SqlConnection sqlCon, SqlTransaction Tran)
{
int strRecAffected = 0;
C_DACClass objC_DACClass = new C_DACClass();
objC_DACClass.Connection_String = c_ConnectionString;
strRecAffected = objC_DACClass.Exec_Int_Multi(vSPName, SCmd, sqlCon, Tran);
strError_Message = Get_ErrorString(objC_DACClass.Error_Message);
return(strRecAffected);
}
//---Fill DataSet By SQL Query
public DataSet Read_DS_Query(string vQuery)
{
DataSet SDataSet = new DataSet();
try
{
C_DACClass objC_DACClass = new C_DACClass();
objC_DACClass.Connection_String = c_ConnectionString;
SDataSet = objC_DACClass.Get_DS_Qry(vQuery);
strError_Message = Get_ErrorString(objC_DACClass.Error_Message);
}
catch (Exception ex)
{
strError_Message = Get_ErrorString(ex.Message);
}
finally
{
}
return(SDataSet);
}
//---Fill DataRow By SQL Query
public DataRow Read_Row_Query(string vQuery)
{
DataRow dr_1 = null;
try
{
C_DACClass objC_DACClass = new C_DACClass();
objC_DACClass.Connection_String = c_ConnectionString;
dr_1 = objC_DACClass.Get_DR_Qry(vQuery);
strError_Message = Get_ErrorString(objC_DACClass.Error_Message);
}
catch (Exception ex)
{
strError_Message = Get_ErrorString(ex.Message);
}
finally
{
}
return(dr_1);
}
//---Fill DataSet By Stored Procedure
public DataSet Read_DS_Procedure(string vSPName, SqlCommand SCmd)
{
DataSet ds_1 = new DataSet();
try
{
C_DACClass objC_DACClass = new C_DACClass();
objC_DACClass.Connection_String = c_ConnectionString;
ds_1 = objC_DACClass.Get_DS_SP(vSPName, SCmd);
strError_Message = Get_ErrorString(objC_DACClass.Error_Message);
}
catch (Exception ex)
{
strError_Message = Get_ErrorString(ex.Message);
}
finally
{
}
return(ds_1);
}
//---Execute Parametered Stored Procedure
public int Execute_Procedure(string vSPName, SqlCommand SCmd)
{
int strRecAffected = 0;
try
{
C_DACClass objC_DACClass = new C_DACClass();
objC_DACClass.Connection_String = c_ConnectionString;
strRecAffected = objC_DACClass.Exec_Int_SP(vSPName, SCmd);
strError_Message = Get_ErrorString(objC_DACClass.Error_Message);
}
catch (Exception ex)
{
strError_Message = Get_ErrorString(ex.Message);
}
finally
{
}
return(strRecAffected);
}
