コード例 #1
0
        //Get primary and secondary contacts
        public static List <BillingStatement> GetBillingStatementList(DateTime _StartDate, DateTime _EndDate, int _BillingGroup)
        {
            List <BillingStatement> listOfBillingStatements = new List <BillingStatement>();

            BillingStatementDataContext dc = new BillingStatementDataContext();
            var result = dc.S1_BillingStatement_GetBillingStatementList(_StartDate, _EndDate, _BillingGroup);

            foreach (var item in result)
            {
                BillingStatement tempBillingStatement = new BillingStatement();

                tempBillingStatement.billingContact.ClientContactID   = item.ClientContactID;
                tempBillingStatement.billingContact.ClientContactName = item.ContactName;
                tempBillingStatement.billingContact.BillingContactID  = item.BillingContactID;
                tempBillingStatement.BillingContactName = item.ContactName;
                tempBillingStatement.ContactEmail       = item.ContactEmail;
                tempBillingStatement.DeliveryMethod     = item.DeliveryMethod;
                tempBillingStatement.ClientName         = item.BillAsClientName;
                tempBillingStatement.LastPrinted        = item.LastPrintedOn;
                tempBillingStatement.Amount             = (item.Amount.HasValue ? item.Amount.Value : 0);
                tempBillingStatement.billingContact.ClientContactAddress1 = item.Amount.Value.ToString("F");
                tempBillingStatement.CurrentActivity = (item.CurrentActivity == 1 ? "Yes" : (item.CurrentActivity == 2 ? "Audit" : (item.CurrentActivity == 3 ? "Secondary" : "No")));

                //Only get primary contacts
                //if (item.PrimaryBillingContact.HasValue && item.PrimaryBillingContact.Value)
                listOfBillingStatements.Add(tempBillingStatement);
            }

            return(listOfBillingStatements);
        }
コード例 #2
0
        //Same as GetBillingStatementList, except that it is filtered by UserID
        public static List <BillingStatement> GetBillingStatementListFromUser(int _UserID, DateTime _StartDate, DateTime _EndDate)
        {
            List <BillingStatement> listOfBillingStatements = new List <BillingStatement>();

            BillingStatementDataContext dc = new BillingStatementDataContext();
            var result = dc.S1_BillingStatement_GetBillingStatementListFromUser(_UserID, _StartDate, _EndDate);

            foreach (var item in result)
            {
                BillingStatement tempBillingStatement = new BillingStatement();

                tempBillingStatement.billingContact.ClientContactID       = item.ClientContactID;
                tempBillingStatement.billingContact.BillingContactID      = item.BillingContactID;
                tempBillingStatement.billingContact.DueText               = item.StatementDate.Value.ToString("MM/dd/yyyy");
                tempBillingStatement.billingContact.ClientContactName     = item.ContactName;
                tempBillingStatement.billingContact.BillingContactName    = item.ClientName;
                tempBillingStatement.billingContact.ClientContactAddress1 = item.Amount.Value.ToString("F");

                listOfBillingStatements.Add(tempBillingStatement);
            }

            return(listOfBillingStatements);
        }
コード例 #3
0
        public static BillingStatement GetCurrentBillingStatement(int _BillingContactID, DateTime _StartDate, DateTime _EndDate)
        {
            BillingStatement billingStatement = new BillingStatement(_BillingContactID, _StartDate, _EndDate);

            return(billingStatement);
        }