public ActionResult GetView(string id)
{
if (id == "Confused" || id == "Go Compare")
{
DailyQuoteTable _model = new DailyQuoteTable
{
QuoteSource = id
};
return(PartialView("InsertData", _model));
}
else if (id == "Compare The Market")
{
DailyQuoteTable _model = new DailyQuoteTable
{
QuoteSource = id
};
return(PartialView("CTMView", _model));
}
else if (id == "Money Supermarket")
{
DailyQuoteTable _model = new DailyQuoteTable
{
QuoteSource = id
};
return(PartialView("MoneySupermarketView", _model));
}
return(null);
}
public ActionResult Create([Bind(Include = "Id,QuoteSource,QuoteType,Date,Value,Comments,TQValue,TQComments,PQValue,TopQValue,TopQComments,PQComments,QBValue,QBComments ,TopQuote,TopQuoteComments,TopQuoteHI,TopQuoteHIComments,TopQuoteQ,TopQuoteQComments,ClickThrough,ClickThroughComments,TotalQueries,TotalQuotesReturned,TotalClicks,ProviderQuoteRate,FilteredQuotes,TotalQueriesComments,TotalQuotesReturnedComments,TotalClicksComments,ProviderQuoteRateComments,FilteredQuotesComments,TopQuotes,TopQuotesComments")] DailyQuoteTable dailyQuote)
{
if (ModelState.IsValid)
{
if (dailyQuote.QuoteSource == "Confused" || dailyQuote.QuoteSource == "Go Compare")
{
DailyQuote newQuote = new DailyQuote();
newQuote.Date = dailyQuote.Date;
newQuote.QuoteSource = dailyQuote.QuoteSource;
newQuote.QuoteType = "Total Quotes";
newQuote.Value = dailyQuote.TQValue;
newQuote.Comments = dailyQuote.TQComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Partner Quotes";
newQuote.Value = dailyQuote.PQValue;
newQuote.Comments = dailyQuote.PQComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Top Quote";
newQuote.Value = dailyQuote.TopQValue;
newQuote.Comments = dailyQuote.TopQComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Top Quotes Q %";
newQuote.Value = dailyQuote.TopQuoteQ;
newQuote.Comments = dailyQuote.TopQuoteQComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Top Quotes HI %";
newQuote.Value = dailyQuote.TopQuoteHI;
newQuote.Comments = dailyQuote.TopQuoteHIComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Quotes Blocked %";
newQuote.Value = dailyQuote.QBValue;
newQuote.Comments = dailyQuote.QBComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
}
if (dailyQuote.QuoteSource == "Compare The Market")
{
DailyQuote newQuote = new DailyQuote();
newQuote.Date = dailyQuote.Date;
newQuote.QuoteSource = dailyQuote.QuoteSource;
newQuote.QuoteType = "Consumer Enquiries";
newQuote.Value = dailyQuote.TQValue;
newQuote.Comments = dailyQuote.TQComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Prices Presented";
newQuote.Value = dailyQuote.PQValue;
newQuote.Comments = dailyQuote.PQComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Prices Presented @P1";
newQuote.Value = dailyQuote.TopQValue;
newQuote.Comments = dailyQuote.TopQComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Click Through (PCTs)";
newQuote.Value = dailyQuote.ClickThrough;
newQuote.Comments = dailyQuote.ClickThroughComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Top Quotes %";
newQuote.Value = dailyQuote.TopQuote;
newQuote.Comments = dailyQuote.TopQuoteComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Quotes Declined %";
newQuote.Value = dailyQuote.QBValue;
newQuote.Comments = dailyQuote.QBComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
}
if (dailyQuote.QuoteSource == "Money Supermarket")
{
DailyQuote newQuote = new DailyQuote();
newQuote.Date = dailyQuote.Date;
newQuote.QuoteSource = dailyQuote.QuoteSource;
newQuote.QuoteType = "Total Queries";
newQuote.Value = dailyQuote.TotalQueries;
newQuote.Comments = dailyQuote.TotalQueriesComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Total Quotes Returned";
newQuote.Value = dailyQuote.TotalQuotesReturned;
newQuote.Comments = dailyQuote.TotalQuotesReturnedComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Total Clicks";
newQuote.Value = dailyQuote.TotalClicks;
newQuote.Comments = dailyQuote.TotalClicksComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Provider Quote Rate %";
newQuote.Value = dailyQuote.ProviderQuoteRate;
newQuote.Comments = dailyQuote.ProviderQuoteRateComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Filtered Quotes";
newQuote.Value = dailyQuote.FilteredQuotes;
newQuote.Comments = dailyQuote.FilteredQuotesComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
newQuote.QuoteType = "Top Quotes";
newQuote.Value = dailyQuote.TopQuotes;
newQuote.Comments = dailyQuote.TopQuoteComments;
db.DailyQuotes.Add(newQuote);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
ModelState.AddModelError("QuoteSource", "Please Select the Date");
ViewBag.QSourceList = GetQuoteSource();
ViewData["QSourceList"] = GetQuoteSource();
return(View(dailyQuote));
}
