public Carac BuscarPorId(int id)
{
try
{
Carac carac = null;
SqlConnection con = db.ConectaDb();
string select = string.Format("select IdCarac,Nombre,Precio from Carac where IdCarac='{0}' order by IdCarac asc", id);
SqlCommand cmd = new SqlCommand(select, con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
carac = new Carac();
carac.IdCarac = (int)reader["IdCarac"];
carac.Nombre = (string)reader["Nombre"];
carac.Precio = (decimal)reader["Precio"];
}
reader.Close();
return carac;
}
catch (Exception ex)
{
return null;
}
finally
{
db.DesconectaDb();
}
}
public string Insertar(Carac o)
{
try
{
SqlConnection con = db.ConectaDb();
string insert = string.Format("insert into Carac(Nombre,Precio) values('{0}',{1})", o.Nombre, o.Precio);
SqlCommand cmd = new SqlCommand(insert, con);
cmd.ExecuteNonQuery();
return "Caracteristica de Hotel Registrada";
}
catch (Exception ex)
{
return ex.Message;
}
finally
{
db.DesconectaDb();
}
}
public List<Carac> ListarTodo()
{
try
{
List<Carac> lstcaracs = new List<Carac>();
Carac carac = null;
SqlConnection con = db.ConectaDb();
SqlCommand cmd = new SqlCommand("select IdCarac,Nombre,Precio from Carac ", con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
carac = new Carac();
carac.IdCarac = (int)reader["IdCarac"];
carac.Nombre = (string)reader["Nombre"];
carac.Precio = (decimal)reader["Precio"];
lstcaracs.Add(carac);
}
reader.Close();
return lstcaracs;
}
catch (Exception ex)
{
return null;
}
finally
{
db.DesconectaDb();
}
}
public string Modificar(Carac o)
{
try
{
SqlConnection con = db.ConectaDb();
string update = string.Format("update Carac set Nombre='{0}',Precio={1} where IdCarac={2}", o.Nombre, o.Precio, o.IdCarac);
SqlCommand cmd = new SqlCommand(update, con);
cmd.ExecuteNonQuery();
return "Caracteristica Actualizada";
}
catch (Exception ex)
{
return ex.Message;
}
finally
{
db.DesconectaDb();
}
}
