public static void UpdateProjectHeader()
{
Console.WriteLine("Projects.LoadDataBase");
try
{
using (var Neo = new NeoTrackerDbEntities())
using (var Genius = new IVCLIVEDBEntities())
{
var list = Neo.Projects.ToList();
foreach (var i in list)
{
var order = Genius.Comms.FirstOrDefault(x => x.No_Com == i.Code);
i.Client = order.Fact_A1;
i.PurchaseOrder = order.No_Po;
Neo.Entry(i).State = EntityState.Modified;
}
Neo.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
}
}
public static void GetProjectItems(Project Project)
{
try
{
using (var Neo = new NeoTrackerDbEntities())
using (var Genius = new IVCLIVEDBEntities())
{
var StatusCreatedID = Neo.Status.First(x => x.Name == "Created").StatusID;
var StatusCompletedID = Neo.Status.First(x => x.Name == "Completed").StatusID;
var list = Genius.Comm2.Where(x => x.No_Com == Project.Code).Select(x => new Item()
{
Code = x.Item,
DueDate = x.Dateliv,
IsActive = true,
Name = x.Des,
SortKey = x.Clef,
SortOrder = x.Ligneitm,
StatusID = x.DateClient < DateTime.Now ? StatusCompletedID : StatusCreatedID,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
CreatedBy = "SYS",
UpdatedBy = "SYS"
}).ToList();
list.ForEach(x => GetItemOperations(x, Project.Code));
Project.Items = list;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
}
}