private void ReloadTheTable()
{
List <EmployeeViewModel> employeeViews;
_sql = new SQLActions();
employeeViews = _sql.GetAllEmployee();
ListOfEmployees.ItemsSource = employeeViews;
}
private void ReloadTotalTable()
{
List <EmployeeViewModel> employeeViews;
_sql = new SQLActions();
employeeViews = _sql.GetAllEmployee();
//ListOfEmployeeTotalHours ==> ListView.Name in xaml
ListOfEmployeeTotalHours.ItemsSource = employeeViews;
}
private void btnCalculateTotalHoursForThePeriod(object sender, RoutedEventArgs eventArgs)
{
List <EmployeeViewModel> employeeViews;
_sql = new SQLActions();
var _beginDate = beginDate.SelectedDate.Value.Date;
var _endDate = endDate.SelectedDate.Value.Date;
employeeViews = _sql.ListAllEmployeeTotalHoursForThePeriod(_beginDate, _endDate);
//ListOfEmployeeTotalHours ==> ListView.Name in xaml
ListOfEmployeeTotalHours.ItemsSource = employeeViews;
}
private void btnRecordHours_Click(object sender, RoutedEventArgs e)
{
int empId = int.Parse(euEmpId.Text);
DateTime workDate = (DateTime)euWorkDate.SelectedDate;
double hours = double.Parse(euHours.Text);
try
{
_sql = new SQLActions();
_sql.InsertEmpHours(empId, workDate, hours);
ReloadTheTable();
}
catch
{
MessageBox.Show("Not Connected to DB", "Error!");
}
}
private void btnSaveChanges_Click(object sender, RoutedEventArgs e)
{
this.euWorkDate.SelectedDate = this.euWorkDate.SelectedDate;
int empId = int.Parse(euEmpId.Text);
string firstName = euFirstName.Text;
string lastName = euLastName.Text;
string email = euEmail.Text;
DateTime dob = (DateTime)euDob.SelectedDate;
string phone = euPhone.Text;
try
{
_sql = new SQLActions();
_sql.UpdateEmployee(empId, firstName, lastName, email, dob, phone);
}
catch
{
MessageBox.Show("Not Connected to DB", "Error!");
}
}
private void btnAddEmployee_Click(object sender, RoutedEventArgs eventArgs)
{
_sql = new SQLActions();
_sql.InsertNewEmployee(_employee.FirstName, _employee.LastName, _employee.Email, _employee.Dob, _employee.Phone);
}
