// GET: UserDemographics/Create public ActionResult Create() { using (RentMyWroxContext context = new RentMyWroxContext()) { ViewBag.Hobbies = context.Hobbies.Where(x => x.IsActive) .OrderBy(x => x.Name).ToList(); } return(View("Manage", new UserDemographics())); }
// GET: UserDemographics public ActionResult Index() { using (RentMyWroxContext context = new RentMyWroxContext()) { var list = context.UserDemographics.OrderBy(x => x.Birthdate).ToList(); return(View(list)); } }
public ActionResult Details(int id) { using (RentMyWroxContext context = new RentMyWroxContext()) { Item item = context.Items.FirstOrDefault(x => x.Id == id); UserHelper.AddUserVisit(id, context); context.SaveChanges(); return(View(item)); } }
public ActionResult Details(int id) { Guid UserID = UserHelper.GetUserId(); ViewBag.ApplicationUser = UserHelper.GetApplicationUser(); using (RentMyWroxContext context = new RentMyWroxContext()) { var order = context.Orders.Include(p => p.OrderDetails.Select(c => c.Item)).FirstOrDefault(x => x.Id == id && x.UserId == UserID); return(View(order)); } }
// GET: UserDemographics public ActionResult Index() { using (RentMyWroxContext context = new RentMyWroxContext()) { var list = context.UserDemographics.OrderBy(x => x.Birthdate).ToList(); list.Add(new UserDemographics { Birthdate = new DateTime(2000, 6, 8) }); return(View(list)); } }
private ShoppingCartSummary GetShoppingCartSummary(RentMyWroxContext 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.Item.Cost); summary.Quantity = cartList.Sum(x => x.Quantity); } return(summary); }
public ActionResult NonAdminSnippet() { using (RentMyWroxContext context = new RentMyWroxContext()) { Notification note = context.Notifications .Where(x => x.DisplayStartDate <= DateTime.Now && x.DisplayEndDate >= DateTime.Now && !x.IsAdminOnly) .OrderByDescending(x => x.CreateDate) .FirstOrDefault(); return(PartialView("_Notification", note)); } }
public static void AddUserVisit(int itemId, RentMyWroxContext context) { Guid userId = GetUserId(); context.UserVisits.RemoveRange(context.UserVisits.Where(x => x.UserId == userId && x.ItemId == itemId)); context.UserVisits.Add(new UserVisit { ItemId = itemId, UserId = userId, VisitDate = DateTime.Now }); }
public ActionResult Recent() { using (RentMyWroxContext context = new RentMyWroxContext()) { Guid newUserId = UserHelper.GetUserId(); var recentItems = (from uv in context.UserVisits join item in context.Items on uv.ItemId equals item.Id where uv.UserId == newUserId orderby uv.VisitDate descending select item as Item).Take(3).ToList(); context.SaveChanges(); return(PartialView("_RecentItems", recentItems)); } }
public void DetailsView1_InsertItem() { Hobby hobby = new Hobby(); TryUpdateModel(hobby); if (ModelState.IsValid) { using (RentMyWroxContext context = new RentMyWroxContext()) { context.Hobbies.Add(hobby); context.SaveChanges(); } } }
public ActionResult Edit(int id, FormCollection collection) { try { using (RentMyWroxContext context = new RentMyWroxContext()) { var item = context.UserDemographics.FirstOrDefault(x => x.Id == id); TryUpdateModel(item); context.SaveChanges(); return(RedirectToAction("Index")); } } catch { return(View()); } }
protected void Page_Load(object sender, EventArgs e) { using (RentMyWroxContext context = new RentMyWroxContext()) { Notification note = context.Notifications .Where(x => x.IsAdminOnly && x.DisplayStartDate <= DateTime.Now && x.DisplayEndDate >= DateTime.Now) .OrderByDescending(y => y.CreateDate) .FirstOrDefault(); if (note != null) { NotificationTitle.Text = note.Title; NotificationDetail.Text = note.Details; } } }
public ActionResult Edit(int id, FormCollection collection) { using (RentMyWroxContext context = new RentMyWroxContext()) { var item = context.UserDemographics.FirstOrDefault(x => x.Id == id); TryUpdateModel(item); var ids = Request.Form.GetValues("HobbyIds"); item.Hobbies = context.Hobbies.Where(x => ids.Contains(x.Id.ToString())).ToList(); var validationErrors = context.GetValidationErrors(); if (validationErrors.Count() == 0) { context.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ServerValidationErrors = ConvertValidationErrorsToString(validationErrors); return(View("Manage", item)); } }
public ActionResult Create(UserDemographics obj) { try { using (RentMyWroxContext context = new RentMyWroxContext()) { var ids = Request.Form.GetValues("HobbyIds"); obj.Hobbies = context.Hobbies .Where(x => ids.Contains(x.Id.ToString())).ToList(); context.UserDemographics.Add(obj); context.SaveChanges(); return(RedirectToAction("Index")); } } catch { return(View()); } }
private ShoppingCartSummary GetShoppingCartSummary(RentMyWroxContext context) { Guid UserID = UserHelper.GetUserId(); ShoppingCartSummary summary = new ShoppingCartSummary(); var appUser = UserHelper.GetApplicationUser(); if (appUser != null) { summary.UserDisplayName = string.Format("{0} {1}", appUser.FirstName, appUser.LastName); } var cartList = context.ShoppingCarts.Where(x => x.UserId == UserID); if (cartList != null && cartList.Count() > 0) { summary.TotalValue = cartList.Sum(x => x.Quantity * x.Item.Cost); summary.Quantity = cartList.Sum(x => x.Quantity); } return(summary); }
public ActionResult Create(UserDemographics obj) { using (RentMyWroxContext context = new RentMyWroxContext()) { var ids = Request.Form.GetValues("HobbyIds"); if (ids != null) { obj.Hobbies = context.Hobbies.Where(x => ids.Contains(x.Id.ToString())).ToList(); } context.UserDemographics.Add(obj); var validationErrors = context.GetValidationErrors(); if (validationErrors.Count() == 0) { context.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ServerValidationErrors = ConvertValidationErrorsToString(validationErrors); return(View("Manage", obj)); } }
protected void SaveItem_Clicked(object sender, EventArgs e) { Item item; using (RentMyWroxContext context = new RentMyWroxContext()) { if (itemId == 0) { item = new Item(); UpdateItem(item); context.Items.Add(item); } else { item = context.Items.FirstOrDefault(x => x.Id == itemId); UpdateItem(item); } context.SaveChanges(); } Response.Redirect("~/admin/ItemList"); }
public ActionResult AddToCart(int id) { Guid UserID = UserHelper.GetUserId(); using (RentMyWroxContext context = new RentMyWroxContext()) { Item addedItem = context.Items.FirstOrDefault(x => x.Id == id); // now that we know it is a valid ID if (addedItem != null) { // Check to see if this item was already added var sameItemInShoppingCart = context.ShoppingCarts .FirstOrDefault(x => x.Item.Id == id && x.UserId == UserID); if (sameItemInShoppingCart == null) { // if not already in cart then add it ShoppingCart sc = new ShoppingCart { Item = addedItem, UserId = UserID, Quantity = 1, DateAdded = DateTime.Now }; context.ShoppingCarts.Add(sc); } else { // increment the quantity of the existing shopping cart item sameItemInShoppingCart.Quantity++; } UserHelper.AddUserVisit(id, context); context.SaveChanges(); } ShoppingCartSummary summary = GetShoppingCartSummary(context); return(PartialView("_ShoppingCartSummary", summary)); } }
public ActionResult Index(int pageNumber = 1, int pageQty = 5, string sortExp = "name_asc") { using (RentMyWroxContext context = new RentMyWroxContext()) { // set most of the items needed on the client-side ViewBag.PageSize = pageQty; ViewBag.PageNumber = pageNumber; ViewBag.SortExpression = sortExp; var items = from i in context.Items where i.IsAvailable select i; // setting this here to get the count of the filtered list ViewBag.ItemCount = items.Count(); switch (sortExp) { case "name_asc": items = items.OrderBy(i => i.Name); break; case "name_desc": items = items.OrderByDescending(i => i.Name); break; case "cost_asc": items = items.OrderBy(i => i.Cost); break; case "cost_desc": items = items.OrderByDescending(i => i.Cost); break; } items = items.Skip((pageNumber - 1) * pageQty).Take(pageQty); return(View(items.ToList())); } }
protected void Page_Load(object sender, EventArgs e) { IList <string> segments = Request.GetFriendlyUrlSegments(); itemId = 0; if (segments != null && segments.Count > 0) { int.TryParse(segments[0], out itemId); } if (!IsPostBack && itemId != 0) { using (RentMyWroxContext context = new RentMyWroxContext()) { var item = context.Items.FirstOrDefault(x => x.Id == itemId); tbAcquiredDate.Text = item.DateAcquired.ToShortDateString(); tbCost.Text = item.Cost.ToString(); tbDescription.Text = item.Description; tbItemNumber.Text = item.ItemNumber; tbName.Text = item.Name; } } }