/// <summary>
/// dodanie pracownika do bazy danych
/// </summary>
public void AddEmployee(Models.Employee employee)
{
using (DatabaseEntities1 context = new DatabaseEntities1())
{
context.Employees.Add(new Employee
{
FirstName = employee.FirstName,
LastName = employee.LastName,
Mail = employee.Mail,
PhoneOffice = employee.OfficePhone,
PhoneMobile = employee.MobilePhone,
Position = employee.Position,
Salary = employee.Salary,
EmploymentDate = employee.EmploymentDate
});
context.SaveChanges();
}
}
/// <summary>
/// edycja danych pracownika
/// </summary>
public void UpdateEmployee(Models.Employee employee)
{
using (DatabaseEntities1 context = new DatabaseEntities1())
{
var employeeToUpdate = from u in context.Employees where u.Id == employee.Id select u;
if (employeeToUpdate != null)
{
foreach (var i in employeeToUpdate)
{
i.FirstName = employee.FirstName;
i.LastName = employee.LastName;
i.PhoneMobile = employee.MobilePhone;
i.PhoneOffice = employee.OfficePhone;
i.Mail = employee.Mail;
i.Position = employee.Position;
i.Salary = employee.Salary;
i.EmploymentDate = employee.EmploymentDate;
}
context.SaveChanges();
}
}
}
/// <summary>
/// odczytanie danych pracowników z bazy i zapis do listy
/// </summary>
public List<Models.Employee> GetEmployees()
{
List<Models.Employee> employees = new List<Models.Employee>();
using (DatabaseEntities1 context = new DatabaseEntities1())
{
var temp = context.Employees.ToList();
foreach (var i in temp)
{
Models.Employee employee = new Models.Employee();
employee.FirstName = i.FirstName;
employee.LastName = i.LastName;
employee.Mail = i.Mail;
employee.OfficePhone = i.PhoneOffice;
employee.MobilePhone = i.PhoneMobile;
employee.Position = i.Position;
employee.Salary = i.Salary;
employee.EmploymentDate = i.EmploymentDate;
employee.Id = i.Id;
employees.Add(employee);
}
}
return employees;
}
/// <summary>
/// usunięcie pracownika z bazy danych
/// </summary>
public void DeleteEmployee(Models.Employee employee)
{
using (DatabaseEntities1 context = new DatabaseEntities1())
{
var employeeToDelete = (from d in context.Employees where d.Id == employee.Id select d).FirstOrDefault();
if (employeeToDelete != null)
{
context.Employees.Remove(employeeToDelete);
context.SaveChanges();
}
}
}