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