コード例 #1
0
ファイル: LMOperations.cs プロジェクト: arun-iyer/CapitalOne
        //helper to reduce duplicate code and make sure month is in MM format.
        private void Append_Grouped_Transaction(ref List <Grouped_Transaction> list, int month, int year, double total_credit, double total_debit)
        {
            Grouped_Transaction gt = new Grouped_Transaction();
            //ensure month is always MM
            string str_month = month.ToString();

            str_month     = str_month.PadLeft(2, '0');
            gt.year_month = year.ToString() + "-" + str_month.ToString();

            gt.monthly_credit = total_credit;
            gt.monthly_debit  = Math.Abs(total_debit);

            list.Add(gt);
        }
コード例 #2
0
ファイル: LMOperations.cs プロジェクト: arun-iyer/CapitalOne
        //this method formats the output Json string based on the transactions grouped by month/year.
        public void Get_Grouped_Transactions_Json(List <Grouped_Transaction> grouped_transactions, out string grouped_json)
        {
            StringBuilder sb = new StringBuilder();

            //Bail out early. If list is empty return empty string.
            if (grouped_transactions.Count == 0)
            {
                grouped_json = "";
                return;
            }

            //build the output JSON based upon the requirements.
            //the format for each line similar to --> "2014-10": {"spent": "$200.00", "income": "$500.00"},
            //the JSON serializer/deserializer library that I am using does not have functionality to
            //customize the fields to the level that is required so I wrote this.
            sb.Append("{");
            foreach (Grouped_Transaction gt in grouped_transactions)
            {
                //format for each line.
                //"2014-10": {"spent": "$200.00", "income": "$500.00"},
                double monthly_credit = Math.Round(gt.monthly_credit, 2);
                double monthly_debit  = Math.Round(gt.monthly_debit, 2);
                sb.Append("\"" + gt.year_month + "\":" + "{\"spent\":\"$" + monthly_debit.ToString() + "\",\"income\":" + "\"$" + monthly_credit.ToString() + "\"}");

                //if it's the very last transaction, append the average month.
                if (grouped_transactions.IndexOf(gt) == grouped_transactions.Count - 1)
                {
                    sb.Append(",\n");
                    //append the averge month.
                    Grouped_Transaction average_month = GetAverageMonth(grouped_transactions);
                    double avg_monthly_credit         = Math.Round(average_month.monthly_credit, 2);
                    double avg_monthly_debit          = Math.Round(average_month.monthly_debit, 2);
                    sb.Append("\"" + average_month.year_month + "\":" + "{\"spent\":\"$" + avg_monthly_debit.ToString() + "\",\"income\":" + "\"$" + avg_monthly_credit.ToString() + "\"}");

                    sb.Append("}");
                }
                else
                {
                    sb.Append(",\n");
                }
            }
            grouped_json = sb.ToString();
        }