public void LoadJoinOldPartialPaymentsFromDb(int stdId) { paymentCollect = new List <PaymentItem>(); partialCollect = new List <PartialPaymentItem>(); billCollect = new List <BillItem>(); paymentCollect.Clear(); partialCollect.Clear(); billCollect.Clear(); using (var db = Connection.CreateConnection()) { db.Open(); var sql = "dbo.spJoinPartialPaymentsOld"; var cmd = new SqlCommand(sql, db); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@StdId", stdId)); var reader = cmd.ExecuteReader(); if (!reader.HasRows) { return; } while (reader.Read()) { var item = new PaymentItem(); var item2 = new PartialPaymentItem(); var item3 = new BillItem(); 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(); item2.PartPay_Id = Int32.Parse(reader["PartPay_Id"].ToString()); item2.PartPay_Bill_Id = Int32.Parse(reader["PartPay_Bill_Id"].ToString()); item2.PartPay_Std_Id = Int32.Parse(reader["PartPay_Std_Id"].ToString()); item2.PartPay_Partition = reader["PartPay_Partition"].ToString(); item2.PartPay_Amount = Decimal.Parse(reader["PartPay_Amount"].ToString()); item2.PartPay_Balance = Decimal.Parse(reader["PartPay_Balance"].ToString()); item2.PartPay_DueDate = reader["PartPay_DueDate"].ToString(); item2.PartPay_DatePaid = reader["PartPay_DatePaid"].ToString(); item2.PartPay_PaymentMade = Decimal.Parse(reader["PartPay_PaymentMade"].ToString()); item2.PartPay_Status = reader["PartPay_Status"].ToString(); item2.PartPay_Deleted = reader["PartPay_Deleted"].ToString(); item3.Bill_Id = Int32.Parse(reader["Bill_Id"].ToString()); paymentCollect.Add(item); partialCollect.Add(item2); billCollect.Add(item3); } db.Close(); } }
public void UpdatePartialPayments(PartialPaymentItem partItem) { using (var db = Connection.CreateConnection()) { db.Open(); var sql = "dbo.spUpdatePartPay"; var cmd = new SqlCommand(sql, db); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Partition", partItem.PartPay_Partition)); cmd.Parameters.Add(new SqlParameter("@Amount", partItem.PartPay_Amount)); cmd.Parameters.Add(new SqlParameter("@Balance", partItem.PartPay_Balance)); cmd.Parameters.Add(new SqlParameter("@Paymade", partItem.PartPay_PaymentMade)); cmd.Parameters.Add(new SqlParameter("@DueDate", partItem.PartPay_DueDate)); cmd.Parameters.Add(new SqlParameter("@DatePaid", partItem.PartPay_DatePaid)); cmd.Parameters.Add(new SqlParameter("@Status", partItem.PartPay_Status)); cmd.Parameters.Add(new SqlParameter("@PartId", partItem.PartPay_Id)); cmd.ExecuteNonQuery(); db.Close(); } }