public static int Delete(bFaq objFaq, SqlConnection sqlConn, SqlTransaction sqlTran)
{
// construct new connection and command objects
SqlConnection conn = sqlConn;
SqlCommand cmd = DBHelper.getSprocCmd("sprocFaqDeleteByParams", conn);
cmd.Transaction = sqlTran;
SqlParameter param;
// add return value param
param = new SqlParameter("@RETURN_VALUE", SqlDbType.Int);
param.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(param);
// Add params
param = new SqlParameter("@FaqID", SqlDbType.Int);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_intFaqID;
cmd.Parameters.Add(param);
param = new SqlParameter("@UserID", SqlDbType.Int);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_intUserID;
cmd.Parameters.Add(param);
param = new SqlParameter("@Question", SqlDbType.NVarChar);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_strQuestion;
cmd.Parameters.Add(param);
param = new SqlParameter("@Answer", SqlDbType.NVarChar);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_strAnswer;
cmd.Parameters.Add(param);
param = new SqlParameter("@isActive", SqlDbType.Bit);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_bolisActive;
cmd.Parameters.Add(param);
param = new SqlParameter("@CreateDate", SqlDbType.DateTime);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_dtCreateDate;
cmd.Parameters.Add(param);
param = new SqlParameter("@ModifyDate", SqlDbType.DateTime);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_dtModifyDate;
cmd.Parameters.Add(param);
param = new SqlParameter("@ModifiedBy", SqlDbType.Int);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_intModifiedBy;
cmd.Parameters.Add(param);
// Execute command
cmd.ExecuteNonQuery();
// get return value
int retValue = 0;
try
{
// get return value of the sproc
retValue = (int)cmd.Parameters["@RETURN_VALUE"].Value;
}
catch (System.Exception)
{ // catch all possible exceptions
retValue = 0; // set retValue To 0 (all ok)
}
return(retValue);
}
public static int Insert(bFaq objFaq)
{
// construct new connection and command objects
SqlConnection conn = DBHelper.getConnection();
SqlCommand cmd = DBHelper.getSprocCmd("sprocFaqInsert", conn);
SqlParameter param;
// Add return value param
param = new SqlParameter("@RETURN_VALUE", SqlDbType.Int);
param.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(param);
// Add params
param = new SqlParameter("@FaqID", SqlDbType.Int);
param.Direction = ParameterDirection.Input;
cmd.Parameters.Add(param);
param = new SqlParameter("@UserID", SqlDbType.Int);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_intUserID;
cmd.Parameters.Add(param);
param = new SqlParameter("@Question", SqlDbType.NVarChar);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_strQuestion;
cmd.Parameters.Add(param);
param = new SqlParameter("@Answer", SqlDbType.NVarChar);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_strAnswer;
cmd.Parameters.Add(param);
param = new SqlParameter("@isActive", SqlDbType.Bit);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_bolisActive;
cmd.Parameters.Add(param);
param = new SqlParameter("@CreateDate", SqlDbType.DateTime);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_dtCreateDate;
cmd.Parameters.Add(param);
param = new SqlParameter("@ModifyDate", SqlDbType.DateTime);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_dtModifyDate;
cmd.Parameters.Add(param);
param = new SqlParameter("@ModifiedBy", SqlDbType.Int);
param.Direction = ParameterDirection.Input;
param.Value = objFaq.m_intModifiedBy;
cmd.Parameters.Add(param);
// open connection
conn.Open();
// Execute command
cmd.ExecuteNonQuery();
// get return value
int retValue = 0;
try
{
// get return value of the sproc
retValue = (int)cmd.Parameters["@RETURN_VALUE"].Value;
}
catch (System.Exception)
{ // catch all possible exceptions
retValue = 0; // set retValue To 0 (all ok)
}
// close connection
conn.Close();
// set dirty flag To false
if (retValue != 0)
{
objFaq.FaqID = retValue;
}
return(retValue);
}
