private static void InitializeParts(WorkshopContext db, int partsNumber)
{
db.Database.EnsureCreated();
//проверка, занесены ли данные в Parts
if (db.Parts.Any())
{
return; //бд иницилизирована
}
string partName;
decimal price;
string descriptionPart;
Random randomObj = new Random(1);
for (int partID = 1; partID <= partsNumber; partID++)
{
partName = MyRandom.RandomString(15);
price = randomObj.Next(5, 100);
descriptionPart = MyRandom.RandomString(20);
db.Parts.Add(new Part
{
partName = partName,
price = price,
descriptionPart = descriptionPart
});
}
//сохранение изменений в бд, связанную с объектом контекста
db.SaveChanges();
}
public OrdersController(WorkshopContext context, IMemoryCache memoryCache,
WorkshopService service)
{
db = context;
this.memoryCache = memoryCache;
this.service = service;
}
private static void InitializeBreakdowns(WorkshopContext db, int breakdownsNumber, int ordersNumber, int partsNumber, int workersNumber)
{
db.Database.EnsureCreated();
//проверка, занесены ли данные в Breakdowns
if (db.Breakdowns.Any())
{
return; //бд иницилизирована
}
int orderID;
int partID;
int workerID;
Random randomObj = new Random(1);
for (int breakdownID = 1; breakdownID <= breakdownsNumber; breakdownID++)
{
orderID = db.Orders.Skip(randomObj.Next(0, db.Orders.Count() - 2)).First().orderID;
partID = db.Parts.Skip(randomObj.Next(0, db.Parts.Count() - 2)).First().partID;
workerID = db.Workers.Skip(randomObj.Next(0, db.Workers.Count() - 2)).First().workerID;
db.Breakdowns.Add(new Breakdown
{
orderID = orderID,
partID = partID,
workerID = workerID
});
}
//сохранение изменений в бд, связанную с объектом контекста
db.SaveChanges();
}
public RequestController(WorkshopContext context, IRequestService service)
{
_context = context;
_service = service;
_service.AddModelState(this.ModelState);
}
public AccountController(UserManager <User> userManager, SignInManager <User> signInManager, WorkshopContext context, RoleManager <IdentityRole> roleManager)
{
this.userManager = userManager;
this.signInManager = signInManager;
this.roleManager = roleManager;
db = context;
}
private static void InitializeWorkers(WorkshopContext db, int workersNumber, int postsNumber)
{
db.Database.EnsureCreated();
//проверка, занесены ли данные в Workers
if (db.Workers.Any())
{
return; //бд иницилизирована
}
string fioWorker;
int postID;
DateTime dateOfEmployment;
DateTime?dateOfDismissal;
decimal salary;
Random randomObj = new Random(1);
for (int workerID = 1; workerID <= workersNumber; workerID++)
{
var date = new DateTime(randomObj.Next(1990, 2018),
randomObj.Next(1, 12),
randomObj.Next(1, 28));
fioWorker = MyRandom.RandomString(15);
postID = db.Posts.Skip(randomObj.Next(0, db.Posts.Count() - 2)).First().postID;
var twoDate = new DateTime(randomObj.Next(1, 10),
randomObj.Next(1, 12),
randomObj.Next(1, 28));
if (workerID % 5 == 0)
{
dateOfDismissal = date.Add(new TimeSpan(twoDate.Ticks));
}
else
{
dateOfDismissal = null;
}
dateOfEmployment = date;
salary = randomObj.Next(100, 1000);
db.Workers.Add(new Worker
{
fioWorker = fioWorker,
postID = postID,
dateOfDismissal = dateOfDismissal,
dateOfEmployment = dateOfEmployment,
salary = salary,
});
}
//сохранение изменений в бд, связанную с объектом контекста
db.SaveChanges();
}
public Task Invoke(HttpContext context, IServiceProvider serviceProvider, WorkshopContext dbContext)
{
if (!(context.Session.Keys.Contains("starting")))
{
//DbUserInitializer.Initialize(serviceProvider).Wait();
DbInitializer.Initialize(dbContext);
context.Session.SetString("starting", "Yes");
}
// Call the next delegate/middleware in the pipeline
return(_next.Invoke(context));
}
private static void InitializeOrders(WorkshopContext db, int ordersNumber, int carsNumber, int workersNumber)
{
db.Database.EnsureCreated();
//проверка, занесены ли данные в Orders
if (db.Orders.Any())
{
return; //бд иницилизирована
}
int carID;
DateTime dateReceipt;
DateTime?dateCompletion;
int workerID;
Random randomObj = new Random(DateTime.Now.Month * 30 + DateTime.Now.Year * 365 + DateTime.Now.Day
+ DateTime.Now.Minute);
for (int orderID = 1; orderID <= ordersNumber; orderID++)
{
var date = new DateTime(randomObj.Next(1990, 2008),
randomObj.Next(1, 12),
randomObj.Next(1, 28));
carID = db.Cars.Skip(randomObj.Next(0, db.Cars.Count() - 2)).First().carID;
dateReceipt = date;
var twoDate = new DateTime(randomObj.Next(1, 10),
randomObj.Next(1, 12),
randomObj.Next(1, 28));
if (orderID % 5 == 0)
{
dateCompletion = date.Add(new TimeSpan(twoDate.Ticks));
}
else
{
dateCompletion = null;
}
workerID = db.Workers.Skip(randomObj.Next(0, db.Workers.Count() - 2)).First().workerID;
db.Orders.Add(new Order
{
carID = carID,
dateReceipt = dateReceipt,
dateCompletion = dateCompletion,
workerID = workerID
});
}
//сохранение изменений в бд, связанную с объектом контекста
db.SaveChanges();
}
private static void InitializeCars(WorkshopContext db, int carsNumber, int ownersNumber)
{
db.Database.EnsureCreated();
//проверка, занесены ли данные в Cars
if (db.Cars.Any())
{
return; //бд иницилизирована
}
int ownerID;
string model;
int vis;
string colour;
string stateNumber;
int yearOfIssue;
int bodyNumber;
int engineNumber;
Random randomObj = new Random(1);
for (int carID = 1; carID <= carsNumber; carID++)
{
ownerID = db.Owners.Skip(randomObj.Next(0, db.Owners.Count() - 2)).First().ownerID;
model = MyRandom.RandomString(10);
vis = randomObj.Next(10, 100);
colour = MyRandom.RandomString(10);
stateNumber = MyRandom.RandomString(9);
yearOfIssue = randomObj.Next(1, 4);
bodyNumber = randomObj.Next(1, 10);
engineNumber = randomObj.Next(1, 10);
db.Cars.Add(new Car
{
ownerID = ownerID,
model = model,
vis = vis,
colour = colour,
stateNumber = stateNumber,
yearOfIssue = yearOfIssue,
bodyNumber = bodyNumber,
engineNumber = engineNumber
});
}
//сохранение изменений в бд, связанную с объектом контекста
db.SaveChanges();
}
public void Configure(IApplicationBuilder app, WorkshopContext context)
{
app.UseStaticFiles();
app.UseAuthentication();
app.UseSession();
app.UseWorkshopCache("Workshop");
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
// инициализация базы данных
DbInitializer.Initialize(context);
}
public static void Initialize(WorkshopContext db)
{
db.Database.EnsureCreated();
int breakdownsNumber = 40;
int carsNumber = 150;
int ordersNumber = 300;
int ownersNumber = 80;
int partsNumber = 50;
int postsNumber = 10;
int workersNumber = 50;
InitializeOwners(db, ownersNumber);
InitializePosts(db, postsNumber);
InitializeParts(db, partsNumber);
InitializeWorkers(db, workersNumber, postsNumber);
InitializeCars(db, carsNumber, ownersNumber);
InitializeOrders(db, ordersNumber, carsNumber, workersNumber);
InitializeBreakdowns(db, breakdownsNumber, ordersNumber, partsNumber, workersNumber);
}
private static void InitializeOwners(WorkshopContext db, int ownersNumber)
{
db.Database.EnsureCreated();
//проверка, занесены ли данные в Owners
if (db.Owners.Any())
{
return; //бд иницилизирована
}
int driverLicense;
string fioOwner;
string adress;
int phone;
Random randomObj = new Random(1);
for (int ownerID = 1; ownerID <= ownersNumber; ownerID++)
{
driverLicense = randomObj.Next(1, 3000);
fioOwner = MyRandom.RandomString(15);
adress = MyRandom.RandomString(15);
phone = randomObj.Next(1, 1000000);
db.Owners.Add(new Owner
{
driverLicense = driverLicense,
fioOwner = fioOwner,
adress = adress,
phone = phone
});
}
//сохранение изменений в бд, связанную с объектом контекста
db.SaveChanges();
}
public PartsController(WorkshopContext context)
{
db = context;
}
public SellerService(WorkshopContext context)
{
_context = context;
}
public RequestService(WorkshopContext context, IFileService fileService)
{
_context = context;
_fileService = fileService;
}
public TweetService(WorkshopContext workshopContext)
{
this.workshopContext = workshopContext;
}
public CustomerController(WorkshopContext context)
{
_context = context;
}
public EmployeesController(WorkshopContext context)
{
_context = context;
}
public ActivityRepository(WorkshopContext context)
{
this.context = context;
}
public ProblemsController(WorkshopContext context)
{
_context = context;
}
public TasksController(WorkshopContext context)
{
_context = context;
}
public CarRepository(WorkshopContext context)
{
this.context = context;
}
public UsersController(UserManager <User> userManager, WorkshopContext context)
{
_userManager = userManager;
db = context;
}
public AttendeesController(WorkshopContext context)
{
_context = context;
}
public DepartmentsController(WorkshopContext context)
{
_context = context;
}
public AccountsController()
{
_db = new WorkshopContext(new DbContextOptions <WorkshopContext>());
}
public SalesRecordService(WorkshopContext context)
{
_context = context;
}
public ValuesController()
{
_context = new WorkshopContext(new DbContextOptions <WorkshopContext>());
}
public WorkshopService(WorkshopContext context)
{
db = context;
}
public CarController(WorkshopContext context)
{
_context = context;
}
