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());
}
}
public static void LoadDataBase()
{
Console.WriteLine("Projects.LoadDataBase");
try
{
using (var Neo = new NeoTrackerDbEntities())
using (var Ice = new Ice_Project_TrackerEntities())
{
var list = Ice.PT_Master.ToList();
foreach (var i in list)
{
Project p = new Project()
{
Name = i.Project_Name,
Comment = i.Notes,
Code = i.Project_Tracker_Number,
ProjectTypeID = Neo.ProjectTypes.FirstOrDefault(x => x.Name == i.Open_Or_Closed).ProjectTypeID,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
CreatedBy = "SYS",
IsActive = true,
UpdatedBy = "SYS"
};
GetProjectItems(p);
Neo.Projects.Add(p);
}
Neo.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
}
}
public static void ResetDb()
{
Console.WriteLine("Maintenance.ResetDb");
try
{
using (var Neo = new NeoTrackerDbEntities())
{
//project
Neo.Database.ExecuteSqlCommand(" DELETE FROM Event ");
Neo.Database.ExecuteSqlCommand(" DELETE FROM Operation ");
Neo.Database.ExecuteSqlCommand(" DELETE FROM Item ");
Neo.Database.ExecuteSqlCommand(" DELETE FROM Project ");
//admin
Neo.Database.ExecuteSqlCommand(" DELETE FROM DepartmentUSer ");
Neo.Database.ExecuteSqlCommand(" DELETE FROM DepartmentOperation ");
Neo.Database.ExecuteSqlCommand(" DELETE FROM [User] ");
Neo.Database.ExecuteSqlCommand(" DELETE FROM Department ");
Neo.Database.ExecuteSqlCommand(" DELETE FROM EventType ");
Neo.Database.ExecuteSqlCommand(" DELETE FROM Status ");
Neo.Database.ExecuteSqlCommand(" DELETE FROM ProjectType ");
Neo.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
}
}
public static void LoadUsers()
{
Console.WriteLine("Admin.LoadUsers");
try
{
using (var Neo = new NeoTrackerDbEntities())
using (var Ice = new Ice_Project_TrackerEntities())
{
var list = Ice.PT_User.ToList();
foreach (var i in list)
{
Neo.Users.Add(new User()
{
FirstName = i.First_Name,
LastName = i.Last_Name,
Email = i.Email_Address,
EmailNotifications = i.Receive_Via_Email == "YES",
IsAdmin = false,
Alias = i.PT_User1,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
CreatedBy = "SYS",
IsActive = true,
UpdatedBy = "SYS"
});
}
Neo.Users.Add(new User()
{
Alias = "kmercier",
Email = "*****@*****.**",
EmailNotifications = true,
IsAdmin = true,
FirstName = "Karrick",
LastName = "Mercier",
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
CreatedBy = "SYS",
IsActive = true,
UpdatedBy = "SYS"
});
Neo.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
}
}
public static void LoadEventTypes()
{
Console.WriteLine("Admin.LoadEventTypes");
try
{
using (var Neo = new NeoTrackerDbEntities())
{
var list = GetLists.GetEventTypes();
Neo.EventTypes.AddRange(list);
Neo.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
}
}
public static void LoadUserDepartments()
{
Console.WriteLine("Admin.LoadUserDepartments");
try
{
using (var Neo = new NeoTrackerDbEntities())
using (var Ice = new Ice_Project_TrackerEntities())
{
var list = (from d in Ice.PT_User_Department
join department in Ice.PT_Department on d.Department_Key equals department.Department_Key
select new
{
department.Dept_Order,
d.PT_User
}).ToList();
foreach (var i in list)
{
var department = Neo.Departments.FirstOrDefault(x => x.SortOrder == i.Dept_Order);
var user = Neo.Users.FirstOrDefault(x => x.Alias == i.PT_User);
if (department != null && user != null)
{
Neo.DepartmentUsers.Add(new DepartmentUser()
{
DepartmentID = department.DepartmentID,
UserID = user.UserID,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
CreatedBy = "SYS",
IsActive = true,
UpdatedBy = "SYS"
});
}
}
Neo.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
}
}
public static void LoadDepartments()
{
Console.WriteLine("Admin.LoadDepartments");
try
{
using (var Neo = new NeoTrackerDbEntities())
using (var Ice = new Ice_Project_TrackerEntities())
{
var list = Ice.PT_Department.ToList();
foreach (var i in list)
{
Department d = new Department()
{
Name = i.Department_Name,
SortOrder = i.Dept_Order,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
CreatedBy = "SYS",
IsActive = true,
UpdatedBy = "SYS",
DepartmentOperations = new List <DepartmentOperation>(),
};
if (i.Department_Name.Equals("Production"))
{
d.DepartmentOperations = GetLists.GetDepartmentOperations();
}
Neo.Departments.Add(d);
}
Neo.SaveChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
}
}
public static void GetItemOperations(Item item, string Order)
{
try
{
using (var Neo = new NeoTrackerDbEntities())
using (var Ice = new Ice_Project_TrackerEntities())
{
var departments = Neo.Departments.ToList();
var temp = (from o in Ice.PT_Project_SalesOrder_Part.Where(x => x.Sales_Order_Key == Order && x.Part.Equals(item.Code))
join d in Ice.PT_Department on o.Department_Key equals d.Department_Key
select new { o, d }
).ToList();
var list = temp.Select(x => new Operation()
{
DepartmentID = departments.First(y => y.SortOrder == x.d.Dept_Order).DepartmentID,
Name = x.d.Department_Name,
SortOrder = x.d.Dept_Order,
EndDate = DateTime.ParseExact(x.o.End_Date.ToString(), "yyyyMMdd", CultureInfo.InvariantCulture),
IsActive = true,
IsCompleted = x.o.Completed_Yes_No.Equals("Yes"),
OperationTime = x.o.Plan_Hrs,
StartDate = DateTime.ParseExact(x.o.Start_Date.ToString(), "yyyyMMdd", CultureInfo.InvariantCulture),
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
CreatedBy = "SYS",
UpdatedBy = "SYS",
});
item.Operations = list.ToList();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message.ToString());
}
}
