public ActionResult AddOrEdit(int id = 0) { if (id == 0) { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { ViewBag.Categories = db.tblCategories.ToList(); ViewBag.Action = "Create New Product"; return(View(new ProductViewModel())); } } else { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { ViewBag.Action = "Edit Product"; ViewBag.Categories = db.tblCategories.ToList(); tblProduct item = db.tblProducts.Where(i => i.ProductId == id).FirstOrDefault(); ProductViewModel itemvm = new ProductViewModel(); itemvm.ProductId = item.ProductId; itemvm.CategoryId = Convert.ToInt32(item.CategoryId); itemvm.ProductName = item.ProductName; itemvm.UnitPrice = item.UnitPrice; itemvm.SellingPrice = item.SellingPrice; itemvm.Description = item.Description; itemvm.Photo = item.Photo; itemvm.IsSpecial = item.IsSpecial; return(View(itemvm)); } } }
public ActionResult Login(LoginViewModel l, string ReturnUrl = "")//return to the url { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { var users = db.tblUsers.Where(a => a.Username == l.Username && a.Password == l.Password).FirstOrDefault(); if (users != null) { //saving value in session Session.Add("username", users.Username); FormsAuthentication.SetAuthCookie(l.Username, l.RememberMe); if (Url.IsLocalUrl(ReturnUrl)) { return(Redirect(ReturnUrl)); } else { Session.Add("userid", users.UserId); if (users.tblUserRoles.Where(r => r.RoleId == 1).FirstOrDefault() != null)//Redirecting to dashboard and userview { return(RedirectToAction("Dashboard", "Admin")); } else { return(RedirectToAction("Index", "Home")); } } } else { ModelState.AddModelError("", "Invalid User"); } } return(View()); }
public ActionResult Delete(int id) { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { tblProduct sm = db.tblProducts.Where(x => x.ProductId == id).FirstOrDefault(); db.tblProducts.Remove(sm); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult ViewOrder_Post(int id) { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { tblOrder sm = db.tblOrders.Where(x => x.OrderId == id).FirstOrDefault(); sm.DeliveredStatus = "Confirmed"; db.SaveChanges(); return(RedirectToAction("ManageOrder", "Order")); } }
public ActionResult AddOrEdit(ProductViewModel ivm) { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { if (ivm.ProductId == 0) { tblProduct itm = new tblProduct(); itm.CategoryId = Convert.ToInt32(ivm.CategoryId); itm.ProductName = ivm.ProductName; itm.UnitPrice = ivm.UnitPrice; itm.SellingPrice = ivm.SellingPrice; itm.Description = ivm.Description; itm.Description = ivm.Description; HttpPostedFileBase fup = Request.Files["Photo"]; if (fup != null) { if (fup.FileName != "") { fup.SaveAs(Server.MapPath("~/rootcss/images" + fup.FileName)); itm.Photo = fup.FileName; } } db.tblProducts.Add(itm); db.SaveChanges(); ViewBag.Message = "Created Successfully"; } else { tblProduct itm = db.tblProducts.Where(i => i.ProductId == ivm.ProductId).FirstOrDefault(); itm.CategoryId = Convert.ToInt32(ivm.CategoryId); itm.ProductName = ivm.ProductName; itm.UnitPrice = ivm.UnitPrice; itm.SellingPrice = ivm.SellingPrice; itm.Description = ivm.Description; itm.IsSpecial = ivm.IsSpecial; HttpPostedFileBase fup = Request.Files["Photo"]; if (fup != null) { if (fup.FileName != "") { fup.SaveAs(Server.MapPath("~/rootcss/images" + fup.FileName)); itm.Photo = fup.FileName; } } db.SaveChanges(); ViewBag.Message = "Updated Successfully"; } ViewBag.Categories = db.tblCategories.ToList(); return(View(new ProductViewModel())); } }
public JsonResult GetData() { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { db.Configuration.LazyLoadingEnabled = false; List <ProductViewModel> lstitem = new List <ProductViewModel>(); var lst = db.tblProducts.Include("tblCategory").ToList(); foreach (var item in lst) { lstitem.Add(new ProductViewModel() { ProductId = item.ProductId, CategoryName = item.tblCategory.CategoryName, ProductName = item.ProductName, Description = item.Description, UnitPrice = item.UnitPrice, SellingPrice = item.SellingPrice, Photo = item.Photo }); } return(Json(new { data = lstitem }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetData() { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { db.Configuration.LazyLoadingEnabled = false; List <OrderViewModel> lstorder = new List <OrderViewModel>(); var empList = db.tblOrders.Select(x => new { OrderId = x.OrderId, Firstname = x.Firstname, Lastname = x.Lastname, Address = x.Address, Phone = x.Phone, Total = x.Total, OrderDate = x.OrderDate, DeliveredStatus = x.DeliveredStatus }).ToList(); foreach (var item in empList) { lstorder.Add(new OrderViewModel() { OrderId = item.OrderId, Firstname = item.Firstname, Lastname = item.Lastname, Address = item.Address, Phone = item.Phone, Total = item.Total.ToString(), OrderDate = item.OrderDate.ToString(), DeliveredStatus = item.DeliveredStatus }); } return(Json(new { data = lstorder }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetData() { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { db.Configuration.LazyLoadingEnabled = false; List <CategoryViewModel> lst = new List <CategoryViewModel>(); var catList = db.tblCategories.ToList(); foreach (var item in catList) { lst.Add(new CategoryViewModel() { CategoryId = item.CategoryId, CategoryName = item.CategoryName }); } return(Json(new { data = lst }, JsonRequestBehavior.AllowGet)); } }
public ActionResult ViewOrder(int id) { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { List <OrderDetailsViewModel> lstod = new List <OrderDetailsViewModel>(); var empList = db.tblOrderDetails.Where(x => x.OrderId == id).ToList(); foreach (tblOrderDetail product in empList) { lstod.Add(new OrderDetailsViewModel() { ProductId = Convert.ToInt32(product.ProductId), ProductName = product.tblProduct.ProductName, Quantity = Convert.ToInt32(product.Quantity), UnitPrice = Convert.ToDecimal(product.UnitPrice) }); } Session.Add("productlist", lstod); Session.Add("orderid", id); return(View(lstod)); } }
public ActionResult AddOrEdit(tblCategory sm) { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { if (sm.CategoryId == 0) { db.tblCategories.Add(sm); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { db.Entry(sm).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult AddOrEdit(int id = 0) { if (id == 0) { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { // ViewBag.Menus = db.tblMenus.ToList(); return(View(new tblCategory())); } } else { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { // ViewBag.Menus = db.tblMenus.ToList(); return(View(db.tblCategories.Where(x => x.CategoryId == id).FirstOrDefault())); } } }
public ActionResult AddOrEdit(CategoryViewModel sm) { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { if (sm.CategoryId == 0) { tblCategory tb = new tblCategory(); tb.CategoryName = sm.CategoryName; db.tblCategories.Add(tb); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { tblCategory tbm = db.tblCategories.Where(m => m.CategoryId == sm.CategoryId).FirstOrDefault(); tbm.CategoryName = sm.CategoryName; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult AddOrEdit(int id = 0) { if (id == 0) { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { ViewBag.Action = "New Category"; return(View(new CategoryViewModel())); } } else { using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities()) { CategoryViewModel sub = new CategoryViewModel(); var menu = db.tblCategories.Where(x => x.CategoryId == id).FirstOrDefault(); sub.CategoryId = menu.CategoryId; sub.CategoryName = menu.CategoryName; ViewBag.Action = "Edit Category"; return(View(sub)); } } }