Esempio n. 1
0
        public JournalEntryLine TranslateJournalEntry(QBJournalEntryLine qbjel, bool bCredit)
        {
            Account acct = GetAccountByID(qbjel.sAccountID);

            JournalEntryLine jel = new JournalEntryLine();

            jel.Desc            = qbjel.sDescrition;
            jel.Amount          = qbjel.dAmount;
            jel.AmountSpecified = true;
            jel.AccountName     = acct.Name;

            if (bCredit)
            {
                jel.PostingType = PostingTypeEnum.Credit;
            }
            else
            {
                jel.PostingType = PostingTypeEnum.Debit;
            }

            jel.PostingTypeSpecified = true;
            jel.AccountTypeSpecified = true;

            return(jel);
        }
Esempio n. 2
0
        public JournalEntryLine TranslateJournalEntry(QBJournalEntryLine qbjel, bool bCredit)
        {
            JournalEntryLine jel = new JournalEntryLine();

            jel.Desc            = qbjel.sDescrition;
            jel.Amount          = qbjel.dAmount;
            jel.AmountSpecified = true;
            jel.AccountId       = new IdType()
            {
                Value = qbjel.sAccountID
            };

            if (bCredit)
            {
                jel.PostingType = PostingTypeEnum.Credit;
            }
            else
            {
                jel.PostingType = PostingTypeEnum.Debit;
            }

            jel.PostingTypeSpecified = true;

            return(jel);
        }
Esempio n. 3
0
        public QBJournalEntryLine(QBJournalEntryLine copyFrom)
        {
            sDescrition = string.Copy(copyFrom.sDescrition);
            sAccountID  = string.Copy(copyFrom.sAccountID);

            dAmount = copyFrom.dAmount;

            bCredit = copyFrom.bCredit;
        }
Esempio n. 4
0
        public QBJournalEntryLine(QBJournalEntryLine copyFrom)
        {
            sDescrition = string.Copy(copyFrom.sDescrition);
            sAccountID = string.Copy(copyFrom.sAccountID);

            dAmount = copyFrom.dAmount;

            bCredit = copyFrom.bCredit;
        }
Esempio n. 5
0
        public JournalEntryLine TranslateJournalEntry(QBJournalEntryLine qbjel, bool bCredit)
        {
            JournalEntryLine jel = new JournalEntryLine();
            jel.Desc = qbjel.sDescrition;
            jel.Amount = qbjel.dAmount;
            jel.AmountSpecified = true;
            jel.AccountId = new IdType() { Value = qbjel.sAccountID };

            if (bCredit) jel.PostingType = PostingTypeEnum.Credit;
            else jel.PostingType = PostingTypeEnum.Debit;

            jel.PostingTypeSpecified = true;

            return jel;
        }
Esempio n. 6
0
        public JournalEntryLine TranslateJournalEntry(QBJournalEntryLine qbjel, bool bCredit)
        {
            Account acct = GetAccountByID(qbjel.sAccountID);

            JournalEntryLine jel = new JournalEntryLine();
            jel.Desc = qbjel.sDescrition;
            jel.Amount = qbjel.dAmount;
            jel.AmountSpecified = true;
            jel.AccountName = acct.Name;

            if( bCredit ) jel.PostingType = PostingTypeEnum.Credit;
            else jel.PostingType = PostingTypeEnum.Debit;

            jel.PostingTypeSpecified = true;
            jel.AccountTypeSpecified = true;

            return jel;
        }
Esempio n. 7
0
        public ActionResult ToQuickBooks(TotalsByFundModel m)
        {
            List<int> lFunds = new List<int>();
            List<QBJournalEntryLine> qbjel = new List<QBJournalEntryLine>();

            var entries = m.TotalsByFund();

            QuickBooksHelper qbh = new QuickBooksHelper();

            foreach (var item in entries)
            {
                if (item.QBSynced > 0) continue;

                var accts = (from e in DbUtil.Db.ContributionFunds
                             where e.FundId == item.FundId
                             select e).Single();

                if (accts.QBAssetAccount > 0 && accts.QBIncomeAccount > 0)
                {
                    QBJournalEntryLine jelCredit = new QBJournalEntryLine();

                    jelCredit.sDescrition = item.FundName;
                    jelCredit.dAmount = item.Total ?? 0;
                    jelCredit.sAccountID = accts.QBIncomeAccount.ToString();
                    jelCredit.bCredit = true;

                    QBJournalEntryLine jelDebit = new QBJournalEntryLine(jelCredit);

                    jelDebit.sAccountID = accts.QBAssetAccount.ToString();
                    jelDebit.bCredit = false;

                    qbjel.Add(jelCredit);
                    qbjel.Add(jelDebit);

                    lFunds.Add(item.FundId ?? 0);
                }
            }

            int iJournalID = qbh.CommitJournalEntries("Bundle from BVCMS", qbjel);

            if (iJournalID > 0)
            {
                string sStart = m.Dt1.Value.ToString("u");
                string sEnd = m.Dt2.Value.AddHours(23).AddMinutes(59).AddSeconds(59).ToString("u");

                sStart = sStart.Substring(0, sStart.Length - 1);
                sEnd = sEnd.Substring(0, sEnd.Length - 1);

                string sFundList = string.Join(",", lFunds.ToArray());
                string sUpdate = "UPDATE dbo.Contribution SET QBSyncID = " + iJournalID + " WHERE FundId IN (" +
                                 sFundList + ") AND ContributionDate BETWEEN '" + sStart + "' and '" + sEnd + "'";

                DbUtil.Db.ExecuteCommand(sUpdate);
            }

            return View("TotalsByFund", m);
        }