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);
}
