public static void LoadList(frmListProjects frmListProjects)
{
using (var _context = new DBLabManagementEntities())
{
var project = _context.Projects.Where(x => x.IDLab == mainController.Lab.IDLab).OrderBy(x => x.StartDate);
foreach (Project p in project)
{
AddurcProject(p, frmListProjects);
}
}
}
public static void Update(Project project, frmListProjects frm, urcProject urc)
{
using (var _context = new DBLabManagementEntities())
{
_context.Projects.AddOrUpdate(project);
_context.SaveChanges();
if (urc != null)
{
urc.Dispose();
}
AddurcProject(project, frm);
}
}
private static void AddurcProject(Project project, frmListProjects frm)
{
if (project.Status.Trim() == "0")
{
frm.AddToDo(project);
}
else
if (project.Status.Trim() == "1")
{
frm.AddDoing(project);
}
else
{
frm.AddComplete(project);
}
}
public static void Add(Project project, frmListProjects frm)
{
using (var _context = new DBLabManagementEntities())
{
var Ids = (from t in _context.Projects select t.IDProject).ToList();
for (int i = 1; i <= _context.Projects.Count() + 1; i++)
{
if (!Ids.Contains(i))
{
project.IDProject = i;
break;
}
}
project.IDLab = mainController.Lab.IDLab;
_context.Projects.Add(project);
_context.SaveChanges();
_project = _context.Projects.FirstOrDefault(x => x.IDProject == project.IDProject);
AddurcProject(project, frm);
}
}
