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);
        }
Exemple #2
0
 public static int InsertEmployee(Employee employee)
 {
     db.Employees.Add(employee);
     db.SaveChanges();
     return(employee.EmployeeID);
 }