Exemple #1
0
 public void CreateOrUpdate(ExperienceBindingModel model)
 {
     using (var context = new CampDatabase())
     {
         Experience experience;
         if (model.Id.HasValue)
         {
             experience = context.Experience.FirstOrDefault(rec => rec.Id ==
                                                            model.Id);
             if (experience == null)
             {
                 throw new Exception("Элемент не найден");
             }
         }
         else
         {
             experience = new Experience();
             context.Experience.Add(experience);
         }
         experience.CounsellorId = model.CounsellorId;
         experience.AgeFrom      = model.AgeFrom;
         experience.AgeTo        = model.AgeTo;
         experience.Years        = model.Years;
         context.SaveChanges();
     }
 }
Exemple #2
0
 public List <ExperienceViewModel> Read(ExperienceBindingModel model)
 {
     using (var context = new CampDatabase())
     {
         return(context.Experience
                .Where(rec => model == null || rec.Id == model.Id || (rec.AgeFrom == model.AgeFrom && rec.AgeTo == model.AgeTo && rec.Years == model.Years && rec.CounsellorId == model.CounsellorId))
                .Select(rec => new ExperienceViewModel
         {
             Id = rec.Id,
             AgeFrom = rec.AgeFrom,
             AgeTo = rec.AgeTo,
             Years = rec.Years
         })
                .ToList());
     }
 }
Exemple #3
0
 public void Delete(ExperienceBindingModel model)
 {
     using (var context = new CampDatabase())
     {
         Experience experience = context.Experience.FirstOrDefault(rec => rec.Id ==
                                                                   model.Id);
         if (experience != null)
         {
             context.Experience.Remove(experience);
             context.SaveChanges();
         }
         else
         {
             throw new Exception("Элемент не найден");
         }
     }
 }