static void Main(string[] args)
{
SoftUniEntities dbo = new SoftUniEntities();
Employee firstEmp = new Employee()
{
EmployeeID = 329,
FirstName = "Aleks",
LastName = "Aleksieva",
AddressID = 3,
DepartmentID = 5,
JobTitle = "Neshto si",
Salary = 600,
HireDate = DateTime.Now.AddDays(10)
};
DAO.Insert(firstEmp);
Employee empToModifyOrDelete = dbo.Employees.Where(x => x.FirstName == "Aleks").FirstOrDefault();
Employee e = DAO.FindByKey(205);
Console.WriteLine(e);
DAO.Modify(empToModifyOrDelete);
DAO.Delete(empToModifyOrDelete, dbo);
}
public static Employee FindByKey(Object key)
{
SoftUniEntities dbe = new SoftUniEntities();
Employee e = dbe.Employees.Find(key);
return e;
}
public static void Delete(Employee e,SoftUniEntities db)
{
if (e != null)
{
db.Employees.Remove(e);
db.SaveChanges();
Console.WriteLine("Succesfully deleted " + e.FirstName);
}
}
public static void Modify(Employee e)
{
SoftUniEntities db = new SoftUniEntities();
var employee = db.Employees.Find(e.EmployeeID);
employee.FirstName = "Modify";
employee.LastName = "Made";
db.SaveChanges();
}
public static void Insert(Employee e)
{
SoftUniEntities db = new SoftUniEntities();
db.Employees.Add(e);
db.SaveChanges();
}
