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