public Reserva BuscarPorId(int id)
{
try
{
Reserva reserva = null;
SqlConnection con = db.ConectaDb();
string select = string.Format("select r.IdReserva,r.FechaIng,r.FechaSal,r.Total,h.IdHuesped from Reserva as r,Huesped as h where r.IdHuesped=h.IdHuesped and r.IdReserva={0}", id);
SqlCommand cmd = new SqlCommand(select, con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())//cuidado con el if y while aka y en listar todos
{
reserva = new Reserva(); Persona a = new Persona();
reserva.IdReserva = (int)reader["IdReserva"];
reserva.FechaIng = (DateTime)reader["FechaIng"];
reserva.FechaSal = (DateTime)reader["FechaSal"];
reserva.Total = (decimal)reader["Total"];
a = new HuespedDAODB().BuscarPorId((int)reader["IdHuesped"]);//CONVERSION DIOS
reserva.huesped = a as Huesped;
}
reader.Close();
return reserva;
}
catch (Exception ex)
{
return null;
}
finally
{
db.DesconectaDb();
}
}
public List <Reserva> ListarTodo()
{
try
{
List <Reserva> lstReservas = new List <Reserva>();
Reserva reserva = null;
SqlConnection conn = db.ConectaDb();
SqlCommand cmd = new SqlCommand("select r.IdReserva,r.FechaIng,r.FechaSal,r.Total,h.IdHuesped from Reserva as r,Huesped as h where r.IdHuesped=h.IdHueped", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
reserva = new Reserva(); Persona a = new Persona();
reserva.IdReserva = (int)reader["IdReserva"];
reserva.FechaIng = (DateTime)reader["FechaIng"];
reserva.FechaSal = (DateTime)reader["FechaSal"];
reserva.Total = (decimal)reader["Total"];
a = new HuespedDAODB().BuscarPorId((int)reader["IdHuesped"]);//CONVERSION DIOS
reserva.huesped = a as Huesped;
lstReservas.Add(reserva);
}
reader.Close();
return(lstReservas);
}
catch (Exception ex)
{
return(null);
}
finally
{
db.DesconectaDb();
}
}
public Reserva BuscarPorId(int id)
{
try
{
Reserva reserva = null;
SqlConnection con = db.ConectaDb();
string select = string.Format("select r.IdReserva,r.FechaIng,r.FechaSal,r.Total,h.IdHuesped from Reserva as r,Huesped as h where r.IdHuesped=h.IdHuesped and r.IdReserva={0}", id);
SqlCommand cmd = new SqlCommand(select, con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())//cuidado con el if y while aka y en listar todos
{
reserva = new Reserva(); Persona a = new Persona();
reserva.IdReserva = (int)reader["IdReserva"];
reserva.FechaIng = (DateTime)reader["FechaIng"];
reserva.FechaSal = (DateTime)reader["FechaSal"];
reserva.Total = (decimal)reader["Total"];
a = new HuespedDAODB().BuscarPorId((int)reader["IdHuesped"]);//CONVERSION DIOS
reserva.huesped = a as Huesped;
}
reader.Close();
return(reserva);
}
catch (Exception ex)
{
return(null);
}
finally
{
db.DesconectaDb();
}
}
public List<Reserva> ListarTodo()
{
try
{
List<Reserva> lstReservas = new List<Reserva>();
Reserva reserva = null;
SqlConnection conn = db.ConectaDb();
SqlCommand cmd = new SqlCommand("select r.IdReserva,r.FechaIng,r.FechaSal,r.Total,h.IdHuesped from Reserva as r,Huesped as h where r.IdHuesped=h.IdHueped", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
reserva = new Reserva(); Persona a = new Persona();
reserva.IdReserva = (int)reader["IdReserva"];
reserva.FechaIng = (DateTime)reader["FechaIng"];
reserva.FechaSal = (DateTime)reader["FechaSal"];
reserva.Total = (decimal)reader["Total"];
a = new HuespedDAODB().BuscarPorId((int)reader["IdHuesped"]);//CONVERSION DIOS
reserva.huesped = a as Huesped;
lstReservas.Add(reserva);
}
reader.Close();
return lstReservas;
}
catch (Exception ex)
{
return null;
}
finally
{
db.DesconectaDb();
}
}
