private void btnUpdate_Click(object sender, EventArgs e)
{
LibraryEntity context = new LibraryEntity();
try
{
Member m = context.Member.Where(x => x.NRIC == tbNRIC.Text).First();
if (tbName.Text != "" && tbContact.Text != "" && tbEmail.Text != "" && m.Address != "")
{
m.MemberName = tbName.Text;
m.Phone = tbContact.Text;
m.Email = tbEmail.Text;
m.Address = tbAddress.Text;
context.SaveChanges();
MessageBox.Show("Update successfully!");
}
else
{
MessageBox.Show("Fill in the all the details");
}
}
catch (System.Data.Entity.Infrastructure.DbUpdateException)
{
MessageBox.Show("Fill in the all the details");
}
catch (System.InvalidOperationException)
{
MessageBox.Show("Invalid NRIC");
}
}
/// <summary>
/// Quotq plus 1
/// </summary>
private void AddQuota()
{
LibraryEntity context = new LibraryEntity();
Member mem = context.Member.Where(x => x.NRIC == txtNRIC.Text).First();
mem.Quota = mem.Quota + 1;
context.SaveChanges();
}
/// <summary>
/// Total stock plus 1
/// </summary>
private void Addtotalstock()
{
LibraryEntity context = new LibraryEntity();
string BokID = dvwBooks.CurrentRow.Cells["BookID"].Value.ToString();
int BookID = Convert.ToInt32(BokID);
Books bok = context.Books.Where(x => x.BookID == BookID).First();
bok.TotalStock = (short)(bok.TotalStock + 1);
context.SaveChanges();
}
/// <summary>
/// Set status to 'in'
/// </summary>
private void BookReturn()
{
LibraryEntity context = new LibraryEntity();
string TranID = dvwBooks.CurrentRow.Cells["TransactionID"].Value.ToString();
int TransID = Convert.ToInt32(TranID);
Borrow bor = context.Borrow.Where(x => x.TransactionID == TransID).First();
bor.RentalStatus = "in";
bor.DateActualReturn = DateTime.Now;
context.SaveChanges();
}
/// <summary>
/// Total stock in book table minus 1
/// </summary>
private void TotalStockminus()
{
LibraryEntity context = new LibraryEntity();
int bookID = Convert.ToInt32(txtBookID.Text);
try
{
Books bok = context.Books.Where(x => x.BookID == bookID).First();
bok.TotalStock = (short)(bok.TotalStock - 1);
context.SaveChanges();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
int booksID = Convert.ToInt32(tbBooksID.Text);
Books books = context.Books.Where(x => x.BookID == booksID).First();
books.Title = tbTitle.Text;
books.Author = tbAuthor.Text;
books.CallNumber = tbCallNumber.Text;
books.Genre = cmbGenre.Text;
context.SaveChanges();
MessageBox.Show("Update successfully");
}
catch (Exception)
{
MessageBox.Show("fill in the all the details");
}
}
/// <summary>
/// Insert a record into borrow table
/// </summary>
private void Borrow()
{
LibraryEntity context = new LibraryEntity();
Borrow bo = new Borrow();
Member me = context.Member.Where(x => x.NRIC == txtNRIC.Text).First();
int bookID = Convert.ToInt32(txtBookID.Text);
Books bok = context.Books.Where(x => x.BookID == bookID).First();
bo.Member = me;
bo.Books = bok;
bo.BookID = bok.BookID;
bo.NRIC = me.NRIC;
bo.RentalStatus = "out";
bo.DateIssue = dtpDOI.Value;
bo.DateDue = dtpDueDate.Value;
bo.Remarks = txtRemarks.Text;
context.Borrow.Add(bo);
context.SaveChanges();
}
/// <summary>
/// Delete the member
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, EventArgs e)
{
LibraryEntity context = new LibraryEntity();
try
{
Member member = context.Member.Where(x => x.NRIC == tbNRIC.Text).First();
context.Member.Remove(member);
context.SaveChanges();
MessageBox.Show("successful");
tbNRIC.Text = null;
tbName.Text = null;
tbEmail.Text = null;
tbContact.Text = null;
tbAddress.Text = null;
}
catch (Exception)
{
MessageBox.Show("Invalid NRIC");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
LibraryEntity context = new LibraryEntity();
Books b = new Books();
try
{
b.Title = tbTitle.Text;
b.Author = tbAuthor.Text;
b.TotalStock = Convert.ToInt16(tbTotalStock.Text);
b.Genre = cmbGenre.SelectedItem.ToString();
b.CallNumber = tbCallNumber.Text;
context.Books.Add(b);
context.SaveChanges();
MessageBox.Show("Update successfull");
this.Close();
}
catch (System.Data.Entity.Infrastructure.DbUpdateException)
{
MessageBox.Show("fill in the all the details");
}
}
private void btnSignup_Click(object sender, EventArgs e)
{
LibraryEntity context = new LibraryEntity();
Member m = new Member();
try
{
m.NRIC = tbNRIC.Text;
m.MemberName = tbName.Text;
m.Phone = tbContact.Text;
m.Email = tbEmail.Text;
m.Address = tbAddress.Text;
///
///The quota for every new member is 4
///
m.Quota = 4;
context.Member.Add(m);
context.SaveChanges();
}
catch (System.Data.Entity.Infrastructure.DbUpdateException)
{
MessageBox.Show("fill in the all the details");
}
}