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); } }