public List <Quote> GetQuoteDetails()
{
try
{
var quotes = new List <Quote>();
using (var context = new MoneyMeContext())
{
quotes = context.Quotes.ToList();
}
return(quotes);
}
catch (Exception ex)
{
throw ex;
}
}
public List <Title> GetTitles()
{
try
{
var titles = new List <Title>();
using (var context = new MoneyMeContext())
{
titles = context.Titles.ToList();
}
return(titles);
}
catch (Exception ex)
{
throw ex;
}
}
public Quote GetQuote(int id)
{
try
{
Quote quote = new Quote();
using (var context = new MoneyMeContext())
{
quote = context.Quotes.FirstOrDefault(q => q.ID.Equals(id));
}
return(quote);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteQuoteDetailsByID(int id)
{
try
{
Quote quote = new Quote();
using (var context = new MoneyMeContext())
{
quote = context.Quotes.FirstOrDefault(q => q.ID.Equals(id));
if (quote != null)
{
context.Remove(quote);
}
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public Quote PostQuote(Quote quote)
{
try
{
using (var context = new MoneyMeContext())
{
Quote foundQuote = context.Quotes.FirstOrDefault(q => q.ID.Equals(quote.ID));
if (foundQuote == null)
{
context.Quotes.Add(quote);
}
else
{
foundQuote.Amount = quote.Amount;
foundQuote.EmailAddress = quote.EmailAddress;
foundQuote.FirstName = quote.FirstName;
foundQuote.LastName = quote.LastName;
foundQuote.MobileNo = quote.MobileNo;
foundQuote.Rate = quote.Rate;
foundQuote.RepaymentMonthly = quote.RepaymentMonthly;
foundQuote.RepaymentWeekly = quote.RepaymentWeekly;
foundQuote.Term = quote.Term;
foundQuote.TermType = quote.TermType;
foundQuote.Title = quote.Title;
}
context.SaveChanges();
}
return(quote);
}
catch (Exception ex)
{
throw ex;
}
}
public QuoteRepository(MoneyMeContext moneyMeContext)
{
_moneyMeContext = moneyMeContext;
}
