public static dbo_RequisitionClearingClass Select_Record(String Clearing_No) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); dbo_RequisitionClearingClass clsdbo_RequisitionClearing = new dbo_RequisitionClearingClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "[RequisitionClearingSelect]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@Clearing_No", Clearing_No); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_RequisitionClearing.Clearing_No = reader["Clearing_No"] is DBNull ? null : reader["Clearing_No"].ToString(); clsdbo_RequisitionClearing.Requisition_No = reader["Requisition_No"] is DBNull ? null : reader["Requisition_No"].ToString(); clsdbo_RequisitionClearing.Clearing_Date = reader["Clearing_Date"] is DBNull ? null : (DateTime?)reader["Clearing_Date"]; clsdbo_RequisitionClearing.User_ID = reader["User_ID"] is DBNull ? null : reader["User_ID"].ToString(); } else { clsdbo_RequisitionClearing = null; } reader.Close(); } catch (SqlException ex) { logger.Error(ex.Message); return(clsdbo_RequisitionClearing); } finally { connection.Close(); } return(clsdbo_RequisitionClearing); }
public static bool Update(dbo_RequisitionClearingClass olddbo_RequisitionClearingClass, dbo_RequisitionClearingClass newdbo_RequisitionClearingClass) { SqlConnection connection = SAMDataClass.GetConnection(); string updateProcedure = "[dbo].[RequisitionClearingUpdate]"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (newdbo_RequisitionClearingClass.Clearing_No != null) { updateCommand.Parameters.AddWithValue("@NewClearing_No", newdbo_RequisitionClearingClass.Clearing_No); } else { updateCommand.Parameters.AddWithValue("@NewClearing_No", DBNull.Value); } if (newdbo_RequisitionClearingClass.Requisition_No != null) { updateCommand.Parameters.AddWithValue("@NewRequisition_No", newdbo_RequisitionClearingClass.Requisition_No); } else { updateCommand.Parameters.AddWithValue("@NewRequisition_No", DBNull.Value); } if (olddbo_RequisitionClearingClass.Clearing_No != null) { updateCommand.Parameters.AddWithValue("@OldClearing_No", olddbo_RequisitionClearingClass.Clearing_No); } else { updateCommand.Parameters.AddWithValue("@OldClearing_No", DBNull.Value); } if (olddbo_RequisitionClearingClass.Requisition_No != null) { updateCommand.Parameters.AddWithValue("@OldRequisition_No", olddbo_RequisitionClearingClass.Requisition_No); } else { updateCommand.Parameters.AddWithValue("@OldRequisition_No", DBNull.Value); } updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); updateCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }
public static bool Add(dbo_RequisitionClearingClass clsdbo_RequisitionClearing) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); SqlConnection connection = SAMDataClass.GetConnection(); string insertProcedure = "[RequisitionClearingInsert]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_RequisitionClearing.Clearing_No != null) { insertCommand.Parameters.AddWithValue("@Clearing_No", clsdbo_RequisitionClearing.Clearing_No); } else { insertCommand.Parameters.AddWithValue("@Clearing_No", DBNull.Value); } if (clsdbo_RequisitionClearing.Requisition_No != null) { insertCommand.Parameters.AddWithValue("@Requisition_No", clsdbo_RequisitionClearing.Requisition_No); } else { insertCommand.Parameters.AddWithValue("@Requisition_No", DBNull.Value); } if (clsdbo_RequisitionClearing.User_ID != null) { insertCommand.Parameters.AddWithValue("@User_ID", clsdbo_RequisitionClearing.User_ID); } else { insertCommand.Parameters.AddWithValue("@User_ID", DBNull.Value); } insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); insertCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }