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 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(); }