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