public ActionResult Add(BindEmployeeMiddlewareViewModel arv) { SqlLiteContext context = new SqlLiteContext(); for (int i = 0; i < arv.Middlewares.Count(); i++) { var employeeMiddleware = context.EmployeeMiddlewares.Where(a => a.EmployeeId == arv.Middlewares[i].EmployeeId && a.MiddlewareId == arv.Middlewares[i].MiddlewareId).FirstOrDefault(); if (arv.Middlewares[i].Connected) { if (employeeMiddleware == null) { var et = new EmployeeMiddleware(); et.EmployeeId = arv.Middlewares[i].EmployeeId; et.MiddlewareId = arv.Middlewares[i].MiddlewareId; var entity = context.EmployeeMiddlewares.Add(et); entity.State = EntityState.Added; } } else { if (employeeMiddleware != null) { var entity = context.EmployeeMiddlewares.Remove(employeeMiddleware); entity.State = EntityState.Deleted; } } } context.SaveChanges(); return(RedirectToAction("Cv", "Home", new { id = arv.Middlewares[0].EmployeeId })); }
public ActionResult Admin(int employeeid) { List <MiddlewareViewModel> Middlewareviewmodellist = new List <MiddlewareViewModel>(); List <Middleware> employeemiddlewarelist = MiddlewareService.GetByEmployee(employeeid); using var context = new SqlLiteContext(); List <Middleware> middlewarelist = context.Middlewares.ToList(); foreach (Middleware t in middlewarelist) { MiddlewareViewModel mvm = new MiddlewareViewModel(); mvm.MiddlewareId = t.MiddlewareId; mvm.EmployeeId = employeeid; mvm.Name = t.Name; foreach (Middleware te in employeemiddlewarelist) { if (t.MiddlewareId == te.MiddlewareId) { mvm.Connected = true; } } Middlewareviewmodellist.Add(mvm); } var sortedlist = Middlewareviewmodellist.OrderBy(foo => foo.Name).ToList(); var arv = new BindEmployeeMiddlewareViewModel(sortedlist); return(View(arv)); }