public void CreateOrUpdate(SettingBindingModel model) { using (var context = new Database()) { Setting element = context.Settings.FirstOrDefault(rec => rec.NumberRoomId == model.NumberRoomId && rec.Id != model.Id); if (element != null) { throw new Exception("Уже номер занят"); } if (model.Id.HasValue) { element = context.Settings.FirstOrDefault(rec => rec.Id == model.Id); if (element == null) { throw new Exception("Элемент не найден"); } } else { element = new Setting(); context.Settings.Add(element); } element.CountPeople = model.CountPeople; element.ArrivalDate = model.ArrivalDate; element.DateDeparture = model.DateDeparture; element.ClientId = model.ClientId; element.NumberRoomId = model.NumberRoomId; context.SaveChanges(); } }
public List <SettingViewModel> Read(SettingBindingModel model) { using (var context = new Database()) { return(context.Settings .Where(rec => model == null || rec.Id == model.Id) .ToList() .Select(rec => new SettingViewModel { Id = rec.Id, CountPeople = rec.CountPeople, ArrivalDate = rec.ArrivalDate, DateDeparture = rec.DateDeparture, ClientId = rec.ClientId, NumberRoomId = rec.NumberRoomId, }) .ToList()); } }