//create a new form to display the graph
private void CreateGraph_Click(object sender, EventArgs e)
{
SightingHistoryProcessing sightings = new SightingHistoryProcessing(connection);
List<int> months = new List<int>();
int[] values = { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
int[] values2 = { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
List<TrackingEntry> tagged = new List<TrackingEntry>();
List<TrackingEntry> notag = new List<TrackingEntry>();
string thestart = StartDate.Value.Year + "-" + StartDate.Value.Month + "-" + StartDate.Value.Day;
string theEnd = EndDate.Value.Year + "-" + EndDate.Value.Month + "-" + EndDate.Value.Day;
DateTime start = new DateTime(StartDate.Value.Year, StartDate.Value.Month, StartDate.Value.Day);
DateTime end = new DateTime(EndDate.Value.Year, EndDate.Value.Month, EndDate.Value.Day);
List<DateTime> dates = new List<DateTime>();
int index = Table.Rows.Add();
int i = 0;
for (int j = 0; j < values.Length; j++)
{
while (end > start)
{
DataGridViewRow row = Table.Rows[index];
row.Cells["MonthYear"].Value = start.Month + "-" + start.Year;
row.Cells["Tagged"].Value = values[j];
row.Cells["nottagged"].Value = values2[j];
int val = start.Month;
start = start.AddMonths(1);
months.Add(val);
i++;
}
}
//query interval of dates
List<TrackingEntry> datelist = new List<TrackingEntry>();
datelist = sightings.filterByDate(thestart, theEnd);
//go through list and create a list of tagged and not tagged
if (datelist == null)
{
MessageBox.Show("No Data Found", "Sighting History");
return;
}
foreach(var item in datelist)
{
if (item.isTagged)
{
tagged.Add(item);
}
else
{
notag.Add(item);
}
}
//compare tagged dates to date range - increment series if valid
for (int ind = 0; ind < months.LongCount(); ind++)
{
DataGridViewRow row = Table.Rows[index];
foreach (TrackingEntry entry in tagged)
{
Date date = new Date();
date.date = entry.entryDate;
string year = date.year;
string month = date.month;
int counter = 0;
if (month == months[ind].ToString())
{
values[Int32.Parse(month) - 1] = values[Int32.Parse(month) - 1] + 1;
}
row.Cells["Tagged"].Value = values[Int32.Parse(month) - 1];
}
foreach (TrackingEntry entry in notag)
{
Date date = new Date();
date.date = entry.entryDate;
string year = date.year;
string month = date.month;
if (month == months[ind].ToString())
{
values2[Int32.Parse(month) - 1] = values2[Int32.Parse(month) - 1] + 1;
}
row.Cells["NotTagged"].Value = values2[Int32.Parse(month) - 1];
}
}
}
private void onSubmit_Click(object sender, EventArgs e)
{
SightingHistoryProcessing sightings = new SightingHistoryProcessing(connection);
//string thestart = StartDate.Value.ToShortDateString();
string thestart = StartDate.Value.Year + "-" + StartDate.Value.Month + "-" + StartDate.Value.Day;
string theEnd = EndDate.Value.Year + "-" + EndDate.Value.Month + "-" + EndDate.Value.Day;
//check if all three are checked
if(ByDate.Checked && Tag.Checked && NoTag.Checked)
{
//using query get by interval
sightinghistorygrid.Rows.Clear();
sightinghistorygrid.Refresh();
List<TrackingEntry> dateTagNoTag = new List<TrackingEntry>();
dateTagNoTag = sightings.filterTagDate(thestart, theEnd);
if(dateTagNoTag == null)
{
MessageBox.Show("No Records found", "Sighting History");
return;
}
foreach(var item in dateTagNoTag)
{
int index = sightinghistorygrid.Rows.Add();
DataGridViewRow row = sightinghistorygrid.Rows[index];
row.Cells["Column1"].Value = item.species;
row.Cells["Column2"].Value = item.tagNumber;
row.Cells["Column3"].Value = item.entryDate;
row.Cells["Column4"].Value = item.taggerName;
row.Cells["Column5"].Value = item.taggerID;
}
}
//check if tag and no tag is checked - NO date
else if(Tag.Checked && NoTag.Checked && !ByDate.Checked)
{
//using query getall
sightinghistorygrid.Rows.Clear();
sightinghistorygrid.Refresh();
List<TrackingEntry> TagNoTag = new List<TrackingEntry>();
TagNoTag = sightings.filterTagNoTag();
if (TagNoTag == null)
{
MessageBox.Show("No Records found", "Sighting History");
return;
}
foreach (var item in TagNoTag)
{
int index = sightinghistorygrid.Rows.Add();
DataGridViewRow row = sightinghistorygrid.Rows[index];
row.Cells["Column1"].Value = item.species;
row.Cells["Column2"].Value = item.tagNumber;
row.Cells["Column3"].Value = item.entryDate;
row.Cells["Column4"].Value = item.taggerName;
row.Cells["Column5"].Value = item.taggerID;
}
}
//check if date and tag are checked
else if (Tag.Checked && ByDate.Checked && !NoTag.Checked)
{
sightinghistorygrid.Rows.Clear();
sightinghistorygrid.Refresh();
List<TrackingEntry> dateTag = new List<TrackingEntry>();
dateTag = sightings.filterTagDate(thestart, theEnd);
if (dateTag == null)
{
MessageBox.Show("No Records found", "Sighting History");
return;
}
foreach (var item in dateTag)
{
int index = sightinghistorygrid.Rows.Add();
DataGridViewRow row = sightinghistorygrid.Rows[index];
row.Cells["Column1"].Value = item.species;
row.Cells["Column2"].Value = item.tagNumber;
row.Cells["Column3"].Value = item.entryDate;
row.Cells["Column4"].Value = item.taggerName;
row.Cells["Column5"].Value = item.taggerID;
}
}
//check if date and no tag are checked
else if (NoTag.Checked && ByDate.Checked && !Tag.Checked)
{
sightinghistorygrid.Rows.Clear();
sightinghistorygrid.Refresh();
List<TrackingEntry> dateNoTag = new List<TrackingEntry>();
dateNoTag = sightings.filterNoTagDate(thestart, theEnd);
if (dateNoTag == null)
{
MessageBox.Show("No Records found", "Sighting History");
return;
}
foreach (var item in dateNoTag)
{
int index = sightinghistorygrid.Rows.Add();
DataGridViewRow row = sightinghistorygrid.Rows[index];
row.Cells["Column1"].Value = item.species;
row.Cells["Column2"].Value = item.tagNumber;
row.Cells["Column3"].Value = item.entryDate;
row.Cells["Column4"].Value = item.taggerName;
row.Cells["Column5"].Value = item.taggerID;
}
}
//check if only date checked
if (ByDate.Checked)
{
sightinghistorygrid.Rows.Clear();
sightinghistorygrid.Refresh();
List<TrackingEntry> datelist = new List<TrackingEntry>();
datelist = sightings.filterByDate(thestart, theEnd);
if (datelist == null)
{
MessageBox.Show("No Records found", "Sighting History");
return;
}
foreach (TrackingEntry item in datelist)
{
int index = sightinghistorygrid.Rows.Add();
DataGridViewRow row = sightinghistorygrid.Rows[index];
row.Cells["Column1"].Value = item.species;
row.Cells["Column2"].Value = item.tagNumber;
row.Cells["Column3"].Value = item.entryDate;
row.Cells["Column4"].Value = item.taggerName;
row.Cells["Column5"].Value = item.taggerID;
}
}
//check if tag checked
else if (Tag.Checked && !ByDate.Checked && !NoTag.Checked)
{
sightinghistorygrid.Rows.Clear();
sightinghistorygrid.Refresh();
List<TrackingEntry> taggedlist = new List<TrackingEntry>();
taggedlist = sightings.filterByTag();
if (taggedlist == null)
{
MessageBox.Show("No Records found", "Sighting History");
return;
}
foreach (TrackingEntry item in taggedlist)
{
int index = sightinghistorygrid.Rows.Add();
DataGridViewRow row = sightinghistorygrid.Rows[index];
row.Cells["Column1"].Value = item.species;
row.Cells["Column2"].Value = item.tagNumber;
row.Cells["Column3"].Value = item.entryDate;
row.Cells["Column4"].Value = item.taggerName;
row.Cells["Column5"].Value = item.taggerID;
}
}
//check if no tag checked
else if (NoTag.Checked && !ByDate.Checked && !Tag.Checked)
{
sightinghistorygrid.Rows.Clear();
sightinghistorygrid.Refresh();
List<TrackingEntry> notaglist = new List<TrackingEntry>();
notaglist = sightings.filterByNoTag();
if (notaglist == null)
{
MessageBox.Show("No Records found", "Sighting History");
return;
}
foreach (TrackingEntry item in notaglist)
{
int index = sightinghistorygrid.Rows.Add();
DataGridViewRow row = sightinghistorygrid.Rows[index];
row.Cells["Column1"].Value = item.species;
row.Cells["Column2"].Value = item.tagNumber;
row.Cells["Column3"].Value = item.entryDate;
row.Cells["Column4"].Value = item.taggerName;
row.Cells["Column5"].Value = item.taggerID;
}
}
}