public PagedList <AccountStatementImport> GetAsiTable(FilterAsiTableSelected filter) { var accountStatementImports = Context.AccountStatementImport .Include(x => x.User) .AsQueryable(); if (filter.IdUser.HasValue) { accountStatementImports = accountStatementImports.Where(x => x.IdUser == filter.IdUser); } if (filter.IdBankAgency.HasValue) { accountStatementImports = accountStatementImports.Where(x => x.IdBankAgency == filter.IdBankAgency); } if (filter.Pagination.SortDirection == "asc") { accountStatementImports = accountStatementImports.OrderBy(filter.Pagination.SortColumn); } else { accountStatementImports = accountStatementImports.OrderByDescending(filter.Pagination.SortColumn); } var results = PagedListRepository <AccountStatementImport> .Create(accountStatementImports, filter.Pagination); return(results); }
public PagedList <AccountStatementImportFile> GetAsifTable(FilterAsifTableSelected filter) { var accountStatementImportFiles = Context.AccountStatementImportFile .Include(x => x.Operation) .Include(x => x.OperationMethod) .Include(x => x.OperationType) .Include(x => x.OperationTypeFamily) .AsQueryable(); if (filter.IdImport != null) { accountStatementImportFiles = accountStatementImportFiles.Where(x => x.IdImport == filter.IdImport); } if (filter.Account != null) { accountStatementImportFiles = accountStatementImportFiles.Where(x => x.IdAccount == filter.Account.Id); } if (filter.AsifState != null) { accountStatementImportFiles = accountStatementImportFiles.Where(x => (int)x.EnumAsifState == filter.AsifState.Id); } if (filter.Pagination.SortDirection == "asc") { accountStatementImportFiles = accountStatementImportFiles.OrderBy(filter.Pagination.SortColumn); } else { accountStatementImportFiles = accountStatementImportFiles.OrderByDescending(filter.Pagination.SortColumn); } var results = PagedListRepository <AccountStatementImportFile> .Create(accountStatementImportFiles, filter.Pagination); return(results); }
public PagedList <User> GetUserTable(FilterUserTableSelected filter) { var users = Context.User .Include(x => x.Shortcuts) .AsQueryable(); if (filter.Keyword != null) { users = users.Where(x => x.FirstName.ToUpper().Contains(filter.Keyword.ToUpper()) || x.LastName.ToUpper().Contains(filter.Keyword.ToUpper()) || x.UserName.ToUpper().Contains(filter.Keyword.ToUpper()) ); } if (filter.Pagination.SortDirection == "asc") { users = users.OrderBy(filter.Pagination.SortColumn); } else { users = users.OrderByDescending(filter.Pagination.SortColumn); } var results = PagedListRepository <User> .Create(users, filter.Pagination); return(results); }
public PagedList <OperationType> GetOtTable(FilterOtTableSelected filter) { var operationTypes = Context.OperationType .Where(x => x.IdUserGroup == filter.User.IdUserGroup) .Include(x => x.OperationTypeFamily) .AsQueryable(); if (filter.Label != null) { operationTypes = operationTypes.Where(x => x.Label.Contains(filter.Label)); } if (filter.Otf != null) { operationTypes = operationTypes.Where(x => x.IdOperationTypeFamily == filter.Otf.Id); } if (filter.Pagination.SortDirection == "asc") { operationTypes = operationTypes.OrderBy(filter.Pagination.SortColumn); } else { operationTypes = operationTypes.OrderByDescending(filter.Pagination.SortColumn); } var results = PagedListRepository <OperationType> .Create(operationTypes, filter.Pagination); return(results); }
public PagedList <Operation> GetTable(FilterOperationTableSelected filter) { var operations = Context.Operation .Where(x => x.IdUserGroup == filter.User.IdUserGroup) .Include(x => x.OperationType) .Include(x => x.OperationMethod) .AsQueryable(); if (filter.Label != null) { operations = operations.Where(x => x.Label.Contains(filter.Label)); } if (filter.OperationMethods != null && filter.OperationMethods.Count > 0) { var idOperationMethods = filter.OperationMethods.Select(x => x.Id).ToList(); operations = operations.Where(x => idOperationMethods.Contains(x.IdOperationMethod)); } if (filter.OperationTypes != null && filter.OperationTypes.Count > 0) { var idOperationTypes = filter.OperationTypes.Select(x => x.Id).ToList(); operations = operations.Where(x => idOperationTypes.Contains(x.IdOperationType)); } if (filter.Pagination.SortDirection == "asc") { operations = operations.OrderBy(filter.Pagination.SortColumn); } else { operations = operations.OrderByDescending(filter.Pagination.SortColumn); } var results = PagedListRepository <Operation> .Create(operations, filter.Pagination); return(results); }
public PagedList <OperationTypeFamily> GetOtfTable(FilterOtfTableSelected filter) { var operationTypeFamilies = Context.OperationTypeFamily .Where(x => x.IdUserGroup == filter.User.IdUserGroup) .Include(x => x.Movement) .AsQueryable(); if (filter.Label != null) { operationTypeFamilies = operationTypeFamilies.Where(x => x.Label.Contains(filter.Label)); } if (filter.Movement != null) { operationTypeFamilies = operationTypeFamilies.Where(x => x.IdMovement == filter.Movement.Id); } //string columnSorted; //columnSorted = $"OperationTypeFamily.{filter.Pagination.SortColumn}"; //if (filter.Pagination.SortColumn.Contains("movement")) //{ // columnSorted = $"{columnSorted}.Label"; //} if (filter.Pagination.SortDirection == "asc") { operationTypeFamilies = operationTypeFamilies.OrderBy(filter.Pagination.SortColumn); } else { operationTypeFamilies = operationTypeFamilies.OrderByDescending(filter.Pagination.SortColumn); } var results = PagedListRepository <OperationTypeFamily> .Create(operationTypeFamilies, filter.Pagination); return(results); }
public PagedList <AccountStatement> GetAsTable(FilterAsTableSelected filter) { var accountStatements = Context.AccountStatement .Include(x => x.Operation) .Include(x => x.OperationMethod) .Include(x => x.OperationType) .Include(x => x.OperationType.OperationTypeFamily) .AsQueryable(); if (filter.IdAccount != null) { accountStatements = accountStatements.Where(x => x.IdAccount == filter.IdAccount); } if (filter.OperationMethod != null && filter.OperationMethod.Count > 0) { var idOperationMethods = filter.OperationMethod.Select(x => x.Id).ToList(); accountStatements = accountStatements.Where(x => idOperationMethods.Contains(x.IdOperationMethod)); } if (filter.Operation != null && filter.Operation.Count > 0) { var idOperations = filter.Operation.Select(x => x.Id).ToList(); accountStatements = accountStatements.Where(x => idOperations.Contains(x.IdOperation)); } if (filter.OperationTypeFamily != null && filter.OperationTypeFamily.Count > 0) { var idOperationTypeFamilies = filter.OperationTypeFamily.Select(x => x.Id).ToList(); accountStatements = accountStatements.Where(x => idOperationTypeFamilies.Contains(x.IdOperationTypeFamily)); } if (filter.OperationType != null && filter.OperationType.Count > 0) { var idOperationTypes = filter.OperationType.Select(x => x.Id).ToList(); accountStatements = accountStatements.Where(x => idOperationTypes.Contains(x.IdOperationType)); } if (filter.DateIntegration != null && filter.DateIntegration.DateMin != null) { accountStatements = accountStatements .Where(x => x.DateIntegration >= filter.DateIntegration.DateMin); if (filter.DateIntegration != null && filter.DateIntegration.DateMax != null) { accountStatements = accountStatements .Where(x => x.DateIntegration <= filter.DateIntegration.DateMax); } } else if (filter.MonthYear != null) { var date = Convert.ToDateTime($"01/{filter.MonthYear.Month.Id}/{filter.MonthYear.Year}"); var dateMin = DateHelper.GetFirstDayOfMonth(date); var dateMax = DateHelper.GetLastDayOfMonth(date); accountStatements = accountStatements .Where(x => x.DateIntegration >= dateMin && x.DateIntegration <= dateMax); } if (filter.Amount != null && filter.Amount.NumberMin != null) { accountStatements = accountStatements .Where(x => x.AmountOperation >= filter.Amount.NumberMin); } if (filter.Amount != null && filter.Amount.NumberMax != null) { accountStatements = accountStatements .Where(x => x.AmountOperation <= filter.Amount.NumberMax); } string columnSorted; if (filter.Pagination.SortColumn.Contains("operationTypeFamily")) { columnSorted = $"OperationType.{filter.Pagination.SortColumn}.Label"; } else { columnSorted = filter.Pagination.SortColumn.Contains("operation") ? $"{filter.Pagination.SortColumn}.Label" : filter.Pagination.SortColumn; } if (filter.Pagination.SortDirection == "asc") { accountStatements = accountStatements.OrderBy(columnSorted); } else { accountStatements = accountStatements.OrderByDescending(columnSorted); } var results = PagedListRepository <AccountStatement> .Create(accountStatements, filter.Pagination); return(results); }