// [Member Form - Create Button codes]
private void buttonCreateMembers_Click(object sender, EventArgs e)
{
// Form Obj initialisation
DataChecker datacheck = new DataChecker();
//Form vairables initialisation
labelWarningMemberForm.Visible = false;
string NUSID = this.textBoxInfoNusIDMembers.Text.Trim().ToUpper();
string MemberType = MemberTypeCheck();
string Name = this.textBoxNameMembers.Text.Trim();
int Mobile = MobileNumCheck(datacheck, this.textBoxPhoneMembers.Text.Trim());
string Email = this.textBoxEmailMembers.Text.Trim();
NUSIDCheck(datacheck, NUSID);
// Member creation - using warning label as bool flag decider
if (labelWarningMemberForm.Visible == false)
{
Member NewMember = new Member
{
NUSID = NUSID, MemberType = MemberType, Name = Name, Mobile = Mobile, Email = Email
};
CreateMember(NewMember);
}
}
// [Member Form - Update Button codes]
private void buttonConfirmChangesMembers_Click(object sender, EventArgs e)
{
DataChecker datacheck = new DataChecker();
labelWarningMemberForm.Visible = false;
string NUSID = this.textBoxInfoNusIDMembers.Text.Trim().ToUpper();
string MemberType = MemberTypeCheck();
string Name = this.textBoxNameMembers.Text.Trim();
int Mobile = MobileNumCheck(datacheck, this.textBoxPhoneMembers.Text.Trim());
string Email = this.textBoxEmailMembers.Text.Trim();
NUSIDCheck(datacheck, NUSID);
// using warning label as bool flag decider
if (labelWarningMemberForm.Visible == false)
{
Member NewMember = new Member
{
NUSID = NUSID, MemberType = MemberType, Name = Name, Mobile = Mobile, Email = Email
};
bool flag = DeleteMember(NUSID);
if (flag == true)
{
CreateMember(NewMember);
}
((MAIN)MdiParent).UpdateStatusLabel("Member record successfully updated");
}
}
private void NUSIDCheck(DataChecker datacheck, string NUSID)
{
if (datacheck.NUSIDVerification(NUSID) == false)
{
labelInfoNusIDMembers.ForeColor = System.Drawing.Color.Red;
labelInfoNusIDMembers.Text = "*NUS ID:";
textBoxInfoNusIDMembers.Text = "Enter in the format of A123456B";
labelWarningMemberForm.Visible = true;
}
else
{
labelInfoNusIDMembers.ForeColor = System.Drawing.Color.Black;
labelInfoNusIDMembers.Text = "NUS ID:";
}
}
// [Member Form - Delete Button codes]
private void buttonDeleteMembers_Click(object sender, EventArgs e)
{
// Form Obj initialisation
DataChecker datacheck = new DataChecker();
labelWarningMemberForm.Visible = false;
string NUSID = this.textBoxInfoNusIDMembers.Text.Trim().ToUpper();
NUSIDCheck(datacheck, NUSID);
if (labelWarningMemberForm.Visible == false)
{
DeleteMember(NUSID);
}
}
// Button will activate search base on NUSID / TransID
private void buttonSearchDeleteBooking_Click(object sender, EventArgs e)
{
this.labelWarning.Visible = false;
this.labelNusIDDeleteBooking.ForeColor = System.Drawing.Color.Black;
DataChecker datacheck = new DataChecker();
if (this.radioButtonNUSIDDeleteBooking.Checked == true)
{
SearchByNUSID(datacheck);
}
else
{
SearchByTransID(datacheck);
}
}
// [Member Form - Data Integrity Checking codes]
private int MobileNumCheck(DataChecker datacheck, string Mobile)
{
if (datacheck.PositiveIntCheck(Mobile) == false)
{
labelInfoPhoneMembers.ForeColor = System.Drawing.Color.Red;
labelInfoPhoneMembers.Text = "*Phone Number:";
textBoxPhoneMembers.Text = "Only local phone number w/o +";
labelWarningMemberForm.Visible = true;
return(0);
}
else
{
labelInfoPhoneMembers.ForeColor = System.Drawing.Color.Black;
labelInfoPhoneMembers.Text = "Phone Number:";
return(Convert.ToInt32(Mobile));
}
}
// Query based on NUSID
private void SearchByNUSID(DataChecker datacheck)
{
string searchinput = this.textBoxNusIDDeleteBooking.Text.Trim().ToUpper();
try
{
SA46Team09BEntities context = new SA46Team09BEntities();
var querySearchByNUSID = from x in context.Transactions where x.NUSID.Contains(searchinput) && x.CancelRef == 0 select x;
List <Transaction> ViewTransactionByNUSID = querySearchByNUSID.ToList <Transaction>();
dataGridViewDeleteBooking.DataSource = ViewTransactionByNUSID;
}
catch
{
MessageBox.Show("Connection fail. Please try again.");
((MAIN)MdiParent).UpdateStatusLabel("Error encounter in last transaction...");
}
}
/* Button triggers the booking. Button can only be enable when a time slot element is CLICKED.
* Otherwise, it is disabled (disabled at load of screen and after a booking)
*/
private void buttonConfirmBooking_Click(object sender, EventArgs e)
{
string NUSID = this.textBoxNUSIDBooking.Text;
this.labelWarning.Visible = false;
this.labelNUSIDBooking.ForeColor = System.Drawing.Color.Black;
this.labelNUSIDBooking.Text = "NUSID";
DataChecker datacheck = new DataChecker();
if (datacheck.NUSIDVerification(NUSID) == false)
{
this.labelWarning.Visible = true;
this.labelNUSIDBooking.ForeColor = System.Drawing.Color.Red;
this.labelNUSIDBooking.Text = "*NUSID";
}
else
{
BookingCreation(NUSID);
}
resetscreen();
}
// Query based on Transaction ID
private void SearchByTransID(DataChecker datacheck)
{
string searchinput = this.textBoxNusIDDeleteBooking.Text.Trim();
if (datacheck.PositiveIntCheck(searchinput) == true)
{
SA46Team09BEntities context = new SA46Team09BEntities();
int searchinputint = Convert.ToInt32(searchinput);
var querySearchByTransID = from x in context.Transactions where x.TransactionID == searchinputint && x.CancelRef == 0 select x;
List <Transaction> ViewTransactionByTransID = querySearchByTransID.ToList <Transaction>();
dataGridViewDeleteBooking.DataSource = ViewTransactionByTransID;
((MAIN)MdiParent).UpdateStatusLabel("Query Completed");
}
else
{
this.labelWarning.Visible = true;
this.labelNusIDDeleteBooking.ForeColor = System.Drawing.Color.Red;
this.labelWarning.Text = "Please enter only positive integers for Transaction ID";
((MAIN)MdiParent).UpdateStatusLabel("Error encounter in last transaction...");
}
}
