// GET: AdminTickets public ActionResult Index() { using (TicketDominatorContext context = new TicketDominatorContext()) { var list = context.Tickets.OrderBy(x => x.Artist).ToList(); return(View(list)); } }
public ActionResult Checkout() { Guid UserId = UserHelper.GetUserId(); ViewBag.ApplicationUser = UserHelper.GetApplicationUser(); ViewBag.CheckingOut = true; using (TicketDominatorContext context = new TicketDominatorContext()) { var shoppingCartItems = context.ShoppingCarts.Include("Ticket").Where(x => x.UserId == UserId); Order newOrder = new Order { OrderDate = DateTime.Now, UserId = UserId, OrderDetails = new List <OrderDetail>() }; foreach (var item in shoppingCartItems) { OrderDetail od = new OrderDetail { Ticket = item.Ticket, PricePaidEach = item.Ticket.Price, Quantity = item.Quantity }; newOrder.OrderDetails.Add(od); } return(View("Details", newOrder)); } }
public static void TransferTemporaryUserToRealUser(Guid tempId, string userId) { using (TicketDominatorContext context = new TicketDominatorContext()) { if (context.ShoppingCarts.Any(x => x.UserId == tempId)) { Guid newUserId = Guid.Parse(userId); var list = context.ShoppingCarts.Include("Ticket").Where(x => x.UserId == tempId); foreach (var tempCart in list) { var sameItemInShoppingCart = context.ShoppingCarts .FirstOrDefault(x => x.Ticket.Id == tempCart.Ticket.Id && x.UserId == newUserId); if (sameItemInShoppingCart == null) { tempCart.UserId = newUserId; } else { sameItemInShoppingCart.Quantity++; context.ShoppingCarts.Remove(tempCart); } } context.SaveChanges(); } } }
public ActionResult Partial() { using (TicketDominatorContext context = new TicketDominatorContext()) { ShoppingCartSummary summary = GetShoppingCartSummary(context); return(PartialView("_AjaxCartSummary", summary)); } }
public ActionResult Details(int?id) { if (id == null) { return(this.RedirectToAction("Index")); } Guid UserID = UserHelper.GetUserId(); ViewBag.ApplicationUser = UserHelper.GetApplicationUser(); using (TicketDominatorContext context = new TicketDominatorContext()) { IQueryable <Order> orders = context.Orders.Include(p => p.OrderDetails.Select(c => c.Ticket)); Order order; if (User.IsInRole("Admin")) { order = orders.FirstOrDefault(x => x.Id == id); } else { order = orders.FirstOrDefault(x => x.Id == id && x.UserId == UserID); } if (order == null) { return(this.RedirectToAction("Index")); } return(View(order)); } }
// GET: Tickets public ActionResult Index(int page = 1, int pageQty = 12, string sortExp = "date", string sortOrder = "asc") { if (User.IsInRole("Admin") && !Request.IsAjaxRequest()) { return(this.RedirectToAction("Index", "AdminTickets")); } using (TicketDominatorContext context = new TicketDominatorContext()) { ViewBag.SortExpression = sortExp; ViewBag.SortOrder = sortOrder; //var items = from i in context.Tickets where i.Amount > 0 select i; var items = context.Tickets.Where(x => x.Amount > 0); switch (sortExp) { case "date": if (sortOrder == "desc") { items = items.OrderByDescending(x => x.Date); } else { items = items.OrderBy(x => x.Date); } break; case "artist": if (sortOrder == "desc") { items = items.OrderByDescending(x => x.Artist); } else { items = items.OrderBy(x => x.Artist); } break; case "venue": if (sortOrder == "desc") { items = items.OrderByDescending(x => x.Venue); } else { items = items.OrderBy(x => x.Venue); } break; } if (Request.IsAjaxRequest()) { return(Json(items.ToList(), JsonRequestBehavior.AllowGet)); } return(View(items.ToPagedList(page, pageQty))); } }
private ShoppingCartSummary GetShoppingCartSummary(TicketDominatorContext context) { ShoppingCartSummary summary = new ShoppingCartSummary(); var cartList = context.ShoppingCarts.Where(x => x.UserId == UserId); if (cartList != null && cartList.Count() > 0) { summary.TotalValue = cartList.Sum(x => x.Quantity * x.Ticket.Price); summary.Quantity = cartList.Sum(x => x.Quantity); } return(summary); }
public ActionResult Create(Ticket obj) { try { // TODO: Add insert logic here using (TicketDominatorContext context = new TicketDominatorContext()) { context.Tickets.Add(obj); context.SaveChanges(); return(RedirectToAction("Index")); } } catch { return(View()); } }
public ActionResult Edit(int id, Ticket obj) { try { using (TicketDominatorContext context = new TicketDominatorContext()) { var item = context.Tickets.FirstOrDefault(x => x.Id == id); TryUpdateModel(item); context.SaveChanges(); return(RedirectToAction("Index")); } } catch { return(View()); } }
public ActionResult Delete(int id, FormCollection collection) { try { // TODO: Add delete logic here using (TicketDominatorContext context = new TicketDominatorContext()) { Ticket ticket = context.Tickets.FirstOrDefault(x => x.Id == id); context.Tickets.Remove(ticket); context.SaveChanges(); return(RedirectToAction("Index")); } } catch { return(View()); } }
// GET: Ticket/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(RedirectToAction("Index")); } Ticket result = null; using (TicketDominatorContext context = new TicketDominatorContext()) { result = context.Tickets.FirstOrDefault(x => x.Id == id); } return(View(result)); }
// GET: SHoppingCart public ActionResult Index() { using (TicketDominatorContext context = new TicketDominatorContext()) { ViewBag.Summary = GetShoppingCartSummary(context); var carts = context.ShoppingCarts.Include("Ticket").Where(x => x.UserId == UserId); if (Request.IsAjaxRequest()) { return(Json(carts.ToList(), JsonRequestBehavior.AllowGet)); } return(View(carts.ToList())); } }
// GET: Tickets/Details/5 public ActionResult Details(int?id) { if (User.IsInRole("Admin")) { return(this.RedirectToAction("Index", "AdminTickets")); } if (id == null) { return(RedirectToAction("Index")); } Ticket result = null; using (TicketDominatorContext context = new TicketDominatorContext()) { result = context.Tickets.FirstOrDefault(x => x.Id == id); } return(View(result)); }
public ActionResult AddToCart(int id, bool mobile = false) { using (TicketDominatorContext context = new TicketDominatorContext()) { Ticket addTicket = context.Tickets.FirstOrDefault(x => x.Id == id); if (addTicket != null) { var sameItemInCart = context.ShoppingCarts.FirstOrDefault(x => x.Ticket.Id == id && x.UserId == UserId); if (sameItemInCart == null) { ShoppingCart sc = new ShoppingCart { Ticket = addTicket, UserId = UserId, Quantity = 1, DateAdded = DateTime.Now }; context.ShoppingCarts.Add(sc); } else { sameItemInCart.Quantity++; } context.SaveChanges(); } ShoppingCartSummary summary = GetShoppingCartSummary(context); if (mobile) { return(Json(summary, JsonRequestBehavior.AllowGet)); } else { return(PartialView("_AjaxCartSummary", summary)); } } }
// GET: Order public ActionResult Index() { ViewBag.ApplicationUser = UserHelper.GetApplicationUser(); using (TicketDominatorContext context = new TicketDominatorContext()) { var UserId = UserHelper.GetUserId(); List <Order> orders = context.Orders.ToList(); if (!User.IsInRole("Admin")) { orders = context.Orders.Where(x => x.UserId == UserId).ToList(); } if (Request.IsAjaxRequest()) { return(Json(orders, JsonRequestBehavior.AllowGet)); } return(View(orders)); } }
public ActionResult Checkout(Order order) { Guid UserID = UserHelper.GetUserId(); ViewBag.ApplicationUser = UserHelper.GetApplicationUser(); using (TicketDominatorContext context = new TicketDominatorContext()) { var shoppingCartTickets = context.ShoppingCarts.Include("Ticket").Where(x => x.UserId == UserId); order.OrderDetails = new List <OrderDetail>(); order.UserId = UserId; order.OrderDate = DateTime.Now; foreach (var ticket in shoppingCartTickets) { int quantity = 0; int.TryParse(Request.Form.Get(ticket.Ticket.Id.ToString()), out quantity); if (quantity > 0) { OrderDetail od = new OrderDetail { Ticket = ticket.Ticket, PricePaidEach = ticket.Ticket.Price, Quantity = quantity }; order.OrderDetails.Add(od); } } order = context.Orders.Add(order); context.ShoppingCarts.RemoveRange(shoppingCartTickets); context.SaveChanges(); return(RedirectToAction("Details", "Order", new { id = order.Id })); } }
// GET: Ticket/Create public ActionResult Create() { using (TicketDominatorContext context = new TicketDominatorContext()) { return(View()); } }