public static CMTSEntity GetCMTSPorId(int IdCMTS) { CMTSEntity entities = new CMTSEntity(); entities = ProviderSoftv.Administracion.GetCMTSPorId(IdCMTS); return(entities ?? new CMTSEntity()); }
public override CMTSEntity GetCMTSPorId(int IdCMTS) { CMTSEntity result = new CMTSEntity(); DBHelper db = new DBHelper(); db.agregarParametro("@IdCMTS", SqlDbType.Int, IdCMTS); SqlDataReader reader = db.consultaReader("ObtieneCMTSPorId"); result = db.MapDataToEntityCollection <CMTSEntity>(reader).FirstOrDefault(); reader.Close(); db.cierraConexion(); return(result); }
public SNMPHelper(int IdCMTS) { cmts = new CMTSEntity(); DBHelper db = new DBHelper(); db.agregarParametro("@IdCMTS", SqlDbType.Int, IdCMTS); SqlDataReader reader = db.consultaReader("ObtieneCMTSPorId"); cmts = db.MapDataToEntityCollection <CMTSEntity>(reader).FirstOrDefault(); reader.Close(); db.cierraConexion(); //Llenamos las oids oids = new Dictionary <string, string>(); oids.Add("SNR", "1.2.3"); }
public SSHHelper(int IdCMTS) { CMTSEntity cmts = new CMTSEntity(); DBHelper db = new DBHelper(); db.agregarParametro("@IdCMTS", SqlDbType.Int, IdCMTS); SqlDataReader reader = db.consultaReader("ObtieneCMTSPorId"); cmts = db.MapDataToEntityCollection <CMTSEntity>(reader).FirstOrDefault(); reader.Close(); db.cierraConexion(); ConnNfo = new ConnectionInfo(cmts.IP, 22, cmts.Usuario, new AuthenticationMethod[] { // Pasword based Authentication new PasswordAuthenticationMethod(cmts.Usuario, cmts.Password), }); }