private void InsertDataIntoHorario(MaterialDbContext db, DateTime dataInicioTurno, int duracao, DateTime dataFimTurno, Turno turnoId, Colaborador colaboradorID, Posto postoID) { db.GerarHorarios.Add( new Horario { DataInicioTurno = dataInicioTurno, Duracao = duracao, DataFimTurno = dataInicioTurno.AddHours(duracao), TurnoId = turnoId.TurnoId, ColaboradorId = colaboradorID.ColaboradorId, PostoId = postoID.PostoId } ); db.SaveChanges(); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, MaterialDbContext db /*UserManager<IdentityUser> userManager, * RoleManager<IdentityRole> roleManager*/) { //SeedDataMaterial.CreateRolesAndUsersAsync(userManager, roleManager).Wait(); //SeedDataMaterial.Populate(db); if (env.IsDevelopment()) { //SeedDataMaterial.CreateTestUsersAsync(userManager, roleManager).Wait(); SeedDataMaterial.Populate(db); app.UseDeveloperExceptionPage(); app.UseDatabaseErrorPage(); } else { app.UseExceptionHandler("/Home/Error"); app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseCookiePolicy(); app.UseAuthentication(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); }); SeedDataMaterial.Populate(db); }
public FuncaoController(MaterialDbContext context) { _context = context; }
public EsterilizarController(MaterialDbContext context) { _context = context; }
private void GenerateHorario(MaterialDbContext db, int numT1, int numT2, int ano, int mes, int dia) { int numPessoasT1 = 1; int numPessoasT2 = 1; int segunda = 2; int domingo = 8; int[] colaboradores = ColabIds(); int[] postos = PostosIds(); int colabT1 = 0; int colabT2 = 0; int postoT1 = 0; int postoT2 = 0; List <int> listaColabs; List <int> listaPosto; Random rnd = new Random(); DateTime data; for (int i = segunda; i <= domingo; i++) { listaPosto = new List <int>(postos); listaColabs = new List <int>(colaboradores); for (int j = 0; j < numPessoasT1; j++) { string turno = "MANHÃ"; int duracao = 8; colabT1 = listaColabs[rnd.Next(0, listaColabs.Count())]; postoT1 = listaPosto[rnd.Next(0, listaPosto.Count())]; data = new DateTime(ano, mes, dia, 8, 0, 0); Turno turnoId = _context.Turno.SingleOrDefault(t => t.Nome.Equals(turno)); Colaborador colaboradorT1 = _context.Colaborador.SingleOrDefault(m => m.ColaboradorId == colabT1); Posto postosT1 = _context.Posto.SingleOrDefault(m => m.PostoId == postoT1); InsertDataIntoHorario(db, data.AddDays(i - 2), duracao, data.AddDays(i - 2).AddHours(duracao), turnoId, colaboradorT1, postosT1); listaColabs.Remove(colabT1); } for (int k = 0; k < numPessoasT2; k++) { string turno = "TARDE"; int duracao = 8; colabT2 = listaColabs[rnd.Next(0, listaColabs.Count())]; data = new DateTime(ano, mes, dia, 16, 0, 0); postoT2 = listaPosto[rnd.Next(0, listaPosto.Count())]; Turno turnoId = _context.Turno.SingleOrDefault(t => t.Nome.Equals(turno)); Colaborador colaboradorT2 = _context.Colaborador.SingleOrDefault(m => m.ColaboradorId == colabT2); Posto postosT2 = _context.Posto.SingleOrDefault(m => m.PostoId == postoT2); InsertDataIntoHorario(db, data.AddDays(i - 2), duracao, data.AddDays(i - 2).AddHours(duracao), turnoId, colaboradorT2, postosT2); listaColabs.Remove(colabT2); } } }
public MaterialcsController(MaterialDbContext context) { _context = context; }
public HorariosController(MaterialDbContext context) { _context = context; }
public ColaboradoresController(MaterialDbContext context) { _context = context; }
public RegrasController(MaterialDbContext context) { _context = context; }
public TurnosController(MaterialDbContext context) { _context = context; }
public PostosController(MaterialDbContext context) { _context = context; }
public EquipamentosController(MaterialDbContext context) { _context = context; }
public HomeController(MaterialDbContext db, IWebHostEnvironment environment) { _environment = environment; _db = db; _translate = JValue.Parse(System.IO.File.ReadAllText("BackTranslate.json", Encoding.GetEncoding("iso-8859-1"))); }
public Trabalho_PostoController(MaterialDbContext context) { _context = context; }