public List <Reserva> SelecionaReserva()
{
using (db = new ConexaoDB())
{
string StrQuery = string.Format("select * from tbreserva;");
MySqlDataReader registros = db.RetornaRegistro(StrQuery);
var reservaList = new List <Reserva>();
while (registros.Read())
{
var ReservaTemporaria = new Reserva
{
IdReserva = int.Parse(registros["IdReserva"].ToString()),
Mesa = new Mesa().SelecionaIdMesa(int.Parse(registros["IdMesa"].ToString())),
Cliente = new Cliente().SelecionaIdCli(int.Parse(registros["IdCli"].ToString())),
DataHoraReserva = DateTime.Parse(registros["DataHoraReserva"].ToString()),
//HoraQueroComer = DateTime.Parse(registros["DataQueroComer"].ToString())
};
reservaList.Add(ReservaTemporaria);
}
return(reservaList);
}
}
