private void btnSubmit_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(tbFName.Text) || string.IsNullOrWhiteSpace(tbLName.Text) || string.IsNullOrWhiteSpace(tbPW.Text) || string.IsNullOrWhiteSpace(tbID.Text))
{
MessageBox.Show("You must input all fields", "Check Your Input", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
String deptCode, fName, lName, pw;
//get data from the inputs
deptCode = ((KeyValuePair <String, String>)comboBox1.SelectedItem).Value;
fName = tbFName.Text;
lName = tbLName.Text;
pw = tbPW.Text;
//insert all data into db
MySqlCommand command = cnn.CreateCommand();
command.CommandText = "insert into Staff values('" + uid + "','" + fName + "','" + lName + "','" + deptCode + "','" + pw + "');";
cnn.Open();
command.ExecuteNonQuery();
cnn.Close();
if (((KeyValuePair <String, String>)comboBox1.SelectedItem).Value == "RM")
{
command.CommandText = "insert into StaffRestaurant values('" + uid + "','" + restNum + "');";
cnn.Open();
command.ExecuteNonQuery();
cnn.Close();
}
//show create success message
MessageBox.Show("Create Success!", "Created", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
m.Show();
}
}
private void button1_Click(object sender, EventArgs e)
{
this.Close();
if (em != null)
{
em.Show();
}
else
{
m.Show();
}
}
private void button1_Click(object sender, EventArgs e)
{
switch (deptCode)
{
case "AM":
this.Hide();
EditMenu em = new EditMenu(this, 0);
em.Show();
break;
case "RM":
this.Hide();
PurchaseRequest pr = new PurchaseRequest(this, restNo, StaffNo);
pr.Show();
break;
case "PM":
this.Hide();
TypeofAgreementMenu tam = new TypeofAgreementMenu(staffName, this);
tam.Show();
break;
case "CM":
this.Hide();
Category cat = new Category(this);
cat.Show();
break;
case "WC":
this.Hide();
WHViewDPI dpi = new WHViewDPI(this);
dpi.Show();
break;
case "AD":
this.Hide();
TypeofAgreementMenu adtam = new TypeofAgreementMenu(staffName, this);
adtam.Show();
break;
}
}
private void btn2_Click(object sender, EventArgs e)
{
switch (deptCode)
{
case "PM":
this.Hide();
PRMapping prm = new PRMapping(this);
prm.Show();
break;
case "RM":
this.Hide();
ViewDeliveryNoteMenu vDN = new ViewDeliveryNoteMenu(this, "RM", restNo);
vDN.Show();
break;
case "AD":
case "WC":
this.Hide();
ViewDeliveryNoteMenu WHvDN = new ViewDeliveryNoteMenu(this, "WC");
WHvDN.Show();
break;
case "AM":
this.Hide();
EditMenu em = new EditMenu(this, 1);
em.Show();
break;
case "CM":
this.Hide();
Item itm = new Item(this);
itm.Show();
break;
}
}
private void button1_Click(object sender, EventArgs e)
{
this.Close();
m.Show();
}