private int TotalBookStockValidation(GalaxyEntities context)
{
var TotalStockCount = from x in context.Books.Where(x => x.BookID == txBookID.Text) select x.TotalStock;
int i = TotalStockCount.Single();
return(i);
}
private void btnUpfM_Click(object sender, EventArgs e)
{
GalaxyEntities ctx = new GalaxyEntities();
Member c = new Member();
try
{
// Validate ID to be existing
if (txmemberID.Text.Length == 5 && txmemberID.Text.Substring(0, 1) == "M")
{
if (Convert.ToInt32(txmemberID.Text.Substring(1, 4)) >= 1000 && Convert.ToInt32(txmemberID.Text.Substring(1, 4)) <= ctx.Members.Count() + 999)
{
// Identify member record
c = ctx.Members.Where(x => x.MemberID == txmemberID.Text).First();
c.FineAmount = Convert.ToDouble(txFine.Text);
ctx.SaveChanges();
MessageBox.Show("Successful update!");
btnclr_Click(sender, e);
}
}
else
{
MessageBox.Show("Not an existing MemberID!");
}
}
catch (Exception a)
{
a = new InvalidInputException("Please ensure that details of member is correct.");
MessageBox.Show(a.Message);
}
}
private void btnSure_Click(object sender, EventArgs e)
{
GalaxyEntities ctx = new GalaxyEntities();
if (txID.Text.Length == 3 && txID.Text.Substring(0, 1) == "S")
{
if (Convert.ToInt32(txID.Text.Substring(1, 2)) >= 1 && Convert.ToInt32(txID.Text.Substring(1, 2)) <= ctx.Staffs.Count())
{
Staff c = ctx.Staffs.Where(x => x.StaffID == txID.Text).First();
txName.Text = c.Name;
txPassword.Text = c.Password;
txPhoneNo.Text = c.PhoneNumber.ToString();
txPosition.Text = c.Position;
txUserName.Text = c.Username;
txAddress.Text = c.Address;
txEmail.Text = c.EmailAddress;
}
else
{
MessageBox.Show("This format of input is right but this staff is not existing! You can add a new one!");
}
}
else
{
MessageBox.Show("You input the wrong format! You can check the notice and input again!");
}
}
public frm11BookSearchForStaff() : base()
{
InitializeComponent();
context = new GalaxyEntities();
// Set search filters
cbxSearchBy.DataSource = new List <string> {
"Book ID", "Title", "Publisher", "Author", "Book Category", "Location",
"Price", "Total Stock", "Number Borrowed", "Availability"
};
// Display all books
gvSearchResult.DataSource = context.Books.Select(x => new {
x.BookID,
x.Title,
x.Publisher,
x.Author,
x.BookCategory,
x.Location,
x.Price,
x.TotalStock,
x.NumberBorrowed,
x.Availability
}).ToList();
}
private void frmBookAdd_Load(object sender, EventArgs e)
{
context = new GalaxyEntities();
GenerateBookID();
cbxCategory.SelectedIndex = 0;
cbxFloor.SelectedIndex = 0;
}
private int ExtensionCount(GalaxyEntities context)
{
var count = from x in context.Transactions where x.MemberID == txMemberID.Text && x.BookID == txBookID.Text select x;
Transaction c = count.First();
int i = c.ExtensionCount;
return(i);
}
private void Extension(GalaxyEntities context)
{
Transaction t = context.Transactions.Where(x => x.BookID == txBookID.Text && x.MemberID == txMemberID.Text).FirstOrDefault();
t.IssueDate = DateTime.Today.Date;
t.DueDate = DateTime.Now.AddDays(10);
t.ExtensionCount += 1;
context.SaveChanges();
}
public frmSearchCustomer()
{
InitializeComponent();
context = new GalaxyEntities();
cbxSearchBy.DataSource = searchByList;
btnRetrieve.Enabled = false;
btnSearch.Enabled = false;
txSearchDetail.ReadOnly = true;
}
private void frmBookSearchForStaff_Load(object sender, EventArgs e)
{
context = new GalaxyEntities();
gv.DataSource = context.Books.Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price,
x.TotalStock, x.NumberBorrowed, x.Availability }).ToList();
cbxSearchBy.SelectedIndex = 0;
txInput.Text = "";
selectedBookID = "";
}
private void frm8BookInformation_Load(object sender, EventArgs e)
{
context = new GalaxyEntities();
tempID = "";
// View first book
position = 0;
bookList = context.Books.ToList();
b = bookList[position];
displayDetails();
displayHistory();
}
public frmTemplateSearch()
{
InitializeComponent();
// Display default filter for user to search by
cbxSearchBy.SelectedIndex = 0;
// Set viewing preference for grid view
gvSearchResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
txSearchDetail.Text = "";
selectedID = "";
context = new GalaxyEntities();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
GalaxyEntities ctx = new GalaxyEntities();
Staff c = ctx.Staffs.Where(x => x.StaffID == txID.Text).First();
c.Name = txName.Text;
c.Password = txPassword.Text;
c.PhoneNumber = txPhoneNo.Text;
c.Position = txPosition.Text;
c.Username = txUserName.Text;
c.Address = txAddress.Text;
c.EmailAddress = txEmail.Text;
ctx.SaveChanges();
MessageBox.Show("Information successfully updated!");
}
private void btnDelete_Click(object sender, EventArgs e)
{
GalaxyEntities ctx = new GalaxyEntities();
if (txID.Text.Length == 3 && txID.Text.Substring(0, 1) == "S" && Convert.ToInt32(txID.Text.Substring(1, 2)) >= 1 && Convert.ToInt32(txID.Text.Substring(1, 2)) <= ctx.Staffs.Count())
{
Staff c = ctx.Staffs.Where(x => x.StaffID == txID.Text).First();
ctx.Staffs.Remove(c);
ctx.SaveChanges();
MessageBox.Show("Staff successfully deleted!");
}
else
{
MessageBox.Show("This staff is not existing! You may input the wrong StaffID, please check and input again!");
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
username = Username_txt.Text;
string password = Password_text.Text;
Username_txt.Text.Trim();
using (GalaxyEntities context = new GalaxyEntities())
{
var user = context.Staffs.FirstOrDefault(u => u.Username == username);
if (user != null)
{
if (user.Password == password)
{
this.Hide();
//this.DialogResult = DialogResult.OK;
//proceed to new form =
frm6BorrowBook f = new frm6BorrowBook();
//frmTemplate temp = new frmTemplate();
//temp.LbUserName = username;
f.Name = user.Name;
f.Location = this.Location;
f.ShowDialog();
this.Close();
//label4.Text = "Login successful";
//if (user.Username == "Venkat") {
// checkBoss = true;
//}
}
else
{
label4.Text = "Wrong password";
}
}
else
{
label4.Text = "No User Called " + username + " found";
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
GalaxyEntities ctx = new GalaxyEntities();
if (txID.Text.Length == 3 && txID.Text.Substring(0, 1) == "S" && Convert.ToInt32(txID.Text.Substring(1, 2)) >= 1 && Convert.ToInt32(txID.Text.Substring(1, 2)) <= ctx.Staffs.Count())
{
bool check = false;
foreach (Staff x in ctx.Staffs.ToList())
{
if (txID.Text == x.StaffID)
{
check = true;
break;
}
}
if (check == false)
{
Staff c = new Staff();
c.StaffID = txID.Text;
c.Name = txName.Text;
c.Password = txPassword.Text;
c.PhoneNumber = txPhoneNo.Text;
c.Position = txPosition.Text;
c.Username = txUserName.Text;
c.Address = txAddress.Text;
c.EmailAddress = txEmail.Text;
ctx.Staffs.Add(c);
ctx.SaveChanges();
MessageBox.Show("Staff successfully added!");
}
else
{
MessageBox.Show("Existed Member ID, please set other ID!!");
}
}
else
{
MessageBox.Show("You may input the wrong StaffID, please check and input again!");
}
}
private void btnExtension_Click(object sender, EventArgs e)
{
using (GalaxyEntities context = new GalaxyEntities())
{
txMemberID.Text.Trim();
txBookID.Text.Trim();
if (UsernamePasswordisValid(context))
{
if (TotalBorrowCount(context))
{
int i = ExtensionCount(context);
var Lecturer = LecturerValidation(context);
if (i < 3)
{
Extension(context);
var Display = context.Transactions.Where
(x => x.BookID == txBookID.Text && x.MemberID == txMemberID.Text).Select(x => new { x.TransactionID, x.BookID, x.MemberID, x.ReturnDate, x.IssueDate, x.DueDate, x.ExtensionCount, x.LoanStatus, x.Remarks });
GV.DataSource = Display.ToList(); // DataGridView
}
else
{
txSuccess.Text = "Extension Limit Reached";
}
}
else
{
txSuccess.Text = "Wrong Input!";
}
}
else
{
txSuccess.Text = "Wrong Input!";
}
}
}
public frmCustomerInformation()
{
InitializeComponent();
context = new GalaxyEntities();
btnBorrow.Enabled = false;
btnPay.Enabled = false;
btnRetrieve.Enabled = false;
btnUpdate.Enabled = false;
btnReturn.Enabled = false;
btnConfirm.Enabled = false;
btnCancel.Enabled = false;
btnAdd.Enabled = true;
groupBoxReadOnly(true);
// Display first customer by default
position = 0;
membersList = context.Members.ToList();
m = membersList[position];
display(m);
}
private void btnRetrieve_Click(object sender, EventArgs e)
{
GalaxyEntities ctx = new GalaxyEntities();
if (txmemberID.Text.Length == 5 && txmemberID.Text.Substring(0, 1) == "M")
{
if (Convert.ToInt32(txmemberID.Text.Substring(1, 4)) >= 1000 && Convert.ToInt32(txmemberID.Text.Substring(1, 4)) <= ctx.Members.Count() + 999)
{
Member c = ctx.Members.Where(x => x.MemberID == txmemberID.Text).First();
txmemberID.Text = c.MemberID.ToString();
txName.Text = c.Name.ToString();
txCategory.Text = c.MemberCategory.ToString();
txFine.Text = c.FineAmount.ToString();
}
else
{
MessageBox.Show("This format of input is right but this member is not existing!");
}
}
else
{
MessageBox.Show("You input the wrong format! You can check the notice and input again!");
}
}
public frm4BooksDetailForMember()
{
InitializeComponent();
context = new GalaxyEntities();
}
private void frmRetrieve_Load(object sender, EventArgs e)
{
context = new GalaxyEntities();
selectedBook = new Book();
}
//methods
private IQueryable <Member> LecturerValidation(GalaxyEntities context)
{
return(context.Members.Where(x => x.MemberID == txMemberID.Text && x.MemberCategory == "Lecturer"));
}
private void btnConfirm_Click(object sender, EventArgs e)
{
using (GalaxyEntities context = new GalaxyEntities()) {
txMemberID.Text.Trim();
txBookID.Text.Trim();
if (txMemberID.Text.Length == 5 && txMemberID.Text.Substring(0, 1) == "M" &&
Convert.ToDouble(txMemberID.Text.Substring(1, 4)) >= 1000 && Convert.ToDouble(txMemberID.Text.Substring(1, 4)) <= context.Members.Count() + 999)
{
if (txBookID.Text.Length == 5 && txBookID.Text.Substring(0, 1) == "G" && Convert.ToDouble(txBookID.Text.Substring(1, 4)) >= 1 && Convert.ToDouble(txBookID.Text.Substring(1, 4)) <= context.Books.Count())
{
int i = TotalBookStockValidation(context);
if (i > 0)
{
var count = context.Transactions.Where(x => x.MemberID == txMemberID.Text && x.LoanStatus == "Borrowed").Count();
var Lecturer = context.Members.Where(x => x.MemberID == txMemberID.Text && x.MemberCategory == "Lecturer");
if (count <= 3)
{
Transaction t = new Transaction();
t.TransactionID = (context.Transactions.Count() + 1);
t.BookID = txBookID.Text;
t.MemberID = txMemberID.Text;
t.IssueDate = DateTime.Today.Date;
t.DueDate = DateTime.Now.AddDays(10);
t.LoanStatus = "";
context.Transactions.Add(t);
context.SaveChanges();
DateTime r = DateTime.Today;
Transaction t1 = context.Transactions.Where
(x => x.MemberID == txMemberID.Text && x.BookID == txBookID.Text).First();
if (Lecturer != null) //Lecturers loan duration is 20 compared to 10
{
t1.DueDate = DateTime.Today.Date.AddDays(20);
}
else
{
t1.DueDate = DateTime.Now.AddDays(10);
}
Book b1 = new Book();
b1 = context.Books.Where(x => x.BookID == txBookID.Text).First();
b1.NumberBorrowed += 1;
b1.TotalStock -= 1;
Member a = new Member();
a = context.Members.Where(x => x.MemberID == txMemberID.Text).First();
a.CurrentBorrowing += 1;
t.LoanStatus = "Borrowed";
context.SaveChanges();
GV.DataSource = context.Transactions.Where(x => x.LoanStatus == "Borrowed" && x.MemberID == txMemberID.Text).
Select(x => new { x.TransactionID, x.BookID, x.MemberID, x.ReturnDate, x.IssueDate, x.DueDate, x.ExtensionCount, x.LoanStatus, x.Remarks }).
ToList();
}
else
{
txSuccess.Text = "Borrowing Limit Reached";
}
}
else
{
txSuccess.Text = "Book Currently Unavailable!";
}
}
else
{
txSuccess.Text = "Wrong input!";
}
}
else
{
txSuccess.Text = "Wrong Input!";
}
}
}
private void frmBookModify_Load(object sender, EventArgs e)
{
context = new GalaxyEntities();
readOnlyFields();
}
private bool TotalBorrowCount(GalaxyEntities context)
{
return(txBookID.Text.Length == 5 && txBookID.Text.Substring(0, 1) == "G" && Convert.ToDouble(txBookID.Text.Substring(1, 4)) >= 1 && Convert.ToDouble(txBookID.Text.Substring(1, 4)) <= context.Books.Count());
}
private bool UsernamePasswordisValid(GalaxyEntities context)
{
return(txMemberID.Text.Length == 5 && txMemberID.Text.Substring(0, 1) == "M" &&
Convert.ToInt32(txMemberID.Text.Substring(1, 4)) >= 1000 && Convert.ToInt32(txMemberID.Text.Substring(1, 4)) <= context.Members.Count() + 999);
}