private async void RegisterBtn_Click(object sender, RoutedEventArgs e)
{
MainWindow.logger.Info("Register Button in TimeView clicked");
try
{
using (var db = new EmploeeContext())
{
var actualMaxRegisterIdnumber = db.workTimes.DefaultIfEmpty().Max(x => x.WorkTimeId);
int num = LoginScreen.acutalEmployeeId;
DateTime begin = DateTime.Parse(DateTimePickerBegin.Text);
DateTime end = DateTime.Parse(DateTimePickerEnd.Text);
double hourSpan = (end - begin).TotalHours;
var workT = new WorkTime {
WorkTimeId = actualMaxRegisterIdnumber + 1, BeginningTime = begin, EndTime = end, EmployeeId = num, Hours = hourSpan
};
await db.workTimes.AddAsync(workT);
await db.SaveChangesAsync();
}
MessageBox.Show("Time registered successfully! :)");
}
catch (System.ArgumentNullException e2)
{
MainWindow.logger.Info("Error occured", e2);
MessageBox.Show("Incorrect data. Try again.");
}
}
private void showWorkerTimes_Click(object sender, RoutedEventArgs e)
{
MainWindow.logger.Info("Show workers time button clicked");
times.Clear();
try
{
int id = Int32.Parse(textWorkerID.Text);
using (var db = new EmploeeContext())
{
var rec = db.workTimes.Where(x => x.EmployeeId == id).ToList();
foreach (var ss in rec)
{
times.Add(ss);
}
dataGrid.ItemsSource = times;
}
}
catch (System.FormatException e3)
{
MainWindow.logger.Info("Error occured", e3);
MessageBox.Show("Incorrect data. Try again.");
}
}
private void showAllDataButton_Click(object sender, RoutedEventArgs e)
{
emps.Clear();
using (var db = new EmploeeContext())
{
foreach (var ss in db.employees)
{
emps.Add(ss);
}
dataGrid.ItemsSource = emps;
}
}
private void showOneWorker_Click(object sender, RoutedEventArgs e)
{
MainWindow.logger.Info("Show one worker button clicked");
emps.Clear();
var name = textWorkerName.Text;
using (var db = new EmploeeContext())
{
var rec = db.employees.Where(x => x.LastName == name).ToList();
foreach (var ss in rec)
{
emps.Add(ss);
}
dataGrid.ItemsSource = emps;
}
}
private void schowMyTimes_Click(object sender, RoutedEventArgs e)
{
MainWindow.logger.Info("Show my times button clicked");
times.Clear();
int num = LoginScreen.acutalEmployeeId;
using (var db = new EmploeeContext())
{
var rec = db.workTimes.Where(x => x.EmployeeId == num).ToList();
foreach (var ss in rec)
{
times.Add(ss);
}
dataGrid.ItemsSource = times;
}
}
private async void SaveButton_Click(object sender, RoutedEventArgs e)
{
MainWindow.logger.Info("Save button in AddingEmployeeView clicked");
try
{
using (var db = new EmploeeContext())
{
var actualMaxIdnumber = db.employees.DefaultIfEmpty().Max(x => x.EmployeeId);
var emp = new Employee {
EmployeeId = actualMaxIdnumber + 1, FirstName = fNameText.Text, LastName = lNameText.Text, Address = addressText.Text, Email = emailText.Text, PhoneNumber = Int32.Parse(phoneText.Text), Position = positionText.Text
};
await db.employees.AddAsync(emp);
await db.SaveChangesAsync();
}
MessageBox.Show("New employee added successfully! :)");
}
catch (System.FormatException e1)
{
MainWindow.logger.Info("Error occured", e1);
MessageBox.Show("Incorrect data. Try again.");
}
}
