public IEnumerable <EV_CLIENTE> GetClientePaginacao(FilterClientes filter, string order, int offset, int limit)
{
var skip = (offset - 1) * limit < 0 ? 0 : (offset - 1) * limit;
var query = Dbset.Include("AD_ORGAOS").Include("EV_INSCRICAO").Where(x =>
(x.NOME.Contains(filter.Nome) || filter.Nome == null) &&
(x.NOME.StartsWith(filter.Letra) || filter.Letra == null) &&
(x.RG.StartsWith(filter.Rg) || filter.Rg == null) &&
(x.INSTITUICAO.Contains(filter.Instituicao) || filter.Instituicao == null) &&
(x.SEXO.Contains(filter.Sexo) || filter.Sexo == null) &&
(x.TEL_CELULAR.Contains(filter.Telcelular) || filter.Telcelular == null) &&
(x.CPF.StartsWith(filter.Cpf) || filter.Cpf == null) &&
(x.EMAIL.Contains(filter.Email) || filter.Email == null) &&
(x.CIDADE.Contains(filter.Cidade) || filter.Cidade == null) &&
(x.DTNASCIMENTO == filter.Dtaniversario || filter.Dtaniversario == null) &&
(x.EV_INSCRICAO.Any(y => y.EVENTOID == filter.Eventoid) || filter.Eventoid == null || filter.Eventoid == 0));
if (order == "asc")
{
var _object = CompiledQuery.Compile <ObjectContext, IQueryable <EV_CLIENTE> >(ctx => query.OrderBy(x => x.DTCADASTRO).Skip(skip).Take(limit));
return(_object.Invoke(((IObjectContextAdapter)Entities).ObjectContext).ToList());
}
else
{
var _object = CompiledQuery.Compile <ObjectContext, IQueryable <EV_CLIENTE> >(ctx => query.OrderByDescending(x => x.DTCADASTRO).Skip(skip).Take(limit));
return(_object.Invoke(((IObjectContextAdapter)Entities).ObjectContext).ToList());
}
}
public PagedListResponse <Dtos.Cliente> GetClientesByFilter(FilterClientes filter)
{
var empresa = CdpContext.Empresas.Single(e => e.Id == filter.EmpresaId);
var idSapOrganizacionDeVenta = int.Parse(empresa.IdSapOrganizacionDeVenta);
var query = CdpContext.Clientes.Where(c => c.IdSapOrganizacionDeVenta == idSapOrganizacionDeVenta &&
(!filter.FilterCresud || (filter.FilterCresud && !c.Id.StartsWith("3"))) &&
c.Id != "2000151" && c.Id != "3000352").AsQueryable();
if (!string.IsNullOrEmpty(filter.MultiColumnSearchText))
{
filter.MultiColumnSearchText = filter.MultiColumnSearchText.ToLower();
query = query.Where(r =>
(r.RazonSocial != null && r.RazonSocial.ToLower().Contains(filter.MultiColumnSearchText)) ||
(r.Cuit != null && r.Cuit.ToLower().Contains(filter.MultiColumnSearchText)) ||
(r.Id != null && r.Id.ToLower().Contains(filter.MultiColumnSearchText))
).AsQueryable();
}
query = query.OrderBy(c => c.RazonSocial).AsQueryable();
return(new PagedListResponse <Dtos.Cliente>
{
Count = query.Count(),
Data = Mapper.Map <IList <Cliente>, IList <Dtos.Cliente> >(query.Skip(filter.PageSize * (filter.CurrentPage - 1)).Take(filter.PageSize).ToList())
});
}
public PaginacaoClientes GetClientePaginacao(FilterClientes filter)
{
var total = m_ClienteService.GetTotalRegistros(filter);
var dataClientes = m_ClienteService.GetClientePaginacao(filter, "asc", 0, 10).Select(item => ConvertToClienteViewModel(item));
return(new PaginacaoClientes {
total = total, rows = dataClientes
});
}
public PaginacaoClientes GetClientePaginacao(FilterClientes filter, string order, int offset, int limit)
{
var total = m_ClienteService.GetTotalRegistros(filter);
var dataClientes = m_ClienteService.GetClientePaginacao(filter, order, offset, limit).Select(item => ConvertToClienteViewModel(item));
return(new PaginacaoClientes {
total = total, rows = dataClientes
});
}
public ActionResult GetClientesByFilter(FilterClientes filter)
{
var response = new PagedListResponse <Cliente>();
try
{
response = _admin.GetClientesByFilter(filter);
}
catch (Exception ex)
{
response.Result.HasErrors = true;
response.Result.Messages.Add(ex.Message);
}
return(this.JsonNet(response));
}
public int GetTotalRegistros(FilterClientes filter)
{
var query = Dbset.Include("EV_INSCRICAO").Where(x =>
(x.NOME.Contains(filter.Nome) || filter.Nome == null) &&
(x.NOME.StartsWith(filter.Letra) || filter.Letra == null) &&
(x.INSTITUICAO.Contains(filter.Instituicao) || filter.Instituicao == null) &&
(x.SEXO.Contains(filter.Sexo) || filter.Sexo == null) &&
(x.TEL_CELULAR.Contains(filter.Telcelular) || filter.Telcelular == null) &&
(x.CPF.StartsWith(filter.Cpf) || filter.Cpf == null) &&
(x.EMAIL.Contains(filter.Email) || filter.Email == null) &&
(x.CIDADE.Contains(filter.Cidade) || filter.Cidade == null) &&
(x.DTNASCIMENTO == filter.Dtaniversario || filter.Dtaniversario == null) &&
(x.EV_INSCRICAO.Any(y => y.EVENTOID == filter.Eventoid) || filter.Eventoid == null || filter.Eventoid == 0));
var _object = CompiledQuery.Compile <ObjectContext, int>(ctx => query.Count());
return(_object.Invoke(((IObjectContextAdapter)Entities).ObjectContext));
}
public MemoryStream ReportCliente(string usuario, string fileName, FilterClientes filter)
{
var totalRegistros = m_ClienteService.GetTotalRegistros(filter);
string[] colunas = filter.Columnsreport.Split(';');
var listaColunas = new List <ColunasReport>();
var indiceColunaMeio = (colunas.Length - 1) / 2;
var colunaAntMeio = string.Empty;
var colunaPosMeio = string.Empty;
for (int i = 0; i < colunas.Length; i++)
{
if (colunas[i].Length == 0)
{
continue;
}
listaColunas.Add(new ColunasReport {
Letra = listaCelulas[i], Coluna = colunas[i]
});
if (i == indiceColunaMeio)
{
colunaAntMeio = listaCelulas[i - 1];
colunaPosMeio = listaCelulas[i];
}
}
var clientes = m_ClienteService.GetClientePaginacao(filter, "asc", 0, totalRegistros);
if (fileName.Contains("xlsx"))
{
return(ReportExcel(clientes, listaColunas, colunaAntMeio, colunaPosMeio, usuario));
}
else if (fileName.Contains("docx"))
{
return(ReportWordPDF(clientes, listaColunas, colunaAntMeio, colunaPosMeio, fileName));// ReportWord(clientes, listaColunas, colunaAntMeio, colunaPosMeio, fileName);
}
else if (fileName.Contains("pdf"))
{
return(ReportWordPDF(clientes, listaColunas, colunaAntMeio, colunaPosMeio, fileName));
}
return(null);
}
public int GetTotalRegistros(FilterClientes filter)
{
return(UnitOfWork.ClienteRepository.GetTotalRegistros(filter));
}
public IEnumerable <EV_CLIENTE> GetClientePaginacao(FilterClientes filter, string order, int offset, int limit)
{
return(UnitOfWork.ClienteRepository.GetClientePaginacao(filter, order, offset, limit));
}
