/// <summary>
/// Date Modified: 26/03/2013
/// Modified By: Marco Abejar
/// (description) Save SF Hotel Request
/// -------------------------------------------
/// Date Modified: 30/May/2013
/// Modified By: Josephine Gad
/// (description) Add Shuttle, MealLunchDinner, Tax Bit and Tax Percent
/// Add fields for audit trail use
/// -------------------------------------------
/// </summary>
public string SeafarerSaveRequestHotelOverflow(string RequestNo, string SfID, string LastName, string FirstName, string Gender, string RegionID,
string PortID, string AirportID, string HotelID, string CheckinDate, string CheckoutDate, string NoNites, string RoomType,
bool MealBreakfast, bool MealLunch, bool MealDinner, bool MealLunchDinner, bool WithShuttle,
string RankID, string VesselInt, string CostCenter, string Comments, string SfStatus, string TimeIn, string TimeOut,
string RoomAmount, bool IsRoomTax, string RoomTaxPercent, string UserID, string TrID, string Currency,
string strLogDescription, string strFunction, string strPageName, DateTime DateGMT, DateTime CreatedDate,
bool IsAir, int SequentNo, long IDBig, int BrandID, double MealVoucher, double ConfirmRate,
double ContractedRate, string EmailTO, string HotelCity)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.SeafarerSaveRequestHotelOverflow(RequestNo, SfID, LastName, FirstName, Gender, RegionID,
PortID, AirportID, HotelID, CheckinDate, CheckoutDate, NoNites, RoomType,
MealBreakfast, MealLunch, MealDinner, MealLunchDinner, WithShuttle,
RankID, VesselInt, CostCenter, Comments, SfStatus, TimeIn, TimeOut,
RoomAmount, IsRoomTax, RoomTaxPercent, UserID, TrID, Currency,
strLogDescription, strFunction, strPageName, DateGMT, CreatedDate, IsAir, SequentNo, IDBig
, BrandID, MealVoucher, ConfirmRate, ContractedRate, EmailTO, HotelCity));
}
catch (Exception ex)
{
throw ex;
}
}
public string SaveCancelPortAgentHotelRequest(short LoadType, long TransHotelID, string UserID, string Reciever
, string Recipient, string BlindCopy, string comment)
{
CrewAssistDAL DAL = new CrewAssistDAL();
return(DAL.SaveCancelPortAgentHotelRequest(LoadType, TransHotelID, UserID, Reciever, Recipient, BlindCopy, comment));
}
public List <CrewAssisRemark> DeleteCrewAssistRemarks(long RemarkID, long TravelReqIdInt,
string RamarksVarchar, string UserID)
{
CrewAssistDAL DAL = new CrewAssistDAL();
return(DAL.DeleteCrewAssistRemarks(RemarkID, TravelReqIdInt, RamarksVarchar, UserID));
}
public List <CrewAssisRemark> InsertCrewAssistRemark(long RemarkID, long TravelReqIdInt
, string RamarksVarchar, string UserID, long IDBigInt, string Role, short ReqSource
, long SeafarerID, int RemarkTypeID, short RemarkStatusID, string SummaryCall
, int RemarkRequestorID, DateTime TransactionDate, DateTime TransactionTime
, string PortCode, bool IR)
{
CrewAssistDAL DAL = new CrewAssistDAL();
return(DAL.InsertCrewAssistRemark(RemarkID, TravelReqIdInt, RamarksVarchar, UserID, IDBigInt, Role, ReqSource, SeafarerID, RemarkTypeID, RemarkStatusID, SummaryCall, RemarkRequestorID, TransactionDate, TransactionTime, PortCode, IR));
}
/// <summary>
/// Date Modified: 27/03/2013
/// Modified By: Muhallidin G Wali
/// (description) Save SF Companion Hotel Request
/// </summary>
public void SeafarerSaveComapnionRequest(string RequestDetailID, string RequestID, string LastName, string FirstName, string Relationship, string Gender, string UserID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
CA.SeafarerSaveComapnionRequest(RequestDetailID, RequestID, LastName, FirstName, Relationship, Gender, UserID);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Modified: 26/03/2013
/// Modified By: Muhallidin G Wali
/// (description) Send SF Companion Hotel Request
/// </summary>
public void SendCompanionHotelTransaction(long RequestIDInt, string UserID, string Reciever, string Recipient, string BlindCopy, bool IsOverFlowRequest)
{
try
{
CrewAssistDAL DAL = new CrewAssistDAL();
DAL.SendCompanionHotelTransaction(RequestIDInt, UserID, Reciever, Recipient, BlindCopy, IsOverFlowRequest);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Author: Muhallidin G Wali
/// DateCreated: 20/Jun/2014
/// Description: check overflow Hotel
/// ----------------------------------------------------------
/// <param name="sExceptionID"></param>
/// <param name="bIsRemove"></param>
public string GetHotelTransactionOverFlow(long SeafarerID, DateTime CheckInDate, DateTime CheckoutDate, long IDBigint, short SeqNo, long TravelReqId, int BranchID, string PortCode, long TransHotelID)
{
try
{
CrewAssistDAL DAL = new CrewAssistDAL();
return(DAL.GetHotelTransactionOverFlow(SeafarerID, CheckInDate, CheckoutDate, IDBigint, SeqNo, TravelReqId, BranchID, PortCode, TransHotelID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Modified: 10/10/2013
/// Modified By: Muhallidin G Wali
/// (description) Get Transportation Rout
/// </summary>
public List <CrewAssistGenericClass> GetComboGeneric(short LoadType, string PortCode, string ArrCode, int PortID, string storeproc)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetComboGeneric(LoadType, PortCode, ArrCode, PortID, storeproc));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Modified: 10/10/2013
/// Modified By: Muhallidin G Wali
/// (description) Insert the Inse
/// </summary>
public string SaveSafeguardRequest(List <CrewAssistSafeguardRequest> list)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.SaveSafeguardRequest(list));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 26/09/2011
/// Created By: Muhallidin G Wali
/// (description) Select Hotel, Port, ExpendType
/// ----------------------------------------------
/// </summary>\\\\\\\\
/// <param name="userString"></param>
/// <param name="cityString"></param>
/// <returns></returns>
public List <CrewAssistTranspo> getVehicleRequest(short LoadType, long VehicleVendorID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.getVehicleRequest(LoadType, VehicleVendorID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Modified: 26/03/2013
/// Modified By: Muhallidin G Wali
/// (description) Save SF Companion Hotel Request
/// </summary>
public List <CrewAssistTranspo> SendVehicleTransactionRequest(string RequestID, string UserID, string ContactName, string ContactNo, string Description, string Function, string FileName)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.SendVehicleTransactionRequest(RequestID, UserID, ContactName, ContactNo, Description, Function, FileName));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 26/09/2011
/// Created By: Muhallidin G Wali
/// (description) Select Hotel, Port, ExpendType
/// ----------------------------------------------
/// </summary>
/// <param name="userString"></param>
/// <param name="cityString"></param>
/// <returns></returns>
public List <VehicleVendor> GetVendorVehicleDetail(short LoadType, long VehicleVendorID, string PortCode)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetVendorVehicleDetail(LoadType, VehicleVendorID, PortCode));
}
catch (Exception ex)
{
throw ex;
}
}
public List <SeafarerDetailHeader> SeafarerDetailList(short loadtype, long SeafarerID, string UserID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.SeafarerDetailTable(loadtype, SeafarerID, UserID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Modified: 26/03/2013
/// Modified By: Muhallidin G Wali
/// (description) Save SF Companion Hotel Request
/// </summary>
public List <CopyEmail> GetTblEmail(Int16 LoadType, Int16 EmailTypeID, long EmailHotelID, long EmailCrewAssistID, long EmailSchedulerID, long EmailShipID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetTblEmail(LoadType, EmailTypeID, EmailHotelID, EmailCrewAssistID, EmailSchedulerID, EmailShipID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Author: Muhallidin G Wali
/// Create date: 09/26/2013
/// Description: Add Copy Email
/// </summary>
public void TblEmail(int EmailTypeID, string EmailType, string Email, long EmailFromID, string UserID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
CA.TblEmail(EmailTypeID, EmailType, Email, EmailFromID, UserID);
}
catch (Exception ex)
{
throw ex;
}
}
public List <crewassistrequest> GetHotelRequest(Int16 LoadType, long RequestID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetHotelRequest(LoadType, RequestID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 28/10/2013
/// Modified By: Muhallidin G Wali
/// (description) Select Vendor Safeguard
/// </summary>
public List <CrewAssistSafeguardVendor> GetVendorSafeguard(short Loadtype, long SafeguardVendorIDInt)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetVendorSafeguard(Loadtype, SafeguardVendorIDInt));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 26/09/2011
/// Created By: Muhallidin G Wali
/// (description) Gett Visa nationality
/// ----------------------------------------------
/// </summary>
/// <param name="userString"></param>
/// <param name="cityString"></param>
/// <returns></returns>
public string GetNationalityVisa(short LoadType, int NationalityIDInt, int VisitVisaIDInt)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetNationalityVisa(LoadType, NationalityIDInt, VisitVisaIDInt));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Modified: 10/10/2013
/// Modified By: Muhallidin G Wali
/// (description) Get Transportation Rout
/// </summary>
public List <ComboGenericClass> GetTransportationRoute(string LoadType, long TransportID, long TravelRequestID, long RecLocID, int SeqNo, string PortCode, int PortID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetTransportationRoute(LoadType, TransportID, TravelRequestID, RecLocID, SeqNo, PortCode, PortID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 17/10/2013
/// Created By: Muhallidin G Wali
/// (description) Select Airport, Seaport
/// ----------------------------------------------
/// </summary>
/// <param name="userString"></param>
/// <param name="cityString"></param>
/// <returns></returns>
public List <CrewAssitPortList> GetPort(short LoadType, string userString)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetPort(LoadType, userString));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 19/01/2012
/// Created By: Muhallidin G Wali
/// description Get hotel , Seaport and ExpendType List
/// ----------------------------------------------
/// </summary>
/// <param name="userString"></param>
/// <param name="cityString"></param>
/// <returns></returns>
public List <CrewAssistHotelList> GetGetHotelPortExpendTypeList(short lodType, string userString, string regionString, string portString)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetGetHotelPortExpendTypeList(lodType, userString, regionString, portString));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 17/10/2013
/// Created By: Muhallidin G Wali
/// (description) Select Airport, Seaport
/// ----------------------------------------------
/// </summary>
/// <param name="userString"></param>
/// <param name="cityString"></param>
/// <returns></returns>
public List <CrewAssitPortListClass> GetPort(string userString)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetPort(userString));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Modified: 10/10/2013
/// Modified By: Muhallidin G Wali
/// (description) Get the Crew assist Meet and greet
/// </summary>
public List <MeetAndGreetGenericClass> GetMeetAndGreetAirport(short LoadType, int MeetAndGreetID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetMeetAndGreetAirport(LoadType, MeetAndGreetID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Modified: 10/10/2013
/// Modified By: Muhallidin G Wali
/// (description) Insert the Crew assist Meet and greet Request
/// </summary>
public string SaveMeetAndGreetRequest(List <CrewAssistMeetAndGreet> list)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.SaveMeetAndGreetRequest(list));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Author: Muhallidin G Wali
/// DateCreated: 13/Mar/2014
/// Description: Get Vehicle Route
/// ----------------------------------------------------------
/// <param name="sExceptionID"></param>
/// <param name="bIsRemove"></param>
public string GetVehicleRoute(short LoadType, long TravelReqID, long IDBigInt, int SeqNo, string Status, string Route, string PortCode, int RouteID)
{
try
{
CrewAssistDAL DAL = new CrewAssistDAL();
return(DAL.GetVehicleRoute(LoadType, TravelReqID, IDBigInt, SeqNo, Status, Route, PortCode, RouteID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Create: 22/10/2013
/// Create By: Muhallidin G Wali
/// (description) get port agent detail
/// </summary>
public List <CrewAssistVendorPortAgent> GetVendorPortAgent(short LoadType, long PortAgentVendorID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.GetVendorPortAgent(LoadType, PortAgentVendorID));
}
catch (Exception ex)
{
throw ex;
}
}
public List <SeafarerDetailHeader> GetAllPastTravelRequest(short loadtype, long SeafarerID, string UserID)
{
try
{
CrewAssistDAL DAL = new CrewAssistDAL();
return(DAL.GetAllPastTravelRequest(loadtype, SeafarerID, UserID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Modified: 28/10/2013
/// Modified By: Muhallidin G Wali
/// (description) Save the Port agent Request to table PortAgentTransaction
/// </summary>
public List <CrewAssistPortAgentRequest> SendPortAgentTransactionRequest(long MeetAndGreetID, string UserID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.SendPortAgentTransactionRequest(MeetAndGreetID, UserID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Created By: Muhallidin G Wali
/// Date Modified: 10/24/2014
/// (description) Insert Air Status.
/// </summary>
public List <SeafarerDetailHeader> InsertAirTransactionStatus(long TravelRequestID, long IdBigint, int SeqNo, int StatusID, string OldStatus, string UserID)
{
try
{
CrewAssistDAL DAL = new CrewAssistDAL();
return(DAL.InsertAirTransactionStatus(TravelRequestID, IdBigint, SeqNo, StatusID, OldStatus, UserID));
}
catch (Exception ex)
{
throw ex;
}
}
public List <SeafarerList> SeafarerList(short loadtype, string Seafarer, string userID)
{
try
{
CrewAssistDAL CA = new CrewAssistDAL();
return(CA.SeafarerList(loadtype, Seafarer, userID));
}
catch (Exception ex)
{
throw ex;
}
}
