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);
}
