Exemple #1
0
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            var VM = new CheckBookVM();

            DataContext = VM;
            VM.Fill();
        }
Exemple #2
0
        [TestMethod]  //List the transaction between April 5th and 7th
        public void TransactionDatesBetween()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            DateTime firstDate  = new DateTime(2015, 05, 04);
            DateTime secondDate = new DateTime(2015, 07, 04);

            var numDate = ob.Transactions.Where(t => t.Date >= firstDate).Where(t => t.Date <= secondDate).Select(t => new { t.Account, t.Payee, t.Amount, t.Tag });


            String[] acc  = new String[] { "Checking", "Checking", "Credit", "Credit", "Credit", "Checking" };
            String[] p    = new String[] { "Moshe", "Tim", "Moshe", "Bracha", "Tim", "Bracha" };
            String[] tags = new String[] { "Food", "Auto", "Food", "Food", "Auto", "Food" };
            double[] amt  = new double[] { 30, 130, 30, 30.5, 130, 30.5 };

            for (int i = 0; i < numDate.Count(); i++)
            {
                Assert.AreEqual(acc[i], numDate.ElementAt(i).Account);
                Assert.AreEqual(p[i], numDate.ElementAt(i).Payee);
                Assert.AreEqual(amt[i], numDate.ElementAt(i).Amount);
                Assert.AreEqual(tags[i], numDate.ElementAt(i).Tag);
            }
        }
Exemple #3
0
      public void DateForEachAccount()
      {
          var ob = new CheckBookVM();

          ob.Fill();
          var d1 = new DateTime(2015, 04, 01);
          var d2 = new DateTime(2015, 04, 03);
          var d3 = new DateTime(2015, 04, 04);
          var d4 = new DateTime(2015, 04, 05);
          var d5 = new DateTime(2015, 04, 06);
          var d6 = new DateTime(2015, 04, 07);

          //Dates on which each account was used
          var d = ob.Transactions.Select(t => t.Date);

          //Testing
          Assert.AreEqual(d4, d.ElementAt(0));
          Assert.AreEqual(d5, d.ElementAt(1));
          Assert.AreEqual(d3, d.ElementAt(2));
          Assert.AreEqual(d6, d.ElementAt(3));
          Assert.AreEqual(d5, d.ElementAt(4));
          Assert.AreEqual(d4, d.ElementAt(5));
          Assert.AreEqual(d5, d.ElementAt(6));
          Assert.AreEqual(d6, d.ElementAt(7));
          Assert.AreEqual(d4, d.ElementAt(8));
          Assert.AreEqual(d1, d.ElementAt(9));
          Assert.AreEqual(d4, d.ElementAt(10));
          Assert.AreEqual(d2, d.ElementAt(11));
      }
Exemple #4
0
        [TestMethod]  //List the dates on which each account was used
        public void DateForAccount()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var total        = ob.Transactions.Count();
            var totalCheckA  = ob.Transactions.Where(t => t.Account == "Checking");
            var totalCreditA = ob.Transactions.Where(t => t.Account == "Credit");

            var checkcount  = totalCheckA.Count();
            var creditcount = totalCreditA.Count();

            DateTime[] dateCheck = new DateTime[] { new DateTime(2015, 07, 04),
                                                    new DateTime(2015, 05, 04),
                                                    new DateTime(2015, 04, 04),
                                                    new DateTime(2015, 03, 04),
                                                    new DateTime(2015, 02, 04),
                                                    new DateTime(2015, 06, 04) };
            DateTime[] dateCredit = new DateTime[] { new DateTime(2015, 07, 04),
                                                     new DateTime(2015, 06, 04),
                                                     new DateTime(2015, 05, 04),
                                                     new DateTime(2015, 04, 04),
                                                     new DateTime(2015, 03, 04),
                                                     new DateTime(2015, 02, 04) };
            for (var i = 0; i < checkcount; i++)
            {
                Assert.AreEqual(dateCheck[i], totalCheckA.ElementAt(i).Date);
            }
            for (var i = 0; i < creditcount; i++)
            {
                Assert.AreEqual(dateCredit[i], totalCreditA.ElementAt(i).Date);
            }
        }
Exemple #5
0
        public void TransactionBtwApril5and7()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var query = ob.Transactions.Where(t => t.Date >= DateTime.Parse("4/5/2015")).Select(g => g.Date <= DateTime.Parse("4/7/2015"));

            Assert.AreEqual(6, query.Count());
        }
Exemple #6
0
        public void AccountUsed()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var AccountDates = ob.Transactions.Select(d => new { d.Date, d.Account }).Count();

            Assert.AreEqual(12, AccountDates);
        }
Exemple #7
0
        public void TransactionDates()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var TransactionCount = ob.Transactions.Where(d => d.Date >= DateTime.Parse("2015-4-5") && d.Date < DateTime.Parse("2015-4-8")).Count();

            Assert.AreEqual(6, TransactionCount);
        }
Exemple #8
0
        public void CntOfTransBtn5and7th()
        {
            var obj = new CheckBookVM();

            obj.Fill();

            var dates = obj.Transactions.Where(t => t.Date.ToShortDateString() == "4/6/2015").Select(t => t.Date).ToArray().Length;

            Assert.AreEqual(3, dates);
        }
Exemple #9
0
        public void AverageFood()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var total = ob.Transactions.GroupBy(t => t.Tag).Select(g => new { g.Key, Avg = g.Average(t => t.Amount) });

            Assert.AreEqual(32.625, total.First().Avg);
            Assert.AreEqual(75, total.Last().Avg);
        }
        public void FillsUpProperly()
        {
            var ob = new CheckBookVM();

            Assert.IsNull(ob.Transactions);

            ob.Fill();

            Assert.AreEqual(12, ob.Transactions.Count);
        }
        public void averagetransactionamount()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var avg = ob.Transactions.GroupBy(t => t.Tag).Select(g => new { g.Key, Avge = g.Average(t => t.Amount) });

            Assert.AreEqual(32.625, avg.First().Avge);
            Assert.AreEqual(75, avg.Last().Avge);
        }
Exemple #12
0
        public void averageTransPerTag()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var average = ob.Transactions.GroupBy(tag => tag.Tag).Select(s => new { s.Key, avg = s.Average(tag => tag.Amount) });

            Assert.AreEqual(32.625, average.First().avg);
            Assert.AreEqual(75, average.Last().avg);
        }
        public void TrnsBtwn5n7()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var NoOfTrns = ob.Transactions.Where(t => t.Date >= DateTime.Parse("4/5/2015") && t.Date < DateTime.Parse("4/8/2015")).Count();

            Assert.AreEqual(6, NoOfTrns);
        }
Exemple #14
0
        public void AccForMostAutoExps()
        {
            var obj = new CheckBookVM();

            obj.Fill();

            var max = obj.Transactions.GroupBy(t => t.Account).Select(g => new { g.Key, Account = g.Select(t => t.Tag == "Auto") }).Max(t => t.Key);

            Assert.AreEqual("Credit", max);
        }
        public void CountofEqualsMoshe()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var count = ob.Transactions.Where(t => t.Payee == "Moshe").Count();

            Assert.AreEqual(4, count);
        }
Exemple #16
0
        public void apriltransactions()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var date  = DateTime.Parse("4/5/2015");
            var date1 = DateTime.Parse("4/8/2015");
            var trans = ob.Transactions.Where(t => (t.Date >= date.Date) & (t.Date < date1.Date)).Count();

            Assert.AreEqual(6, trans);
        }
Exemple #17
0
        public void aprilTransactions()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var start_date = DateTime.Parse("4/5/2015");
            var end_date   = DateTime.Parse("4/8/2015");
            var trans      = ob.Transactions.Where(tag => (tag.Date >= start_date.Date) & (tag.Date < end_date.Date)).Count();

            Assert.AreEqual(6, trans);
        }
Exemple #18
0
        public void MoneyOnAuto()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var Checking  = ob.Transactions.Where(c => c.Tag == "Auto" && c.Account == "Checking").Sum(a => a.Amount);
            var Credittot = ob.Transactions.Where(h => h.Tag == "Auto" && h.Account == "Credit").Sum(a => a.Amount);

            Assert.IsTrue(Checking == Credittot);
        }
Exemple #19
0
        public void AvgTransaction()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var tot = ob.Transactions.GroupBy(s => s.Tag).Select(n => new { n.Key, avg = n.Average(s => s.Amount) });

            Assert.AreEqual(32.625, tot.First().avg);
            Assert.AreEqual(75, tot.Last().avg);
        }
Exemple #20
0
        public void ListNumberOfTransactionsForEachAccount()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var checkingCount = ob.Transactions.Where(t => t.Account == "Checking" && t.Date.ToString("d") == DateTime.Parse("4/6/2015").ToString("d")).Count();
            var creditCount   = ob.Transactions.Where(t => t.Account == "Credit" && t.Date > DateTime.Parse("2015-4-5") && t.Date.ToString("d") == DateTime.Parse("4/6/2015").ToString("d")).Count();

            Assert.AreEqual(1, checkingCount);
            Assert.AreEqual(1, creditCount);
        }
Exemple #21
0
        public void ListDates()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var CheckingDates = ob.Transactions.Where(t => t.Account == "Checking").Select(t => t.Date.Date.ToString("d"));
            var CreditDates   = ob.Transactions.Where(t => t.Account == "Credit").Select(t => t.Date.Date.ToString("d"));

            Assert.AreEqual(DateTime.Now.AddDays(-1).Date.ToString("d"), CheckingDates.ElementAt(0));
            Assert.AreEqual(DateTime.Now.AddDays(-1).Date.ToString("d"), CreditDates.ElementAt(0));
        }
Exemple #22
0
        public void AccountOnAuto()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var count  = ob.Transactions.Where(t => t.Tag == "Auto").Select(t => t.Account);
            var count1 = ob.Transactions.Select(g => g.Amount).Max();

            Assert.AreEqual(130, count1);
            Assert.AreEqual("credit", count);
        }
        public void dates()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var myDate  = "4-4-2015";
            var myDate1 = "4-7-2015";
            var count   = ob.Transactions.Where(t => t.Date > Convert.ToDateTime(myDate) & t.Date < Convert.ToDateTime(myDate1)).Count();

            Assert.AreEqual(6, count);
        }
Exemple #24
0
        public void NumbersOfTransactionsOfEachAccount()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var Date  = new DateTime(2015, 04, 06);
            var Date1 = ob.Transactions.Where(t => t.Date == Date).Select(t => t.Date).ToArray().Length;

            Assert.AreEqual(2, Date1);
        }
Exemple #25
0
        [TestMethod]  //How much did you pay each payee for food?
        public void PayeeAmountFood()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var paymentF = ob.Transactions.Where(l => l.Tag == "Food").GroupBy(t => t.Payee).Select(g => new { Sum = g.Sum(t => t.Amount) });

            Assert.AreEqual(130, paymentF.First().Sum);
            Assert.AreEqual(131, paymentF.Last().Sum);
        }
Exemple #26
0
        public void TotalForEachPayee()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var Sum = ob.Transactions.GroupBy(t => t.Payee).Select(g => new { g.Key, Sum = g.Sum(t => t.Amount) }).ToArray();

            Assert.AreEqual(130, Sum[0].Sum);
            Assert.AreEqual(300, Sum[1].Sum);
            Assert.AreEqual(131, Sum[2].Sum);
        }
Exemple #27
0
        public void ListTransactions()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var transaction = ob.Transactions;
            var list        = ob.Transactions.Where(t => t.Date.ToString("d") == DateTime.Parse("4/6/2015").ToString("d"));

            Assert.AreEqual(transaction.ElementAt(1), list.ElementAt(0));
            Assert.AreEqual(transaction.ElementAt(7), list.ElementAt(1));
        }
        public void Group()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var total = ob.Transactions.GroupBy(t => t.Tag).Select(g => new { g.Key, Sum = g.Sum(t => t.Amount) });

            Assert.AreEqual(261, total.First().Sum);
            Assert.AreEqual(300, total.Last().Sum);
        }
Exemple #29
0
        public void MoreMoneySpentOnAuto()
        {
            var ob = new CheckBookVM();

            ob.Fill();

            var CheckingAmount = ob.Transactions.Where(p => p.Tag == "Auto" && p.Account == "Checking").Sum(a => a.Amount);
            var CreditAmount   = ob.Transactions.Where(p => p.Tag == "Auto" && p.Account == "Credit").Sum(a => a.Amount);

            Assert.IsTrue(CheckingAmount == CreditAmount);
        }
Exemple #30
0
        public void PayForEachPayeeForFood()
        {
            var ob = new CheckBookVM();

            ob.Fill();
            var category = "Food";
            var totalPay = ob.Transactions.Where(t => t.Tag == category).GroupBy(t => new { t.Payee }).Select((g => new { g.Key, Sum = g.Sum(t => t.Amount) })).ToList();

            Assert.AreEqual(130, totalPay[0].Sum);
            //Assert.AreEqual(0, atotal[1].Sum);
            Assert.AreEqual(131, totalPay[1].Sum);
        }