예제 #1
0
        public List<Event> getAllItems()
        {
            var connector = DbConnector.Instance;
            if (!connector.Connected()) connector.Connect();

            //Create a list to store the result
            var results = new List<Event>();

            string query = "SELECT * FROM events";

            //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_event = new Event((int)dataReader["id"],
                    dataReader["name"].ToString(),
                    (DateTime)dataReader["datetime"],
                    (int)dataReader["location_id"], 
                    null,
                    dataReader["description"].ToString());
                results.Add(new_event);
            }

            //close Data Reader
            dataReader.Close();

            //return list to be displayed
            return results;
        }
예제 #2
0
 public EventModel Create(Event e)
 {
     return new EventModel()
     {
         parent_url = GetRootUrl(),
         url = GetUrlByApi("EventApi", e.id),
         //id = e.id,
         name = e.name,
         description = e.description,
         date = e.datetime.ToShortDateString(),
         time = e.datetime.ToShortTimeString(),
         teacher_urls = e.teachers.Select(t => this.CreateSummary(t).url).ToList(),
         location_url = this.CreateSummary(e.location).url,
     };
 }
예제 #3
0
 public BaseModel CreateSummary(Event e)
 {
     return new BaseModel()
     {
         parent_url = GetRootUrl(),
         url = GetUrlByApi("EventApi", e.id),
         name = e.name
     };
 }