public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new EmpleatContext(
serviceProvider.GetRequiredService <
DbContextOptions <EmpleatContext> >()))
{
// Look for any movies.
if (context.Empleats.Any())
{
return; // DB has been seeded
}
context.Empleats.AddRange(
new Empleat
{
Nom = "Ismael",
Cognom = "Anaya",
Càrrec = "CTO",
Sou = "40000"
},
new Empleat
{
Nom = "Patricia",
Cognom = "Costa",
Càrrec = "CEO",
Sou = "60000"
}
);
context.SaveChanges();
}
}
public IActionResult Delete(int id, string nom, string cognom, string carrec, int sou)
{
EmpleatContext context = HttpContext.RequestServices.GetService(typeof(MySQL_Empleat.Models.EmpleatContext)) as EmpleatContext;
//context.DeleteEmpleat(id);
return(View(context.DeleteEmpleat(id, nom, cognom, carrec, sou)));
}
public EmpleatsController(EmpleatContext context)
{
_context = context;
}
public EmpleatsController(EmpleatContext context, IData <Empleat> data)
{
_context = context;
_data = data;
}
public IActionResult AddEmpleat()
{
EmpleatContext context = HttpContext.RequestServices.GetService(typeof(EmpleatMySql.Models.EmpleatContext)) as EmpleatContext;
return(View(context.GetAll()));
}
public IActionResult Create([Bind("Id,Nom,Cognom,Carrec,Sou")] Empleat emp)
{
EmpleatContext context = HttpContext.RequestServices.GetService(typeof(MySQL_Empleat.Models.EmpleatContext)) as EmpleatContext;
return(View(context.InsertEmpleat(emp)));
}
public IActionResult Index()
{
EmpleatContext context = HttpContext.RequestServices.GetService(typeof(MySQL_Empleat.Models.EmpleatContext)) as EmpleatContext;
return(View(context.GetAllEmpleats()));
}
