public ActionResult Index() { using (var context = new ReadModelContainer()) { var query = from media in context.MediaItems select media; return View(query.ToArray()); } }
public ActionResult Index() { using (var context = new ReadModelContainer()) { var query = from Customer in context.CustomerItems select Customer; return View(query.ToArray()); } }
public ViewResult Return(Guid customerId) { using (var context = new ReadModelContainer()) { var query = (from rented in context.CustomerRentedItems where rented.CustomerId == customerId select rented).ToArray(); return View(new CustomerMoviesModel() { CustomerId = query[0].CustomerId, CustomerName = query[0].CustomerName, RentedMedias = query }); } }
public ActionResult Index() { IEnumerable<NoteItem> items; using (var context = new ReadModelContainer()) { var query = from item in context.NoteItemSet orderby item.CreationDate select item; items = query.ToArray(); } return View(items); }
public ActionResult Edit(Guid id) { NoteItem item; using (var context = new ReadModelContainer()) { item = context.NoteItemSet.Single(note => note.Id == id) ; } var command = new ChangeNoteText(); command.NoteId = id; command.NewText = item.Text; return View(command); }
public ActionResult Report() { IEnumerable<TotalsPerDayItem> items; using (var context = new ReadModelContainer()) { var query = from item in context.TotalsPerDayItemSet orderby item.Date descending select item; items = query.ToArray(); } return View(items); }
public ViewResult Rent(Guid customerId) { using (var context = new ReadModelContainer()) { var customer = (from c in context.CustomerItems where c.Id == customerId select c).Single(); var rentedMedia = (from rented in context.CustomerRentedItems select rented.MediaId).ToArray(); var query = from m in context.MediaItems where !rentedMedia.Contains(m.Id) select m; return View(new CustomerMoviesModel() { CustomerId = customer.Id, CustomerName = customer.Name, Medias = query.ToArray() }); } }