public decimal GetPriceSalesByPart(int PartId, SV_CURRENCY moneda)
{
//int x = 0;
//if(PartId == 204)
// x = 1;
var find = _details.Where(d => d.part_id == PartId);
if (find.Count() > 0)
{
decimal total = find.Sum(d => d.ext_price);
if (moneda == "YEN")
{
int headId = find.First().head_id;
DateTime docDate = _heads.Where(h => h.id == headId).First().docdate;
var TC = _multi_currency.YEN(docDate);
if (TC == 0)
{
return(-1);
}
else
{
return(total / TC);
}
}
else
{
return(total);
}
}
else
{
return(0);
}
}
public decimal SaldoDisponible(int EntradaId, SV_CURRENCY moneda)
{
decimal TotalEntrada = _source.Where(sa => sa.id == EntradaId &&
sa.tipo == Main._InOBC &&
sa.aproval_state.id == 2)
.Select(sa => sa.TotalByCurrency(moneda))
.Sum();
decimal TotalConsumido = _source.Where(
sa => sa.entrada_id == EntradaId &&
sa.tipo == Main._OutOBC &&
sa.aproval_state.id == 2)
.Select(sa => sa.TotalByCurrency(moneda))
.Sum();
return(TotalEntrada - TotalConsumido);
}
