private void YearSearch_Load(object sender, EventArgs e) { this.Text = "Occurrences reported in " + selectedYear; olvFlag.AspectToStringConverter = delegate(object x) { return(String.Empty); }; olvFlag.ImageGetter = delegate(object rowObject) { CrashInfo s = (CrashInfo)rowObject; return(s.Img); }; olvCrashes.SetObjects(CrashInfo.GetCrashes(selectedYear)); //Deletes the Crashes List CrashInfo.AllCrashes.Clear(); lblResults.Text = "Showing " + olvCrashes.Items.Count + " results"; this.Show(); SplashScreen.CloseSplashScreen(); this.Activate(); lblResults.Visible = true; }
/// <summary> /// Fully create all the years of occurrences in the DB /// </summary> /// <returns></returns> public void FullDBSync(object sender, DoWorkEventArgs e) { btnLock.Enabled = false; btnSync.Enabled = false; int date = 2018; int count = 0; while (date <= Convert.ToInt32(DateTime.Now.Year)) { List <CrashInfo> values = CrashInfo.GetCrashes(date.ToString()); foreach (CrashInfo cr in values) { int id = DBSync.GetOccurrenceIDByLink(cr.Link); int img_ID; int countryID = 0; if (id == 0) { countryID = DBSync.GetFlagByFlagName(cr.Flag_Name); if (countryID <= 0) { countryID = DBSync.CreateFlagImage(cr.Flag_Name, DBSync.ImageToByteArray(cr.Img)); } //Creates the occurrence, if it doesn't exist id = DBSync.CreateOccurence(cr, countryID); if (id != 0) { count++; } //Creates the page for the occurrence img_ID = DBSync.GetPlaneImageIDByPlaneModel(cr.Plane); if (img_ID <= 0) { img_ID = DBSync.CreatePlaneImage(cr.Plane, DBSync.ImageToByteArray(cr.Img)); } DBSync.CreateOccurrenceInfo(CrashDetails.RetrieveInfoFromWebsite(Resources.MainPage + cr.Link), id, img_ID); } else { if (DBSync.GetOccurrenceInfoByID(id) <= 0) //If it does not exist { img_ID = DBSync.GetPlaneImageIDByPlaneModel(cr.Plane); if (img_ID <= 0) { img_ID = DBSync.CreatePlaneImage(cr.Plane, DBSync.ImageToByteArray(cr.Img)); } DBSync.CreateOccurrenceInfo(CrashDetails.RetrieveInfoFromWebsite(Resources.MainPage + cr.Link), id, img_ID); } } } CrashInfo.AllCrashes.Clear(); date++; } Settings.Default.OccurrencesSync = DateTime.Now; Settings.Default.IndividualSync = DateTime.Now; Settings.Default.Save(); lblOcc.Text = "Incidents: " + Settings.Default.OccurrencesSync.ToString(); lblIndividual.Text = "Individual: " + Settings.Default.IndividualSync.ToString(); btnLock.Enabled = true; isLocked = true; }