private static int? CreateProject(string projectName, string description, IEnumerable<Employee> projectMembers)
{
using (var context = new SoftUniContext())
{
if (context.Projects.FirstOrDefault(p => p.Name == projectName) == null)
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var project = new Project()
{
Name = projectName,
Description = description,
StartDate = DateTime.Now,
};
foreach (var member in projectMembers)
{
context.Entry(member).State = EntityState.Unchanged;
project.Employees.Add(member);
}
context.Projects.Add(project);
context.SaveChanges();
transaction.Commit();
return project.ProjectID;
}
catch (Exception)
{
transaction.Rollback();
}
}
}
}
return null;
}
