Ejemplo n.º 1
0
        /// <summary>
        /// Loads the Donor log listView with the donoations for the
        /// Selected donor
        /// </summary>
        private void loadDonorLogList()
        {
            double totLbs = 0;
            int    totCnt = 0;

            lvDonorHistory.Items.Clear();
            Application.DoEvents();
            ListViewItem lvItm;

            string donorWhereClause = " WHERE DonorID=" + donorID.ToString();

            switch (cboDonorPeriod.SelectedIndex)
            {
            case 0: donorWhereClause += CCFBGlobal.SQLDateRangeCurMonth();   break;

            case 1: donorWhereClause += CCFBGlobal.SQLDateRangePrevMonth();  break;

            case 2: donorWhereClause += CCFBGlobal.SQLDateRangeLast90Days(); break;

            case 3: donorWhereClause += CCFBGlobal.SQLDateRangeCurYear();    break;

            case 4: donorWhereClause += CCFBGlobal.SQLDateRangePrevYear();   break;

            case 5: break;

            default: donorWhereClause += DateRangeCustom();                   break;
            }

            clsFDHist.openWhere(donorWhereClause);

            for (int i = 0; i < clsFDHist.RowCount; i++)
            {
                clsFDHist.setDataRow(i);
                lvItm = new ListViewItem((i + 1).ToString());
                lvItm.SubItems.Add(CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_Donation, clsFDHist.DonationType));
                lvItm.SubItems.Add(clsFDHist.TrxDate.ToShortDateString());
                lvItm.SubItems.Add(String.Format("{0:0,0}", clsFDHist.Pounds));
                lvItm.SubItems.Add(clsFDHist.Notes);
                lvItm.SubItems.Add(CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_FoodClass, clsFDHist.FoodClass));
                lvItm.SubItems.Add(clsFDHist.FoodCode);
                lvItm.SubItems.Add(clsFDHist.TrxID.ToString());
                lvDonorHistory.Items.Add(lvItm);

                totCnt++;
                totLbs += clsFDHist.Pounds;
            }
            tbDonorCnt.Text = CCFBGlobal.formatNumberWithCommas(totCnt);
            tbDonorLbs.Text = String.Format("{0:0,0}", totLbs);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Loads the Donor log listView with the donoations for the
        /// Selected donor
        /// </summary>
        private void loadDonorLogList()
        {
            decimal totDollars = 0;
            int     totCnt     = 0;

            lvDonorHistory.Items.Clear();
            Application.DoEvents();
            ListViewItem lvItm;

            string donorWhereClause = " WHERE DonorID=" + donorID.ToString();

            switch (cboDonorPeriod.SelectedIndex)
            {
            case 0: donorWhereClause += CCFBGlobal.SQLDateRangeCurMonth();   break;

            case 1: donorWhereClause += CCFBGlobal.SQLDateRangePrevMonth();  break;

            case 2: donorWhereClause += CCFBGlobal.SQLDateRangeLast90Days(); break;

            case 3: donorWhereClause += CCFBGlobal.SQLDateRangeCurYear();    break;

            case 4: donorWhereClause += CCFBGlobal.SQLDateRangePrevYear();   break;

            case 5: break;

            default: donorWhereClause += DateRangeCustom();                   break;
            }

            clsCashDonations.openWhere(donorWhereClause);

            for (int i = 0; i < clsCashDonations.RowCount; i++)
            {
                clsCashDonations.setDataRow(i);
                lvItm = new ListViewItem((i + 1).ToString());
                lvItm.SubItems.Add(clsCashDonations.TrxDate.ToShortDateString());
                lvItm.SubItems.Add(String.Format("{0:0,0.00}", clsCashDonations.DollarValue));
                lvItm.SubItems.Add(clsCashDonations.Notes);
                lvItm.SubItems.Add(clsCashDonations.TrxID.ToString());
                lvDonorHistory.Items.Add(lvItm);

                totCnt++;
                totDollars += clsCashDonations.DollarValue;
            }
            tbDonorCnt.Text          = CCFBGlobal.formatNumberWithCommas(totCnt);
            tbTotalDonorDollars.Text = String.Format("{0:0,0.00}", totDollars);
        }