private void SetFiltrosSessao(FormFiltersVisitaEnderecosViewModels data) { if (data != null) { HttpContext.Session.SetString("IdLote", (data.IdLote == null) ? "" : data.IdLote); HttpContext.Session.SetString("ZId", (data.ZId == null) ? "" : data.ZId); HttpContext.Session.SetString("DId", (data.DId == null) ? "" : data.DId); HttpContext.Session.SetString("AId", (data.AId == null) ? "" : data.AId); HttpContext.Session.SetString("Endereco", (data.Endereco == null) ? "" : data.Endereco); } }
private FormFiltersVisitaEnderecosViewModels GetFiltrosSessao() { var ffvm = new FormFiltersVisitaEnderecosViewModels(); ffvm.IdLote = (HttpContext.Session.GetString("IdLote") == "") ? null : HttpContext.Session.GetString("IdLote"); ffvm.ZId = (HttpContext.Session.GetString("ZId") == "") ? null : HttpContext.Session.GetString("ZId"); ffvm.DId = (HttpContext.Session.GetString("DId") == "") ? null : HttpContext.Session.GetString("DId"); ffvm.AId = (HttpContext.Session.GetString("AId") == "") ? null : HttpContext.Session.GetString("AId"); ffvm.Endereco = (HttpContext.Session.GetString("Endereco") == "") ? null : HttpContext.Session.GetString("Endereco"); return(ffvm); }
public List <LotePorEndereco> GetEnderecosAtivos([FromForm] FormFiltersVisitaEnderecosViewModels filtros) { int? id = HttpContext.Session.GetInt32("UserId"); int? delegacao = HttpContext.Session.GetInt32("Delegação"); int? zona = HttpContext.Session.GetInt32("Zona"); string tipo = HttpContext.Session.GetString("UserTipo"); int? area = HttpContext.Session.GetInt32("Área"); IQueryable <LotePorEndereco> e; if (filtros == null) { e = _context._11_LoteAtivoEndereco.FromSql("exec [dbo].[LotePorEndereco_Ativos] {0},{1},{2},{3},{4},{5}", null, zona, delegacao, null, null, (tipo == "cli" && (area != null)) ? id : null); } else { e = _context._11_LoteAtivoEndereco.FromSql("exec [dbo].[LotePorEndereco_Ativos] {0},{1},{2},{3},{4},{5}", filtros.IdLote, ((zona != null) ? zona.ToString() : (filtros.ZId != null) ? filtros.ZId.ToString() : null), ((delegacao != null) ? delegacao.ToString() : (filtros.DId != null) ? filtros.DId.ToString() : null), filtros.AId, filtros.Endereco, (tipo == "cli" && (area != null)) ? id : null); } return(e.ToList()); }
public IActionResult GetListLoteAtivoView([FromForm] FormFiltersVisitaEnderecosViewModels filtros, bool eIndex, int PaginaClicada) { SetFiltrosSessao(filtros); //lista vinda da SP var evList = GetEnderecosAtivos(filtros); ViewBag.Potencial = evList.Sum(c => c.Potencial); //lógica do tratado ---------------------------------------------- ViewBag.Tratados = evList.Sum(e => e.Tratados); ViewBag.TratadosPercent = (ViewBag.Potencial != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.Tratados), Convert.ToDecimal(ViewBag.Potencial)) * 100) : 0; ViewBag.NaoTratados = ViewBag.Potencial - ViewBag.Tratados; ViewBag.NaoTratadosPercent = (ViewBag.Potencial != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.NaoTratados), Convert.ToDecimal(ViewBag.Potencial)) * 100) : 0; ViewBag.c0Visita = evList.Sum(e => e.Visitas0); ViewBag.c0VisitaPercent = (ViewBag.NaoTratados != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.c0Visita), Convert.ToDecimal(ViewBag.NaoTratados)) * 100) : 0; ViewBag.c1Visita = evList.Sum(e => e.Visitas1); ViewBag.c1VisitaPercent = (ViewBag.NaoTratados != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.c1Visita), Convert.ToDecimal(ViewBag.NaoTratados)) * 100) : 0; ViewBag.c2Visita = evList.Sum(e => e.Visitas2); ViewBag.c2VisitaPercent = (ViewBag.NaoTratados != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.c2Visita), Convert.ToDecimal(ViewBag.NaoTratados)) * 100) : 0; //fim da lógica do tratado ---------------------------------------------- ViewBag.Visitados = evList.Sum(c => c.Visitados); ViewBag.VisitadosPercent = (ViewBag.Potencial != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.Visitados), Convert.ToDecimal(ViewBag.Potencial)) * 100) : 0; ViewBag.NaoVisitados = ViewBag.Potencial - ViewBag.Visitados; ViewBag.NaoVisitadosPercent = (ViewBag.Potencial != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.NaoVisitados), Convert.ToDecimal(ViewBag.Potencial)) * 100) : 0; //ok ViewBag.Contratados = evList.Sum(c => c.Contratados); ViewBag.ContratadosPercent = (ViewBag.Potencial != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.Contratados), Convert.ToDecimal(ViewBag.Potencial)) * 100) : 0; ViewBag.NaoContratados = ViewBag.Potencial - ViewBag.Contratados; ViewBag.NaoContratadosPercent = (ViewBag.Potencial != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.NaoContratados), Convert.ToDecimal(ViewBag.Potencial)) * 100) : 0; //ok ViewBag.D2 = evList.Sum(e => e.D2); ViewBag.D2Percent = (ViewBag.Potencial != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.D2), Convert.ToDecimal(ViewBag.Potencial)) * 100) : 0; ViewBag.Svg = evList.Sum(e => e.Svg); ViewBag.SvgPercent = (ViewBag.Potencial != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.Svg), Convert.ToDecimal(ViewBag.Potencial)) * 100) : 0; ViewBag.Sve = evList.Sum(e => e.Sve); ViewBag.SvePercent = (ViewBag.Potencial != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.Sve), Convert.ToDecimal(ViewBag.Potencial)) * 100) : 0; //ok ViewBag.Visitas = evList.Sum(c => c.Visitas); ViewBag.Entrevistas = evList.Sum(c => c.Entrevistas); ViewBag.EntrevistasPercent = (ViewBag.Visitas != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.Entrevistas), Convert.ToDecimal(ViewBag.Visitas)) * 100) : 0; ViewBag.VisitasImpr = evList.Sum(c => c.VisitasImpr); ViewBag.VisitasImprPercent = (ViewBag.Visitas != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.VisitasImpr), Convert.ToDecimal(ViewBag.Visitas)) * 100) : 0; ViewBag.Ausentes = evList.Sum(c => c.Ausencias); ViewBag.AusentesPercent = (ViewBag.Visitas != 0) ? Convert.ToInt32(decimal.Divide(Convert.ToDecimal(ViewBag.Ausentes), Convert.ToDecimal(ViewBag.Visitas)) * 100) : 0; ViewBag.VisitaAgendada = evList.Sum(c => c.VisitasAgendadas); //ok if (eIndex) { return(View("VisitasEnderecos", evList)); } else { dynamic jsonModel = new ExpandoObject(); jsonModel.Numeracoes = new List <string>(); jsonModel.Porcentagens = new List <string>(); jsonModel.Numeracoes.Add(ViewBag.Potencial.ToString()); //e0 jsonModel.Numeracoes.Add(ViewBag.Visitados.ToString()); //e1 jsonModel.Numeracoes.Add(ViewBag.NaoVisitados.ToString()); //e2 jsonModel.Numeracoes.Add(evList.Count().ToString()); //e3 jsonModel.Numeracoes.Add(ViewBag.Contratados.ToString()); //e4 jsonModel.Numeracoes.Add(ViewBag.NaoContratados.ToString()); //e5 jsonModel.Numeracoes.Add(ViewBag.D2.ToString()); //e6 jsonModel.Numeracoes.Add(ViewBag.Svg.ToString()); //e7 jsonModel.Numeracoes.Add(ViewBag.Sve.ToString()); //e8 jsonModel.Numeracoes.Add(ViewBag.Visitas.ToString()); //e9 jsonModel.Numeracoes.Add(ViewBag.Entrevistas.ToString()); //e10 jsonModel.Numeracoes.Add(ViewBag.VisitasImpr.ToString()); //e11 jsonModel.Numeracoes.Add(ViewBag.Ausentes.ToString()); //e12 jsonModel.Numeracoes.Add(ViewBag.VisitaAgendada.ToString()); //e13 //tratados jsonModel.Numeracoes.Add(ViewBag.Tratados.ToString()); //e14 jsonModel.Numeracoes.Add(ViewBag.NaoTratados.ToString()); //e15 jsonModel.Numeracoes.Add(ViewBag.c0Visita.ToString()); //e16 jsonModel.Numeracoes.Add(ViewBag.c1Visita.ToString()); //e17 jsonModel.Numeracoes.Add(ViewBag.c2Visita.ToString()); //e18 jsonModel.Porcentagens.Add(ViewBag.VisitadosPercent.ToString()); //ep0 jsonModel.Porcentagens.Add(ViewBag.NaoVisitadosPercent.ToString()); //ep1 jsonModel.Porcentagens.Add(ViewBag.ContratadosPercent.ToString()); //ep2 jsonModel.Porcentagens.Add(ViewBag.NaoContratadosPercent.ToString()); //ep3 jsonModel.Porcentagens.Add(ViewBag.D2Percent.ToString()); //ep4 jsonModel.Porcentagens.Add(ViewBag.SvgPercent.ToString()); //ep5 jsonModel.Porcentagens.Add(ViewBag.SvePercent.ToString()); //ep6 jsonModel.Porcentagens.Add(ViewBag.EntrevistasPercent.ToString()); //ep7 jsonModel.Porcentagens.Add(ViewBag.VisitasImprPercent.ToString()); //ep8 jsonModel.Porcentagens.Add(ViewBag.AusentesPercent.ToString()); //ep9 //tratados jsonModel.Porcentagens.Add(ViewBag.TratadosPercent.ToString()); //ep10 jsonModel.Porcentagens.Add(ViewBag.NaoTratadosPercent.ToString()); //ep11 jsonModel.Porcentagens.Add(ViewBag.c0VisitaPercent.ToString()); //ep12 jsonModel.Porcentagens.Add(ViewBag.c1VisitaPercent.ToString()); //ep13 jsonModel.Porcentagens.Add(ViewBag.c2VisitaPercent.ToString()); //ep14 // continuar dia 30/06/2017 var pagina = 0; if (PaginaClicada != 0) { pagina = (PaginaClicada - 1) * 20; } jsonModel.EV = evList.Skip(pagina).Take(20); jsonModel.QuantasPaginasExistem = (evList.Count() != 0) ? Math.Ceiling(decimal.Divide(Convert.ToDecimal(evList.Count()), 20)) : 1; return(Json(jsonModel)); } }