public static void Modify(
Employee employee,
string firstName,
string middleName,
string lastName,
string jobTitle,
int departmentId,
int? managerId,
DateTime hireDate,
decimal salary,
int? addressId)
{
employee.FirstName = firstName;
employee.MiddleName = middleName;
employee.LastName = lastName;
employee.JobTitle = jobTitle;
employee.DepartmentID = departmentId;
if (managerId != null)
{
employee.ManagerID = managerId;
}
employee.HireDate = hireDate;
employee.Salary = salary;
if (addressId != null)
{
employee.AddressID = addressId;
}
Db.SaveChanges();
}
public static void Main()
{
Employee employee = new Employee()
{
FirstName = "Mincho",
MiddleName = "Georgiev",
LastName = "Dimitrov",
JobTitle = "Some job",
DepartmentID = 13,
ManagerID = 33,
HireDate = DateTime.Now.AddYears(-2),
Salary = 9999,
AddressID = 133
};
// 01. Insert an employee
EmployeeDao.Add(employee);
// 02. Print his/her primary key generated by the DB
Console.WriteLine(employee.EmployeeID);
// 03. Changes the employee first name and saves it to the database
EmployeeDao.Modify(
employee,
"Georgi",
"Petrov",
"Mihajlov",
"Driver",
5,
null,
DateTime.Now.AddDays(-30),
3333,
null);
Console.WriteLine(employee.FirstName + " " + employee.MiddleName + " " +
employee.LastName + ", job: " + employee.JobTitle);
// other tests:
Employee emp = EmployeeDao.FindByKey(294);
Console.WriteLine(emp.EmployeeID + " " + emp.FirstName + " " + emp.MiddleName + " " +
emp.LastName + ", job: " + emp.JobTitle);
EmployeeDao.Delete(emp);
Employee deletedEmp = EmployeeDao.FindByKey(294);
if (deletedEmp == null)
{
Console.WriteLine("Employee with ID 294, is deleted");
}
}
public static void Delete(Employee employee)
{
Db.Employees.Remove(employee);
Db.SaveChanges();
}
public static void Add(Employee employee)
{
Db.Employees.Add(employee);
Db.SaveChanges();
}
