public static void RemoveEmployee(string name) { using (var db = new SoftUniEntities()) { var customer = db.Employees.Where(x => x.FirstName == name).FirstOrDefault<Employee>(); db.Employees.Remove(customer); db.SaveChanges(); } }
public static void ModifyEmployee(string firstName, string newFirstName) { using (var db = new SoftUniEntities()) { Employee employee = db.Employees.Where(x => x.FirstName == firstName).FirstOrDefault<Employee>(); employee.FirstName = newFirstName; db.SaveChanges(); } }
public static void InsertProject(string name, string description, DateTime startDate) { using( var db = new SoftUniEntities()) { Project newProject = new Project() { Name = name, Description = description, StartDate = startDate }; db.Projects.Add(newProject); db.SaveChanges(); } }
static void Main(string[] args) { SoftUniEntities dbOne = new SoftUniEntities(); SoftUniEntities1 dbTwo = new SoftUniEntities1(); var empOne = dbOne.Employees.Where(e => e.DepartmentID == 1).ToArray(); var empTwo = dbOne.Employees.Where(e => e.DepartmentID == 1).ToArray(); for (int i = 0; i < empOne.Length; i++) { empOne[i].FirstName = "Huhum"; empTwo[i].FirstName = "Zazum"; } dbOne.SaveChanges(); dbTwo.SaveChanges(); }
public static void InsertEmployee(string firstName, string lastName, string jobTitle, string departmentName, DateTime hireDate, decimal salary) { using (var db = new SoftUniEntities()) { var employee = new Employee() { FirstName = firstName, LastName = lastName, JobTitle = jobTitle, DepartmentID = db.Departments .Where(d => d.Name == departmentName) .FirstOrDefault().DepartmentID, HireDate = hireDate, Salary = salary }; db.Employees.Add(employee); db.SaveChanges(); } }