public static void Run([TimerTrigger("*/10 * * * * *")] TimerInfo myTimer, ILogger log)
{
// Download Data
FileHandler fh = new FileHandler();
string result = fh.ReadData(fh.UnzipData(fh.DownloadData()));
// Read Data
DataParsing dp = new DataParsing();
dp.ParseData(result);
String url = Environment.GetEnvironmentVariable("DataSourceLocation");
log.LogInformation($"Data Source Location: {result}");
}
public static void Run([TimerTrigger("0 0 */1 * * *")] TimerInfo myTimer, ILogger log)
{
// Execute every 1 Hour to Update Database
// Download Data
log.LogInformation($"Downloading data...");
FileHandler fh = new FileHandler();
string location = fh.DownloadData();
if (location == "")
{
// Add Log - Download Failed
SqlHandler sqlh = new SqlHandler();
log.LogInformation($"Download Failed");
sqlh.LogData("Download Failed, No Changes Made");
}
else
{
string result = fh.ReadData(fh.UnzipData(location));
log.LogInformation($"Reading data...");
// Read Data
DataParsing dp = new DataParsing();
dp.ParseData(result);
log.LogInformation($"Storing data...");
// Store Data
SqlHandler sqlh = new SqlHandler();
bool diffrence = sqlh.CheckDifference();
if (diffrence)
{
// Update Database
log.LogInformation($"Clear SQL...");
sqlh.ClearData();
log.LogInformation($"Insert SQL...");
sqlh.ImportData();
sqlh.LogData("New Data - New Week");
// Add Log - Changes Made
}
else
{
// Add Log - No Changes
log.LogInformation($"No Changes Made");
sqlh.LogData("No Changes Made");
}
log.LogInformation($"Data updated successfully");
}
}
