private static void Main(string[] args)
{
VirusDAL virusDal = new VirusDAL();
try
{
string url = "https://www.worldometers.info/coronavirus/";
Task <IHtmlDocument> documentTask = GetHtmlDocument(url);
documentTask.Wait();
var document = documentTask.Result;
CaseBlobs caseBlobs = GetCasesFromHtmlDoc(document);
virusDal.SaveDataCaseBlob(caseBlobs);
}
catch (Exception e)
{
var error = new VirusErrorLog();
error.ApplicationName = "VirusScraper";
error.ExceptionMessage = e.Message;
error.StackTrace = e.StackTrace;
error.DateAdded = DateTime.Now;
virusDal.SaveErrorLog(error);
}
}
public void SaveErrorLog(VirusErrorLog error)
{
SqlConnection connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=Josh;Integrated Security=SSPI;");
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Insert into VirusErrorLog Values (@ExceptionMessage, @DateAdded, @StackTrace, @ApplicationName)";
cmd.Parameters.AddWithValue("@ExceptionMessage", error.ExceptionMessage);
cmd.Parameters.AddWithValue("@DateAdded", DateTime.Now);
cmd.Parameters.AddWithValue("@StackTrace", error.StackTrace);
cmd.Parameters.AddWithValue("@ApplicationName", error.ApplicationName);
cmd.Connection = connection;
cmd.ExecuteNonQuery();
}
static void Main(string[] args)
{
VirusDAL virusDal = new VirusDAL();
CaseParser parser = new CaseParser();
try
{
var caseBlobs = virusDal.GetUnprocessedCaseBlobs();
List <Case> parsedCases = parser.ParseCases(caseBlobs);
virusDal.SaveCases(parsedCases);
foreach (var caseBlob in caseBlobs)
{
virusDal.MarkProcessed(caseBlob.casesBlobId);
}
//mark as processed
//after the information is parsed
// mark processed as "1" and then move on
//update the method
}
catch (Exception e)
{
var error = new VirusErrorLog();
error.ApplicationName = "VirusScraper";
error.ExceptionMessage = e.Message;
error.StackTrace = e.StackTrace;
virusDal.SaveErrorLog(error);
}
}
