private void ValidatetxtbMemberID()
{
using (SA45Team07B_LibraryEntities context = new SA45Team07B_LibraryEntities())
{
string inputID = txtbMemberID.Text.ToString();
this.memberFound = (from x in context.Members
where x.MemberID.ToString() == inputID
select x).FirstOrDefault();
if (memberFound != null)
{
facultyOfMemberFound = memberFound.Faculties;
memberTypeOfMemberFound = memberFound.MemberCategories;
DisplayTextboxData();
DisplayDGVData();
errorProviderForMemberID.SetError(txtbMemberID, "");
}
else
{
errorProviderForMemberID.SetError(txtbMemberID, "Invalid Member ID");
toolStripStatusLabel1.Text = "Invalid Member ID";
ClearTextboxData();
DisplayDGVData();
btnSaveChanges.Enabled = false;
}
}
}
private void ValidatetxtbRFID()
{
using (SA45Team07B_LibraryEntities context = new SA45Team07B_LibraryEntities())
{
string inputRFID = txtbRFID.Text.ToString();
this.RFIDofReturnBook = (from x in context.RFIDs
where x.RFID == inputRFID
select x).FirstOrDefault();
if (RFIDofReturnBook != null)
{
this.returnBook = RFIDofReturnBook.Books;
lastTransaction = (from x in context.IssueTrans
where x.TransactionID == RFIDofReturnBook.LastTransactionID
select x).FirstOrDefault();
if (lastTransaction == null)
{
ClearTextboxData();
MessageBox.Show("No last transaction record.");
}
else if (lastTransaction.Status == "in")
{
ClearTextboxData();
MessageBox.Show("No active transaction record.");
}
else
{
borrower = lastTransaction.Members;
borrowerMemberType = borrower.MemberCategories;
borrowerFaculty = borrower.Faculties;
DisplayTextboxData();
errorProviderForRFID.SetError(txtbRFID, "");
toolStripStatusLabel1.Text = "1 record is found.";
btnSubmit.Enabled = true;
}
}
else
{
errorProviderForRFID.SetError(txtbRFID, "Invalid RFID");
toolStripStatusLabel1.Text = "Invalid RFID";
ClearTextboxData();
btnSubmit.Enabled = false;
}
}
}
//Add for Add Member
private void buttonAdd_Click(object sender, EventArgs e)
{
SA45Team07B_LibraryEntities context2 = new SA45Team07B_LibraryEntities();
Member newMember = new Member();
newMember.SchoolID = maskedTextBoxSchoolID.Text.ToUpper();
newMember.MemberName = textBoxMemberName.Text.Trim();
MemberCategories cat = new MemberCategories();
cat = context2.MemberCategories.Where(x => x.CategoryName == comboBoxMemberType.SelectedItem.ToString()).FirstOrDefault();
newMember.MemberCategories = cat;
Faculty fac = new Faculty();
fac = context2.Faculties.Where(x => x.FacultyName == comboBoxFacultyName.SelectedItem.ToString()).FirstOrDefault();
newMember.Faculties = fac;
newMember.ContactNumber = textBoxContactNumber.Text.Trim();
newMember.Email = textBoxEmail.Text.ToLower().Trim();
newMember.Discontinued = "N";
newMember.LoanedQty = 0;
DialogResult dr = MessageBox.Show("Confirm add new member?", "Confirmation", MessageBoxButtons.YesNoCancel);
if (dr == DialogResult.Yes)
{
context2.Members.Add(newMember);
context2.SaveChanges();
MessageBox.Show(string.Format("Successfully added <<{0}>>.", newMember.MemberName));
Close();
}
else if (dr == DialogResult.No)
{
DialogResult = 0;
}
else if (dr == DialogResult.Cancel)
{
DialogResult = 0;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
long memberID;
using (SA45Team07B_LibraryEntities context = new SA45Team07B_LibraryEntities())
{
if (Int64.TryParse(dataGridViewMemberList.CurrentRow.Cells["MemberIDColumn"].Value.ToString(), out memberID))
{
this.memberFound = (from m in context.Members
where m.MemberID == memberID
select m).First();
this.facultyofMemberFound = memberFound.Faculties;
this.memberTypeOfMemberFound = memberFound.MemberCategories;
}
else
{
// should no happen
throw new Exception("No member is selected");
}
}
this.DialogResult = DialogResult.OK;
}
