public void testDate()
 {
     DateQuery query = new DateQuery(connection);
     Date date = new Date();
     date = query.getDate(1);
     Console.WriteLine(date.year);
     Console.Write(date.month);
 }
        public void updateDate(TrackingEntry entry)
        {
            string date = entry.entryDate;
            Date trackingDate = new Date();
            DateQuery dateQuery = new DateQuery(connection);

            trackingDate = dateQuery.getDate(date);
            if(trackingDate == null)
            {
                trackingDate = new Date();
                trackingDate.date = date;
                dateQuery.addDate(trackingDate);
            }
            else
            {
                dateQuery.incrementSightings(trackingDate.id);
            }
        }
 public DateQueryUnitTest(MySqlConnection connection)
 {
     this.connection = connection;
     query = new DateQuery(connection);
 }