public string ExecuteNonQuery(SqlConnection dbCon, string Query)
{
string str;
clsUtil _clsUtil = new clsUtil();
if (dbCon.State != ConnectionState.Open)
{
str = "FAIL::Connection Not Opened";
}
else
{
SqlCommand sqlCommand = new SqlCommand(Query, dbCon);
try
{
sqlCommand.ExecuteNonQuery();
_clsUtil.writeLog(string.Concat("DB SUCCESS : ", Query));
str = "SUCCESS";
}
catch (Exception exception1)
{
Exception exception = exception1;
_clsUtil.writeLog(string.Concat("DBEXECN ERR : ", Query));
str = string.Concat("FAIL::", exception.ToString());
}
}
return(str);
}
public DataSet ExecuteDSQuery(SqlConnection dbCon, string Query)
{
DataSet dataSet;
DataSet dataSet1 = new DataSet();
clsUtil _clsUtil = new clsUtil();
if (dbCon.State != ConnectionState.Open)
{
_clsUtil.writeLog("Connection FAIL");
dataSet = new DataSet();
}
else
{
try
{
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter()
{
SelectCommand = new SqlCommand(Query, dbCon)
};
sqlDataAdapter.Fill(dataSet1);
_clsUtil.writeLog(string.Concat("DB SUCCESS : ", Query));
dataSet = dataSet1;
}
catch (Exception exception1)
{
Exception exception = exception1;
_clsUtil.writeLog(string.Concat("DBEXEC ERR : ", Query));
_clsUtil.writeLog(string.Concat("DBEXEC ERR : ", exception.ToString()));
dataSet = new DataSet();
}
}
return(dataSet);
}
public DataSet ExecuteDSQuery(SqlConnection dbCon, SqlTransaction tran, string Query)
{
DataSet dataSet;
DataSet dataSet1 = new DataSet();
clsUtil _clsUtil = new clsUtil();
if (dbCon.State != ConnectionState.Open)
{
_clsUtil.writeLog("Connection FAIL");
dataSet = new DataSet();
}
else
{
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter()
{
SelectCommand = new SqlCommand(Query, dbCon, tran)
};
sqlDataAdapter.Fill(dataSet1);
_clsUtil.writeLog(string.Concat("DB SUCCESS : ", Query));
dataSet = dataSet1;
}
return(dataSet);
}
public string ExecuteNonQuery(SqlConnection dbCon, SqlTransaction tran, string Query)
{
string str;
clsUtil _clsUtil = new clsUtil();
if (dbCon.State != ConnectionState.Open)
{
str = "FAIL::Connection Not Opened";
}
else
{
(new SqlCommand(Query, dbCon, tran)).ExecuteNonQuery();
_clsUtil.writeLog(string.Concat("DB SUCCESS : ", Query));
str = "SUCCESS";
}
return(str);
}
