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