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); }