public void AddGoCompare(string fileLocationHome, string fileLocationQuote)
{
//declare classes
FileCorrect cm = new FileCorrect();
OpenExcelDB openDB = new OpenExcelDB();
ExcelUnprotect eu = new ExcelUnprotect();
eu.UnprotectExcelFile(fileLocationHome);
eu.UnprotectExcelFile(fileLocationQuote);
cm.FileDateCorrect(fileLocationHome);
cm.FileDateCorrect(fileLocationQuote);
var ConnectionString = openDB.ConnectionString(fileLocationHome);
var ConnectionStringTwo = openDB.ConnectionString(fileLocationQuote);
DailyPerformanceReportDbEntities1 db = new DailyPerformanceReportDbEntities1();
var quoteSource = "Go Compare";
var days = db.GetEntryDates(quoteSource).FirstOrDefault().Value;
var daysToGoBack = Convert.ToInt32(days);
do
//var daysPast = DateTime.Now.AddDays(-i).ToString();
{
var daysPast = Convert.ToString(DateTime.Now.AddDays(-days).Date.ToOADate());
var daysPastAlt = DateTime.Now.AddDays(-days).ToString("ddd, dd MMM yyyy");
DateTime daysPastdb = DateTime.Now.AddDays(-days).Date;
--days;
AddGoCompareToDb(ConnectionString, ConnectionStringTwo, daysPast, daysPastAlt, daysPastdb);
}while (days > 0);
}
public void AddMoneySupermarket(string fileLocation)
{
//declare classes
FileCorrect cm = new FileCorrect();
OpenExcelDB openDB = new OpenExcelDB();
cm.FileDateCorrect(fileLocation);
var ConnectionString = openDB.ConnectionString(fileLocation);
DailyPerformanceReportDbEntities1 db = new DailyPerformanceReportDbEntities1();
var quoteSource = "Money Supermarket";
var days = db.GetEntryDates(quoteSource).FirstOrDefault().Value;
var daysToGoBack = Convert.ToInt32(days);
do
//var daysPast = DateTime.Now.AddDays(-i).ToString("ddd, dd MMM yyyy");
{
var daysPast = DateTime.Now.AddDays(-daysToGoBack).ToString("yyyy.MM.dd");
DateTime daysPastdb = DateTime.Now.AddDays(-daysToGoBack).Date;
--daysToGoBack;
AddMSToDb(daysPast, daysPastdb, ConnectionString);
}while (daysToGoBack > 1);
}
public void GetAggregatorsExcelInfo(string fileLocation)
{
//declare classes
FileCorrect ga = new FileCorrect();
OpenExcelFile ga1 = new OpenExcelFile();
ExcelRowListByRowValuecs ga2 = new ExcelRowListByRowValuecs();
ExcelCleanUp ga3 = new ExcelCleanUp();
//open excel file and set xlworksheet to be used in retrievecolumnByRow
ga.FileDateCorrect(fileLocation);
var xlWorksheet = ga1.OpenExcel(fileLocation);
// returns list of colum values based on search value.
var rowList = ga2.RetrieveRowByRow(xlWorksheet, yesterday);
ga3.CleanUp(fileLocation);
}
public void AddCompareTheMarket(string fileLocation)
{
//declare classes
FileCorrect cm = new FileCorrect();
OpenExcelFile cm1 = new OpenExcelFile();
ExcelColumnListByRowValue cm2 = new ExcelColumnListByRowValue();
ExcelCleanUp cm3 = new ExcelCleanUp();
CTMunprotect eu = new CTMunprotect();
cm.FileDateCorrect(fileLocation);
//eu.UnprotectExcelFile(fileLocation);
DailyPerformanceReportDbEntities1 db = new DailyPerformanceReportDbEntities1();
var quoteSource = "Compare the Market";
var days = db.GetEntryDates(quoteSource).FirstOrDefault().Value;
var daysToGoBack = Convert.ToInt32(days);
while (daysToGoBack > 0)
{
//var daysPast = DateTime.Now.AddDays(-i).ToString("ddd, dd MMM yyyy");
do
{
var daysPast = DateTime.Now.AddDays(-daysToGoBack).ToString("dd/MM/yyyy");
var daysPastdb = DateTime.Now.AddDays(-daysToGoBack).Date;
--daysToGoBack;
AddCTMToDb(cm1, cm2, fileLocation, cm3, daysPast, daysPastdb);
}while (daysToGoBack > 0);
}
}
