public async Task <ActionResult> Put(PlantillaCalendari plantilla) { _context.Attach(plantilla).State = EntityState.Modified; await _context.SaveChangesAsync(); return(NoContent()); }
public async Task <ActionResult <int> > Post(PlantillaCalendari plantilla) { _context.Add(plantilla); await _context.SaveChangesAsync(); return(Ok(plantilla.Id)); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { // configurem els camps a les taules SQL modelBuilder.ApplyConfiguration(new CalendariFestesConfiguracio()); modelBuilder.ApplyConfiguration(new CalendariTreballadorConfiguracio()); modelBuilder.ApplyConfiguration(new ConveniConfiguracio()); modelBuilder.ApplyConfiguration(new ConveniTreballadorConfiguracio()); modelBuilder.ApplyConfiguration(new DetallCalendariTreballadorConfiguracio()); modelBuilder.ApplyConfiguration(new DetallPlantillaCalendariConfiguracio()); modelBuilder.ApplyConfiguration(new PlantillaCalendariConfiguracio()); modelBuilder.ApplyConfiguration(new TreballadorConfiguracio()); // Data seeding modelBuilder.Entity <CalendariFestes>().HasData( new CalendariFestes { Id = 1, Data = new DateTime(2021, 1, 1), Festa = "Cap d'Any", Tipus = TipusFesta.Autonomica }, new CalendariFestes { Id = 2, Data = new DateTime(2021, 1, 6), Festa = "Reis", Tipus = TipusFesta.Autonomica }, new CalendariFestes { Id = 3, Data = new DateTime(2021, 4, 2), Festa = "Divendres Sant", Tipus = TipusFesta.Autonomica }, new CalendariFestes { Id = 4, Data = new DateTime(2021, 4, 5), Festa = "Dilluns de Pasqua", Tipus = TipusFesta.Autonomica }, new CalendariFestes { Id = 5, Data = new DateTime(2021, 5, 1), Festa = "Primer de Maig", Tipus = TipusFesta.Autonomica }, new CalendariFestes { Id = 6, Data = new DateTime(2021, 6, 24), Festa = "Sant Joan", Tipus = TipusFesta.Autonomica }, new CalendariFestes { Id = 7, Data = new DateTime(2021, 9, 11), Festa = "Diada Nacional de CAT", Tipus = TipusFesta.Autonomica }, new CalendariFestes { Id = 8, Data = new DateTime(2021, 10, 12), Festa = "Fiesta Nasiona Nyorda", Tipus = TipusFesta.Nacional }, new CalendariFestes { Id = 9, Data = new DateTime(2021, 11, 1), Festa = "Tots Sants", Tipus = TipusFesta.Autonomica }, new CalendariFestes { Id = 10, Data = new DateTime(2021, 12, 6), Festa = "Dia de la Constitucion Nyorda", Tipus = TipusFesta.Nacional }, new CalendariFestes { Id = 11, Data = new DateTime(2021, 12, 8), Festa = "La Immaculada", Tipus = TipusFesta.Autonomica }, new CalendariFestes { Id = 12, Data = new DateTime(2021, 12, 25), Festa = "Nadal", Tipus = TipusFesta.Autonomica } ); modelBuilder.Entity <Conveni>().HasData( new Conveni { Id = 1, Codi = "79002575012007", DataInici = new DateTime(2020, 11, 30), HoresAnuals = 1600, Nom = "Acció social amb infants, joves, families i d'altres, en situació de risc" }, new Conveni { Id = 2, Codi = "79002795012009", DataInici = new DateTime(2014, 4, 30), HoresAnuals = 1500, Nom = "Associacions per discapacitats" }, new Conveni { Id = 3, Codi = "79001565011999", DataInici = new DateTime(2019, 2, 7), HoresAnuals = 1250, Nom = "Centres especials de treballadors disminuits fisics o sensorials de Catalunya" } ); var plantilla1 = new PlantillaCalendari { Id = 1, Nom = "Plantilla1", DataInici = new DateTime(2021, 1, 1), Observacions = "Plantilla 1" }; var plantilla2 = new PlantillaCalendari { Id = 2, Nom = "Plantilla2", DataInici = new DateTime(2021, 1, 1), Observacions = "Plantilla 2" }; modelBuilder.Entity <PlantillaCalendari>().HasData(plantilla1, plantilla2); var detallplantilla1 = new DetallPlantillaCalendari { Id = 1, DataInicial = new DateTime(2021, 1, 1), DataFinal = new DateTime(2021, 7, 31), HoraInici1 = new TimeSpan(7, 0, 0), HoraFinal1 = new TimeSpan(13, 0, 0), HoraInici2 = new TimeSpan(15, 0, 0), HoraFinal2 = new TimeSpan(19, 0, 0), Vacances = false, Observacions = "tram1", PlantillaCalendariId = 1 }; var detallplantilla2 = new DetallPlantillaCalendari { Id = 2, DataInicial = new DateTime(2021, 8, 1), DataFinal = new DateTime(2021, 8, 31), Vacances = true, Observacions = "tram vacances", PlantillaCalendariId = 1 }; var detallplantilla3 = new DetallPlantillaCalendari { Id = 3, DataInicial = new DateTime(2021, 9, 1), DataFinal = new DateTime(2021, 12, 31), HoraInici1 = new TimeSpan(7, 0, 0), HoraFinal1 = new TimeSpan(13, 0, 0), HoraInici2 = new TimeSpan(15, 0, 0), HoraFinal2 = new TimeSpan(19, 0, 0), Vacances = true, Observacions = "tram tram2", PlantillaCalendariId = 1 }; modelBuilder.Entity <DetallPlantillaCalendari>().HasData( detallplantilla1, detallplantilla2, detallplantilla3 ); modelBuilder.Entity <Treballador>().HasData( new Treballador { Id = 1, Codi = "T1", Nom = "Joan", PrimerCognom = "Lopez", SegonCognom = "Teclas", NIF = "77653456A", NSS = "081234567890", Adreça = "Carrer Badal, 45", CP = "08000", Poblacio = "Barcelona", Provincia = "Barcelona", Telefon1 = "938065434", Mobil1 = "600102030", Email1 = "*****@*****.**", Centre = Centre.Barcelona, Departament = Departament.Administracio, DataAlta = new DateTime(2010, 1, 1) }, new Treballador { Id = 2, Codi = "T2", Nom = "Julia", PrimerCognom = "Garcia", SegonCognom = "Vacas", NIF = "67345768B", NSS = "501234567890", Adreça = "Calle los Mañicos, 56", CP = "50000", Poblacio = "Zaragoza", Provincia = "Zaragoza", Telefon1 = "976436574", Mobil1 = "600102030", Email1 = "*****@*****.**", Centre = Centre.Saragossa, Departament = Departament.Administracio, DataAlta = new DateTime(2010, 1, 1) }, new Treballador { Id = 3, Codi = "T3", Nom = "Ramir", PrimerCognom = "Rodriguez", SegonCognom = "Samuel", NIF = "19463891C", NSS = "461234567890", Adreça = "Carrer de les Falles", CP = "46000", Poblacio = "Valencia", Provincia = "Valencia", Telefon1 = "966543546", Mobil1 = "600102030", Email1 = "*****@*****.**", Centre = Centre.Valencia, Departament = Departament.Administracio, DataAlta = new DateTime(2010, 1, 1) }, new Treballador { Id = 4, Codi = "T4", Nom = "Angel", PrimerCognom = "Porrata", SegonCognom = "Pesarrodona", NIF = "47586923D", NSS = "088934675421", Adreça = "Avinguda Europa, 123-4rt-5ª", CP = "08000", Poblacio = "Barcelona", Provincia = "Barcelona", Telefon1 = "938065434", Mobil1 = "600102030", Email1 = "*****@*****.**", Centre = Centre.Barcelona, Departament = Departament.Compres, DataAlta = new DateTime(2010, 1, 1) }, new Treballador { Id = 5, Codi = "T5", Nom = "Isabel", PrimerCognom = "Santisteban", SegonCognom = "Junqueres", NIF = "79583452E", NSS = "084578695473", Adreça = "Carrer de Gaudi, 56-1", CP = "08000", Poblacio = "Barcelona", Provincia = "Barcelona", Telefon1 = "938065434", Mobil1 = "600102030", Email1 = "*****@*****.**", Centre = Centre.Barcelona, Departament = Departament.Comptabilitat, DataAlta = new DateTime(2010, 1, 1) }, new Treballador { Id = 6, Codi = "T6", Nom = "Maria", PrimerCognom = "Poltre", SegonCognom = "Patrixol", NIF = "89562854F", NSS = "086736593712", Adreça = "Carretera de les Aigues s/n", CP = "08000", Poblacio = "Barcelona", Provincia = "Barcelona", Telefon1 = "938065434", Mobil1 = "600102030", Email1 = "*****@*****.**", Centre = Centre.Barcelona, Departament = Departament.Informatica, DataAlta = new DateTime(2010, 1, 1) }, new Treballador { Id = 7, Codi = "T7", Nom = "Montse", PrimerCognom = "Massanes", SegonCognom = "Ameba", NIF = "10694825G", NSS = "080898786757", Adreça = "Passeig Sant Joan, 23-Atic", CP = "08000", Poblacio = "Barcelona", Provincia = "Barcelona", Telefon1 = "938065434", Mobil1 = "600102030", Email1 = "*****@*****.**", Centre = Centre.Barcelona, Departament = Departament.Personal, DataAlta = new DateTime(2010, 1, 1) }, new Treballador { Id = 8, Codi = "T8", Nom = "Ignasi", PrimerCognom = "Codina", SegonCognom = "Pujol", NIF = "69372517H", NSS = "085647987809", Adreça = "Carrer Petrixol, 34", CP = "08000", Poblacio = "Barcelona", Provincia = "Barcelona", Telefon1 = "938065434", Mobil1 = "600102030", Email1 = "*****@*****.**", Centre = Centre.Barcelona, Departament = Departament.RRHH, DataAlta = new DateTime(2010, 1, 1) }, new Treballador { Id = 9, Codi = "T9", Nom = "Hector", PrimerCognom = "Rucol", SegonCognom = "Broquil", NIF = "90785940I", NSS = "083425475900", Adreça = "Carrer Industria 88-4-4", CP = "08000", Poblacio = "Barcelona", Provincia = "Barcelona", Telefon1 = "938065434", Mobil1 = "600102030", Email1 = "*****@*****.**", Centre = Centre.Barcelona, Departament = Departament.Comptabilitat, DataAlta = new DateTime(2010, 1, 1) }, new Treballador { Id = 10, Codi = "T10", Nom = "Victor", PrimerCognom = "Bascara", SegonCognom = "Costa", NIF = "80583760J", NSS = "080808786757", Adreça = "Plaça del Pes de la Palla 4-1", CP = "08000", Poblacio = "Barcelona", Provincia = "Barcelona", Telefon1 = "938065434", Mobil1 = "600102030", Email1 = "*****@*****.**", Centre = Centre.Barcelona, Departament = Departament.Personal, DataAlta = new DateTime(2010, 1, 1) } ); }