public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.Manufacture.Any()) { return; // DB has been seeded } context.Manufacture.AddRange( new Manufacture { Quantity = 7, Date = DateTime.Parse("2020-8-19"), ProductID = 3, EmployeeID = 3, //CompanyID = 1 } ); context.Manufacture.AddRange( new Manufacture { Quantity = 5, Date = DateTime.Parse("2020-9-19"), ProductID = 5, EmployeeID = 2, // CompanyID = 2 } ); context.Manufacture.AddRange( new Manufacture { Quantity = 6, Date = DateTime.Parse("2020-9-19"), ProductID = 4, EmployeeID = 5, // CompanyID = 1 } ); context.Manufacture.AddRange( new Manufacture { Quantity = 6, Date = DateTime.Parse("2020-10-19"), ProductID = 3, EmployeeID = 8, //CompanyID = 2 } ); context.Manufacture.AddRange( new Manufacture { Quantity = 5, Date = DateTime.Parse("2020-11-19"), ProductID = 2, EmployeeID = 15, //CompanyID = 1 } ); context.Manufacture.AddRange( new Manufacture { Quantity = 4, Date = DateTime.Parse("2020-12-19"), ProductID = 1, EmployeeID = 20, //CompanyID = 1 } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { if (context.GradeHistory.Any()) { return; } context.GradeHistory.AddRange( new GradeHistory { GrahAllPoint = 0, Count = 1, GrahRound1 = 0, GrahRound2 = 0, GrahRound3 = 0, GrahYear = "2562", GrahBonusUp = 10000, GrahSalaryUp = 25000, } ); context.GradeHistory.AddRange( new GradeHistory { GrahAllPoint = 3, Count = 2, GrahRound1 = 3, GrahRound2 = 3, GrahRound3 = 3, GrahYear = "2562", GrahBonusUp = 5000, GrahSalaryUp = 2000, } ); context.GradeHistory.AddRange( new GradeHistory { GrahAllPoint = 5, Count = 2, GrahRound1 = 4, GrahRound2 = 4, GrahRound3 = 4, GrahYear = "2562", GrahBonusUp = 10000, GrahSalaryUp = 25000, } ); context.GradeHistory.AddRange( new GradeHistory { GrahAllPoint = 4, Count = 1, GrahRound1 = 4, GrahRound2 = 4, GrahRound3 = 4, GrahYear = "2562", GrahBonusUp = 10000, GrahSalaryUp = 25000, } ); context.GradeHistory.AddRange( new GradeHistory { GrahAllPoint = 3, Count = 1, GrahRound1 = 3, GrahRound2 = 3, GrahRound3 = 3, GrahYear = "2562", GrahBonusUp = 10000, GrahSalaryUp = 25000, } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { if (context.Project_Product.Any()) { return; // DB has been seeded } context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 1, ProjectID = 1 } ); context.Project_Product.AddRange( new Project_Product { Qty = 15, ProductID = 2, ProjectID = 1 } ); context.Project_Product.AddRange( new Project_Product { Qty = 20, ProductID = 3, ProjectID = 1 } ); context.Project_Product.AddRange( new Project_Product { Qty = 5, ProductID = 4, ProjectID = 1 } ); context.Project_Product.AddRange( new Project_Product { Qty = 15, ProductID = 5, ProjectID = 2 } ); context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 1, ProjectID = 2 } ); context.Project_Product.AddRange( new Project_Product { Qty = 15, ProductID = 2, ProjectID = 2 } ); context.Project_Product.AddRange( new Project_Product { Qty = 5, ProductID = 3, ProjectID = 2 } ); context.Project_Product.AddRange( new Project_Product { Qty = 20, ProductID = 4, ProjectID = 3 } ); context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 5, ProjectID = 3 } ); context.Project_Product.AddRange( new Project_Product { Qty = 20, ProductID = 1, ProjectID = 3 } ); context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 2, ProjectID = 3 } ); context.Project_Product.AddRange( new Project_Product { Qty = 20, ProductID = 3, ProjectID = 3 } ); context.Project_Product.AddRange( new Project_Product { Qty = 5, ProductID = 4, ProjectID = 4 } ); context.Project_Product.AddRange( new Project_Product { Qty = 15, ProductID = 5, ProjectID = 4 } ); context.Project_Product.AddRange( new Project_Product { Qty = 5, ProductID = 1, ProjectID = 4 } ); context.Project_Product.AddRange( new Project_Product { Qty = 15, ProductID = 2, ProjectID = 4 } ); context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 3, ProjectID = 5 } ); context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 4, ProjectID = 5 } ); context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 5, ProjectID = 5 } ); context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 1, ProjectID = 5 } ); context.Project_Product.AddRange( new Project_Product { Qty = 15, ProductID = 2, ProjectID = 6 } ); context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 3, ProjectID = 6 } ); context.Project_Product.AddRange( new Project_Product { Qty = 15, ProductID = 4, ProjectID = 6 } ); context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 5, ProjectID = 7 } ); context.Project_Product.AddRange( new Project_Product { Qty = 20, ProductID = 1, ProjectID = 7 } ); context.Project_Product.AddRange( new Project_Product { Qty = 10, ProductID = 2, ProjectID = 7 } ); context.Project_Product.AddRange( new Project_Product { Qty = 20, ProductID = 3, ProjectID = 7 } ); context.Project_Product.AddRange( new Project_Product { Qty = 5, ProductID = 4, ProjectID = 8 } ); context.Project_Product.AddRange( new Project_Product { Qty = 5, ProductID = 5, ProjectID = 8 } ); context.Project_Product.AddRange( new Project_Product { Qty = 5, ProductID = 1, ProjectID = 8 } ); context.Project_Product.AddRange( new Project_Product { Qty = 15, ProductID = 2, ProjectID = 8 } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.Order_Product.Any()) { return; // DB has been seeded } context.Order_Product.AddRange( new Order_Product { Qty = 10, // Price = 1990, ProductID = 1, OrderID = 1 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, // Price = 1200, ProductID = 1, OrderID = 2 } ); context.Order_Product.AddRange( new Order_Product { Qty = 20, // Price = 2000, ProductID = 2, OrderID = 3 } ); context.Order_Product.AddRange( new Order_Product { Qty = 5, // Price = 2100, ProductID = 2, OrderID = 4 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, // Price = 2200, ProductID = 3, OrderID = 5 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, //Price = 3700, ProductID = 3, OrderID = 6 } ); context.Order_Product.AddRange( new Order_Product { Qty = 20, // Price = 4000, ProductID = 4, OrderID = 7 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, //Price = 3200, ProductID = 4, OrderID = 8 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, //Price = 3100, ProductID = 5, OrderID = 9 } ); context.Order_Product.AddRange( new Order_Product { Qty = 5, // Price = 2500, ProductID = 5, OrderID = 10 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, // Price = 1990, ProductID = 1, OrderID = 11 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, //Price = 1200, ProductID = 2, OrderID = 12 } ); context.Order_Product.AddRange( new Order_Product { Qty = 20, //Price = 2000, ProductID = 3, OrderID = 13 } ); context.Order_Product.AddRange( new Order_Product { Qty = 5, //Price = 2100, ProductID = 4, OrderID = 14 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, //Price = 2200, ProductID = 5, OrderID = 15 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, //Price = 3700, ProductID = 1, OrderID = 16 } ); context.Order_Product.AddRange( new Order_Product { Qty = 20, //Price = 4000, ProductID = 1, OrderID = 17 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, //Price = 3200, ProductID = 1, OrderID = 18 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, //Price = 3100, ProductID = 2, OrderID = 19 } ); context.Order_Product.AddRange( new Order_Product { Qty = 5, // Price = 2500, ProductID = 2, OrderID = 20 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, //Price = 1990, ProductID = 2, OrderID = 21 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, //Price = 1200, ProductID = 3, OrderID = 22 } ); context.Order_Product.AddRange( new Order_Product { Qty = 20, //Price = 2000, ProductID = 3, OrderID = 23 } ); context.Order_Product.AddRange( new Order_Product { Qty = 5, //Price = 2100, ProductID = 3, OrderID = 24 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, // Price = 2200, ProductID = 4, OrderID = 25 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, //Price = 3700, ProductID = 4, OrderID = 26 } ); context.Order_Product.AddRange( new Order_Product { Qty = 20, //Price = 4000, ProductID = 4, OrderID = 27 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, //Price = 3200, ProductID = 5, OrderID = 28 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, //Price = 3100, ProductID = 5, OrderID = 29 } ); context.Order_Product.AddRange( new Order_Product { Qty = 5, // Price = 2500, ProductID = 5, OrderID = 30 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, //Price = 1990, ProductID = 1, OrderID = 1 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, //Price = 1200, ProductID = 1, OrderID = 2 } ); context.Order_Product.AddRange( new Order_Product { Qty = 20, //Price = 2000, ProductID = 2, OrderID = 3 } ); context.Order_Product.AddRange( new Order_Product { Qty = 5, //Price = 2100, ProductID = 2, OrderID = 4 } ); context.Order_Product.AddRange( new Order_Product { Qty = 4, //Price = 2200, ProductID = 3, OrderID = 5 } ); context.Order_Product.AddRange( new Order_Product { Qty = 11, // Price = 3700, ProductID = 3, OrderID = 6 } ); context.Order_Product.AddRange( new Order_Product { Qty = 16, //Price = 4000, ProductID = 4, OrderID = 7 } ); context.Order_Product.AddRange( new Order_Product { Qty = 12, //Price = 3200, ProductID = 4, OrderID = 8 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, //Price = 3100, ProductID = 5, OrderID = 9 } ); context.Order_Product.AddRange( new Order_Product { Qty = 9, //Price = 2500, ProductID = 5, OrderID = 10 } ); context.Order_Product.AddRange( new Order_Product { Qty = 13, //Price = 1990, ProductID = 1, OrderID = 11 } ); context.Order_Product.AddRange( new Order_Product { Qty = 13, //Price = 1200, ProductID = 2, OrderID = 12 } ); context.Order_Product.AddRange( new Order_Product { Qty = 18, //Price = 2000, ProductID = 3, OrderID = 13 } ); context.Order_Product.AddRange( new Order_Product { Qty = 8, // Price = 2100, ProductID = 4, OrderID = 14 } ); context.Order_Product.AddRange( new Order_Product { Qty = 11, //Price = 2200, ProductID = 5, OrderID = 15 } ); context.Order_Product.AddRange( new Order_Product { Qty = 114, // Price = 3700, ProductID = 1, OrderID = 16 } ); context.Order_Product.AddRange( new Order_Product { Qty = 19, // Price = 4000, ProductID = 1, OrderID = 17 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, //Price = 3200, ProductID = 1, OrderID = 18 } ); context.Order_Product.AddRange( new Order_Product { Qty = 11, //Price = 3100, ProductID = 2, OrderID = 19 } ); context.Order_Product.AddRange( new Order_Product { Qty = 6, //Price = 2500, ProductID = 2, OrderID = 20 } ); context.Order_Product.AddRange( new Order_Product { Qty = 10, // Price = 1990, ProductID = 2, OrderID = 21 } ); context.Order_Product.AddRange( new Order_Product { Qty = 15, // Price = 1200, ProductID = 3, OrderID = 22 } ); context.Order_Product.AddRange( new Order_Product { Qty = 20, //Price = 2000, ProductID = 3, OrderID = 23 } ); context.Order_Product.AddRange( new Order_Product { Qty = 5, // Price = 2100, ProductID = 3, OrderID = 24 } ); context.Order_Product.AddRange( new Order_Product { Qty = 12, // Price = 2200, ProductID = 4, OrderID = 25 } ); context.Order_Product.AddRange( new Order_Product { Qty = 12, //Price = 3700, ProductID = 4, OrderID = 26 } ); context.Order_Product.AddRange( new Order_Product { Qty = 6, // Price = 4000, ProductID = 4, OrderID = 27 } ); context.Order_Product.AddRange( new Order_Product { Qty = 12, //Price = 3200, ProductID = 5, OrderID = 28 } ); context.Order_Product.AddRange( new Order_Product { Qty = 12, //Price = 3100, ProductID = 5, OrderID = 29 } ); context.Order_Product.AddRange( new Order_Product { Qty = 3, //Price = 2500, ProductID = 5, OrderID = 30 } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.Product.Any()) { return; // DB has been seeded } context.Product.AddRange( new Product { Name = "Hydraulic cylinder", //Stock = 100, CostPrice = 1500, SellingPrice = 2000, Status = "Manufacture", PartnersID = 1, } ); context.Product.AddRange( new Product { Name = "Shock absorber", //Stock = 100, CostPrice = 2500, SellingPrice = 3000, Status = "Manufacture", PartnersID = 2, } ); context.Product.AddRange( new Product { Name = "Brake cylinder", //Stock = 100, CostPrice = 1000, SellingPrice = 1500, Status = "Manufacture", PartnersID = 3, } ); context.Product.AddRange( new Product { Name = "Caliper", //Stock = 100, CostPrice = 500, SellingPrice = 1000, Status = "Manufacture", PartnersID = 4, } ); context.Product.AddRange( new Product { Name = "Disc brakes", //Stock = 100, CostPrice = 2000, SellingPrice = 2500, Status = "Manufacture", PartnersID = 5, } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.Safety.Any()) { return; // DB has been seeded } context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-1-1"), incident = 4, Total_Incident = 5 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-2-1"), incident = 2, Total_Incident = 7 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-3-1"), incident = 2, Total_Incident = 1 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-4-1"), incident = 0, Total_Incident = 1 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-5-1"), incident = 2, Total_Incident = 2 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-6-1"), incident = 1, Total_Incident = 6 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-7-1"), incident = 3, Total_Incident = 4 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-8-1"), incident = 2, Total_Incident = 5 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-9-1"), incident = 5, Total_Incident = 2 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-10-1"), incident = 4, Total_Incident = 3 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-11-1"), incident = 3, Total_Incident = 4 } ); context.Safety.AddRange( new Safety { DateIncident = DateTime.Parse("2020-12-1"), incident = 1, Total_Incident = 5 } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.Department.Any()) { return; // DB has been seeded } context.Department.AddRange( new Department { DepartmentName = "Information Technology", Image = "null", Status = "open" } ); context.Department.AddRange( new Department { DepartmentName = "Production Department", Image = "null", Status = "open" } ); context.Department.AddRange( new Department { DepartmentName = "Sales Department", Image = "null", Status = "open" } ); context.Department.AddRange( new Department { DepartmentName = "Accounting Department", Image = "null", Status = "open" } ); context.Department.AddRange( new Department { DepartmentName = "Human Resource", Image = "null", Status = "open" } ); /*---------------------------------*/ context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.EmployeeType.Any()) { return; // DB has been seeded } context.Position.AddRange( new Position { PositionName = "admin" } ); context.Position.AddRange( new Position { PositionName = "Manager" } ); context.Position.AddRange( new Position { PositionName = "Employee" } ); context.Position.AddRange( new Position { PositionName = "CEO" } ); /* ---------------------------------*/ context.EmployeeType.AddRange( new EmployeeType { EmployeeTypeName = "Full Time" } ); context.EmployeeType.AddRange( new EmployeeType { EmployeeTypeName = "Part Time" } ); /*---------------------------------*/ /*---------------------------------*/ context.Department.AddRange( new Department { DepartmentName = "Information Technology", Image = "null", Status = "open" } ); context.Department.AddRange( new Department { DepartmentName = "Production Department", Image = "null", Status = "open" } ); context.Department.AddRange( new Department { DepartmentName = "Sales Department", Image = "null", Status = "open" } ); context.Department.AddRange( new Department { DepartmentName = "Accounting Department", Image = "null", Status = "open" } ); context.Department.AddRange( new Department { DepartmentName = "Human Resource", Image = "null", Status = "open" } ); /*---------------------------------*/ context.Company.AddRange( new Company { CompanyName = "Tbkk", Image = "null", Status = "open" } ); context.SaveChanges(); /*---------------------------------*/ } using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.Login.Any()) { return; // DB has been seeded } /*---------------------------------*/ context.Employee.AddRange( new Employee { FirstName = "Charlotte", LastName = "Daisy", Address = "London", Telephone = "0632158475", Salary = 16000, Email = "*****@*****.**", Age = 23, Birthday = DateTime.Parse("2539-3-2"), Status = "Working", Date_of_employment = DateTime.Parse("2562-3-2"), Gender = "male", Employee_CompanyID = 1, Employee_DepartmentID = 1, Employee_EmployeeTypeID = 1, Employee_PositionID = 1 } ); context.Employee.AddRange( new Employee { FirstName = "Chloe", LastName = "Ella", Address = "Gloucester", Telephone = "0621453339", Salary = 15000, Email = "*****@*****.**", Age = 31, Birthday = DateTime.Parse("2531-3-21"), Status = "Working", Date_of_employment = DateTime.Parse("2561-3-2"), Gender = "female", Employee_CompanyID = 1, Employee_DepartmentID = 2, Employee_EmployeeTypeID = 2, Employee_PositionID = 2 } ); /*---------------------------------*/ context.Login.AddRange( new Login { Username = "******", Password = "******", Login_EmployeeID = 1 } ); /*+++++++++++++++++++++++++++++++++++++++++++*/ context.Login.AddRange( new Login { Username = "******", Password = "******", Login_EmployeeID = 2 } ); /*+++++++++++++++++++++++++++++++++++++++++++*/ context.SaveChanges(); } using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.GradeHistory.Any()) { return; // DB has been seeded } context.GradeHistory.AddRange( new GradeHistory { GrahAllPoint = 4, Count = 1, GrahRound1 = 4, GrahRound2 = 4, GrahRound3 = 4, GrahYear = "2562", GrahBonusUp = 10000, GrahSalaryUp = 25000, } ); context.GradeHistory.AddRange( new GradeHistory { GrahAllPoint = 3, Count = 2, GrahRound1 = 3, GrahRound2 = 3, GrahRound3 = 3, GrahYear = "2562", GrahBonusUp = 5000, GrahSalaryUp = 2000, } ); context.GradeHistory.AddRange( new GradeHistory { GrahAllPoint = 5, Count = 2, GrahRound1 = 4, GrahRound2 = 4, GrahRound3 = 4, GrahYear = "2562", GrahBonusUp = 10000, GrahSalaryUp = 25000, } ); context.GradeHistory.AddRange( new GradeHistory { GrahAllPoint = 4, Count = 1, GrahRound1 = 4, GrahRound2 = 4, GrahRound3 = 4, GrahYear = "2562", GrahBonusUp = 10000, GrahSalaryUp = 25000, } ); context.GradeHistory.AddRange( new GradeHistory { GrahAllPoint = 3, Count = 1, GrahRound1 = 3, GrahRound2 = 3, GrahRound3 = 3, GrahYear = "2562", GrahBonusUp = 10000, GrahSalaryUp = 25000, } ); context.Evaluation.AddRange( new Evaluation { EvaDetail = "NULL", EvaSumPoint = 4, EvaDate = DateTime.Parse("2562-2-12"), EvaStatus = 2, Evatype = "1", Eva_GradeHistoryID = 1 } ); context.Evaluation.AddRange( new Evaluation { EvaDetail = "NULL", EvaSumPoint = 4, EvaDate = DateTime.Parse("2562-2-12"), EvaStatus = 2, Evatype = "1", Eva_GradeHistoryID = 2, EvaluatorID = 1 } ); context.Evaluation.AddRange( new Evaluation { EvaDetail = "NULL", EvaSumPoint = 4, EvaDate = DateTime.Parse("2562-2-12"), EvaStatus = 2, Evatype = "1", Eva_GradeHistoryID = 3, EvaluatorID = 1 } ); context.Evaluation.AddRange( new Evaluation { EvaDetail = "NULL", EvaSumPoint = 4, EvaDate = DateTime.Parse("2562-2-12"), EvaStatus = 2, Evatype = "1", Eva_GradeHistoryID = 4, EvaluatorID = 1 } ); context.Evaluation.AddRange( new Evaluation { EvaDetail = "NULL", EvaSumPoint = 4, EvaDate = DateTime.Parse("2562-2-12"), EvaStatus = 2, Evatype = "1", Eva_GradeHistoryID = 5, EvaluatorID = 1 } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.Employee.Any()) { return; // DB has been seeded } context.Employee.AddRange( new Employee { FirstName = "Charlotte", LastName = "Daisy", Address = "London", Telephone = "0632158475", Salary = 16000, Email = "*****@*****.**", StatusEva = 0, Birthday = DateTime.Parse("2539-3-2"), Status = "Working", Date_of_employment = DateTime.Parse("2562-3-2"), Gender = "male", Employee_CompanyID = 1, Employee_DepartmentID = 1, Employee_EmployeeTypeID = 1, Employee_PositionID = 1 } ); context.Employee.AddRange( new Employee { FirstName = "Chloe", LastName = "Ella", Address = "Gloucester", Telephone = "0621453339", Salary = 15000, Email = "*****@*****.**", StatusEva = 0, Birthday = DateTime.Parse("2531-3-21"), Status = "Working", Date_of_employment = DateTime.Parse("2561-3-2"), Gender = "female", Employee_CompanyID = 1, Employee_DepartmentID = 2, Employee_EmployeeTypeID = 2, Employee_PositionID = 2 } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.Rival_Product.Any()) { return; // DB has been seeded } context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-2-2"), Price = 3500, ProductID = 1, RivalID = 1 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-4-2"), Price = 1500, ProductID = 2, RivalID = 1 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-6-2"), Price = 2000, ProductID = 3, RivalID = 1 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-8-2"), Price = 2500, ProductID = 4, RivalID = 1 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-10-2"), Price = 3000, ProductID = 5, RivalID = 1 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-2-2"), Price = 1500, ProductID = 1, RivalID = 2 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-4-2"), Price = 2500, ProductID = 2, RivalID = 2 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-6-2"), Price = 1500, ProductID = 3, RivalID = 2 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-8-2"), Price = 2900, ProductID = 4, RivalID = 2 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-10-2"), Price = 2000, ProductID = 5, RivalID = 2 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-2-2"), Price = 3000, ProductID = 1, RivalID = 3 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-4-2"), Price = 2500, ProductID = 2, RivalID = 3 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-6-2"), Price = 2100, ProductID = 3, RivalID = 3 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-8-2"), Price = 3200, ProductID = 4, RivalID = 3 } ); context.Rival_Product.AddRange( new Rival_Product { RivDate = DateTime.Parse("2020-10-2"), Price = 2000, ProductID = 5, RivalID = 3 } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.Partners.Any()) { return; // DB has been seeded } context.Partners.AddRange( new Partners { FirstName = "Serafim", LastName = "William", Address = "Ancient Britain ", Email = "*****@*****.**", Telephone = "0987654321" } ); context.Partners.AddRange( new Partners { FirstName = "Nicholas", LastName = "Oscar", Address = "Manchester", Email = "*****@*****.**", Telephone = "0809101112" } ); context.Partners.AddRange( new Partners { FirstName = "Aaron", LastName = "Ethan", Address = "Nottingham", Email = "*****@*****.**", Telephone = "0678910111" } ); context.Partners.AddRange( new Partners { FirstName = "Keith", LastName = "Maverick", Address = "Norwich", Email = "*****@*****.**", Telephone = "09123456789" } ); context.Partners.AddRange( new Partners { FirstName = "Seth", LastName = "Todd", Address = "Plymouth", Email = "*****@*****.**", Telephone = "0807060504" } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new tbkkDataContext( serviceProvider.GetRequiredService < DbContextOptions <tbkkDataContext> >())) { // Look for any movies. if (context.Product_Loss_Reduction.Any()) { return; // DB has been seeded } context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-1-1"), Limits = 2.58, Man_Hr_Per_pc = 1.65, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-2-1"), Limits = 1.78, Man_Hr_Per_pc = 1.85, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-3-1"), Limits = 1.98, Man_Hr_Per_pc = 2.05, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-4-1"), Limits = 1.75, Man_Hr_Per_pc = 2.91, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-5-1"), Limits = 1.78, Man_Hr_Per_pc = 2.95, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-6-1"), Limits = 2.18, Man_Hr_Per_pc = 2.45, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-7-1"), Limits = 1.58, Man_Hr_Per_pc = 1.25, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-8-1"), Limits = 1.48, Man_Hr_Per_pc = 2.95, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-9-1"), Limits = 1.75, Man_Hr_Per_pc = 1.91, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-10-1"), Limits = 2.78, Man_Hr_Per_pc = 2.95, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-11-1"), Limits = 2.18, Man_Hr_Per_pc = 1.45, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-12-1"), Limits = 1.58, Man_Hr_Per_pc = 1.25, type_productLoossID = 1 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-1-1"), Limits = 2.18, Man_Hr_Per_pc = 1.45, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-2-1"), Limits = 1.58, Man_Hr_Per_pc = 1.25, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-3-1"), Limits = 1.48, Man_Hr_Per_pc = 2.95, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-4-1"), Limits = 1.75, Man_Hr_Per_pc = 1.91, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-5-1"), Limits = 2.78, Man_Hr_Per_pc = 2.95, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-6-1"), Limits = 2.18, Man_Hr_Per_pc = 1.45, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-7-1"), Limits = 1.58, Man_Hr_Per_pc = 1.25, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-8-1"), Limits = 1.48, Man_Hr_Per_pc = 2.95, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-9-1"), Limits = 1.75, Man_Hr_Per_pc = 1.91, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-10-1"), Limits = 2.78, Man_Hr_Per_pc = 2.95, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-11-1"), Limits = 2.18, Man_Hr_Per_pc = 1.45, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-12-1"), Limits = 2.58, Man_Hr_Per_pc = 1.25, type_productLoossID = 2 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-1-1"), Limits = 2.18, Man_Hr_Per_pc = 1.45, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-2-1"), Limits = 1.58, Man_Hr_Per_pc = 1.25, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-3-1"), Limits = 2.48, Man_Hr_Per_pc = 2.95, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-4-1"), Limits = 2.10, Man_Hr_Per_pc = 1.10, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-5-1"), Limits = 2.79, Man_Hr_Per_pc = 2.99, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-6-1"), Limits = 2.18, Man_Hr_Per_pc = 1.48, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-7-1"), Limits = 1.57, Man_Hr_Per_pc = 1.27, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-8-1"), Limits = 1.46, Man_Hr_Per_pc = 2.96, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-9-1"), Limits = 1.75, Man_Hr_Per_pc = 1.95, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-10-1"), Limits = 2.74, Man_Hr_Per_pc = 2.94, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-11-1"), Limits = 2.13, Man_Hr_Per_pc = 1.43, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-12-1"), Limits = 1.53, Man_Hr_Per_pc = 1.23, type_productLoossID = 3 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-1-1"), Limits = 2.12, Man_Hr_Per_pc = 1.42, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-2-1"), Limits = 1.51, Man_Hr_Per_pc = 1.21, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-3-1"), Limits = 2.48, Man_Hr_Per_pc = 2.95, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-4-1"), Limits = 1.95, Man_Hr_Per_pc = 1.91, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-5-1"), Limits = 2.88, Man_Hr_Per_pc = 2.85, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-6-1"), Limits = 2.78, Man_Hr_Per_pc = 1.75, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-7-1"), Limits = 1.68, Man_Hr_Per_pc = 1.65, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-8-1"), Limits = 1.58, Man_Hr_Per_pc = 2.55, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-9-1"), Limits = 1.45, Man_Hr_Per_pc = 1.41, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-10-1"), Limits = 2.38, Man_Hr_Per_pc = 2.35, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-11-1"), Limits = 2.28, Man_Hr_Per_pc = 1.25, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-12-1"), Limits = 1.18, Man_Hr_Per_pc = 1.15, type_productLoossID = 4 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-1-1"), Limits = 2.11, Man_Hr_Per_pc = 1.42, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-2-1"), Limits = 1.53, Man_Hr_Per_pc = 1.24, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-3-1"), Limits = 1.45, Man_Hr_Per_pc = 2.96, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-4-1"), Limits = 1.77, Man_Hr_Per_pc = 1.98, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-5-1"), Limits = 2.79, Man_Hr_Per_pc = 2.90, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-6-1"), Limits = 2.10, Man_Hr_Per_pc = 1.40, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-7-1"), Limits = 1.50, Man_Hr_Per_pc = 1.20, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-8-1"), Limits = 1.40, Man_Hr_Per_pc = 2.90, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-9-1"), Limits = 1.70, Man_Hr_Per_pc = 1.90, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-10-1"), Limits = 2.70, Man_Hr_Per_pc = 2.90, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-11-1"), Limits = 2.10, Man_Hr_Per_pc = 1.20, type_productLoossID = 5 } ); context.Product_Loss_Reduction.AddRange( new Product_Loss_Reduction { Date = DateTime.Parse("2020-12-1"), Limits = 1.30, Man_Hr_Per_pc = 1.40, type_productLoossID = 5 } ); context.SaveChanges(); } }