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