public ActionResult Edit(long id) { utblMstCompCategorie model = new utblMstCompCategorie(); model = objdal.GetCategoryByID(id); return(View(model)); }
public string DeleteCategory(long id) { try { utblMstCompCategorie model = db.utblMstCompCategories.Find(id); db.utblMstCompCategories.Remove(model); db.SaveChanges(); return("Category Removed"); } catch (Exception) { return("Error: Server error, try again later"); } }
public string SaveCategory(utblMstCompCategorie model) { var parCategoryID = new SqlParameter("@CategoryID", model.CompCategoryID); var parCategoryName = new SqlParameter("@CategoryName", model.CompCategoryName); var parUserID = new SqlParameter("@UserID", model.UserID); return(db.Database.SqlQuery <string>("udspCompCategorySaveUpdate @CategoryID, @CategoryName, @UserID", parCategoryID, parCategoryName, parUserID).FirstOrDefault()); //else //{ // var parCategoryID = new SqlParameter("@CategoryID", model.CompCategoryID); // return db.Database.SqlQuery<string>("udspCategoryUpdate @CategoryID, @CategoryName, @UserID", // parCategoryID, parCategoryName, parUserID).FirstOrDefault(); //} }
public ActionResult Edit(utblMstCompCategorie model) { if (ModelState.IsValid) { model.UserID = User.Identity.Name; string result = objdal.SaveCategory(model); if (result.Contains("Success")) { objSite.AddAuditLog("utblMstCompCategories", "New Component Categorys Updated", IPAddressGetter.GetIPAddress(), User.Identity.Name); TempData["ErrMsg"] = result; return(RedirectToAction("Categorylist", "CompCategory", new { Area = "Admin" })); } TempData["ErrMsg"] = result; } return(View(model)); }