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