public void Insert(DealBM model) { using (var context = new DataBaseContext()) { context.Deals.Add(CreateModel(model, new Deal())); context.SaveChanges(); } }
private Deal CreateModel(DealBM model, Deal deal) { deal.Date = model.Date; deal.EmployeeId = model.EmployeeId; deal.ApplicantId = model.ApplicantId; deal.VacancyId = model.VacancyId; return(deal); }
public void CreateOrUpdate(DealBM model) { if (model.Id.HasValue) { _dealStorage.Update(model); } else { _dealStorage.Insert(model); } }
public void Update(DealBM model) { using (var context = new DataBaseContext()) { Deal element = context.Deals.FirstOrDefault(rec => rec.Id == model.Id); if (element == null) { throw new Exception("Сделка не найдена"); } CreateModel(model, element); context.SaveChanges(); } }
public void Delete(DealBM model) { var element = _dealStorage.GetElement(new DealBM { Id = model.Id }); if (element == null) { throw new Exception("Сделка не найдена"); } _dealStorage.Delete(model); }
public List <DealVM> Read(DealBM model) { if (model == null) { return(_dealStorage.GetFullList()); } if (model.Id.HasValue) { return(new List <DealVM> { _dealStorage.GetElement(model) }); } return(_dealStorage.GetFilteredList(model)); }
public void Delete(DealBM model) { using (var context = new DataBaseContext()) { Deal element = context.Deals.FirstOrDefault(rec => rec.Id == model.Id); if (element != null) { context.Deals.Remove(element); context.SaveChanges(); } else { throw new Exception("Сделка не найдена"); } } }
public List <DealVM> GetFilteredList(DealBM model) { if (model == null) { return(null); } using (var context = new DataBaseContext()) { return(context.Deals .Include(rec => rec.Vacancy) .Include(rec => rec.Applicant) .Include(rec => rec.Employee) .Where(rec => rec.Date >= model.Date) .Select(CreateModel).ToList()); } }
public DealVM GetElement(DealBM model) { if (model == null) { return(null); } using (var context = new DataBaseContext()) { var deal = context.Deals .Include(rec => rec.Vacancy) .Include(rec => rec.Applicant) .Include(rec => rec.Employee) .FirstOrDefault(rec => rec.Id == model.Id); return(deal != null? CreateModel(deal) : null); } }