public ActionResult Add(BindEmployeeTradeViewModel arv)
{
SqlLiteContext context = new SqlLiteContext();
for (int i = 0; i < arv.Trades.Count(); i++)
{
var employeeTrade = context.EmployeeTrades.Where(a => a.EmployeeId == arv.Trades[i].EmployeeId && a.TradeId == arv.Trades[i].TradeId).FirstOrDefault();
if (arv.Trades[i].Connected)
{
if (employeeTrade == null)
{
var et = new EmployeeTrade();
et.EmployeeId = arv.Trades[i].EmployeeId;
et.TradeId = arv.Trades[i].TradeId;
var entity = context.EmployeeTrades.Add(et);
entity.State = EntityState.Added;
}
}
else
{
if (employeeTrade != null)
{
var entity = context.EmployeeTrades.Remove(employeeTrade);
entity.State = EntityState.Deleted;
}
}
}
context.SaveChanges();
return(RedirectToAction("Cv", "Home", new { id = arv.Trades[0].EmployeeId }));
}
public ActionResult Admin(int employeeid)
{
List <TradeViewModel> Tradeviewmodellist = new List <TradeViewModel>();
List <Trade> employeetradelist = TradeService.GetByEmployee(employeeid);
using var context = new SqlLiteContext();
List <Trade> tradelist = context.Trades.ToList();
foreach (Trade t in tradelist)
{
TradeViewModel tvm = new TradeViewModel();
tvm.TradeId = t.TradeId;
tvm.EmployeeId = employeeid;
tvm.Name = t.Name;
tvm.Connected = false;
foreach (Trade te in employeetradelist)
{
if (t.TradeId == te.TradeId)
{
tvm.Connected = true;
}
}
Tradeviewmodellist.Add(tvm);
}
var sortedlist = Tradeviewmodellist.OrderBy(foo => foo.Name).ToList();
var model = new BindEmployeeTradeViewModel(sortedlist);
return(View(model));
}
