public JsonResult GetCategory(int CategoryId) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var cat = db.Categories.Where(a => a.ID == CategoryId).FirstOrDefault(); return(Json(cat)); }
public JsonResult GetItem(int ItemId) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var cat = db.Items.Where(a => a.ID == ItemId).FirstOrDefault(); return(Json(cat)); }
public JsonResult Remove(int cartId) { try { CartService cartService = new CartService(); ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var Item = db.Items.Where(a => a.ID == cartId).FirstOrDefault(); CartItem cartItem = cartService.RemoveFromCart(Item); List <CartItem> CartItems = (List <CartItem>)Session["Cart"]; CartItems.RemoveAll(x => x.ID == cartItem.ID); Session["Cart"] = CartItems; return(Json(cartItem.Name)); } catch (Exception ex) { return(Json("0")); } //Session["UserId"] = 1; //int userId = (int)Session["UserId"]; //int id = Convert.ToInt32(Session["UserId"]); }
public ActionResult DeleteItems(int id) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var hut = db.Items.Where(a => a.ID == id).FirstOrDefault(); return(View(hut)); }
public JsonResult Add(int ItemId) { try { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var Item = db.Items.Where(a => a.ID == ItemId).FirstOrDefault(); if (Session["Wishlist"] == null) { List <Item> Wishlist = new List <Item>(); Wishlist.Add(Item); Session["Wishlist"] = Wishlist; } else { List <Item> Wishlist = (List <Item>)Session["Wishlist"]; Wishlist.Add(Item); Session["Wishlist"] = Wishlist; } return(Json(Item.Name)); } catch (Exception ex) { return(Json("0")); } //Session["UserId"] = 1; //int userId = (int)Session["UserId"]; //int id = Convert.ToInt32(Session["UserId"]); }
public ActionResult DeleteCategories(int id) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var user = db.Categories.Where(a => a.ID == id).FirstOrDefault(); return(View(user)); }
public string Update(int id, string name, decimal price, HttpPostedFileBase imageurl, string itemdesc, int catid, string available) { if (imageurl == null) { return("Please select an image!"); } //set new upload location string location = Server.MapPath("~/Content/Images/"); //generate folder if it doessnt exist if (!Directory.Exists(location)) { Directory.CreateDirectory(location); } //get file name var fileName = Path.GetFileName(imageurl.FileName); //get file extension string extension = Path.GetExtension(imageurl.FileName); //create unique file name string uniquefilename = Guid.NewGuid().ToString("N") + extension; //Combine location with image string fileinpath = Path.Combine(location + uniquefilename); //Store image imageurl.SaveAs(fileinpath); string dbpath = "/Content/Images/" + uniquefilename; ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); Item item = db.Items.Where(a => a.ID == id).FirstOrDefault(); item.Name = name; item.Price = price; item.ImageURL = dbpath; item.ItemDescription = itemdesc; item.CategoryID = catid; item.Availability = available; int count = db.SaveChanges(); if (count > 0) { return("1"); } else { return("An error occured. Please try again."); } }
public ActionResult AddItems() { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); ViewModel vm = new ViewModel(); var listofcategories = db.Categories.ToList(); vm.ctgry = listofcategories; return(View(vm)); }
// // GET: /Items/ public ActionResult Item() { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); List <Item> item = db.Items.OrderBy(a => a.CategoryID).ToList(); ViewModel vm = new ViewModel(); vm.item = item; return(View(vm)); }
public ActionResult Blog() { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var names = db.Categories.OrderBy(a => a.CategoryName).ToList(); ViewModel vm = new ViewModel(); vm.ctgry = names; return(View(vm)); }
// // GET: /Categories/ public ActionResult categories() { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); List <Category> catg = db.Categories.OrderBy(a => a.CategoryName).ToList(); ViewModel vm = new ViewModel(); vm.ctgry = catg; return(View(vm)); }
public ActionResult EditItems(int id) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var hut = db.Items.Where(a => a.ID == id).FirstOrDefault(); ViewModel vm = new ViewModel(); var listofcategories = db.Categories.ToList(); vm.ctgry = listofcategories; vm.SingleItem = hut; return(View(vm)); }
public JsonResult Update(int cartId, int quantity) { try { CartService cartService = new CartService(); ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var Item = db.Items.Where(a => a.ID == cartId).FirstOrDefault(); CartItem cartItem = cartService.ConvertToCartItem(Item, quantity); if (Session["Cart"] == null) { List <CartItem> CartItems = new List <CartItem>(); CartItems.Add(cartItem); Session["Cart"] = CartItems; } else { List <CartItem> CartItems = (List <CartItem>)Session["Cart"]; // if that item is already in the cart var check = CartItems.Where(a => a.ID == cartId).FirstOrDefault(); if (check != null) { foreach (var item in CartItems) { if (item.ID == cartId) { item.Quantity = quantity; } } Session["Cart"] = CartItems; } else { CartItems.Add(cartItem); Session["Cart"] = CartItems; } } return(Json(cartItem.Name)); } catch (Exception ex) { return(Json("0")); } //Session["UserId"] = 1; //int userId = (int)Session["UserId"]; //int id = Convert.ToInt32(Session["UserId"]); }
public ActionResult Sale() { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var ctgry = db.Categories.OrderBy(a => a.CategoryName).ToList(); var item = db.Items.OrderBy(a => a.Price).ToList(); ViewModel vm = new ViewModel(); vm.ctgry = ctgry; vm.item = item; return(View(vm)); }
public ActionResult categoriespage(int id) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var list = db.Categories.OrderBy(a => a.CategoryName).ToList(); var items = db.Items.Where(a => a.CategoryID == id).Take(15).ToList(); ViewModel vm = new ViewModel(); vm.ctgry = list; vm.item = items; vm.totalcount = db.Items.Where(a => a.CategoryID == id).Count(); return(View(vm)); }
public ActionResult Index() { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var item = db.Items.OrderByDescending(a => a.DateAdded).Take(12).ToList(); var item1 = db.Items.OrderBy(a => a.Price).Where(a => a.Price < 5000).Take(12).ToList(); var item2 = db.Items.OrderByDescending(a => a.Price).Where(a => a.Price >= 10000).Take(12).ToList(); ViewModel vm = new ViewModel(); vm.item = item; vm.item1 = item1; vm.item2 = item2; return(View(vm)); }
public ActionResult Product() { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var ctgry = db.Categories.OrderBy(a => a.CategoryName).ToList(); var items = db.Items.OrderBy(a => a.CategoryID).Take(15).ToList(); ViewModel vm = new ViewModel(); vm.ctgry = ctgry; vm.item = items; vm.totalcount = db.Items.Count(); return(View(vm)); }
public string Login(string email, string password) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); AdminUser admin = db.AdminUsers.Where(a => a.Email == email && a.password == password).FirstOrDefault(); if (admin != null) { Session["email"] = admin.Email; Session["UserId"] = admin.ID; return("1"); } else { return("0"); } }
public string Delete(int id) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var del = db.Categories.Where(a => a.ID == id).FirstOrDefault(); db.Categories.Remove(del); int count = db.SaveChanges(); if (count > 0) { return("Deleted Successfully! Press 'OK' to continue..."); } else { return("An error occured!"); } }
public string Delete(int id) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); Item item = db.Items.Where(a => a.ID == id).FirstOrDefault(); db.Items.Remove(item); int count = db.SaveChanges(); if (count > 0) { return("You have deleted this item. Click 'OK' to continue..."); } else { return("An error occured. Try again."); } }
public ActionResult ProductDetail(int id) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); var hut = db.Items.Where(a => a.ID == id).FirstOrDefault(); //category name var name = db.Categories.Where(a => a.ID == hut.CategoryID).FirstOrDefault(); //Related Products var items = db.Items.Where(a => a.CategoryID == hut.CategoryID).ToList(); ViewModel vm = new ViewModel(); vm.SingleItem = hut; vm.SingleCategory = name; vm.item = items; return(View(vm)); }
public string Update(string cname, int id) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); Category cat = db.Categories.Where(a => a.ID == id).FirstOrDefault(); cat.CategoryName = cname; int count = db.SaveChanges(); if (count > 0) { return("Updated Successfully! Press 'OK' to continue..."); } else { return("An error occurred!"); } }
public string AddCategories(string cname) { ShopMgtSystemDBContext db = new ShopMgtSystemDBContext(); Category category = new Category(); category.CategoryName = cname; db.Categories.Add(category); int count = db.SaveChanges(); if (count > 0) { return("You have added a new category."); } else { return("An error occured."); } }