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