public static List <Sighting> GetSightingsList() { MySqlConnection conn = DB.Connection(); conn.Open(); List <Sighting> allSightings = new List <Sighting>(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM sightings ORDER BY date_time ASC LIMIT 10"; MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int id = rdr.GetInt32(0); string description = rdr.GetString(1); string type = rdr.GetString(2); DateTime time = rdr.GetDateTime(3); string address = rdr.GetString(4); string city = rdr.GetString(5); string state = rdr.GetString(6); Sighting newSighting = new Sighting(description, type, time, address, city, state, id); allSightings.Add(newSighting); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allSightings); }
public List <Sighting> GetAllUserSightings() { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM sightings WHERE user_id = @UserId;"; cmd.Parameters.AddWithValue("@UserId", Id); var rdr = cmd.ExecuteReader() as MySqlDataReader; List <Sighting> allSightings = new List <Sighting>() { }; while (rdr.Read()) { int id = rdr.GetInt32(0); string description = rdr.GetString(1); string type = rdr.GetString(2); DateTime time = rdr.GetDateTime(3); string address = rdr.GetString(4); string city = rdr.GetString(5); string state = rdr.GetString(6); double lat = rdr.GetDouble(7); double lng = rdr.GetDouble(8); int userId = rdr.GetInt32(9); Sighting newSighting = new Sighting(description, type, time, address, city, state, lat, lng, userId, id); allSightings.Add(newSighting); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allSightings); }
public override bool Equals(System.Object otherSighting) { if (!(otherSighting is Sighting)) { return(false); } else { Sighting newSighting = (Sighting)otherSighting; bool idEquality = (this.Id == newSighting.Id); bool descriptionEquality = (this.Description == newSighting.Description); bool typeEquality = (this.Type == newSighting.Type); bool timeEquality = (this.Time == newSighting.Time); bool addressEquality = (this.Address == newSighting.Address); bool cityEquality = (this.City == newSighting.City); bool stateEquality = (this.State == newSighting.State); bool latEquality = (this.Lat == newSighting.Lat); bool lngEquality = (this.Lng == newSighting.Lng); bool UserIdEquality = (this.UserId == newSighting.UserId); return(idEquality && descriptionEquality && typeEquality && timeEquality && addressEquality && cityEquality && stateEquality && latEquality && lngEquality && UserIdEquality); } }