public MarksViewModel GetElement(MarksBindingModel model) { if (model == null) { return(null); } using (var context = new JournalDb()) { var mark = context.Marks .Include(rec => rec.User) .Include(rec => rec.Discipline) .FirstOrDefault(rec => rec.Id == model.Id); return(mark != null ? new MarksViewModel { Id = mark.Id, UserId = mark.UserId, UserName = mark.User.UserName, DisciplineId = mark.DisciplineId, DisciplineName = mark.Discipline.NameDiscipline, Mark = mark.Mark, Date = mark.Date, } : null); } }
public List <MarksViewModel> GetFilteredList(MarksBindingModel model) { if (model == null) { return(null); } using (var context = new JournalDb()) { return(context.Marks .Include(rec => rec.User) .Include(rec => rec.Discipline) .Where(rec => (!model.DateFrom.HasValue && !model.DateTo.HasValue && rec.Date.Date == model.Date.Date) || (model.DateFrom.HasValue && model.DateTo.HasValue && rec.Date.Date >= model.DateFrom.Value.Date && rec.Date.Date <= model.DateTo.Value.Date)) .ToList() .Select(rec => new MarksViewModel { Id = rec.Id, UserId = rec.UserId, DisciplineId = rec.DisciplineId, UserName = rec.User.UserName, DisciplineName = rec.Discipline.NameDiscipline, Mark = rec.Mark, Date = rec.Date, }) .ToList()); } }
public void Insert(MarksBindingModel model) { using (var context = new JournalDb()) { context.Marks.Add(CreateModel(model, new Marks())); context.SaveChanges(); } }
private Marks CreateModel(MarksBindingModel model, Marks mark) { mark.Mark = model.Mark; mark.Date = model.Date; mark.UserId = model.UserId; mark.DisciplineId = model.DisciplineId; return(mark); }
public List <MarksViewModel> Read(MarksBindingModel model) { if (model == null) { return(markStorage.GetFullList()); } return(new List <MarksViewModel> { markStorage.GetElement(model) }); }
public void Delete(MarksBindingModel model) { var mark = markStorage.GetElement( new MarksBindingModel { Id = model.Id }); if (mark == null) { throw new Exception("Оценка не найдена"); } markStorage.Delete(model); }
public void Update(MarksBindingModel model) { using (var context = new JournalDb()) { var mark = context.Marks.FirstOrDefault(rec => rec.Id == model.Id); if (mark == null) { throw new Exception("Оценка не найдена"); } CreateModel(model, mark); context.SaveChanges(); } }