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