public static List <Relatorio> getRelatorioByBusca(RelatorioModelView model)
{
//busca no banco
List <Relatorio> lst = new List <Relatorio>();
RelatorioRepository tprep = new RelatorioRepository();
//busca inicial pelo representante
lst = tprep.Search(tp => tp.representanteid == model.representanteid).ToList();
//fabrica
if (model.fabricaid != 0)
{
lst = (from x in lst where x.fabricaid == model.fabricaid select x).ToList();
}
//data boleto
if (model.dtboletode != DateTime.Today | model.dtboletoate != DateTime.Today)
{
lst = (from x in lst where x.Boleto.Dtboleto >= model.dtboletode & x.Boleto.Dtboleto <= model.dtboletoate select x).ToList();
}
//data vencimento
if (model.dtvencimentode != DateTime.Today | model.dtvencimentoate != DateTime.Today)
{
lst = (from x in lst where x.Boleto.DtVencimento >= model.dtboletode & x.Boleto.DtVencimento <= model.dtboletoate select x).ToList();
}
//boletoid
if (model.boletoid != 0)
{
lst = (from x in lst where x.talaoitensid == model.boletoid select x).ToList();
}
//cliente
if (model.clienteid != 0)
{
lst = (from x in lst where x.clienteid == model.clienteid select x).ToList();
}
//Assessor
if (model.assessorid != 0)
{
lst = (from x in lst where x.assessorid == model.assessorid select x).ToList();
}
//Número Boleto de - ate
if (model.nrboletode != 0 & model.nrboletoate != 0)
{
lst = (from x in lst where x.talaoitensid >= model.nrboletode & x.talaoitensid <= model.nrboletoate select x).ToList();
}
if (model.relatoriostatusid != 0)
{
lst = (from x in lst where x.relatoriostatusid == model.relatoriostatusid select x).ToList();
}
return(lst);
}
public async Task <ActionResult <Relatorio> > PostRelatorio(RelatorioModelView modelView)
{
var relatorio = new Relatorio();
relatorio.Nome = modelView.Nome;
relatorio.Descricao = modelView.Descricao;
_relatoriosRepository.Relatorios.Add(relatorio);
await _relatoriosRepository.SaveChangesAsync();
return(CreatedAtAction("GetRelatorio", new { id = relatorio.Id }, relatorio));
}
public static void UpdateRelatorio(RelatorioModelView model)
{
Relatorio objretorno = new Relatorio();
//faz o de para: objModelView para objEntity
Mapper.CreateMap <RelatorioModelView, Relatorio>();
var objtpprod = Mapper.Map <Relatorio>(model);
objtpprod.Dataalt = DateTime.Now;
RelatorioRepository tpprod = new RelatorioRepository();
tpprod.Edit(objtpprod);
tpprod.Save();
}
