public void DashboardAverages() { try { Saved_CalculationsDtoCollection uplift = new Saved_CalculationsDtoCollection(); Calculation calculations = new Calculation(); saved_calculations utilCalc = new saved_calculations(); UpliftsCalcs uplifts = new UpliftsCalcs(); FormulationsDtoCollection formulas = new FormulationsDtoCollection(); formulations formUtil = new formulations(); var usuario = getUser(); var species = usuario.specie_id; var usuario_id = usuario.user_id; var provider = GetCurrentProvider(this); uplifts = calculations.DashboardAVGS(usuario_id, species, "", provider); uplift = utilCalc.GetCaculations(usuario_id, species); formulas = formUtil.FormulasConsulta(usuario_id, species); ViewBag.avg_ame = uplifts.AME; ViewBag.qtdCalculations = uplift.Count; ViewBag.avg_posp = uplifts.Phosphorus; ViewBag.avg_calcio = uplifts.Calcium; ViewBag.avg_daa = uplifts.DAA; ViewBag.avg_custo = calculations.SavingsMedio(formulas); } catch (Exception ex) { throw ex; } }
public ActionResult RecentFeeds(string value) { try { var provider = GetCurrentProvider(this); List <Saved_CalculationsDto> listFormulasCalculadas = new List <Saved_CalculationsDto>(); List <FormulationsDto> listaDeFormulas = new List <FormulationsDto>(); List <Saved_CalculationsDto> list_produtos = new List <Saved_CalculationsDto>(); saved_calculations calcUtilSaved = new saved_calculations(); formulations formulaNumeral = new formulations(); Calculation calcUtil = new Calculation(); products utilProd = new products(); saved_calculations util2 = new saved_calculations(); var species = Convert.ToInt64(Session["specie_id"]); //var usuario = getUser(); var usuario = (Exist_UsersDto)Session["usuario"]; listaDeFormulas = formulaNumeral.GetLastest(usuario.user_id, species); foreach (var item in listaDeFormulas) { listFormulasCalculadas = listFormulasCalculadas.Concat(calcUtilSaved.ConsultarFormula(item.formula_id)).ToList(); } var upliftList = new List <UpliftsCalcs>(); var formulas = listFormulasCalculadas.GroupBy(p => p.formula_id.formula_id).Select(g => g.First()).ToList(); var divisor = formulas.Count / 3; string content = ""; var pular = 0; foreach (var item in formulas) { var produtos = listFormulasCalculadas.Where(f => f.product_level_name == item.product_level_name).ToList(); produtos = produtos.GroupBy(p => p.product_level_name).Select(g => g.First()).ToList(); foreach (var prod in produtos) { list_produtos.Add(new Saved_CalculationsDto() { product_level_name = prod.product_level_name, formula_id = item.formula_id }); upliftList.Add(calcUtil.CalculateUplifts(item.formula_id.formula_id, prod.product_level_name, provider)); } } ViewBag.UpliftsCalcs = upliftList; ViewBag.produtos = list_produtos; var listFormulas = formulas; if (divisor == 0) { content = "<div class='carousel-item active' >"; content = content + "<div class='row row-small-gutter'>"; ViewBag.formulas = listFormulas; content = content + RenderViewToString("RecentFeeds", new FormulationsDtoCollection()); content = content + "</div> </div>"; } else { for (int i = 0; i < divisor; i++) { string check_index = i == 0 ? "active" : ""; content = "<div class='carousel-item " + check_index + " ' >"; content = content + "<div class='row row-small-gutter'>"; if (pular == 0) { listFormulas = listFormulas.Take(3).ToList(); pular = 3; } else { listFormulas = listFormulas.Skip(pular).Take(3).ToList(); } ViewBag.formulas = listFormulas; content = content + RenderViewToString("RecentFeeds", new FormulationsDtoCollection()); content = content + "</div> </div>"; } } return(Json(new { content = content, divisor = divisor })); } catch (Exception ex) { return(Content("<label>" + "Erro. Contacte o administrador" + "</label>")); } }