public GetNationalRoutes NationalRoutes(string route, string connectionName) { Database db = DatabaseFactory.CreateDatabase(connectionName); DbCommand dbCommand = db.GetStoredProcCommand("GetNationalRoutes"); db.AddInParameter(dbCommand, "@Route", DbType.String, route); GetNationalRoutes item = new GetNationalRoutes(); using (IDataReader dr = db.ExecuteReader(dbCommand)) { int _citCouId = dr.GetOrdinal("CatCitCouId"); while (dr.Read()) { item.CatCitCoudId = dr.GetString(_citCouId); } } return(item); }
public static GetNationalRoutes NationalRoutes(string agent) { GetNationalRoutes nationalRoutes = new GetNationalRoutes(); GetNationalRoutesDAL objNationalRoutes = new GetNationalRoutesDAL(); try { try { nationalRoutes = objNationalRoutes.NationalRoutes(agent, CommonENT.MYCTSDB_CONNECTION); } catch (Exception ex) { new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos); nationalRoutes = objNationalRoutes.NationalRoutes(agent, CommonENT.MYCTSDBBACKUP_CONNECTION); } } catch { } return(nationalRoutes); }