public void CreateOrUpdate(SystemUnitBindingModel model) { using (var context = new Database()) { SystemUnit element = context.SystemUnits.FirstOrDefault(rec => rec.Marka == model.Marka && rec.Id != model.Id); if (element != null) { throw new Exception("Уже есть комп с таким названием"); } if (model.Id.HasValue) { element = context.SystemUnits.FirstOrDefault(rec => rec.Id == model.Id); if (element == null) { throw new Exception("Элемент не найден"); } } else { element = new SystemUnit(); context.SystemUnits.Add(element); } element.Marka = model.Marka; element.DateOfCreate = model.DateOfCreate; element.Type = model.Type; context.SaveChanges(); } }
public List <SystemUnitViewModel> Read(SystemUnitBindingModel model) { using (var context = new Database()) { return(context.SystemUnits .Where(rec => model == null || rec.Id == model.Id) .Select(rec => new SystemUnitViewModel { Id = rec.Id, Marka = rec.Marka, Type = rec.Type, DateOfCreate = rec.DateOfCreate }) .ToList()); } }
public void Delete(SystemUnitBindingModel model) { using (var context = new Database()) { SystemUnit element = context.SystemUnits.FirstOrDefault(rec => rec.Id == model.Id); if (element != null) { context.SystemUnits.Remove(element); context.SaveChanges(); } else { throw new Exception("Элемент не найден"); } } }