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