public VolarisPointToPoint GetPointToPointFlightsV2(string departure, string arrival, string conexion)
{
try
{
Database dataBase = DatabaseFactory.CreateDatabase(conexion);
DbCommand dataBaseCommand = dataBase.GetStoredProcCommand("GetVolarisPointToPointV2");
dataBase.AddInParameter(dataBaseCommand, "@To", DbType.String, departure);
dataBase.AddInParameter(dataBaseCommand, "@From", DbType.String, arrival);
var point = new VolarisPointToPoint();
using (IDataReader dataReader = dataBase.ExecuteReader(dataBaseCommand))
{
int id = dataReader.GetOrdinal("ID");
int pointTo = dataReader.GetOrdinal("To");
int pointFrom = dataReader.GetOrdinal("From");
int isInternational = dataReader.GetOrdinal("IsInternational");
while (dataReader.Read())
{
point.ID = dataReader.GetInt32(id);
point.To = dataReader.GetString(pointTo);
point.From = dataReader.GetString(pointFrom);
point.IsInternational = dataReader.GetBoolean(isInternational);
}
}
return(point);
}
catch (Exception ex)
{
return(new VolarisPointToPoint());
}
}
public static VolarisPointToPoint VolarisPointToPoint(string departure, string arrival)
{
VolarisPointToPointDAL objPCCs = new VolarisPointToPointDAL();
VolarisPointToPoint point = new VolarisPointToPoint();
try
{
point = objPCCs.GetPointToPointFlightsV2(departure, arrival, CommonENT.MYCTSDB_CONNECTION);
}
catch (Exception ex)
{
try
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
point = objPCCs.GetPointToPointFlightsV2(departure, arrival, CommonENT.MYCTSDB_CONNECTION);
}
catch { }
}
return(point);
}
