public int ExecuteProcedure(string spName, SqlParameter[] param)
{
int count = 0;
objCmd = new SqlCommand(spName, OpenConnection());
objCmd.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter para in param)
{
objCmd.Parameters.Add(para);
}
try
{
count = objCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
CLS_ErrorLog objLog = new CLS_ErrorLog();
objLog.Write(ex);
}
finally
{
CloseConnection();
objCmd.Dispose();
}
return(count);
}
public SqlDataReader ExecuteReader(string sqlQuery)
{
SqlCommand objCmd = new SqlCommand();
string strData = string.Empty;
try
{
objCmd = new SqlCommand(sqlQuery, OpenConnection());
objCmd.CommandTimeout = 0;
}
catch (Exception ex)
{
CLS_ErrorLog objLog = new CLS_ErrorLog();
objLog.Write(ex);
}
return(objCmd.ExecuteReader(CommandBehavior.CloseConnection));
}
public DataSet GetData_DS(string sqlQuery)
{
objDS = new DataSet();
objDA = new SqlDataAdapter(sqlQuery, OpenConnection());
try
{
objDA.Fill(objDS);
}
catch (Exception ex)
{
CLS_ErrorLog objLog = new CLS_ErrorLog();
objLog.Write(ex);
}
finally
{
CloseConnection();
objDA.Dispose();
}
return(objDS);
}
public int ExecuteNonQuery(string sqlQuery)
{
int count = 0;
objCmd = new SqlCommand(sqlQuery, OpenConnection());
try
{
count = Convert.ToInt16(objCmd.ExecuteNonQuery());
}
catch (Exception ex)
{
CLS_ErrorLog objLog = new CLS_ErrorLog();
objLog.Write(ex);
}
finally
{
CloseConnection();
objCmd.Dispose();
}
return(count);
}
public string ExecuteScalar(string sqlQuery)
{
string strData = string.Empty;
SqlCommand objCmd = new SqlCommand();
try
{
objCmd = new SqlCommand(sqlQuery, OpenConnection());
objCmd.CommandTimeout = 0;
strData = Convert.ToString(objCmd.ExecuteScalar());
}
catch (Exception ex)
{
CLS_ErrorLog objLog = new CLS_ErrorLog();
objLog.Write(ex);
}
finally
{
objCmd.Dispose();
CloseConnection();
}
return(strData);
}
