public void Create(Project project)
{
try
{
using (var Trans = Context.Database.BeginTransaction())
{
try
{
Context.Projects.Add(project);
Context.SaveChanges();
var id = Context.Projects.OrderByDescending(i => i.ProjectID).First().ProjectID;
AddOrUpdatePhases(project, id, Context);
Context.SaveChanges();
Trans.Commit();
}
catch (Exception ex)
{
Console.Write(ex);
Trans.Rollback();
}
}
}
catch (Exception ex)
{
Console.Write(ex);
}
Context.Dispose();
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
public void Update(Project project)
{
try
{
var context = new ProjectLineContext();
using (var Trans = context.Database.BeginTransaction())
{
try
{
//Get Project of the DB
var update = FindById(project.ProjectID);
DeletePhasesExistens(update, project, context);
//Update Project Data
update.Title = project.Title;
update.Description = project.Description;
update.StartDate = project.StartDate;
update.EndDate = project.EndDate;
update.UserID = project.UserID;
update.OwnerID = project.OwnerID;
context.Entry(update).State = EntityState.Modified;
context.SaveChanges();
AddOrUpdatePhases(project, update.ProjectID, context);
Trans.Commit();
}
catch (Exception ex)
{
Console.Write(ex);
Trans.Rollback();
}
}
context.Dispose();
}
catch (Exception ex)
{
Console.Write(ex);
}
}