public static void InsertAirBookingOther(string TravelReqIDString, string FlightNoString,
string ArrivalDateString, string DepartureDateString, string DepartureLoc, string ArrivalLoc,
string AirlineString, string TicketNoString, string AirStatusString, string CreatedByString,
string StatusString, string RemarksString, bool IsBillToCrew)
{
AirDAL.InsertAirBookingOther(TravelReqIDString, FlightNoString, ArrivalDateString,
DepartureDateString, DepartureLoc, ArrivalLoc, AirlineString, TicketNoString, AirStatusString, CreatedByString,
StatusString, RemarksString, IsBillToCrew);
}
public static void UpdateAirBookingOther(string AirIDString, string FlightNoString,
string ArrivalDateString, string DepartureDateString, string DepartureLoc, string ArrivalLoc,
string AirlineString, string TicketNoString, string AirStatusString, string ModifiedByString,
string StatusString, string RemarksString, bool IsBillToCrew)
{
AirDAL.UpdateAirBookingOther(AirIDString, FlightNoString,
ArrivalDateString, DepartureDateString, DepartureLoc, ArrivalLoc,
AirlineString, TicketNoString, AirStatusString, ModifiedByString,
StatusString, RemarksString, IsBillToCrew);
}
public static IDataReader GetSFAirTravelDetailsOtherById(string AirIdBigint)
{
IDataReader dt = null;
try
{
dt = AirDAL.GetSFAirTravelDetailsOtherById(AirIdBigint);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 31/01/2012
/// Created By: Gelo Oquialda
/// (description) Insert airport hotel assignment
/// </summary>
public static Int32 InsertAirportHotel(Int32 AirportID, Int32 BranchID, String User, Int16 iRoomType,
string sLogDescription, string sFunction, string sPageName)
{
try
{
Int32 AirportHotelID = 0;
AirDAL.InsertAirportHotel(AirportID, BranchID, User, iRoomType, sLogDescription, sFunction, sPageName);
return(AirportHotelID);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 20/01/2012
/// Created By: Gelo Oquialda
/// (description) Load airport list by region
/// </summary>
//public static DataTable AirportLoad(string regionString, string userstring)
//{
// DataTable dt = null;
// try
// {
// dt = AirDAL.AirportLoad(regionString, userstring);
// return dt;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (dt != null)
// {
// dt.Dispose();
// }
// }
//}
/// <summary>
/// Date Created: 27/01/2012
/// Created By: Gelo Oquialda
/// (description) Loads airport code with airport name
/// </summary>
public static IDataReader GetAirportCodeName(int AirportID)
{
IDataReader dr = null;
try
{
dr = AirDAL.GetAirportCodeName(AirportID);
return(dr);
}
catch (Exception ex)
{
throw ex;
}
}
public static IDataReader GetSFAirTravelDetailsById(string AirID, string SeqNo)
{
IDataReader dt = null;
try
{
dt = AirDAL.GetSFAirTravelDetailsById(AirID, SeqNo);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetAirline()
{
DataTable dt = null;
try
{
dt = AirDAL.GetAirline();
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 19/01/2012
/// Created By: Gelo Oquialda
/// (description) Get Airport List By country ID
/// ----------------------------------------------
/// </summary>
/// <param name="CountryID"></param>
/// <returns></returns>
public static DataTable GetAirportByCountry(string CountryID, string RegionID, string AirportName, string AirportInitial)
{
DataTable dt = null;
try
{
dt = AirDAL.GetAirportByCountry(CountryID, RegionID, AirportName, AirportInitial);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
public static void UpdateAirBooking(string AirIdBigint, string SeqNo, string AirStatusString, bool IsBillToCrew,
string RemarksString, string ModifiedByString)
{
AirDAL.UpdateAirBooking(AirIdBigint, SeqNo, AirStatusString, IsBillToCrew, RemarksString, ModifiedByString);
}
/// <summary>
/// Date Created: 04/Mar/2014
/// Created By: Josephine Gad
/// (description) Get Airport List By Region
/// ----------------------------------------------
/// </summary>
/// <param name="CountryID"></param>
/// <returns></returns>
public static List <AirportDTO> GetAirportByRegion(string RegionID, string AiportName)
{
return(AirDAL.GetAirportByRegion(RegionID, AiportName));
}
