public void DeletePasive(int id)
{
try
{
var StatusUpdate = FindById(id);
using (Context = new ProjectLineContext())
{
// StatusUpdate.StatusID = 0;
StatusUpdate.Active = false;
Context.Entry(StatusUpdate).State = EntityState.Modified;
Context.SaveChanges();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void Update(User User)
{
try
{
var update = FindById(User.UserID);
using (Context = new ProjectLineContext())
{
if (User.Password == "")
{
update.FirstName = User.FirstName;
update.LastName = User.LastName;
update.Email = User.Email;
update.Company = User.Company;
update.Address = User.Address;
update.Phone = User.Phone;
update.Mobile = User.Mobile;
update.Active = User.Active;
update.RoleID = User.RoleID;
}
else
{
update.FirstName = User.FirstName;
update.LastName = User.LastName;
update.Email = User.Email;
update.Company = User.Company;
update.Address = User.Address;
update.Phone = User.Phone;
update.Mobile = User.Mobile;
update.Password = HashPassword(User.Password);
update.Active = User.Active;
update.RoleID = User.RoleID;
}
Context.Entry(update).State = EntityState.Modified;
Context.SaveChanges();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void Update(Phase phase, ProjectLineContext context)
{
try
{
var update = FindById(phase.PhaseID, context);
update.Title = phase.Title;
update.Description = phase.Description;
update.StartDate = phase.StartDate;
update.EndDate = phase.EndDate;
update.DemoUrl = phase.DemoUrl;
update.DemoName = phase.DemoName;
context.Entry(update).State = EntityState.Modified;
context.SaveChanges();
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void Update(Role rol)
{
try
{
var update = FindById(rol.RoleID);
using (Context = new ProjectLineContext())
{
//update.Title = rol.Title;
update.Description = rol.Description;
Context.Entry(update).State = EntityState.Modified;
Context.SaveChanges();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
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);
}
}
public void Update(Phase phase)
{
try
{
var update = FindById(phase.PhaseID);
using (Context = new ProjectLineContext())
{
update.Title = phase.Title;
update.Description = phase.Description;
update.StartDate = phase.StartDate;
update.EndDate = phase.EndDate;
update.DemoUrl = phase.DemoUrl;
Context.Entry(update).State = EntityState.Modified;
Context.SaveChanges();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void Update(Objective objective)
{
try
{
var update = FindById(objective.ObjectiveID);
using (Context = new ProjectLineContext())
{
update.Title = objective.Title;
update.Description = objective.Description;
update.Completed = objective.Completed;
update.Weight = objective.Weight;
update.Estimated = objective.Estimated;
update.Effort = objective.Effort;
Context.Entry(update).State = EntityState.Modified;
Context.SaveChanges();
}
}
catch (Exception ex)
{
Console.Write(ex);
}
}
