示例#1
0
        public static DataTable LoadTransactions(string desiredCurrency, string desiredSKU, string justTotals, string orderByColumn, string refreshFromWeb)
        {
            //should refresh from web?
            bool refreshWeb = string.IsNullOrEmpty(refreshFromWeb);

            ds.TransactionsDataTable tdt;
            loadTransactionsFromWeb(out tdt, refreshWeb);

            //filter by SKU
            desiredSKU = desiredSKU.Trim();
            if (!string.IsNullOrEmpty(desiredSKU))
            {
                var arr = tdt.WhereSKU(desiredSKU);
                tdt = TableTools.ImportRows(tdt, arr) as ds.TransactionsDataTable;
            }

            //order
            if (string.IsNullOrEmpty(orderByColumn.Trim()))
            {
                orderByColumn = "sku, currency";
            }
            tdt = TableTools.SortBy(orderByColumn.Trim(), tdt) as ds.TransactionsDataTable;


            desiredCurrency = desiredCurrency.Trim();
            bool fillTotals = !string.IsNullOrEmpty(justTotals);

            ds.RatesDataTable rdt = LoadRates(string.Empty, string.Empty, string.Empty, "n") as ds.RatesDataTable;

            DataTable dtResult = convertTransactionsRates(desiredCurrency, ref tdt, ref rdt, fillTotals);


            return(dtResult);
        }
示例#2
0
        private static void fillMissingRates(ref ds.RatesDataTable rdt)
        {
            IEnumerable <string> distinct = rdt.Select(o => o.from).Distinct().ToArray();

            foreach (var item in distinct)
            {
                foreach (var item2 in distinct)
                {
                    if (item.CompareTo(item2) != 0)
                    {
                        ds.RatesRow r = rdt.FirstOrDefault(o => o.from.CompareTo(item) == 0 && o.to.CompareTo(item2) == 0);

                        if (r == null)
                        {
                            ds.RatesRow refe = rdt.FirstOrDefault(o => o.from.CompareTo(item2) == 0 && o.to.CompareTo(item) == 0);

                            r      = rdt.NewRatesRow();
                            r.from = item;
                            r.to   = item2;

                            if (refe == null)
                            {
                                IEnumerable <ds.RatesRow> refesFrom = rdt.Where(o => o.from.CompareTo(item) == 0).ToArray();

                                foreach (var refeFrom in refesFrom)
                                {
                                    ds.RatesRow refeTo = rdt.FirstOrDefault(o => o.from.CompareTo(refeFrom.to) == 0 && o.to.CompareTo(item2) == 0);

                                    if (refeTo == null)
                                    {
                                        continue;
                                    }

                                    r.rate = Decimal.Round(refeFrom.rate * refeTo.rate, 4);
                                    break;
                                }
                            }
                            else
                            {
                                r.rate = Decimal.Round(1 / refe.rate, 4);
                            }

                            rdt.AddRatesRow(r);
                        }
                    }
                }
            }
        }
示例#3
0
        private static void loadRatesFromWeb(out ds.RatesDataTable rdt, bool refreshFromWeb)
        {
            if (refreshFromWeb)
            {
                TableTools.GetTableFromWebAndStoreFile(rtxUri, currentRatesFile);
            }

            DataTable ratesRaw = TableTools.LoadTableFromFile(currentRatesFile);

            rdt = new ds.RatesDataTable();
            TableTools.SerializeTableAs(rdt, ref ratesRaw);

            if (refreshFromWeb)
            {
                fillMissingRates(ref rdt);
                rdt.AcceptChanges();
                rdt.WriteXml(currentRatesFile, XmlWriteMode.IgnoreSchema);
            }
        }
示例#4
0
        private static DataTable convertTransactionsRates(string desiredCurrency, ref ds.TransactionsDataTable tdt, ref ds.RatesDataTable rdt, bool fillTotals)
        {
            ds.TransactionsDataTable tdtTot = new ds.TransactionsDataTable();
            var  distinctSku      = tdt.SelectDistinctSKU();
            bool conversionNeeded = !string.IsNullOrEmpty(desiredCurrency);

            foreach (var sku in distinctSku)
            {
                //transacciones de 1 sku
                IEnumerable <ds.TransactionsRow> txsBySKU = tdt.WhereSKU(sku);
                //distintos tipos de monedas (distintas a desiredCurrency) para ese sku
                string[] distinctCurrencies = txsBySKU.Select(o => o.currency).Distinct().ToArray();

                //computar el total en el  desiredCurrency
                foreach (string thisCurrency in distinctCurrencies)
                {
                    //la tasa
                    decimal rate = 1;
                    if (conversionNeeded)
                    {
                        var r = rdt.First(thisCurrency, desiredCurrency);
                        if (r != null)
                        {
                            rate = r.rate;
                        }
                    }
                    decimal currencyTotal = 0;
                    currencyTotal = convertAndGetTotalAmount(ref txsBySKU, rate, thisCurrency);

                    if (fillTotals)
                    {
                        string label = string.Empty;
                        label = thisCurrency + to + thisCurrency;

                        if (conversionNeeded)
                        {
                            label = thisCurrency + to + desiredCurrency;
                        }
                        addTxsTotal(ref tdtTot, sku, label, currencyTotal);
                    }
                }

                if (conversionNeeded)
                {
                    decimal sum   = tdtTot.Where(o => o.sku.CompareTo(sku) == 0).Sum(o => o.amount);
                    string  label = "TOTAL" + to + desiredCurrency;
                    addTxsTotal(ref tdtTot, sku, label, sum);
                }
            }

            if (fillTotals)
            {
                tdtTot.AcceptChanges();
                return(tdtTot);
            }
            else
            {
                cleanTxsConversion(desiredCurrency, ref tdt);
                tdt.AcceptChanges();
                return(tdt);
            }
        }