public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new tbkk_ACContext(
serviceProvider.GetRequiredService <
DbContextOptions <tbkk_ACContext> >()))
{
// Look for any movies.
if (context.Brand.Any())
{
return; // DB has been seeded
}
context.Brand.AddRange(
new Brand
{
BrandName = "Intel",
Image = "Intel_Inside.jpg",
Status = "Using",
}
);
context.SaveChanges();
}
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new tbkk_ACContext(
serviceProvider.GetRequiredService <DbContextOptions <tbkk_ACContext> >()))
{
// Look for any movies.
if (context.EmployeeType.Any())
{
return; // DB has been seeded
}
context.Brand.AddRange(
new Brand
{
BrandName = "Intel",
Image = "pingpong.jpeg",
Status = "In stock"
}
);
context.Brand.AddRange(
new Brand
{
BrandName = "Microsoft",
Image = "pingpong.jpeg",
Status = "In stock"
}
);
context.Category.AddRange(
new Category
{
CategoryName = "Mouse",
Image = "pingpong.jpeg",
TypeName = "Accessory",
Status = "In stock"
}
);
context.Category.AddRange(
new Category
{
CategoryName = "Microsoft Office",
Image = "pingpong.jpeg",
TypeName = "License",
Status = "In stock"
}
);
context.Company.AddRange(
new Company
{
CompanyName = "Branch 1",
Image = "pingpong.jpeg",
Status = "Using"
}
);
context.Company.AddRange(
new Company
{
CompanyName = "Branch 2",
Image = "pingpong.jpeg",
Status = "Using"
}
);
context.Department.AddRange(
new Department
{
DepartmentName = "IT Service",
Image = "pingpong.jpeg",
Status = "Using"
}
);
context.Department.AddRange(
new Department
{
DepartmentName = "Human Resourse",
Image = "pingpong.jpeg",
Status = "Using"
}
);
context.EmployeeType.AddRange(
new EmployeeType
{
EmployeeTypeName = "Full-time",
Status = "Using"
}
);
context.EmployeeType.AddRange(
new EmployeeType
{
EmployeeTypeName = "Part-time",
Status = "Using"
}
);
context.Location.AddRange(
new Location
{
LocationName = "building 1, Floor 2",
Note = "-",
Status = "Using"
}
);
context.Location.AddRange(
new Location
{
LocationName = "building 2, Floor 2",
Note = "-",
Status = "Using"
}
);
context.Network.AddRange(
new Network
{
NetworkName = "B2-F2",
IpAddr = "8888.8888.8888",
Note = "-",
Password = "******",
Status = "Using"
}
);
context.Network.AddRange(
new Network
{
NetworkName = "B2-F1",
IpAddr = "8888.8888.8888",
Note = "-",
Password = "******",
Status = "Using"
}
);
context.Position.AddRange(
new Position
{
PositionName = "personnel",
Status = "Using"
}
);
context.Position.AddRange(
new Position
{
PositionName = "head",
Status = "Using"
}
);
context.Supplier.AddRange(
new Supplier
{
SupplierName = "nan",
ContactName = "-",
Address = "-",
Email = "-",
URL = "-",
Image = "pingpong.jpeg",
Status = "Using"
}
);
context.Supplier.AddRange(
new Supplier
{
SupplierName = "boom",
ContactName = "-",
Address = "-",
Email = "-",
URL = "-",
Image = "pingpong.jpeg",
Status = "Using"
}
);
context.SaveChanges();
}
using (var context = new tbkk_ACContext(
serviceProvider.GetRequiredService <DbContextOptions <tbkk_ACContext> >()))
{
// Look for any movies.
if (context.Model.Any())
{
return; // DB has been seeded
}
context.Model.AddRange(
new Model
{
ModelName = "9300 dpi",
Note = "-",
Brand_BrandID = 1,
Category_CategoryID = 1,
Status = "Using"
}
);
context.Model.AddRange(
new Model
{
ModelName = "-",
Note = "-",
Brand_BrandID = 2,
Category_CategoryID = 2,
Status = "Using"
}
);
context.SaveChanges();
}
using (var context = new tbkk_ACContext(
serviceProvider.GetRequiredService <DbContextOptions <tbkk_ACContext> >()))
{
// Look for any movies.
if (context.Employee.Any())
{
return; // DB has been seeded
}
context.Employee.AddRange(
new Employee
{
FirstName = "Nattatida",
LastName = "Srisa",
Gender = "Female",
Email = "*****@*****.**",
Call = "092-381-3880",
Line = "xxxxxx",
Image = "pingpong.jpeg",
Addr = "Bangsean",
Date = DateTime.Parse("1989-2-12"),
Status = "Using",
Company_CompanyID = 1,
Department_DepartmentID = 1,
Location_LocationID = 1,
EmployeeType_EmployeeTypeID = 1,
Position_PositionID = 1
}
);
context.Employee.AddRange(
new Employee
{
FirstName = "Chanon",
LastName = "Srisa",
Gender = "Male",
Email = "*****@*****.**",
Call = "092-381-3881",
Line = "xxxxxx1",
Image = "pingpong.jpeg",
Addr = "Samutprakarn",
Date = DateTime.Parse("1989-2-11"),
Status = "Using",
Company_CompanyID = 2,
Department_DepartmentID = 2,
Location_LocationID = 2,
EmployeeType_EmployeeTypeID = 2,
Position_PositionID = 2
}
);
context.License.AddRange(
new License
{
LicenseName = "xxx-xxx-xx",
SoftewareName = "office",
PurchaseDate = DateTime.Parse("2019-2-10"),
StartDate = DateTime.Parse("2019-2-20"),
ExpireDate = DateTime.Parse("2024-2-10"),
PONumber = "xxxxxx-xxx",
Attachfiles = "null",
Note = "-",
Status = "Using",
Model_ModelID = 2,
Supplier_SupplierID = 2,
Department_DepartmentID = 2,
Company_CompanyID = 2
}
);
context.License.AddRange(
new License
{
LicenseName = "xxx-xxx-xx",
SoftewareName = "access",
PurchaseDate = DateTime.Parse("2019-2-10"),
StartDate = DateTime.Parse("2019-2-20"),
ExpireDate = DateTime.Parse("2024-2-20"),
PONumber = "xxxxxx-xxx",
Attachfiles = "null",
Note = "-",
Status = "Using",
Model_ModelID = 2,
Supplier_SupplierID = 2,
Department_DepartmentID = 2,
Company_CompanyID = 2
}
);
context.Asset.AddRange(
new Asset
{
AssetName = "PC-001",
SerailNumber = "xxx-xxx-xx1",
MACAddr = "xxx.xxx.xxx",
InstallDate = DateTime.Parse("2019-2-20"),
PurchaseDate = DateTime.Parse("2019-2-10"),
ExpireDate = DateTime.Parse("2024-2-10"),
PONumber = "xxx-xxx-xxx",
Price = "19,200",
Warranty = 3,
Type = "Asset",
Note = "-",
Status = "Using",
Company_CompanyID = 2,
Location_LocationID = 2,
Department_DepartmentID = 2,
Supplier_SupplierID = 2,
Employee_EmployeeID = 1,
Image = "pingpong.jpeg"
}
);
context.Asset.AddRange(
new Asset
{
AssetName = "KB-001",
SerailNumber = "xxx-xxx-xx1",
MACAddr = "xxx.xxx.xxx",
InstallDate = DateTime.Parse("2019-2-12"),
PurchaseDate = DateTime.Parse("2019-2-10"),
ExpireDate = DateTime.Parse("2024-2-12"),
PONumber = "xxx-xxx-xxx",
Price = "1,200",
Warranty = 1,
Type = "Accessory",
Note = "-",
Status = "Using",
Company_CompanyID = 2,
Location_LocationID = 2,
Department_DepartmentID = 2,
Supplier_SupplierID = 2,
Employee_EmployeeID = 1,
Image = "pingpong.jpeg"
}
);
context.SaveChanges();
}
using (var context = new tbkk_ACContext(
serviceProvider.GetRequiredService <DbContextOptions <tbkk_ACContext> >()))
{
// Look for any movies.
if (context.Login.Any())
{
return; // DB has been seeded
}
context.Login.AddRange(
new Login
{
Username = "******",
Password = "******",
Employee_EmployeeID = 1
}
);
context.SaveChanges();
}
}
public IndexModel(tbkk_AC.Models.tbkk_ACContext context)
{
_context = context;
}
public CreateModel(tbkk_AC.Models.tbkk_ACContext context, IHostingEnvironment environment)
{
_context = context;
this.environment = environment;
}
public CreateModel(tbkk_AC.Models.tbkk_ACContext context)
{
_context = context;
}
public EditModel(tbkk_AC.Models.tbkk_ACContext context)
{
_context = context;
}
public DetailsModel(tbkk_AC.Models.tbkk_ACContext context)
{
_context = context;
}
public DeleteModel(tbkk_AC.Models.tbkk_ACContext context)
{
_context = context;
}
public HomeModel(tbkk_AC.Models.tbkk_ACContext context)
{
_context = context;
}
