public List <Business.Entities.Plan> listarPlanesPorNombre(string nombre)
{
try
{
List <Business.Entities.Plan> planes = new List <Plan>();
string nom = "%" + nombre + "%";
Conexion.getInstance().Connect();
SqlCommand cmd = new SqlCommand("select * from Planes where CONVERT(VARCHAR,nombre) like'" + nom + "'", Conexion.getInstance().Conection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int idPlan = (int)reader.GetValue(0);
String nombr = reader.GetString(1);
String desc = reader.GetString(2);
Business.Entities.Plan plan = new Plan(nombr, desc);
if (reader["idEsp"] != DBNull.Value)
{
int IdEspecialidad = (int)reader.GetValue(3);
Business.Entities.Especialidad esp = EspecialidadDB.getInstance().buscarEspecialidadPorId(IdEspecialidad);
plan.Especialidad = esp;
}
plan.IdPlan = idPlan;
planes.Add(plan);
}
Conexion.getInstance().Disconnect();
return(planes);
}
catch (Exception e)
{
Conexion.getInstance().Disconnect();
return(null);
}
}
public static EspecialidadDB getInstance()
{
if (EspecialidadDB._instance == null)
{
EspecialidadDB._instance = new EspecialidadDB();
}
return(EspecialidadDB._instance);
}
public Business.Entities.Plan buscarPlanPorId(int id)
{
try
{
Conexion.getInstance().Connect();
SqlCommand cmd = new SqlCommand("select * from Planes where idPlan='" + id + "'", Conexion.getInstance().Conection);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
int idPlan = (int)reader.GetValue(0);
String nombr = reader.GetString(1);
String desc = reader.GetString(2);
Business.Entities.Plan plan = new Plan(nombr, desc);
if (reader["idEsp"] != DBNull.Value)
{
int IdEspecialidad = (int)reader.GetValue(3);
Business.Entities.Especialidad esp = EspecialidadDB.getInstance().buscarEspecialidadPorId(IdEspecialidad);
plan.Especialidad = esp;
}
plan.IdPlan = idPlan;
Conexion.getInstance().Disconnect();
return(plan);
}
catch (Exception e)
{
Conexion.getInstance().Disconnect();
return(null);
}
}
