public DataTableOutput <SalaryTabulator> GetSalarysTabulators(DataTableInput input)
{
var output = new DataTableOutput <SalaryTabulator>();
var searchBy = (input.search != null) ? input.search.value : null;
var take = input.length;
var skip = input.start;
var recordsFiltered = 0;
string sortBy = "";
bool sortDir = true;
if (input.order != null)
{
// in this example we just default sort on the 1st column
sortBy = input.columns[input.order[0].column].data;
sortDir = input.order[0].dir.ToLower() == "asc";
}
IEnumerable <SalaryTabulator> result = repository.SortOrderAndPaging(searchBy, take, skip, sortBy, sortDir, out recordsFiltered);
if (result == null)
{
output.data = new List <SalaryTabulator>();
}
output.data = result.ToList();
output.recordsFiltered = recordsFiltered;
output.recordsTotal = repository.Count(x => 1 == 1);
return(output);
}
public async Task <DataTableResponse <UserDataTable> > GetTableData(DataTableInput model, ICollection <User> list)
{
try
{
var result = new DataTableResponse <UserDataTable>();
int totalRecords = list.Count;
var modifiedData = list.Select(d => new UserDataTable
{
Id = d.Id.ToString(),
UserName = d.UserName,
Email = d.Email,
Name = d.FirstName,
Lastname = d.LastName,
PhoneNumber = d.PhoneNumber != null ? d.PhoneNumber.ToString() : null,
TwoFactorEnabled = d.TwoFactorEnabled.ToString()
}
);
if (!string.IsNullOrEmpty(model.search.value) &&
!string.IsNullOrWhiteSpace(model.search.value))
{
modifiedData = modifiedData.Where(p => p.UserName.ToLower().Contains(model.search.value) ||
p.Email.ToLower().Contains(model.search.value) ||
p.Name.ToLower().Contains(model.search.value) ||
p.Lastname.ToLower().Contains(model.search.value) ||
p.PhoneNumber.ToLower().Contains(model.search.value) ||
p.TwoFactorEnabled.ToLower().Contains(model.search.value)
).ToList();
}
string sortBy = "";
string sortDir = "";
if (model.order != null)
{
sortBy = model.columns[model.order[0].column].data;
sortDir = model.order[0].dir.ToLower();
}
int recFilter = modifiedData.Count();
modifiedData = modifiedData.AsQueryable().OrderBy(sortBy + " " + sortDir).Skip(model.start).Take(model.length).ToList();
result.draw = model.draw;
result.recordsTotal = totalRecords;
result.recordsFiltered = recFilter;
result.data = modifiedData;
return(result);
}
catch (Exception ex)
{
throw;
}
}
public async Task <DataTableResponse <TemplateDataTable> > GetTableData(DataTableInput model, ICollection <Template> list)
{
try
{
var result = new DataTableResponse <TemplateDataTable>();
int totalRecords = list.Count;
var modifiedData = list.Select(d => new TemplateDataTable
{
Id = d.Id.ToString(),
Date = d.Date.ToString(),
Description = d.Description,
Amount = d.Amount.ToString(),
fk_TypeId = d.fk_TypeId.ToString(),
Type = d.Type.Name,
fk_CategoryId = d.fk_CategoryId.ToString(),
Category = d.fk_CategoryId != null ? d.Category.Name : null
}
);
if (!string.IsNullOrEmpty(model.search.value) &&
!string.IsNullOrWhiteSpace(model.search.value))
{
modifiedData = modifiedData.Where(p => p.Date.ToLower().Contains(model.search.value) ||
p.Description.ToLower().Contains(model.search.value) ||
p.Amount.ToLower().Contains(model.search.value) ||
p.Type.Contains(model.search.value) ||
p.Category.ToLower().Contains(model.search.value)
).ToList();
}
string sortBy = "";
string sortDir = "";
if (model.order != null)
{
sortBy = model.columns[model.order[0].column].data;
sortDir = model.order[0].dir.ToLower();
}
int recFilter = modifiedData.Count();
modifiedData = modifiedData.AsQueryable().OrderBy(sortBy + " " + sortDir).Skip(model.start).Take(model.length).ToList();
result.draw = model.draw;
result.recordsTotal = totalRecords;
result.recordsFiltered = recFilter;
result.data = modifiedData;
return(result);
}
catch (Exception ex)
{
throw;
}
}
public async Task <DataTableResponse <TypeDataTable> > GetTableData(DataTableInput model, ICollection <Type> list)
{
try
{
var result = new DataTableResponse <TypeDataTable>();
int totalRecords = list.Count;
var modifiedData = list.Select(d => new TypeDataTable
{
Id = d.Id.ToString(),
Name = d.Name,
EndTaxType = d.EndTaxType.ToString(),
Debit = d.TransactionType.ToString(),
ExtraInput = d.ExtraInput,
fk_StatusId = d.fk_StatusId.ToString(),
Status = d.Status.Name
}
);
if (!string.IsNullOrEmpty(model.search.value) &&
!string.IsNullOrWhiteSpace(model.search.value))
{
modifiedData = modifiedData.Where(p => p.Name.ToLower().Contains(model.search.value) ||
p.EndTaxType.ToLower().Contains(model.search.value) ||
p.Debit.ToLower().Contains(model.search.value) ||
p.ExtraInput.Contains(model.search.value) ||
p.Status.ToLower().Contains(model.search.value)
).ToList();
}
string sortBy = "";
string sortDir = "";
if (model.order != null)
{
sortBy = model.columns[model.order[0].column].data;
sortDir = model.order[0].dir.ToLower();
}
int recFilter = modifiedData.Count();
modifiedData = modifiedData.AsQueryable().OrderBy(sortBy + " " + sortDir).Skip(model.start).Take(model.length).ToList();
result.draw = model.draw;
result.recordsTotal = totalRecords;
result.recordsFiltered = recFilter;
result.data = modifiedData;
return(result);
}
catch (Exception ex)
{
throw;
}
}
public async Task <JsonResult> GetCategoryTableData(DataTableInput model)
{
try
{
var categories = await _categoryService.GetDefault();
var result = await _dataTableFactory.GetTableData(model, categories);
return(Json(new { draw = result.draw, recordsTotal = result.recordsTotal, recordsFiltered = result.recordsFiltered, data = result.data }));
}
catch (Exception ex)
{
throw;
}
}
public async Task <JsonResult> GetUserTableData(DataTableInput model)
{
try
{
var users = await _userManager.Users.ToListAsync();
var result = await _dataTableFactory.GetTableData(model, users);
return(Json(new { draw = result.draw, recordsTotal = result.recordsTotal, recordsFiltered = result.recordsFiltered, data = result.data }));
}
catch (Exception ex)
{
throw;
}
}
public async Task <DataTableResponse <UserRoleDataTable> > GetTableData(DataTableInput model, ICollection <UserRoleDataTable> list)
{
try
{
var result = new DataTableResponse <UserRoleDataTable>();
int totalRecords = list.Count;
var modifiedData = list.Select(d => new UserRoleDataTable
{
User = d.User,
UserId = d.UserId,
Role = d.Role,
RoleId = d.RoleId
}
);
if (!string.IsNullOrEmpty(model.search.value) &&
!string.IsNullOrWhiteSpace(model.search.value))
{
modifiedData = modifiedData.Where(p => p.User.ToLower().Contains(model.search.value) ||
p.Role.ToLower().Contains(model.search.value)
).ToList();
}
string sortBy = "";
string sortDir = "";
if (model.order != null)
{
sortBy = model.columns[model.order[0].column].data;
sortDir = model.order[0].dir.ToLower();
}
int recFilter = modifiedData.Count();
modifiedData = modifiedData.AsQueryable().OrderBy(sortBy + " " + sortDir).Skip(model.start).Take(model.length).ToList();
result.draw = model.draw;
result.recordsTotal = totalRecords;
result.recordsFiltered = recFilter;
result.data = modifiedData;
return(result);
}
catch (Exception ex)
{
throw;
}
}
public async Task <DataTableResponse <WalletDataTable> > GetTableData(DataTableInput model, ICollection <Wallet> list)
{
try
{
var result = new DataTableResponse <WalletDataTable>();
int totalRecords = list.Count;
var modifiedData = list.Select(d => new WalletDataTable
{
Id = d.Id.ToString(),
Name = d.Name,
Description = d.Description,
StartBalance = d.StartBalance.ToString(),
CurrentBalance = d.CurrentBalance.ToString()
}
);
if (!string.IsNullOrEmpty(model.search.value) &&
!string.IsNullOrWhiteSpace(model.search.value))
{
modifiedData = modifiedData.Where(p => p.Name.ToLower().Contains(model.search.value)
).ToList();
}
string sortBy = "";
string sortDir = "";
if (model.order != null)
{
sortBy = model.columns[model.order[0].column].data;
sortDir = model.order[0].dir.ToLower();
}
int recFilter = modifiedData.Count();
modifiedData = modifiedData.AsQueryable().OrderBy(sortBy + " " + sortDir).Skip(model.start).Take(model.length).ToList();
result.draw = model.draw;
result.recordsTotal = totalRecords;
result.recordsFiltered = recFilter;
result.data = modifiedData;
return(result);
}
catch (Exception ex)
{
throw;
}
}
public async Task <JsonResult> GetStatusTableData(DataTableInput model)
{
try
{
var user = await _userManager.GetUserAsync(User);
var status = await _statusService.GetByUser(user);
var result = await _dataTableFactory.GetTableData(model, status);
return(Json(new { draw = result.draw, recordsTotal = result.recordsTotal, recordsFiltered = result.recordsFiltered, data = result.data }));
}
catch (Exception ex)
{
throw;
}
}
public JsonResult getAll(DataTableInput input)
{
DataTableOutput <SalaryTabulator> salaryTabulators = new DataTableOutput <SalaryTabulator>();
DataTableOutput <SalaryTabulatorDTO> salaryTabulatorsDTO = new DataTableOutput <SalaryTabulatorDTO>();
try
{
salaryTabulators = salaryTabuladorService.GetSalarysTabulators(input);
salaryTabulatorsDTO = AutoMapperConfiguration.Instance.Mapper.Map <DataTableOutput <SalaryTabulatorDTO> >(salaryTabulators);
}
catch (Exception e)
{
sb.Clear();
sb.Append("An error has ocurred when it try to retrieve Salary Tabulators");
SeriLogHelper.WriteError(e, sb.ToString());
return(new JsonHttpStatusResult(e.Message, HttpStatusCode.InternalServerError));
}
return(Json(salaryTabulatorsDTO, JsonRequestBehavior.DenyGet));
}
public async Task <JsonResult> GetUserRoleTableData(DataTableInput model)
{
try
{
var userRoles = new List <UserRoleDataTable>();
var users = await _userManager.Users.ToListAsync();
foreach (var user in users)
{
var roles = await _userManager.GetRolesAsync(user);
if (roles == null)
{
return(Json(null));
}
foreach (var roleName in roles)
{
var role = await _roleManager.FindByNameAsync(roleName);
var userRole = new UserRoleDataTable
{
User = user.UserName,
UserId = user.Id.ToString(),
Role = role.Name,
RoleId = role.Id.ToString()
};
userRoles.Add(userRole);
}
}
var result = await _dataTableFactory.GetTableData(model, userRoles);
return(Json(new { draw = result.draw, recordsTotal = result.recordsTotal, recordsFiltered = result.recordsFiltered, data = result.data }));
}
catch (Exception ex)
{
throw;
}
}
public DataTableOutput <Employee> GetByFilters(string jobNumber, string name, int?departamentId, int?salaryTabulatorId, DataTableInput input)
{
var output = new DataTableOutput <Employee>();
var query = repository.GetPredicateByFilters(null, jobNumber, name, "", "", "", null, null, null, null, departamentId, salaryTabulatorId);
string sortBy = "";
bool sortDir = true;
if (input.order != null)
{
// in this example we just default sort on the 1st column
sortBy = input.columns[input.order[0].column].data;
sortDir = input.order[0].dir.ToLower() == "asc";
}
IEnumerable <Employee> result = repository.SortOrderAndPaging(query, input.length, input.start, sortBy, sortDir);
if (result == null)
{
output.data = new List <Employee>();
}
output.data = result.ToList();
output.recordsFiltered = repository.Count(query);
output.recordsTotal = repository.Count(x => 1 == 1);
return(output);
}
public IEnumerable <Employee> GetByFilters(string inWhatEverColumn, DataTableInput input)
{
return(repository.GetByFilters(inWhatEverColumn));
}
