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 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 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());
}
}
