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; } }