protected void BindTravelAgentRequests()
{
BLL_TRV_TravelRequest treq = new BLL_TRV_TravelRequest();
DataSet ds = new DataSet();
int rowcount = ucCustomPagerItems.isCountRecord;
string status = ViewState["Status"].ToString();
int VCode = 0;
if (!String.IsNullOrEmpty(cmbVessel.SelectedValue))
{
VCode = Convert.ToInt32(cmbVessel.SelectedValue);
}
ds = treq.Get_TravelRequests_Agent(Convert.ToInt32(Session["USERID"].ToString()),
Convert.ToInt32(cmbFleet.SelectedValue), VCode,
txtSectorFrom.Text, txtSectorTo.Text, txtTrvDateFrom.Text,
txtTrvDateTo.Text, txtPaxName.Text, status, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount, UDFLib.ConvertIntegerToNull(ddlVessel_Manager.SelectedValue), UDFLib.ConvertIntegerToNull(ddlQuotedBy.SelectedValue), UDFLib.ConvertIntegerToNull(ddlRequestedBy.SelectedValue));
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
rptParent.DataSource = ds;
rptParent.DataBind();
}
public string Get_ApprovalUserList(string RequestID, string UserID)
{
try
{
int RequestID_ = 0;
int UserID_ = 0;
if (RequestID != "")
{
RequestID_ = int.Parse(RequestID);
}
if (UserID != "")
{
UserID_ = int.Parse(UserID);
}
BLL_TRV_TravelRequest objTrv = new BLL_TRV_TravelRequest();
objTrv.RequestUserPreference(RequestID_, UserID_);
return("1");
}
catch
{
return("0");
}
}
protected void imgMarkTraveled_click(object sender, CommandEventArgs e)
{
BLL_TRV_TravelRequest treq = new BLL_TRV_TravelRequest();
int retval = treq.Update_Travel_Flag(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session["USERID"].ToString()));
BindTravelAgentRequests();
}
protected void rptChild_OnItemDataBound(object source, RepeaterItemEventArgs e)
{
BLL_TRV_TravelRequest objRequest = new BLL_TRV_TravelRequest();
try
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
System.Data.DataRow drv = (System.Data.DataRow)e.Item.DataItem;
string message = "";
message = objRequest.Get_Pax_Validation(Convert.ToInt32(drv["requestid"].ToString()), "DEL");
if (message != "OK")
{
((Image)e.Item.FindControl("btnDelete")).Attributes.Add("onclick", "alert('" + message + "'); return false;");
}
else
{
((Image)e.Item.FindControl("btnDelete")).Attributes.Add("onclick", "return confirm('This will DELETE the PAX from travel request. Do you want to proceed?');");
}
}
}
catch { }
finally { objRequest = null; }
}
protected void imgUserPrefc_Click(object s, EventArgs e)
{
int ReqID = 0;
if (s.GetType() == typeof(LinkButton))
{
Int32.TryParse(((LinkButton)s).CommandArgument, out ReqID);
}
else
{
Int32.TryParse(((ImageButton)s).CommandArgument, out ReqID);
}
btnSendUserPreference.CommandArgument = ReqID.ToString();
BLL_TRV_TravelRequest objtrvrerq = new BLL_TRV_TravelRequest();
string[] strUserListID = objtrvrerq.Get_User_Preference(ReqID).Split(',');
foreach (string ID in strUserListID)
{
ListItem lit = chklistUser.Items.FindByValue(ID);
if (lit != null)
{
lit.Selected = true;
}
}
updUserlist.Update();
string msgmodal = String.Format("showModal('dvUserList', false);");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "ApprmodalUser", msgmodal, true);
}
/// Agent will be able to paste the ticket if the status is Issued or Approved
/// Status can be checked in TRequest.Get_TravelStatus menthod
protected void btnPasteTicket_Click(object source, EventArgs e)
{
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
string status = "";
DataTable dtStatus = TRequest.Get_TravelStatus(UDFLib.ConvertToInteger(Request.QueryString["requestid"].ToString()));
if (dtStatus.Rows.Count > 0)
{
status = dtStatus.Rows[0]["currentStatus"].ToString();
if (status == "APPROVED" || status == "ISSUED")
{
string ticketno = ((TextBox)((GridViewRow)((Button)source).Parent.Parent).FindControl("txtETicketNumber")).Text;
if (ticketno.Trim().Length > 1)
{
hdf_TicketNumber.Value = ticketno;
hdf_PaxID.Value = ((Button)source).CommandArgument.Split(',')[0];
hdf_Flightid.Value = ((Button)source).CommandArgument.Split(',')[1];
String msgmodal = String.Format("showModal('dvCreateTicket');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "dvCreateTicket", msgmodal, true);
}
else
{
String msgmodal = String.Format("alert('Please enter ticket number !');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "vlddvCreateTicket", msgmodal, true);
}
}
}
}
protected void rptQuotes_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
if (e.CommandName.ToUpper() == "RESETQUOTE")
{
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
int MailID = TRequest.ResetQuotation(requestID, 0, Convert.ToInt32(e.CommandArgument));
TRequest = null;
string UploadFilePath = ConfigurationManager.AppSettings["TRV_UPLOAD_PATH"];
string URL = String.Format("window.open('../crew/EmailEditor.aspx?ID=+" + MailID.ToString() + @"&FILEPATH=" + UploadFilePath.Remove(UploadFilePath.Length - 1, 1).Replace(@"\", @"\\") + "');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "k" + MailID.ToString(), URL, true);
GetQuotationForEvaluation();
}
if (e.CommandName.ToUpper() == "PREFERENCE")
{
BLL_TRV_QuoteRequest Qr = new BLL_TRV_QuoteRequest();
Qr.UpdateUserPreference(requestID, Convert.ToInt32(e.CommandArgument), Convert.ToInt32(Session["USERID"]));
Qr = null;
GetTravelRequestDetails();
GetQuotationForEvaluation();
}
}
catch { }
}
protected void btnRollbackTR_Click(object s, EventArgs e)
{
BLL_TRV_TravelRequest objTr = new BLL_TRV_TravelRequest();
objTr.RollBack_TravelRequest(Convert.ToInt32(hdf_TRID_Rollback.Value), txtRemarkRollback.Text, Convert.ToInt32(Session["userid"]));
BindRequestList();
}
protected void btnSendUserPreference_Click(object s, EventArgs e)
{
int ReqID = 0;
string msgmodal = "";
if (Int32.TryParse(((Button)s).CommandArgument, out ReqID))
{
DataTable dtUser = new DataTable();
dtUser.Columns.Add("id");
DataRow dr;
foreach (ListItem lit in chklistUser.Items)
{
if (lit.Selected)
{
dr = dtUser.NewRow();
dr["id"] = lit.Value;
dtUser.Rows.Add(dr);
}
}
if (dtUser.Rows.Count > 0)
{
BLL_TRV_TravelRequest objtrvrerq = new BLL_TRV_TravelRequest();
objtrvrerq.RequestUserPreference(ReqID, Convert.ToInt32(Session["userid"].ToString()), dtUser);
msgmodal = String.Format("hideModal('dvUserList');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "closeUseronsave", msgmodal, true);
}
else
{
msgmodal = String.Format("alert('Please select user .');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "sendalUser", msgmodal, true);
}
}
}
protected void BindRequestList()
{
BLL_TRV_TravelRequest treq = new BLL_TRV_TravelRequest();
int rowcount = ucCustomPagerItems.isCountRecord;
string status = ViewState["Status"].ToString();
try
{
if ((status == "RFQ SENT" || status == "QUOTE RECEIVED") && !chkShowAllPendingApproval.Checked)
{
Approver_ID = UDFLib.ConvertToInteger(Session["userid"]);
}
DataSet ds = new DataSet();
ds = treq.GetRequestList(UDFLib.ConvertIntegerToNull(cmbFleet.SelectedValue), UDFLib.ConvertIntegerToNull(cmbVessel.SelectedValue), UDFLib.ConvertIntegerToNull(cmbSupplier.SelectedValue),
UDFLib.ConvertStringToNull(txtSectorFrom.Text), UDFLib.ConvertStringToNull(txtSectorTo.Text), UDFLib.ConvertStringToNull(txtTrvDateFrom.Text)
, UDFLib.ConvertStringToNull(txtTrvDateTo.Text), UDFLib.ConvertStringToNull(txtPaxName.Text), UDFLib.ConvertStringToNull(status), UDFLib.ConvertIntegerToNull(Approver_ID), ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
rptParent.DataSource = ds;
rptParent.DataBind();
}
catch { }
finally { treq = null; }
}
protected void btnApprove_Click(object s, EventArgs e)
{
BLL_TRV_TravelRequest obj = new BLL_TRV_TravelRequest();
obj.Upd_Approve_TravelPO_Mob(1);
gvQuotations.Visible = false;
string msgmodal = String.Format(" alert('Quotation has been approved successfully');window.open('','_self','');self.close();");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "ApprmodalFinalApproved", msgmodal, true);
}
private void BindFlightDetails()
{
BLL_TRV_TravelRequest objreq = new BLL_TRV_TravelRequest();
DataTable dtFlight = objreq.Get_RequestFlight(UDFLib.ConvertToInteger(Request.QueryString["Request_ID"]));
ViewState["SegmentDetails_Original"] = dtFlight;
GrdFlight.DataSource = dtFlight;
GrdFlight.DataBind();
}
protected void cmdGet_Click(object sender, EventArgs e)
{
BLL_TRV_TravelRequest objTrv = new BLL_TRV_TravelRequest();
DataTable dt = objTrv.Get_SearchCrew(0, 0, 0, UDFLib.ConvertToInteger(Session["USERID"].ToString()), txtSearch.Text).Tables[0];
GrdCrew.DataSource = dt;
GrdCrew.DataBind();
}
protected void btnReworkPIC_Click(object s, EventArgs e)
{
BLL_TRV_TravelRequest objTR = new BLL_TRV_TravelRequest();
int sts = objTR.UPD_Rework_TravelPIC(txtReworkRemark.Text, Convert.ToInt32(Request.QueryString["requestid"]), Convert.ToInt32(Session["userid"]));
if (sts > 0)
{
string msgmodal = String.Format("alert('Reworked successfully.');window.close();window.opener.location.reload();");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgrework", msgmodal, true);
}
}
public string CheckPersonTravelWithinFiveDays(string staffids)
{
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
DataTable dt = TRequest.GetPersonNameToTravelWithinfiveDays(staffids);
return(UDFLib.CreateHtmlTableFromDataTable(dt, new string[] { "Name", "Route", "Date/Time", "Travelled" }, new string[] { "NAME", "F_ROUTE", "DEPARTURE_DATE", "ISTRAVELLED" }, ""));
//if (dt.Rows.Count > 0)
// return dt.Rows[0][0].ToString();
//else
// return "";
}
protected void GetETickets()
{
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
try
{
grdTickets.DataSource = TRequest.Get_ETicket_By_RequestID(UDFLib.ConvertToInteger(Request.QueryString["requestid"].ToString()));
grdTickets.DataBind();
}
catch { }
finally { TRequest = null; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BLL_TRV_TravelRequest obj=new BLL_TRV_TravelRequest();
DataSet ds=obj.Get_QuoateForApprovals(Convert.ToInt32(Request.QueryString["RequestID"]));
gvQuotations.DataSource = ds.Tables[1];
gvQuotations.DataBind();
lblVesselName.Text = ds.Tables[0].Rows[0]["vesselName"].ToString();
lblPaxName.Text = ds.Tables[0].Rows[0]["Pax"].ToString();
}
}
protected void cmdSaveRemark_Click(object sender, EventArgs e)
{
BLL_TRV_TravelRequest tr = new BLL_TRV_TravelRequest();
try
{
tr.AddRemarks(requestID, txtRemarks.Text, Convert.ToInt32(Session["USERID"].ToString()), UserID);
grdRemarks.DataBind();
}
catch { }
finally { tr = null; }
}
protected void GetTravelReqeustByID()
{
BLL_TRV_TravelRequest treq = new BLL_TRV_TravelRequest();
try
{
ViewState["CurrentStatus"] = treq.GetCurrentStatus(RequestID, AgentID).ToString().ToUpper();
if (Convert.ToString(ViewState["CurrentStatus"]) == "CLOSED")
{
Response.Write("<center style='color:red;'>Travel request has been close...</center>");
Response.End();
}
if (Convert.ToString(ViewState["CurrentStatus"]) == "NA")
{
Response.Write("<center style='color:red;'>Unkonwn request status, please contact XT...</center>");
Response.End();
}
if (Convert.ToString(ViewState["CurrentStatus"]) == "QUOTE RECEIVED" || Convert.ToString(ViewState["CurrentStatus"]) == "NEW" || Convert.ToString(ViewState["CurrentStatus"]) == "RFQ SENT")
{
btnAddQuotation.Enabled = true;
}
else
{
btnAddQuotation.Enabled = false;
}
DataSet ds = new DataSet();
objRequestFlights.SelectParameters["RequestID"].DefaultValue = RequestID.ToString();
ds = treq.GetTravelRequestByID(RequestID, 1);
lblRequestorName.Text = ds.Tables[0].Rows[0]["created_By"].ToString();
lblRequestorEmail.Text = ds.Tables[0].Rows[0]["MailID"].ToString();
lblRequestorMobile.Text = ds.Tables[0].Rows[0]["Mobile_Number"].ToString();
hdf_CompanyName.Value = ds.Tables[0].Rows[0]["Company_Name"].ToString();
lblSeamanStatus.Text = ds.Tables[0].Rows[0]["isSeaman"].ToString() == "Y" ? "SEAMAN TICKET" : "NOT A SEAMAN TICKET";
lblSeamanStatus.ForeColor = ds.Tables[0].Rows[0]["isSeaman"].ToString() == "Y" ? System.Drawing.Color.Blue : System.Drawing.Color.Red;
hdfIsSeaman.Value = ds.Tables[0].Rows[0]["isSeaman"].ToString();
rptRequest.DataSource = ds;
rptRequest.DataBind();
rptPax.DataSource = ds.Tables[1];
rptPax.DataBind();
}
catch { }
finally { treq = null; }
}
public string GetQuoteAgent(int RequestId, int Quoted)
{
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
DataTable dt;
StringBuilder sTable = new StringBuilder();
try
{
dt = TRequest.GetQuoteAgents(RequestId, Quoted);
return(UDFLib.CreateHtmlTableFromDataTable(dt, new string[] { }, new string[] { "full_name" }, "Name :"));
}
catch { throw; }
finally { TRequest = null; }
}
public string GetPaxsName(int RequestId)
{
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
DataTable dt;
StringBuilder shtmlTable = new StringBuilder();
try
{
dt = TRequest.Get_Pax_Users(RequestId);
return(UDFLib.CreateHtmlTableFromDataTable(dt, new string[] { "Code", "Name", "Rank", "Passport No.", "Seaman Book No." }, new string[] { "Staff_Code", "name", "Rank_Short_Name", "Passport_Number", "Seaman_Book_Number" }, "Pax Details:"));
}
catch { throw; }
finally { TRequest = null; }
}
public string GetRoutInfo(int RequestId)
{
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
DataTable dt;
StringBuilder shtmlTable = new StringBuilder();
try
{
dt = TRequest.GetRoutInfo(RequestId);
return(UDFLib.CreateHtmlTableFromDataTable(dt, new string[] { "From", "To", "Name" }, new string[] { "RouteFrom", "RouteTo", "Name" }, "Route / Person Information:"));
}
catch { throw; }
finally { TRequest = null; }
}
protected void rptChild_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
int id;
if (e.CommandName.ToUpper() == "REMOVEPAX")
{
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
id = Convert.ToInt32(e.CommandArgument);
TRequest.RemovePaxFromTravelRequest(id, Convert.ToInt32(Session["USERID"].ToString()));
TRequest = null;
GetTravelRequestDetails();
}
}
catch { }
}
public DataSet GetRequestList(int vessel_id, string stage, string request_id, string pax_name, string airport, int agent_id)
{
try
{
BLL_TRV_TravelRequest objTrv = new BLL_TRV_TravelRequest();
DataSet ds = new DataSet();
int rowcount = 1;
ds = objTrv.GetRequestList(vessel_id, stage, request_id, pax_name, airport, agent_id, ref rowcount);
return(ds);
}
catch (Exception ex)
{
CustomSoapException(ex.GetType().Name, ex.Message);
return(null);
}
}
protected void GetTravelRequestDetails()
{
BLL_TRV_TravelRequest treq = new BLL_TRV_TravelRequest();
try
{
DataSet ds = new DataSet();
ds = treq.GetTravelRequestByID(requestID, 0);
lblSeamanStatus.Text = ds.Tables[0].Rows[0]["isSeaman"].ToString() == "Y" ? "SEAMAN TICKET" : "NOT A SEAMAN TICKET";
lblSeamanStatus.ForeColor = ds.Tables[0].Rows[0]["isSeaman"].ToString() == "Y" ? System.Drawing.Color.Blue : System.Drawing.Color.Red;
rptParent.DataSource = ds;
rptParent.DataBind();
}
catch { }
finally { treq = null; }
}
protected void rptChild_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int id;
try
{
if (e.CommandName == "removepax")
{
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
id = Convert.ToInt32(e.CommandArgument);
TRequest.RemovePaxFromTravelRequest(id, Convert.ToInt32(Session["USERID"].ToString()));
TRequest = null;
BindRequest();
}
}
catch { }
}
protected void btnSendForApproval_Click(object s, EventArgs e)
{
BLL_TRV_QuoteRequest QR = new BLL_TRV_QuoteRequest();
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
BLL_Infra_UserCredentials objuser = new BLL_Infra_UserCredentials();
DataTable dtuser = objuser.Get_UserDetails(Int32.Parse(lstUserList.SelectedValue));
DataTable dtCurrentuser = objuser.Get_UserDetails(Convert.ToInt32(Session["userid"]));
QR.Insert_Approval_Entry(Convert.ToInt32(Session["USERID"].ToString()),
Int32.Parse(lstUserList.SelectedValue),
0,
Convert.ToInt32(Request.QueryString["requestid"].ToString()), txtRemark.Text, "");
string msgmodal = String.Format("alert('Sent successfully to selected approver.');window.close();window.opener.location.reload();");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Apprmodal", msgmodal, true);
}
public List <tktByVessel> AsyncGet_tktByVessel()
{
BLL_TRV_TravelRequest objtr = new BLL_TRV_TravelRequest();
DataTable dt_tktByVessel = objtr.Get_tktByVessel();
List <tktByVessel> dataList = new List <tktByVessel>();
foreach (DataRow dtrow in dt_tktByVessel.Rows)
{
tktByVessel details = new tktByVessel();
details.Vessel_Name = dtrow[0].ToString();
details.Count = UDFLib.ConvertIntegerToNull(dtrow[2]);
dataList.Add(details);
}
return(dataList);
}
public List <TotalAmount> AsyncGet_TotalAmount()
{
BLL_TRV_TravelRequest objtr = new BLL_TRV_TravelRequest();
DataTable dt_TotalAmount = objtr.Get_TotalAmount();
List <TotalAmount> dataList = new List <TotalAmount>();
foreach (DataRow dtrow in dt_TotalAmount.Rows)
{
TotalAmount details = new TotalAmount();
details.MonthName = dtrow[1].ToString();
details.totalAmount = UDFLib.ConvertDecimalToNull(dtrow[4]);
dataList.Add(details);
}
return(dataList);
}
protected void GetETickets()
{
BLL_TRV_TravelRequest TRequest = new BLL_TRV_TravelRequest();
try
{
DataTable dt = TRequest.Get_ETicket_By_RequestID(UDFLib.ConvertToInteger(Request.QueryString["requestid"].ToString()));
grdTickets.DataSource = dt;
grdTickets.DataBind();
if (dt.Rows.Count == 0)
{
Response.Write("<br><br><center><h2>E-Ticket is not yet issued for the travel request</h2></center>");
}
}
catch { }
finally { TRequest = null; }
}
