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