public PagedResult <AllSolicitationSubsidyDto> AgentPagination([FromQuery] FilterSolicitationSubsidyDto filters)
{
var agentId = GetIdUser();
const int pageSize = 10;
var resultFull = new List <AllSolicitationSubsidyDto>();
var result = new object();
int totalRows = 0;
var pageIndex = filters.Page == 0 ? 1 : filters.Page;
var results = _dataContext.GetSolicitationsByAgent(agentId, filters.FirstName,
filters.LastName, filters.Dni, "FIRSTNAME ASC", pageSize, pageIndex);
return(new PagedResult <AllSolicitationSubsidyDto>
{
List = results.List.Select(_mapper.Map <AllSolicitationSubsidyDto>).OrderByDescending(x => x.CreateDate).ToList(),
TotalRecords = results.TotalRecords
});
}
public PagedResult <AllSolicitationSubsidyDto> SupervisorPaginationAsync(
[FromQuery] FilterSolicitationSubsidyDto filters)
{
const int pageSize = 10;
var resultFull = new List <AllSolicitationSubsidyDto>();
var result = new object();
int totalRows = 0;
var supervisorId = GetIdUser();
var pageIndex = filters.Page == 0 ? 1 : filters.Page;
var results = _dataContext.GetAgentsSolicitationBySupervisor(supervisorId, filters.FirstName,
filters.LastName, filters.Dni, "FIRSTNAME ASC", pageSize, pageIndex, filters.IsRefund);
return(new PagedResult <AllSolicitationSubsidyDto>()
{
List = results.List.Select(_mapper.Map <AllSolicitationSubsidyDto>).ToList(),
TotalRecords = results.TotalRecords
});
}
public ServiceResult <List <AllSolicitationSubsidyDto> > Get_agents_solicitation_by_supervisor(
Guid Supervisor, Guid AgentId, FilterSolicitationSubsidyDto filters)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var item = new List <AllSolicitationSubsidyDto>();
var pageIndex = filters.Page == 0 ? 1 : filters.Page;
using (var command = new SqlCommand("exec get_agents_solicitation_by_supervisor " +
"@SupervisorId = '" + Supervisor + "' , " +
"@AgentId = '" + AgentId + "' , " +
"@PageSize = '" + 1 + "' ," +
"@PageIndex = '" + pageIndex + "' , " +
"@FirstName = '" + filters.FirstName + "' , " +
"@LastName = '" + filters.LastName + "' , " +
"@Dni = '" + filters.Dni + "' , " +
"@SortBy = 'FIRSTNAME ASC' ", connection))
{
using (var dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
item.Add(
new AllSolicitationSubsidyDto()
{
Id = dataReader.GetGuid(0),
FullName = dataReader.GetString(1),
CreateDate = dataReader.GetDateTime(2),
Motive = dataReader.GetString(3),
Localities = dataReader.GetString(4),
Total = dataReader.GetDecimal(5),
State = dataReader.GetString(6)
}
);
}
}
}
connection.Close();
return(new ServiceResult <List <AllSolicitationSubsidyDto> >(item));
}
}
public PagedResult <AllSolicitationSubsidyDto> AgentPagination([FromQuery] FilterSolicitationSubsidyDto filters)
{
var agentId = GetIdUser();
const int pageSize = 10;
var resultFull = new List <AllSolicitationSubsidyDto>();
var result = new object();
int totalRows = 0;
var pageIndex = filters.Page == 0 ? 1 : filters.Page;
var results = _dataContext.GetSolicitationsByAgent(agentId, filters.FirstName,
filters.LastName, filters.Dni, "FIRSTNAME ASC", pageSize, pageIndex);
foreach (var s in results.List)
{
if (!s.IsRefund && s.FinalizeDate == null && s.State == "Aceptado")
{
if (DateTime.Today.CompareTo(s.EndDate.Value) >= 0)
{
var solicitation = _dataContext.SolicitationSubsidies.FirstOrDefault(sol => sol.Id == s.Id);
SolicitationState solicitationState = new SolicitationState()
{
Id = new Guid(),
SolicitationSubsidy = solicitation,
ChangeDate = DateTime.Now,
StateId = State.Finished
};
_dataContext.SolicitationStates.Add(solicitationState);
solicitation.FinalizeDate = s.EndDate;
s.FinalizeDate = s.EndDate;
_dataContext.SolicitationSubsidies.Update(solicitation);
_dataContext.SaveChanges();
}
}
}
return(new PagedResult <AllSolicitationSubsidyDto>
{
List = results.List.Select(_mapper.Map <AllSolicitationSubsidyDto>).OrderByDescending(x => x.CreateDate).ToList(),
TotalRecords = results.TotalRecords
});
}
