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.");
}
}
