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