public ActionResult AddCategory(DeviceCategoryModel model) { using (var con = new SqlConnection(_connectionString)) { var result = con.Query <int>("Add_Modify_Delete_Category", new { CatId = "", model.CatName, model.IsRepair, model.IsActive, model.SortOrder, model.Comments, User = CurrentUser.UserId, Action = "add", companyId = CurrentUser.CompanyId }, commandType: CommandType.StoredProcedure).FirstOrDefault(); var response = new ResponseModel(); if (result == 1) { response.IsSuccess = true; response.Response = "Successfully Added"; TempData["response"] = response; } else { response.IsSuccess = true; response.Response = "Category Already Exist"; TempData["response"] = response; } } return(RedirectToAction("DeviceCategory")); }
public ActionResult EditDeviceCategory(DeviceCategoryModel model) { try { using (var con = new SqlConnection(_connectionString)) { var result = con.Query <int>("Add_Modify_Delete_Category", new { model.CatId, model.CatName, model.IsRepair, model.IsActive, model.SortOrder, model.Comments, User = CurrentUser.UserId, Action = "edit", companyId = CurrentUser.CompanyId }, commandType: CommandType.StoredProcedure).FirstOrDefault(); var response = new ResponseModel(); if (result == 2) { response.IsSuccess = true; response.Response = "Category Successfully Updated"; TempData["response"] = response; } } } catch (Exception e) { throw e; } return(RedirectToAction("DeviceCategory")); }