public static double giveHourSpan()
{
using (var db = new EmploeeContext())
{
return(db.workTimes.Where(x => x.WorkTimeId == 123).Select(u => u.Hours).FirstOrDefault());
}
}
public static DateTime giveBeginTime()
{
using (var db = new EmploeeContext())
{
return(db.workTimes.Where(x => x.WorkTimeId == 123).Select(u => u.BeginningTime).FirstOrDefault());
}
}
public static string giveEmail()
{
using (var db = new EmploeeContext())
{
return(db.employees.Where(x => x.Position == "tester").Select(u => u.Email).FirstOrDefault().ToString());
}
}
public static int givePhone()
{
using (var db = new EmploeeContext())
{
return(db.employees.Where(x => x.Position == "tester").Select(u => u.PhoneNumber).FirstOrDefault());
}
}
public static void setTestWorker()
{
using (var db = new EmploeeContext())
{
var emp = db.employees.Where(x => x.Position == "tester");
if (!emp.Any())
{
var actualMaxIdnumber = db.employees.DefaultIfEmpty().Max(x => x.EmployeeId);
var testEmp = new Employee {
EmployeeId = actualMaxIdnumber + 1, FirstName = "Jan", LastName = "Kowalski", Address = "Warszawa", Email = "*****@*****.**", PhoneNumber = 725321843, Position = "tester"
};
db.employees.Add(testEmp);
db.SaveChanges();
}
}
}
public static void setTestTime()
{
using (var db = new EmploeeContext())
{
var wt = db.workTimes.Where(x => x.WorkTimeId == 123);
if (!wt.Any())
{
DateTime begin = new DateTime(2020, 5, 10, 4, 0, 0);
DateTime end = new DateTime(2020, 5, 10, 12, 0, 0);
double hourSpan = (end - begin).TotalHours;
var workT = new WorkTime {
WorkTimeId = 123, BeginningTime = begin, EndTime = end, EmployeeId = 1, Hours = hourSpan
};
db.workTimes.Add(workT);
db.SaveChanges();
}
}
}
private void btnSubmit_Click(object sender, RoutedEventArgs e)
{
using (var db = new EmploeeContext())
{
var tempUser = db.employees.FirstOrDefault(x => x.FirstName == textEmpFirstName.Text && x.LastName == textEmpLastName.Text);
if (tempUser == null)
{
MainWindow.logger.Info("Incorrect login to system");
MessageBox.Show("Błąd! Nie ma takiego pracownika.");
}
else
{
acutalEmployeeId = tempUser.EmployeeId;
MainWindow.logger.Info("Correct login to system");
MessageBox.Show("Zalogowano pomyślnie");
MainWindow window = new MainWindow();
window.Show();
this.Close();
}
}
}
