Пример #1
0
 public List <Business.Entities.Materia> listarMateriasPorNombre(string nombre)
 {
     try
     {
         string nomb = "%" + nombre + "%";
         Conexion.getInstance().Connect();
         SqlCommand    cmd    = new SqlCommand("select * from dbo.Materia where CONVERT(VARCHAR,nombre) like'" + nomb + "'", Conexion.getInstance().Conection);
         SqlDataReader reader = cmd.ExecuteReader();
         List <Business.Entities.Materia> materias = new List <Materia>();
         while (reader.Read())
         {
             int    idMateria = (int)reader.GetValue(0);
             string nom       = reader.GetString(1);
             string desc      = reader.GetString(2);
             int    hsSem     = (int)reader.GetValue(3);
             int    hsTot     = (int)reader.GetValue(4);
             int    idPlan    = (int)reader.GetValue(5);
             Business.Entities.Materia mat = new Materia(nom, desc, hsSem, hsTot);
             mat.IdMateria = idMateria;
             if (reader["idPlan"] != DBNull.Value)
             {
                 Business.Entities.Plan plan = PlanDB.getInstance().buscarPlanPorId((int)reader.GetValue(5));
                 mat.Plan = plan;
             }
             materias.Add(mat);
         }
         Conexion.getInstance().Disconnect();
         return(materias);
     }
     catch (Exception e)
     {
         Conexion.getInstance().Disconnect();
         return(null);
     }
 }
Пример #2
0
 public static PlanDB getInstance()
 {
     if (PlanDB._instance == null)
     {
         PlanDB._instance = new PlanDB();
     }
     return(PlanDB._instance);
 }