public ActionResult AddOrEdit(ProductViewModel ivm) { using (eveningDBEntities db = new eveningDBEntities()) { 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.IsSpecial = ivm.IsSpecial; HttpPostedFileBase fup = Request.Files["Photo"]; if (fup != null) { if (fup.FileName != "") { fup.SaveAs(Server.MapPath("~/ProductImages/" + 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["SmallImage"]; if (fup != null) { if (fup.FileName != "") { fup.SaveAs(Server.MapPath("~/ProductImages/" + fup.FileName)); itm.Photo = fup.FileName; } } db.SaveChanges(); ViewBag.Message = "Updated Successfully"; } ViewBag.Categories = db.tblCategories.ToList(); return(View(new ProductViewModel())); } }
public ActionResult Delete(int id) { using (eveningDBEntities db = new eveningDBEntities()) { 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 AddOrEdit(CategoryViewModel sm) { using (eveningDBEntities db = new eveningDBEntities()) { 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 ChangePassword(ChangePasswordViewModel ch) { string username = Session["username"].ToString(); tbluserone us = _db.tbluserones.Where(u => u.UserName == username && u.Password == ch.OldPassword).FirstOrDefault(); if (us != null) { us.Password = ch.NewPassword; _db.SaveChanges(); } else { return(Json(new { success = false, message = "You Enter Wrong Password" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = true, message = "Password Changed Successfully" }, JsonRequestBehavior.AllowGet)); }