public ValidationResult ManipulateOwner(DSM_Owner owner, string action, out string status) { _ownerDataService.ManipulateOwner(owner, action, out status); if (status.Length > 0) { return(new ValidationResult(status, _localizationService.GetResource(status))); } return(ValidationResult.Success); }
public string ManipulateOwner(DSM_Owner owner, string action, out string errorNumber) { errorNumber = String.Empty; try { DatabaseProviderFactory factory = new DatabaseProviderFactory(); SqlDatabase db = factory.CreateDefault() as SqlDatabase; using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("SetOwner")) { // Set parameters db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, owner.OwnerID); db.AddInParameter(dbCommandWrapper, "@UDOwnerCode", SqlDbType.NVarChar, owner.UDOwnerCode.Trim()); db.AddInParameter(dbCommandWrapper, "@OwnerLevelID", SqlDbType.NVarChar, owner.OwnerLevelID); db.AddInParameter(dbCommandWrapper, "@OwnerName", SqlDbType.NVarChar, owner.OwnerName.Trim()); db.AddInParameter(dbCommandWrapper, "@OwnerShortName", SqlDbType.NVarChar, owner.OwnerShortName.Trim()); db.AddInParameter(dbCommandWrapper, "@ParentOwner", SqlDbType.NVarChar, owner.ParentOwner); db.AddInParameter(dbCommandWrapper, "@UserLevel", SqlDbType.Int, owner.UserLevel); db.AddInParameter(dbCommandWrapper, "@SetBy ", SqlDbType.NVarChar, owner.SetBy); db.AddInParameter(dbCommandWrapper, "@ModifiedBy", SqlDbType.NVarChar, owner.ModifiedBy); db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.Int, owner.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); }