private void RedirectPage(string department)
{
if (department == "Teller")
{
//GOTO teller page
TellerWindow tellerWin = new TellerWindow(CurrentEmployee);
tellerWin.ShowDialog();
}
else if (department == "Customer Service")
{
//GOTO customer service page
CustomerServiceWindow csWin = new CustomerServiceWindow(CurrentEmployee);
csWin.ShowDialog();
}
else if (department == "Maintenance Team")
{
//GOTO maintenance
MaintenanceWindow maintenanceWin = new MaintenanceWindow(CurrentEmployee);
maintenanceWin.ShowDialog();
}
else if (department == "HRM")
{
//GOTO HRM
HRMWindow hrmWin = new HRMWindow(CurrentEmployee);
hrmWin.ShowDialog();
}
else if (department == "Finance Team")
{
//GOTO Finance Team
FinanceWindow financeWin = new FinanceWindow(CurrentEmployee);
financeWin.ShowDialog();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Window back = new TellerWindow(employee);
back.Show();
this.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
DataTable dt = new DataTable();
connect.executeUpdate("update queue set status = 'Done' where division = 'Teller' and status in ('Not Done') limit 1");
dt = connect.executeQuery("select * from queue where division = 'Teller' and status in ('Not Done') limit 1");
tq.erase();
if (dt.Rows.Count == 1)
{
DataRow data = dt.Rows[0];
tq.setValue(data["queueno"].ToString(), data["uniquequeue"].ToString());
}
connect.executeUpdate("update employee set rating = (((rating*ratecount) + " + float.Parse(star.ToString()) + ")/(ratecount+1)), ratecount = (ratecount + 1) where id = '" + employee.id + "'");
MessageBox.Show("Thank You For Your Rating! ");
Window twindow = new TellerWindow(employee);
twindow.Show();
this.Close();
}
private void submit(object sender, RoutedEventArgs e)
{
string itemid = itemtxt.Text;
DataTable dt = new DataTable();
dt = connect.executeQuery("select * from item where employee = '" + employee.id + "' and itemid = '" + itemid + "' limit 1");
if (dt.Rows.Count == 0)
{
label.Content = "Invalid item!";
return;
}
else
{
DataRow data;
data = dt.Rows[0];
string emp = data["employee"].ToString();
if (data["itemstatus"].ToString() == "Broken")
{
label.Content = "Item is already reported!";
return;
}
else
{
MessageBox.Show("Success Reporting Item");
connect.executeUpdate("insert into schedule values ('" + itemid + "', 'Teller " + data["itemname"].ToString() + "', CURRENT_DATE + (SELECT((COUNT(*) + 1) / 3) + 1 from item where itemstatus = 'Broken'),'Not Fixed')");
connect.executeUpdate("update item set itemstatus = 'Broken' where itemid = '" + itemid + "'");
Window back = new TellerWindow(employee);
back.Show();
this.Close();
}
}
}
