public ActionResult Add(BindEmployeeTechniqueViewModel arv)
{
SqlLiteContext context = new SqlLiteContext();
for (int i = 0; i < arv.Techniques.Count(); i++)
{
var employeeTechnique = context.EmployeeTechniques.Where(a => a.EmployeeId == arv.Techniques[i].EmployeeId && a.TechniqueId == arv.Techniques[i].TechniqueId).FirstOrDefault();
if (arv.Techniques[i].Connected)
{
if (employeeTechnique == null)
{
var et = new EmployeeTechnique();
et.EmployeeId = arv.Techniques[i].EmployeeId;
et.TechniqueId = arv.Techniques[i].TechniqueId;
var entity = context.EmployeeTechniques.Add(et);
entity.State = EntityState.Added;
}
}
else
{
if (employeeTechnique != null)
{
var entity = context.EmployeeTechniques.Remove(employeeTechnique);
entity.State = EntityState.Deleted;
}
}
}
context.SaveChanges();
return(RedirectToAction("Cv", "Home", new { id = arv.Techniques[0].EmployeeId }));
}
public ActionResult Admin(int employeeid)
{
List <TechniqueViewModel> Techniqueviewmodellist = new List <TechniqueViewModel>();
List <Technique> employeetechlist = TechniqueService.GetByEmployee(employeeid);
using var context = new SqlLiteContext();
List <Technique> techlist = context.Techniques.ToList();
foreach (Technique t in techlist)
{
TechniqueViewModel tvm = new TechniqueViewModel();
tvm.TechniqueId = t.TechniqueId;
tvm.EmployeeId = employeeid;
tvm.Name = t.Name;
tvm.Connected = false;
foreach (Technique te in employeetechlist)
{
if (t.TechniqueId == te.TechniqueId)
{
tvm.Connected = true;
}
}
Techniqueviewmodellist.Add(tvm);
}
var sortedlist = Techniqueviewmodellist.OrderBy(foo => foo.Name).ToList();
var arv = new BindEmployeeTechniqueViewModel(sortedlist);
return(View(arv));
}
