public List<Location> getAllItems() { var connector = DbConnector.Instance; if (!connector.Connected()) connector.Connect(); //Create a list to store the result var results = new List<Location>(); string query = "SELECT * FROM locations"; //Create Command MySqlCommand cmd = new MySqlCommand(query, connector.Connection()); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list while (dataReader.Read()) { var new_Location = new Location((int)dataReader["id"], dataReader["name"].ToString(), dataReader["description"].ToString(), dataReader["gmaps_url"].ToString()); results.Add(new_Location); } //close Data Reader dataReader.Close(); //return list to be displayed return results; }
public Event() { this.id = -1; this.name = ""; this.description = ""; this.datetime = DateTime.Now; this.location = new Location(); this.teachers = new List<Teacher>(); }
public LocationModel Create(Location l) { return new LocationModel { parent_url = GetRootUrl(), url = GetUrlByApi("LocationApi", l.id), //id = l.id, name = l.name, gmaps_url = l.gmaps_url, description = l.description }; }
public Event(int new_id, string new_name, DateTime new_datetime, int location_id, List<int> teacher_ids, string new_description = "") { this.id = new_id; this.name = new_name; this.datetime = new_datetime; if ( Timetable.Instance.locations.Any() ) this.location = Timetable.Instance.locations.Find(l => l.id==location_id); this.description = new_description; if (teacher_ids != null && teacher_ids.Any()) { this.teachers = Timetable.Instance.teachers.FindAll(t => teacher_ids.Contains(t.id)).ToList(); } else { this.teachers = new List<Teacher>(); } }
public Event(int new_id, string new_name, DateTime new_datetime, Location new_location, string new_description = "", List<Teacher> new_teachers = null) { this.id = new_id; this.name = new_name; this.datetime = new_datetime; this.location = new_location; this.description = new_description; if (new_teachers != null) { this.teachers = new_teachers; } else { this.teachers = new List<Teacher>(); } }
public BaseModel CreateSummary(Location l) { return new BaseModel() { parent_url = GetRootUrl(), url = GetUrlByApi("LocationApi", l.id), name = l.name }; }