public async Task <dynamic> DeleteDocCategory(DSM_DocCategory objDocCategory) { _action = "delete"; _respStatus = await Task.Run(() => _docCategoryService.ManipulateDocCategory(objDocCategory, _action, out _outStatus)); return(Json(new { Message = _respStatus.Message, _respStatus }, JsonRequestBehavior.AllowGet)); }
public async Task <dynamic> EditDocCategory(DSM_DocCategory objDocCategory) { if (ModelState.IsValid) { _action = "edit"; objDocCategory.SetBy = UserID; objDocCategory.ModifiedBy = objDocCategory.SetBy; _respStatus = await Task.Run(() => _docCategoryService.ManipulateDocCategory(objDocCategory, _action, out _outStatus)); return(Json(new { Message = _respStatus.Message, _respStatus }, JsonRequestBehavior.AllowGet)); } else { _respStatus = new ValidationResult("E404", _localizationService.GetResource("E404")); } return(Json(new { Message = _respStatus.Message, _respStatus }, JsonRequestBehavior.AllowGet)); }
public string ManipulateDocCategory(DSM_DocCategory category, string action, out string errorNumber) { errorNumber = String.Empty; try { DatabaseProviderFactory factory = new DatabaseProviderFactory(); SqlDatabase db = factory.CreateDefault() as SqlDatabase; using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("SetDocCategory")) { // Set parameters db.AddInParameter(dbCommandWrapper, "@DocCategoryID", SqlDbType.NVarChar, category.DocCategoryID); db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, category.OwnerID); db.AddInParameter(dbCommandWrapper, "@DocCategorySL", SqlDbType.NVarChar, category.DocCategorySL); db.AddInParameter(dbCommandWrapper, "@UDDocCategoryCode", SqlDbType.NVarChar, category.UDDocCategoryCode); db.AddInParameter(dbCommandWrapper, "@DocCategoryName", SqlDbType.NVarChar, DataValidation.TrimmedOrDefault(category.DocCategoryName)); db.AddInParameter(dbCommandWrapper, "@UserLevel", SqlDbType.Int, category.UserLevel); db.AddInParameter(dbCommandWrapper, "@SetBy ", SqlDbType.NVarChar, category.SetBy); db.AddInParameter(dbCommandWrapper, "@ModifiedBy", SqlDbType.NVarChar, category.ModifiedBy); db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.Int, category.Status); db.AddInParameter(dbCommandWrapper, "@Action", SqlDbType.VarChar, action); db.AddOutParameter(dbCommandWrapper, spStatusParam, SqlDbType.VarChar, 10); // Execute SP. db.ExecuteNonQuery(dbCommandWrapper); // Getting output parameters and setting response details. if (!db.GetParameterValue(dbCommandWrapper, spStatusParam).IsNullOrZero()) { // Get the error number, if error occurred. errorNumber = db.GetParameterValue(dbCommandWrapper, spStatusParam).PrefixErrorCode(); } } } catch (Exception ex) { errorNumber = "E404"; // Log ex.Message Insert Log Table } return(errorNumber); }
public ValidationResult ManipulateDocCategory(DSM_DocCategory docCategory, string action, out string status) { _categoryDataService.ManipulateDocCategory(docCategory, action, out status); return(status.Length > 0 ? new ValidationResult(status, _localizationService.GetResource(status)) : ValidationResult.Success); }