public ManagePaymentTran(int primarykey)
{
InitializeComponent();
pt = context.PaymentTrans.Where(x => x.PaymentID == primarykey).ToList().First();
textBox1.Text = pt.TransactionID.ToString();
textBox2.Text = pt.Fee.ToString();
if (pt.Remarks != null)
{
textBox8.Text = pt.Remarks;
}
}
private void ReturnBtn_Click(object sender, EventArgs e)
{
//if(false)
if (TodateTimePicker.Value < ActualdateTimePicker1.Value)
{
PaymentTran pt = new PaymentTran();
if (context.PaymentTrans.Count(x => x.TransactionID == it.TransactionID) == 0)
{
pt.TransactionID = it.TransactionID;
pt.Fee = CaculateFee(TodateTimePicker.Value, ActualdateTimePicker1.Value);
pt.IsPaid = "False";
context.PaymentTrans.Add(pt);
context.SaveChanges();
}
else
{
pt = context.PaymentTrans.Where(x => x.TransactionID == it.TransactionID).ToList().First();
}
DialogResult result = MessageBox.Show("Overdue! You must pay the Fee first. \n the Fee is " + pt.Fee, " Warning", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
pt.IsPaid = "True";
context.SaveChanges();
it.DateActualReturn = ActualdateTimePicker1.Value.Date;
it.RentailStatus = "IN";
it.IsLate = "True";
Book book = context.Books.Where(x => x.BookCode == it.BookCode).ToList().First();
book.NumberAvaliable += 1;
book.NumberRented -= 1;
context.SaveChanges();
MessageBox.Show("Success!");
this.Close();
}
}
else
{
it.DateActualReturn = ActualdateTimePicker1.Value.Date;
it.RentailStatus = "IN";
it.IsLate = "False";
Book book = context.Books.Where(x => x.BookCode == it.BookCode).ToList().First();
book.NumberAvaliable += 1;
book.NumberRented -= 1;
context.SaveChanges();
MessageBox.Show("Success!");
this.Close();
}
}
private void Delete_Click(object sender, EventArgs e)
{
int primarykey;
if (dataGridView.Rows.Count > 0)
{
if (Int32.TryParse(dataGridView.CurrentRow.Cells[0].Value.ToString(), out primarykey))
{
switch (clickedBtn)
{
case ButtonClicked.BookList:
{
Book item = context.Books.Where(x => x.BookCode == primarykey).ToList().First();
if (ConfirmDelete())
{
context.Books.Remove(item);
context.SaveChanges();
MessageBox.Show("Delete success!");
}
break;
}
case ButtonClicked.CustomerList:
{
Customer item = context.Customers.Where(x => x.CustomerID == primarykey).ToList().First();
if (ConfirmDelete())
{
context.Customers.Remove(item);
context.SaveChanges();
MessageBox.Show("Delete success!");
}
break;
}
case ButtonClicked.Extention:
{
ExtendApplication item = context.ExtendApplications.Where(x => x.ApplicationID == primarykey).ToList().First();
if (ConfirmDelete())
{
context.ExtendApplications.Remove(item);
context.SaveChanges();
MessageBox.Show("Delete success!");
}
break;
}
case ButtonClicked.IssueTran:
{
IssueTran item = context.IssueTrans.Where(x => x.TransactionID == primarykey).ToList().First();
if (ConfirmDelete())
{
context.IssueTrans.Remove(item);
context.SaveChanges();
MessageBox.Show("Delete success!");
}
break;
}
case ButtonClicked.PaymentTran:
{
PaymentTran item = context.PaymentTrans.Where(x => x.PaymentID == primarykey).ToList().First();
if (ConfirmDelete())
{
context.PaymentTrans.Remove(item);
context.SaveChanges();
MessageBox.Show("Delete success!");
}
break;
}
case ButtonClicked.AuthorList:
{
Author item = context.Authors.Where(x => x.AuthorID == primarykey).ToList().First();
if (ConfirmDelete())
{
context.Authors.Remove(item);
context.SaveChanges();
MessageBox.Show("Delete success!");
}
break;
}
case ButtonClicked.PublisherList:
{
Publisher item = context.Publishers.Where(x => x.PublisherID == primarykey).ToList().First();
if (ConfirmDelete())
{
context.Publishers.Remove(item);
context.SaveChanges();
MessageBox.Show("Delete success!");
}
break;
}
case ButtonClicked.CountryList:
{
Country item = context.Countries.Where(x => x.CountryCode == primarykey).ToList().First();
if (ConfirmDelete())
{
context.Countries.Remove(item);
context.SaveChanges();
MessageBox.Show("Delete success!");
}
break;
}
}
}
}
else
{
MessageBox.Show("No data in the table");
}
}
public ManagePaymentTran()
{
InitializeComponent();
pt = new PaymentTran();
IsAddNew = true;
}
