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