public static dbo_CreditPaymentClass Select_Record(String Payment_No) { dbo_CreditPaymentClass clsdbo_CreditPayment = new dbo_CreditPaymentClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "[CreditPaymentSelect]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@Payment_No", Payment_No); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_CreditPayment.Payment_No = reader["Payment_No"] is DBNull ? null : reader["Payment_No"].ToString(); clsdbo_CreditPayment.Credit_ID = reader["Credit_ID"] is DBNull ? null : reader["Credit_ID"].ToString(); clsdbo_CreditPayment.Payment_Date = reader["Payment_Date"] is DBNull ? null : (DateTime?)reader["Payment_Date"]; clsdbo_CreditPayment.Payment_Amount = reader["Payment_Amount"] is DBNull ? null : (Decimal?)reader["Payment_Amount"]; clsdbo_CreditPayment.Payment_Method = reader["Payment_Method"] is DBNull ? null : reader["Payment_Method"].ToString(); clsdbo_CreditPayment.Bank = reader["Bank"] is DBNull ? null : reader["Bank"].ToString(); clsdbo_CreditPayment.Cheque_No = reader["Cheque_No"] is DBNull ? null : reader["Cheque_No"].ToString(); clsdbo_CreditPayment.Date = reader["Date"] is DBNull ? null : (DateTime?)reader["Date"]; clsdbo_CreditPayment.Clearing_Cheque = reader["Clearing_Cheque"] is DBNull ? null : (Boolean?)reader["Clearing_Cheque"]; } else { clsdbo_CreditPayment = null; } reader.Close(); } catch (SqlException ex) { logger.Error(ex.Message); return(clsdbo_CreditPayment); } finally { connection.Close(); } return(clsdbo_CreditPayment); }
public static bool Update(dbo_CreditPaymentClass newdbo_CreditPaymentClass) { SqlConnection connection = SAMDataClass.GetConnection(); string updateProcedure = "[CreditPaymentUpdate]"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (newdbo_CreditPaymentClass.Payment_No != null) { updateCommand.Parameters.AddWithValue("@NewPayment_No", newdbo_CreditPaymentClass.Payment_No); } else { updateCommand.Parameters.AddWithValue("@NewPayment_No", DBNull.Value); } if (newdbo_CreditPaymentClass.Credit_ID != null) { updateCommand.Parameters.AddWithValue("@NewCredit_ID", newdbo_CreditPaymentClass.Credit_ID); } else { updateCommand.Parameters.AddWithValue("@NewCredit_ID", DBNull.Value); } if (newdbo_CreditPaymentClass.Payment_Date.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewPayment_Date", newdbo_CreditPaymentClass.Payment_Date); } else { updateCommand.Parameters.AddWithValue("@NewPayment_Date", DBNull.Value); } if (newdbo_CreditPaymentClass.Payment_Amount.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewPayment_Amount", newdbo_CreditPaymentClass.Payment_Amount); } else { updateCommand.Parameters.AddWithValue("@NewPayment_Amount", DBNull.Value); } if (newdbo_CreditPaymentClass.Payment_Method != null) { updateCommand.Parameters.AddWithValue("@NewPayment_Method", newdbo_CreditPaymentClass.Payment_Method); } else { updateCommand.Parameters.AddWithValue("@NewPayment_Method", DBNull.Value); } if (newdbo_CreditPaymentClass.Bank != null) { updateCommand.Parameters.AddWithValue("@NewBank", newdbo_CreditPaymentClass.Bank); } else { updateCommand.Parameters.AddWithValue("@NewBank", DBNull.Value); } if (newdbo_CreditPaymentClass.Cheque_No != null) { updateCommand.Parameters.AddWithValue("@NewCheque_No", newdbo_CreditPaymentClass.Cheque_No); } else { updateCommand.Parameters.AddWithValue("@NewCheque_No", DBNull.Value); } if (newdbo_CreditPaymentClass.Date.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewDate", newdbo_CreditPaymentClass.Date); } else { updateCommand.Parameters.AddWithValue("@NewDate", DBNull.Value); } if (newdbo_CreditPaymentClass.Clearing_Cheque.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewClearing_Cheque", newdbo_CreditPaymentClass.Clearing_Cheque); } else { updateCommand.Parameters.AddWithValue("@NewClearing_Cheque", DBNull.Value); } if (newdbo_CreditPaymentClass.Last_Modified_Date.HasValue == true) { updateCommand.Parameters.AddWithValue("@Last_Modified_Date", newdbo_CreditPaymentClass.Last_Modified_Date); } else { updateCommand.Parameters.AddWithValue("@Last_Modified_Date", 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_CreditPaymentClass clsdbo_CreditPayment) { SqlConnection connection = SAMDataClass.GetConnection(); string insertProcedure = "[CreditPaymentInsert]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_CreditPayment.Payment_No != null) { insertCommand.Parameters.AddWithValue("@Payment_No", clsdbo_CreditPayment.Payment_No); } else { insertCommand.Parameters.AddWithValue("@Payment_No", DBNull.Value); } if (clsdbo_CreditPayment.Credit_ID != null) { insertCommand.Parameters.AddWithValue("@Credit_ID", clsdbo_CreditPayment.Credit_ID); } else { insertCommand.Parameters.AddWithValue("@Credit_ID", DBNull.Value); } if (clsdbo_CreditPayment.Payment_Date.HasValue == true) { insertCommand.Parameters.AddWithValue("@Payment_Date", clsdbo_CreditPayment.Payment_Date); } else { insertCommand.Parameters.AddWithValue("@Payment_Date", DBNull.Value); } if (clsdbo_CreditPayment.Payment_Amount.HasValue == true) { insertCommand.Parameters.AddWithValue("@Payment_Amount", clsdbo_CreditPayment.Payment_Amount); } else { insertCommand.Parameters.AddWithValue("@Payment_Amount", DBNull.Value); } if (clsdbo_CreditPayment.Payment_Method != null) { insertCommand.Parameters.AddWithValue("@Payment_Method", clsdbo_CreditPayment.Payment_Method); } else { insertCommand.Parameters.AddWithValue("@Payment_Method", DBNull.Value); } if (clsdbo_CreditPayment.Bank != null) { insertCommand.Parameters.AddWithValue("@Bank", clsdbo_CreditPayment.Bank); } else { insertCommand.Parameters.AddWithValue("@Bank", DBNull.Value); } if (clsdbo_CreditPayment.Cheque_No != null) { insertCommand.Parameters.AddWithValue("@Cheque_No", clsdbo_CreditPayment.Cheque_No); } else { insertCommand.Parameters.AddWithValue("@Cheque_No", DBNull.Value); } if (clsdbo_CreditPayment.Date.HasValue == true) { insertCommand.Parameters.AddWithValue("@Date", clsdbo_CreditPayment.Date); } else { insertCommand.Parameters.AddWithValue("@Date", DBNull.Value); } if (clsdbo_CreditPayment.Clearing_Cheque.HasValue == true) { insertCommand.Parameters.AddWithValue("@Clearing_Cheque", clsdbo_CreditPayment.Clearing_Cheque); } else { insertCommand.Parameters.AddWithValue("@Clearing_Cheque", DBNull.Value); } if (clsdbo_CreditPayment.Clearing_No != null) { insertCommand.Parameters.AddWithValue("@Clearing_No", clsdbo_CreditPayment.Clearing_No); } else { insertCommand.Parameters.AddWithValue("@Clearing_No", 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(); } }