コード例 #1
0
        public bool RemoveLoanSchedule(int loanID)
        {
            try
            {
                using (LoanPriceEntities context = new LoanPriceEntities())
                {
                    List<LoanSchedule> loans = context.LoanSchedules.Where(s => s.LoanID == loanID).ToList();

                    for (int i = 0; i < loans.Count; i++)
                    {
                        context.DeleteObject(loans[i]);
                    }

                    context.SaveChanges();
                    return true;
                }
            }
            catch (Exception ex)
            {
                return false;
            }
        }
コード例 #2
0
        public bool RemoveAllLoans()
        {
            try
            {
                using (LoanPriceEntities context = new LoanPriceEntities())
                {
                    List<Loans> loans = context.Loans.ToList();

                    for (int i = 0; i < loans.Count; i++)
                    {
                        LoanScheduleBL loanScheduleBL = new LoanScheduleBL();
                        loanScheduleBL.RemoveLoanSchedule(loans[i].ID);
                        context.DeleteObject(loans[i]);

                    }

                    context.SaveChanges();
                    return true;
                }
            }
            catch (Exception ex)
            {
                return false;
            }
        }
コード例 #3
0
        public bool RemoveAllQuotesAndTrades()
        {
            try
            {
                using (LoanPriceEntities context = new LoanPriceEntities())
                {
                    List<QuotesAndTrades> quotesAndTrades = context.QuotesAndTrades.ToList();

                    for (int i = 0; i < quotesAndTrades.Count; i++)
                    {
                        context.DeleteObject(quotesAndTrades[i]);
                    }

                    context.SaveChanges();
                    return true;
                }
            }
            catch (Exception)
            {
                return false;
            }
        }