private void DeleteEmployee_Click(object sender, RoutedEventArgs e)
{
EmployeeScheduleDatabaseDataSetTableAdapters.EmployeesTableAdapter empAdapter =
new EmployeeScheduleDatabaseDataSetTableAdapters.EmployeesTableAdapter();
EmployeeScheduleDatabaseDataSet.EmployeesDataTable empdata = empAdapter.GetData();
try
{
EmployeeScheduleDatabaseDataSet.EmployeesRow delRow =
empdata.FindByempId(selectedEmp.EmpId);
delRow.Delete();
empAdapter.Update(delRow);
allEmps.Remove(selectedEmp);
EmployeeList.ItemsSource = null;
EmployeeList.ItemsSource = allEmps;
System.Windows.MessageBox.Show("Employee Deleted!");
}
catch
{
System.Windows.MessageBox.Show("whoops");
}
}
public void PullData()
{
if (allSShifts != null)
{
allSShifts.Clear();
}
EmployeeScheduleDatabaseDataSetTableAdapters.ScheduledShiftTableAdapter SSAdapter =
new EmployeeScheduleDatabaseDataSetTableAdapters.ScheduledShiftTableAdapter();
EmployeeScheduleDatabaseDataSet.ScheduledShiftDataTable sshiftdata = SSAdapter.GetData();
EmployeeScheduleDatabaseDataSetTableAdapters.ShiftTableTableAdapter SAdapter =
new EmployeeScheduleDatabaseDataSetTableAdapters.ShiftTableTableAdapter();
EmployeeScheduleDatabaseDataSet.ShiftTableDataTable shiftdata = SAdapter.GetData();
EmployeeScheduleDatabaseDataSetTableAdapters.EmployeesTableAdapter empAdapter =
new EmployeeScheduleDatabaseDataSetTableAdapters.EmployeesTableAdapter();
EmployeeScheduleDatabaseDataSet.EmployeesDataTable empdata = empAdapter.GetData();
foreach (EmployeeScheduleDatabaseDataSet.ScheduledShiftRow row in sshiftdata)
{
ScheduledShift tempSShift = new ScheduledShift();
tempSShift.SShiftId = row.SShiftId;
tempSShift.ScheduledDate = row.Date;
tempSShift.Starttime = shiftdata.FindByShiftId(row.ShiftId).StartTime;
tempSShift.Endtime = shiftdata.FindByShiftId(row.ShiftId).EndTime;
tempSShift.EmpName = empdata.FindByempId(row.EmpId).firstName + " " + empdata.FindByempId(row.EmpId).lastName;
allSShifts.Add(tempSShift);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
EmployeeScheduleDatabaseDataSetTableAdapters.EmployeesTableAdapter empAdapter =
new EmployeeScheduleDatabaseDataSetTableAdapters.EmployeesTableAdapter();
EmployeeScheduleDatabaseDataSet.EmployeesDataTable empdata = empAdapter.GetData();
if (updateEmp != null)
{
EmployeeScheduleDatabaseDataSet.EmployeesRow editRow =
empdata.FindByempId(updateEmp.EmpId);
editRow.firstName = EmpFNameTextBox.Text;
editRow.lastName = EmpLNameTextBox.Text;
try
{
empAdapter.Update(editRow);
Employees empWindow = new Employees();
empWindow.Show();
this.Close();
}
catch
{
System.Windows.MessageBox.Show("whoops");
}
}
else
{
EmployeeScheduleDatabaseDataSet.EmployeesRow newRow =
empdata.NewEmployeesRow();
newRow.empId = empdata.Last().empId + 1;
newRow.firstName = EmpFNameTextBox.Text;
newRow.lastName = EmpLNameTextBox.Text;
try
{
empAdapter.Insert(newRow.empId, newRow.firstName, newRow.lastName);
Employees empWindow = new Employees();
empWindow.Show();
this.Close();
}
catch
{
System.Windows.MessageBox.Show("whoops");
}
}
}
