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