/// <summary>
/// Get Travel Request by RequestID
/// </summary>
/// <param name="RequestID"></param>
/// <returns>Dataset filled with 1 table having travel request details</returns>
public DataSet GetTravelRequestByID(int RequestID, int AgentID)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.GET_TravelRequest_ByID(RequestID, AgentID)); }
catch { throw; }
}
/// <summary>
/// return list of fleets
/// </summary>
/// <returns>Dataset with list of fleets</returns>
public DataSet GetFleetList()
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.GetFleetList()); }
catch { throw; }
}
/// <summary>
/// Get all travel Requests in a hyrarichel manner with request at top and pax underneath
/// </summary>
/// <returns>Dataset with 2 tables. Parent & child. Parent Table = Request, Child table = Pax</returns>
public DataSet GetRequestList()
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.GET_TravelRequest()); }
catch { throw; }
}
/// <summary>
/// Remove Pax from an exisiting request.
/// </summary>
/// <param name="RequestID">Exisitng request id</param>
/// <param name="StaffID">Staffid to be added to the list</param>
/// <param name="RemovedBy">Person name adding pax to the request</param>
/// <returns>true on success, false otherwise</returns>
public Boolean RemovePaxFromTravelRequest(int RequestPaxId, int Deleted_By)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Remove_PAX_From_TravelRequest(RequestPaxId, Deleted_By)); }
catch { throw; }
}
/// <summary>
/// Add Flights to the existing request
/// </summary>
/// <param name="RequestID">Existing request id</param>
/// <param name="FlightDetail">object wrapped in trv_request class</param>
/// <returns>true on success, false otherwise</returns>
public Boolean AddFlightToTravelRequest(int RequestID, TRV_Request FlightDetail)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.ADD_FLIGHT_TO_TravelRequest(RequestID, FlightDetail)); }
catch { throw; }
}
/// <summary>
/// Update eTicketNumber to the travel request flight
/// </summary>
/// <param name="id">flight id for which eTicketNumber has to be updated</param>
/// <param name="eTicketNumber">eTicketNumber</param>
/// <returns>true on success, false otherwise</returns>
public Boolean UpdateETicketNumber(int RequestID, int Flightid, string eTicketNumber, int updated_by, int PaxID)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Update_eTicketNumber(RequestID, Flightid, eTicketNumber, updated_by, PaxID)); }
catch { throw; }
}
/// <summary>
/// returns list of vessels
/// </summary>
/// <param name="FleetCode">fleetcode for which vessel list is required.</param>
/// <returns>Dataset as list of vessels</returns>
public DataSet GetVesselList(int @FleetCode)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.GetVesselList(FleetCode)); }
catch { throw; }
}
/// <summary>
/// Add Flights to the existing request
/// </summary>
/// <param name="RequestID">Existing request id</param>
/// <param name="FlightDetail">object wrapped in trv_request class</param>
/// <returns>true on success, false otherwise</returns>
public DataSet GetFlightByRequestID(int RequestID)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Get_Fligts_By_RequestID(RequestID)); }
catch { throw; }
}
/// <summary>
/// Create a new travel request
/// </summary>
/// <param name="newRequest">object as new request with all properties set</param>
/// <returns>New created request id</returns>
public int CreateTravelRequest(TRV_Request newRequest, int Vessel_ID = 0, int ReqID = 0, string Change_Remark = "")
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.ADD_TravelRequest(newRequest, Vessel_ID, ReqID, Change_Remark)); }
catch { throw; }
}
/// <summary>
/// Add Remarks in travel request
/// </summary>
/// <param name="requestid">Request id to add remarks</param>
/// <param name="remarks">remarks to be added</param>
/// <param name="remarkby">username adding remarks</param>
/// <param name="agentid">agent id if remark is added by agent/supplier</param>
/// <returns></returns>
public Boolean AddRemarks(int requestid, string remarks, int remarkby, int agentid, string RemarkAgentIDs = "")
{
DataTable dtAgentIDs = new DataTable();
dtAgentIDs.Columns.Add("TAID");
DataRow drID;
foreach (string sid in RemarkAgentIDs.Split(','))
{
if (sid.Trim() != "")
{
drID = dtAgentIDs.NewRow();
drID["TAID"] = sid;
dtAgentIDs.Rows.Add(drID);
}
}
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Add_Remarks(requestid, remarks, remarkby, agentid, dtAgentIDs)); }
catch { throw; }
finally { TRequest = null; }
}
/// <summary>
/// Get Current status of request
/// </summary>
/// <param name="RequestID">Request id for which status is seed</param>
/// <param name="AgentID">Agent id if status is request at agent level, 0 otherwise</param>
/// <returns>string as result</returns>
public string GetCurrentStatus(int RequestID, int AgentID)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Get_Current_Status(RequestID, AgentID)); }
catch { throw; }
}
/// <summary>
/// Save email in database
/// </summary>
/// <param name="subject">suject of email</param>
/// <param name="mailTO">mail to list, separated by commas</param>
/// <param name="MailCC">mail to cc list, separated by commas</param>
/// <param name="body">mail body</param>
/// <param name="userid">user id sending this email</param>
/// <returns>int, newly created email record id in database</returns>
public int SaveEmail(string subject, string mailTO, string MailCC, string body, int userid)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Save_Email(subject, mailTO, MailCC, body, userid)); }
catch { throw; }
}
/// <summary>
/// Get Agetn list to whom RFQ has been sent
/// </summary>
/// <param name="RequestID">Request ID</param>
/// <returns>Agent list as datatable</returns>
public DataTable GetQuoteAgents(int RequestID, int Quoted)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Get_Quote_Agent(RequestID, Quoted)); }
catch { throw; }
finally { TRequest = null; }
}
public int Update_Travel_Flag(int AgentReqstID, int Userid, int RequsetID = 0)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Update_Travel_Flag(AgentReqstID, Userid, RequsetID)); }
catch { throw; }
finally { TRequest = null; }
}
public int ResetQuotation(int RequestID, int AgentID, int QuoteID)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Reset_Quotations(RequestID, AgentID, QuoteID)); }
catch { throw; }
finally { TRequest = null; }
}
/// <summary>
/// Cancels the travel request
/// </summary>
/// <param name="RequestID">Requestid to be cancelled</param>
/// <returns>true on success, false otherwise</returns>
public Boolean CancelRequest(int RequestID, int Deleted_By)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Cancel_TravelRequest(RequestID, Deleted_By)); }
catch { throw; }
finally { TRequest = null; }
}
/// <summary>
/// Put the request for Refund.
/// </summary>
/// <param name="RequestID">request id to put for refund</param>
/// <returns>true on successfull</returns>
public Boolean RefundRequest(int RequestID, int Created_By, string Refund_Remarks)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Refund_Request_DL(RequestID, Created_By, Refund_Remarks)); }
catch { throw; }
finally { TRequest = null; }
}
public DataTable GetRoutInfo(int RequestID)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.GetRoutInfo(RequestID)); }
catch { throw; }
finally { TRequest = null; }
}
public DataSet Get_Request_Pax(int RequestID)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Get_Request_Pax_DL(RequestID)); }
catch { throw; }
finally { TRequest = null; }
}
public string Get_Pax_Validation(int RequestID, string Action)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Get_Pax_Validation_DL(RequestID, Action)); }
catch { throw; }
finally { TRequest = null; }
}
public DataTable Get_ETicket_By_RequestID(int RequestID)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Get_ETicket_By_RequestID_DL(RequestID)); }
catch { throw; }
finally { TRequest = null; }
}
/// <summary>
///
/// </summary>
/// <param name="crewid"></param>
/// <param name="userid"></param>
/// <param name="Search_Text"></param>
/// <returns></returns>
public DataSet Get_SearchCrew(int crewid, int EventID, int VoyageID, int userid, string Search_Text)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Get_SearchCrew_DL(crewid, EventID, VoyageID, userid, Search_Text)); }
catch { throw; }
finally { TRequest = null; }
}
/// <summary>
/// Get crew list by event id
/// </summary>
/// <param name="VoyageID">voyage id for which crew list is desired</param>
/// <returns>Dataset containing the list of crew</returns>
public DataSet GetCrewListByVoyageID(int EventID)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.Get_CrewList_By_EventID(EventID)); }
catch { throw; }
finally { TRequest = null; }
}
/// <summary>
/// Add Pax to an exisiting request.
/// </summary>
/// <param name="RequestID">Exisitng request id</param>
/// <param name="StaffID">Staffid to be added to the list</param>
/// <param name="CreatedBy">Person name adding pax to the request</param>
/// <returns>true on success, false otherwise</returns>
public Boolean AddPaxToTravelRequest(int RequestID, int StaffID, int CreatedBy, int VoyageID, int EventID)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try
{
return(TRequest.ADD_PAX_IN_TravelRequest(RequestID, StaffID, CreatedBy, VoyageID, EventID));
}
catch { throw; }
}
public DataSet GetRequestList(int vessel_id, string stage, string request_id, string pax_name, string airport, int agentid, ref int rowcount)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try
{
//return TRequest.GET_TravelRequest();
return(TRequest.Search_Travel_Request(vessel_id, stage, request_id, pax_name, airport, agentid, ref rowcount));
}
catch { throw; }
}
public string RequestUserPreference(int RequestID, int UserID, DataTable dtUser)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try
{
return(TRequest.RequestUserPreference_DL(RequestID, UserID, dtUser));
}
catch { throw; }
finally { TRequest = null; }
}
public DataTable GetPersonNameToTravelWithinfiveDays(string staffid)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try
{
return(TRequest.GetPersonNameToTravelWithinfiveDays(staffid));
}
catch { throw; }
finally { TRequest = null; }
}
public DataSet Get_TravelRequests_Agent(int UserID, int fleetid, int vesselid, string travelFrom,
string travelTo, string dateFrom, string dateTo, string name, string status, int?pagenumber, int?pagesize, ref int isfetchcount, int?AppCompanyID, int?QuotedBY = null, int?RequestedBy = null)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try
{
//return TRequest.GET_TravelRequest_By_AgentID(AgentID);
return(TRequest.Get_TravelRequests_Agent_DL(fleetid, vesselid, UserID, travelFrom, travelTo, dateFrom, dateTo, name, status, pagenumber, pagesize, ref isfetchcount, AppCompanyID, QuotedBY, RequestedBy));
}
catch { throw; }
}
public DataSet GetRequestList(int?fleetid, int?vesselid, int?agentid, string travelFrom,
string travelTo, string dateFrom, string dateTo, string name, string status, int?Approver_ID, int?pagenumber, int?pagesize, ref int isfetchcount)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try
{
//return TRequest.GET_TravelRequest();
return(TRequest.Search_Travel_Request(fleetid, vesselid, agentid, travelFrom, travelTo, dateFrom, dateTo, name, status, Approver_ID, pagenumber, pagesize, ref isfetchcount));
}
catch { throw; }
}
/// <summary>
/// Get Remarks
/// </summary>
/// <param name="requestid">Requestid to get the remarks for</param>
/// <param name="agentid">AgentID </param>
/// <returns></returns>
public DataSet GetRemarks(int requestid, int agentid)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
DataSet ds = new DataSet();
try
{
ds = TRequest.Get_Remarks(requestid, agentid);
return(ds);
}
catch { throw; }
finally { TRequest = null; }
}