public JsonResult search(string name) { int res = 0; BaseCategory_Table obj = db.BaseCategory_Table.Where(x => x.BaseCatName == name && x.BaseCatIsDeleted == false).FirstOrDefault(); ProductCategory_Table obj1 = db.ProductCategory_Table.Where(x => x.ProductCatName == name && x.ProductCatIsDeleted == false).FirstOrDefault(); User_Table obj2 = db.User_Table.Where(x => x.UserName == name && x.UserIsDeleted == false).FirstOrDefault(); if (obj != null) { res = 1; Session["base_cat"] = obj.BaseCatId; var redirectUrl = new UrlHelper(Request.RequestContext).Action("Product_cat", "Buyer"); return(Json(new { res, Url = redirectUrl }, JsonRequestBehavior.AllowGet)); } else if (obj1 != null) { res = 1; Session["prod_cat"] = obj1.ProductCatId; var redirectUrl = new UrlHelper(Request.RequestContext).Action("Product_page", "Buyer"); return(Json(new { res, Url = redirectUrl }, JsonRequestBehavior.AllowGet)); } else if (obj2 != null) { res = 1; Session["brand_id"] = obj2.UserId; var redirectUrl = new UrlHelper(Request.RequestContext).Action("Brand_page", "Buyer"); return(Json(new { res, Url = redirectUrl }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { res }, JsonRequestBehavior.AllowGet)); } }
public JsonResult BaseCategoryDelete(int BaseCatId) { ShoppingCartDbEntities db = new ShoppingCartDbEntities(); BaseCategory_Table basecategory = db.BaseCategory_Table.Find(BaseCatId); // Details of patricular role to be deleted is obtained using it's id basecategory.BaseCatIsDeleted = true; //Obtained data record is made inactive by setting value of isdeleted field to one db.SaveChanges(); bool result = true; var redirectUrl = new UrlHelper(Request.RequestContext).Action("ManageBaseCategories", "Admin"); //passing url to which control to be navigated is stored in a variable return(Json(new { result, Url = redirectUrl }, JsonRequestBehavior.AllowGet)); //Values updated and url is returned back to ajax success function }
public ActionResult ManageBaseCategories(BaseCategory_Table category) //new object of BaseCategory_Table are passed to post function ManageBaseCategories { category.BaseCatCreateDate = DateTime.Now; category.BaseCatCreatedBy = Session["user"].ToString(); category.BaseCatUpdateDate = DateTime.Now; category.BaseCatUpdatedBy = Session["user"].ToString(); category.BaseCatIsDeleted = false; /* Values are added */ db.BaseCategory_Table.Add(category); //Adding values to Role_Table db.SaveChanges(); return(RedirectToAction("ManageBaseCategories")); }
public JsonResult BaseCategoryEdit(int BaseCatId, string BaseCatName, string BaseCatDescription) //updated values are passed as parameters of post function through ajax method { ShoppingCartDbEntities db = new ShoppingCartDbEntities(); BaseCategory_Table category = db.BaseCategory_Table.Find(BaseCatId); //Details of patricular base category to be edited is obtained using it's id category.BaseCatName = BaseCatName; category.BaseCatDesc = BaseCatDescription; category.BaseCatUpdatedBy = Session["user"].ToString(); category.BaseCatIsDeleted = false; category.BaseCatUpdateDate = DateTime.Now; db.SaveChanges(); var redirectUrl = new UrlHelper(Request.RequestContext).Action("ManageBaseCategories", "Admin"); //passing url to which control to be navigated is stored in a variable return(Json(new { BaseCatId = BaseCatId, BaseCatName = BaseCatName, BaseCatDesc = BaseCatDescription, Url = redirectUrl }, JsonRequestBehavior.AllowGet)); //Values updated and url is returned back to ajax success function }