public IApiResult Delete(DeleteUserGroup operation) { var result = operation.ExecuteAsync().Result; if (result is ValidationsOutput) { return(new ApiResult <List <ValidationItem> >() { Data = ((ValidationsOutput)result).Errors }); } else { return(new ApiResult <object>() { Status = ApiResult <object> .ApiStatus.Success }); } }
public async static Task <IDTO> UpdateMode(User user) { OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); user.ModificationDate = DateTime.Now; oracleParams.Add(UserSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)user.ID ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_USERNAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)user.UserName ?? DBNull.Value, 30); oracleParams.Add(UserSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)user.Name ?? DBNull.Value, 500); oracleParams.Add(UserSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)user.Name2 ?? DBNull.Value, 500); oracleParams.Add(UserSpParams.PARAMETER_EFFECTIVE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)user.EffectiveDate ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_EXPIRY_DATE, OracleDbType.Date, ParameterDirection.Input, (object)user.ExpiryDate ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_LOCKUP_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)user.Status ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)user.StatusDate ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_PASSWORD, OracleDbType.Varchar2, ParameterDirection.Input, (object)Encryption.EncryptPassword(user.Password) ?? DBNull.Value, 1000); oracleParams.Add(UserSpParams.PARAMETER_EMAIL, OracleDbType.Varchar2, ParameterDirection.Input, (object)user.Email ?? DBNull.Value, 30); oracleParams.Add(UserSpParams.PARAMETER_COMPANY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)user.CompanyID ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_NO_OF_LOGIN, OracleDbType.Int64, ParameterDirection.Input, (object)user.NoOfLogin ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_BIRTHDATE, OracleDbType.Date, ParameterDirection.Input, (object)user.BirthDate ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_PICTURE, OracleDbType.Varchar2, ParameterDirection.Input, (object)user.Picture ?? DBNull.Value, 500); oracleParams.Add(UserSpParams.PARAMETER_COUNTRY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)user.CountryID ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_MOBILE, OracleDbType.Varchar2, ParameterDirection.Input, (object)user.Mobile ?? DBNull.Value, 30); oracleParams.Add(UserSpParams.PARAMETER_LOCKUP_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)user.UserType ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)user.CreatedBy ?? DBNull.Value, 30); oracleParams.Add(UserSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)user.CreationDate ?? DBNull.Value); oracleParams.Add(UserSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)user.ModifiedBy ?? DBNull.Value, 30); oracleParams.Add(UserSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)user.ModificationDate ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(UserSpName.SP_UPADTE_USER, oracleParams) == -1) { //Delete Relations complate.message = "Updated Successfully"; List <UserGroup> userRelations = new List <UserGroup>(); GetUserGroups userRelationGroup = new GetUserGroups(); userRelationGroup.UserID = user.ID; userRelationGroup.LangID = 1; userRelations = (List <UserGroup>)userRelationGroup.QueryAsync().Result; foreach (var userRelation in userRelations) { DeleteUserGroup deleteUserGroup = new DeleteUserGroup(); deleteUserGroup.ID = userRelation.ID; await deleteUserGroup.ExecuteAsync(); } if (user.Branches.Length > 0) { // Add Relations if (user.Branches.Length > 0) { // Add Relations UserGroup userGroup = new UserGroup(); userGroup.UserName = user.UserName; userGroup.UserID = user.ID; userGroup.RefrenceIDs = user.Branches; if (user.UserRelationID.HasValue) { userGroup.UserRelationID = user.UserRelationID; } else { userGroup.UserRelationID = 1; } await DBUserGroupSetup.AddUserBranches(userGroup); } } return(complate); } else { complate.message = "Operation Failed"; } return(complate); }