public void UpdatePayment(PaymentItem payItem) { using (var db = Connection.CreateConnection()) { db.Open(); var sql = "dbo.spUpdatePayments"; var cmd = new SqlCommand(sql, db); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@PayNo", payItem.Payment_Number)); cmd.Parameters.Add(new SqlParameter("@Amount", payItem.Payment_Paid)); cmd.Parameters.Add(new SqlParameter("@DatePaid", payItem.Payment_DatePaid)); cmd.Parameters.Add(new SqlParameter("@PayId", payItem.Payment_Id)); cmd.ExecuteNonQuery(); db.Close(); } }
public void SavePayment(PaymentItem payItem) { using (var db = Connection.CreateConnection()) { db.Open(); var sql = "dbo.spInsertPayment"; var cmd = new SqlCommand(sql, db); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@PartId", payItem.Payment_PartPay_Id)); cmd.Parameters.Add(new SqlParameter("@BillId", payItem.Payment_Bill_Id)); cmd.Parameters.Add(new SqlParameter("@StdId", payItem.Payment_Std_Id)); cmd.Parameters.Add(new SqlParameter("@PayNum", payItem.Payment_Number)); cmd.Parameters.Add(new SqlParameter("@AmountPay", payItem.Payment_Paid)); cmd.Parameters.Add(new SqlParameter("@DatePaid", payItem.Payment_DatePaid)); cmd.Parameters.Add(new SqlParameter("@IsOld", payItem.Payment_IsOld)); cmd.Parameters.Add(new SqlParameter("@Deleted", payItem.Payment_Deleted)); cmd.ExecuteNonQuery(); db.Close(); } }
public void LoadPaymentsWithPartialIdFromDb(int partId) { paymentCollect = new List <PaymentItem>(); paymentCollect.Clear(); using (var db = Connection.CreateConnection()) { db.Open(); var sql = "dbo.spLoadPaymentsWithPartId"; var cmd = new SqlCommand(sql, db); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@PartId", partId)); var reader = cmd.ExecuteReader(); if (!reader.HasRows) { return; } while (reader.Read()) { var item = new PaymentItem(); item.Payment_Id = Int32.Parse(reader["Payment_Id"].ToString()); item.Payment_PartPay_Id = Int32.Parse(reader["Payment_PartPay_Id"].ToString()); item.Payment_Bill_Id = Int32.Parse(reader["Payment_Bill_Id"].ToString()); item.Payment_Std_Id = Int32.Parse(reader["Payment_Std_Id"].ToString()); item.Payment_Number = Int32.Parse(reader["Payment_Number"].ToString()); item.Payment_Paid = Decimal.Parse(reader["Payment_Paid"].ToString()); item.Payment_DatePaid = reader["Payment_DatePaid"].ToString(); item.Payment_Deleted = reader["Payment_Deleted"].ToString(); paymentCollect.Add(item); } db.Close(); } }