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();
}
}
