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