private void back(object sender, RoutedEventArgs e)
{
Window back = new HRMManageEmployee(employee);
back.Show();
this.Close();
}
private void manage(object sender, RoutedEventArgs e)
{
Window manage = new HRMManageEmployee(employee);
manage.Show();
this.Close();
}
private void selectitem(object sender, SelectionChangedEventArgs e)
{
MessageBoxResult result = MessageBox.Show("Recruit This Employee?", "Are you sure?", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No);
switch (result)
{
case MessageBoxResult.Yes:
MessageBox.Show("Employee Recruited!");
DataTable dt5 = new DataTable();
dt5 = connect.executeQuery("select * from employee where division = '" + candidatedivision.ElementAt(datagrid.SelectedIndex).ToString() + "'");
if (candidatedivision.ElementAt(datagrid.SelectedIndex).Equals("Teller"))
{
connect.executeUpdate("insert into employee values ('T00" + (dt5.Rows.Count + 1) + "','" + candidatename.ElementAt(datagrid.SelectedIndex) + "','Teller','password',4000000,0,0,'Active')");
}
else if (candidatedivision.ElementAt(datagrid.SelectedIndex).Equals("Customer Service"))
{
connect.executeUpdate("insert into employee values ('CS00" + (dt5.Rows.Count + 1) + "','" + candidatename.ElementAt(datagrid.SelectedIndex) + "','Customer Service','password',5000000,0,0,'Active')");
}
else if (candidatedivision.ElementAt(datagrid.SelectedIndex).Equals("Human Resource"))
{
connect.executeUpdate("insert into employee values ('HRM00" + (dt5.Rows.Count + 1) + "','" + candidatename.ElementAt(datagrid.SelectedIndex) + "','Human Resource','password',6000000,0,0,'Active')");
}
else if (candidatedivision.ElementAt(datagrid.SelectedIndex).Equals("Security & Maintenance"))
{
connect.executeUpdate("insert into employee values ('SM00" + (dt5.Rows.Count + 1) + "','" + candidatename.ElementAt(datagrid.SelectedIndex) + "','Security & Maintenance','password',5500000,0,0,'Active')");
}
else if (candidatedivision.ElementAt(datagrid.SelectedIndex).Equals("Finance"))
{
connect.executeUpdate("insert into employee values ('F00" + (dt5.Rows.Count + 1) + "','" + candidatename.ElementAt(datagrid.SelectedIndex) + "','Finance','password',5000000,0,0,'Active')");
}
else if (candidatedivision.ElementAt(datagrid.SelectedIndex).Equals("Manager"))
{
connect.executeUpdate("insert into employee values ('M00" + (dt5.Rows.Count + 1) + "','" + candidatename.ElementAt(datagrid.SelectedIndex) + "','Manager','password',20000000,0,0,'Active')");
}
connect.executeUpdate("delete from candidate where id = '" + candidateid.ElementAt(datagrid.SelectedIndex) + "'");
Window a = new HRMManageEmployee(employee);
a.Show();
this.Close();
break;
case MessageBoxResult.No:
break;
}
}
