public static Project AddProject(string projectName, DateTime startDate, DateTime endDate, ICollection <Employee> employees) { SoftUniEntities db = new SoftUniEntities(); DbContextTransaction newProjectTransaction = db.Database.BeginTransaction(); Project newProject = new Project(); try { newProject.Name = projectName; newProject.StartDate = startDate; newProject.EndDate = endDate; newProject.Employees = employees; newProject = db.Projects.Add(newProject); db.SaveChanges(); newProjectTransaction.Commit(); } catch (Exception ex) { newProjectTransaction.Rollback(); } return(newProject); }
public static int InsertEmployee(Employee employee) { db.Employees.Add(employee); db.SaveChanges(); return(employee.EmployeeID); }