示例#1
0
        //Change this to IConsumerDebt
        public void SaveData(CreditCardModel ccData)
        {
            var ccTableData = new CreditCardTableData
            {
                VendorName      = ccData.CardVendor,
                AccountNickName = ccData.CardNickname,
                CreditCardType  = ccData.CardType,
                OwingBalance    = ccData.CardBalance,
                CreditLine      = ccData.CardBalance
            };

            int CreditCardId = CreditCardDbService.Add(ccTableData);

            foreach (InterestRateModel item in ccData.InterestRates)
            {
                var interestData = new InterestRateTableData
                {
                    CreditCardFK = CreditCardId,
                    StartDate    = item.StartDate,
                    EndDate      = item.EndDate,
                    InterestRate = item.InterestRate
                };

                InterestRateDbService.Add(interestData);
            }
        }
        public void AddCreditCard()
        {
            var ccInfo = new CreditCardTableData()
            {
                CreditCardType  = 1,
                VendorName      = "Discover",
                AccountNickName = "My Rewards Card",
                CreditLine      = 100,
                OwingBalance    = 24.99f
            };

            int CreditCardId;

            CreditCardId = CreditCardDbService.Add(ccInfo);

            var ccRate1 = new InterestRateTableData()
            {
                StartDate    = new DateTime(2019, 04, 30, 0, 0, 0),
                EndDate      = new DateTime(2020, 04, 30, 0, 0, 0),
                InterestRate = 0.3f,
                CreditCardFK = CreditCardId
            };

            InterestRateDbService.Add(ccRate1);

            var ccRate2 = new InterestRateTableData()
            {
                StartDate    = new DateTime(2018, 04, 30, 0, 0, 0),
                EndDate      = new DateTime(2019, 04, 30, 0, 0, 0),
                InterestRate = 0.2f,
                CreditCardFK = CreditCardId
            };

            InterestRateDbService.Add(ccRate2);
        }
示例#3
0
        public static void Edit(InterestRateTableData interestRate)
        {
            using var context = new SqliteContext();
            var entity = context.InterestRates.Update(interestRate);

            entity.State = EntityState.Modified;
            context.SaveChanges();
        }
示例#4
0
        public static void Delete(InterestRateTableData interestRate)
        {
            using var context = new SqliteContext();
            var entity = context.InterestRates.Remove(interestRate);

            entity.State = EntityState.Deleted;
            context.SaveChanges();
        }
示例#5
0
        public static void Add(InterestRateTableData interestRate)
        {
            using var context = new SqliteContext();
            var entity = context.InterestRates.Add(interestRate);

            entity.State = EntityState.Added;
            context.SaveChanges();
        }