/// <summary>
/// Date Created: 21/07/2011
/// Created By: Josephine Gad
/// (description) Get seafarer personal info based from status and itinerary no
/// </summary>
public static DataTable GetSFTravelInfo(string sfCode, string status, string recloc)
{
DataTable dt = null;
try
{
dt = SuperUserDAL.GetSFTravelInfo(sfCode, status, recloc);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 31/08/2011
/// Created By: Josephine Gad
/// (description) Get seafarer air bookings by travel request ID
/// </summary>
public static DataTable GetSFAirTravelDetailsAll(string sfCode, string status)
{
DataTable dt = null;
try
{
dt = SuperUserDAL.GetSFAirTravelDetailsAll(sfCode, status);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 03/11/2011
/// Created By: Josephine Gad
/// (description) Get pending hotel bookings
/// </summary>
public static DataTable GetSFHotelTravelDetailsPending(string TravelReqID, string manualReqID)
{
DataTable dt = null;
try
{
dt = SuperUserDAL.GetSFHotelTravelDetailsPending(TravelReqID, manualReqID);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 24/07/2011
/// Created By: Josephine Gad
/// (description) Get vendor by Type (HO/VE)
/// ------------------------------------------
/// Date Created: 21/10/2011
/// Created By: Josephine Gad
/// (description) Add parameter country and city
/// </summary>
public static DataTable GetVendor(string TypeString, bool IsAccredited, string country, string city, string port, string user, string role)
{
DataTable dt = null;
try
{
dt = SuperUserDAL.GetVendor(TypeString, IsAccredited, country, city, port, user, role);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 11/07/2011
/// Created By: Marco Abejar
/// (description) Get seafarer port travel info
/// </summary>
public static DataTable GetSFPortTravelDetails(string TravelReqID, string RecLoc, string ManualReqID, string SFStatus)
{
DataTable dt = null;
try
{
dt = SuperUserDAL.GetSFPortTravelDetails(TravelReqID, RecLoc, ManualReqID, SFStatus);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 26/08/2011
/// Created By: Josephine Gad
/// (description) Get seafarer hotel bookings by travel request ID
/// --------------------------------------------------
/// </summary>
public static DataTable GetSFHotelDetailsAll(string TravelReqIDInt, string ManualRequestIdInt, string statusString)
{
DataTable dt = null;
try
{
dt = SuperUserDAL.GetSFHotelDetailsAll(TravelReqIDInt, ManualRequestIdInt, statusString);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 10/10/2011
/// Created By: Josephine Gad
/// (description) Get hotel booking by record locator or manual request ID, travel req ID, and SF ID
/// </summary>
public static DataTable GetSFHotelDetailsByID(string TravelReqID, string SfID, string sfStatus,
string recLoc, string manualReqID)
{
DataTable dt = null;
try
{
dt = SuperUserDAL.GetSFHotelDetailsByID(TravelReqID, SfID, sfStatus,
recLoc, manualReqID);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
