public async void LoadEvents() { BtnLoading.IsRunning = true; var list = await api.GetEventos(Convert.ToInt32(Settings.idSeminario)); _eventos = new ObservableCollection <Models.Evento>(list); ListEvento.ItemsSource = _eventos; ListEvento.EndRefresh(); BtnLoading.IsRunning = false; }
public ListEvento List(string filtro) { try { ListEvento list = new ListEvento(); getProcedure("SelectEventos"); cmd.Parameters.AddWithValue("pfiltro", filtro); conn.Open(); MySqlDataReader dr = cmd.ExecuteReader(); cmd.Parameters.Clear(); if (dr.HasRows) { while (dr.Read()) { Evento evento = new Evento(); evento.Id = int.Parse(dr["id"].ToString()); evento.Titulo = dr["titulo"].ToString(); evento.Responsavel = Convert.ToInt32(dr["responsavel"].ToString()); evento.ResponsavelNome = dr["responsavelNome"].ToString(); evento.DataInicio = Convert.ToDateTime(dr["dataInicio"].ToString()); evento.DataFim = Convert.ToDateTime(dr["dataFim"].ToString()); evento.Obra = dr["obra"].ToString(); list.Add(evento); } } dr.Close(); return(list); } catch (Exception ex) { throw new Exception(ex.Message); } finally { conn.Close(); } }