protected void imgbtndeleteFlight_Click(object s, EventArgs e) { GridViewRow grdlt = (GridViewRow)(s as ImageButton).Parent.Parent; DataTable dtFlight = CreateDtFlight(); DataRow dr = null; if (GrdFlight.Rows.Count > 1) { foreach (GridViewRow gr in GrdFlight.Rows) { if (grdlt.RowIndex != gr.RowIndex) { UserControl_ctlAirPortList txtFrom1 = (gr.FindControl("txtFrom1") as UserControl_ctlAirPortList); UserControl_ctlAirPortList txtTo1 = (gr.FindControl("txtTo1") as UserControl_ctlAirPortList); dr = dtFlight.NewRow(); dr["travelOrigin"] = txtFrom1.Text; dr["travelDestination"] = txtTo1.Text; dr["departureDate"] = (gr.FindControl("txtDepDate1") as TextBox).Text; dr["PrefDephours"] = (gr.FindControl("cmbDepHours1") as DropDownList).SelectedValue; dr["PrefDepmins"] = (gr.FindControl("cmbDepMins1") as DropDownList).SelectedValue; dtFlight.Rows.Add(dr); } GrdFlight.DataSource = dtFlight; GrdFlight.DataBind(); } } }
protected void Bind_Quote_Details() { BLL_TRV_QuoteRequest objRFQ = new BLL_TRV_QuoteRequest(); DataSet dsQuoteDetails = objRFQ.Get_Quotation_Details(Convert.ToInt32(Request.QueryString["RequestID"]), Convert.ToInt32(Request.QueryString["QuoteID"])); if (dsQuoteDetails.Tables.Count > 1) { dsQuoteDetails.Tables[1].PrimaryKey = new DataColumn[] { dsQuoteDetails.Tables[1].Columns["id"] }; GrdFlight.DataSource = dsQuoteDetails.Tables[1]; GrdFlight.DataBind(); } if (dsQuoteDetails.Tables[0].Rows.Count > 0) { txtGDSLocator.Text = dsQuoteDetails.Tables[0].Rows[0]["GDSLocator"].ToString(); txtTicketDeadline.Text = dsQuoteDetails.Tables[0].Rows[0]["TicketingDeadline"].ToString(); cmbHours.Items.FindByValue(dsQuoteDetails.Tables[0].Rows[0]["TimeHours"].ToString()).Selected = true; cmbMins.Items.FindByValue(dsQuoteDetails.Tables[0].Rows[0]["TimeMins"].ToString()).Selected = true; txtFare.Text = dsQuoteDetails.Tables[0].Rows[0]["Fare"].ToString(); txtTax.Text = dsQuoteDetails.Tables[0].Rows[0]["Tax"].ToString(); txtPNRText.Text = dsQuoteDetails.Tables[0].Rows[0]["Remarks"].ToString(); cmbCurrency.Items.FindByValue(dsQuoteDetails.Tables[0].Rows[0]["currency"].ToString()).Selected = true; txtbaggageallowances.Text = dsQuoteDetails.Tables[0].Rows[0]["Baggage_Charge"].ToString(); txtCancellationCharge.Text = dsQuoteDetails.Tables[0].Rows[0]["Cancellation_Charge"].ToString(); txtDateChangeAllow.Text = dsQuoteDetails.Tables[0].Rows[0]["Date_Change_Charge"].ToString(); } }
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 GrdFlight_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { if (GrdFlight.Rows.Count > 1) { DataTable dtFlight = CreateDtFlight();; DataRow dr = null; foreach (GridViewRow grFlt in GrdFlight.Rows) { dr = dtFlight.NewRow(); dr["ID"] = GrdFlight.DataKeys[grFlt.RowIndex].Values["ID"].ToString(); dr["Flight"] = (grFlt.FindControl("txtFlight") as TextBox).Text; dr["From"] = (grFlt.FindControl("txtFrom") as TextBox).Text; dr["To"] = (grFlt.FindControl("txtTo") as TextBox).Text; dr["FlightStatus"] = (grFlt.FindControl("cmbFlightStatus") as DropDownList).SelectedValue; dr["DepartureDate"] = (grFlt.FindControl("txtDeparureDate") as TextBox).Text; dr["DepHour"] = (grFlt.FindControl("cmbDepHours") as DropDownList).SelectedItem.Value; dr["DepMin"] = (grFlt.FindControl("cmbDepMins") as DropDownList).SelectedItem.Value; dr["ArrivalDate"] = (grFlt.FindControl("txtArrivalDate") as TextBox).Text; dr["ArrHour"] = (grFlt.FindControl("cmbArrHours") as DropDownList).SelectedItem.Value; dr["ArrMin"] = (grFlt.FindControl("cmbArrMins") as DropDownList).SelectedItem.Value; dr["Locator"] = (grFlt.FindControl("txtAirlineLocator") as TextBox).Text; dr["Remarks"] = (grFlt.FindControl("txtFlightRemark") as TextBox).Text; dr["TravelClass"] = (grFlt.FindControl("cmbTravelClass") as DropDownList).SelectedValue; dtFlight.Rows.Add(dr); } dr = dtFlight.Rows.Find(e.Keys["ID"].ToString()); if (dr != null) { if (!dr["id"].ToString().Contains("-")) { BLL_TRV_QuoteRequest qr = new BLL_TRV_QuoteRequest(); qr.DeleteQuoteFlight(Convert.ToInt32(dr["id"]), Convert.ToInt32(Session["USERID"].ToString())); } dtFlight.Rows.Remove(dr); } GrdFlight.DataSource = dtFlight; GrdFlight.DataBind(); } //ViewState["DataTable"] = dtFlight; } catch { } }
private void AddToDataTable() { try { DataTable dtFlight = CreateDtFlight(); DataRow dr = null; foreach (GridViewRow grFlt in GrdFlight.Rows) { dr = dtFlight.NewRow(); dr["ID"] = GrdFlight.DataKeys[grFlt.RowIndex].Values["ID"].ToString(); dr["Flight"] = (grFlt.FindControl("txtFlight") as TextBox).Text; dr["From"] = (grFlt.FindControl("txtFrom") as TextBox).Text; dr["To"] = (grFlt.FindControl("txtTo") as TextBox).Text; dr["FlightStatus"] = (grFlt.FindControl("cmbFlightStatus") as DropDownList).SelectedValue; dr["DepartureDate"] = (grFlt.FindControl("txtDeparureDate") as TextBox).Text; dr["DepHour"] = (grFlt.FindControl("cmbDepHours") as DropDownList).SelectedItem.Value; dr["DepMin"] = (grFlt.FindControl("cmbDepMins") as DropDownList).SelectedItem.Value; dr["ArrivalDate"] = (grFlt.FindControl("txtArrivalDate") as TextBox).Text; dr["ArrHour"] = (grFlt.FindControl("cmbArrHours") as DropDownList).SelectedItem.Value; dr["ArrMin"] = (grFlt.FindControl("cmbArrMins") as DropDownList).SelectedItem.Value; dr["Locator"] = (grFlt.FindControl("txtAirlineLocator") as TextBox).Text; dr["Remarks"] = (grFlt.FindControl("txtFlightRemark") as TextBox).Text; dr["TravelClass"] = (grFlt.FindControl("cmbTravelClass") as DropDownList).SelectedValue; dtFlight.Rows.Add(dr); } dr = dtFlight.NewRow(); dr["ID"] = System.Guid.NewGuid().ToString(); dr["TravelClass"] = "Economy"; dr["FlightStatus"] = "Confirm"; dr["ArrHour"] = "0"; dr["ArrMin"] = "0"; dr["DepHour"] = "0"; dr["DepMin"] = "0"; dtFlight.Rows.Add(dr); GrdFlight.DataSource = dtFlight; GrdFlight.DataBind(); // ViewState["DataTable"] = dtFlight; } catch { } }
protected void rdoReturn_SelectedIndexChanged(object sender, EventArgs e) { if (GrdFlight.Rows.Count < 5) { RadioButtonList objsender = (RadioButtonList)sender; DataTable dtFlight = CreateDtFlight(); string strFrom = "", strTo = ""; DataRow dr = null; foreach (GridViewRow gr in GrdFlight.Rows) { UserControl_ctlAirPortList txtFrom1 = (gr.FindControl("txtFrom1") as UserControl_ctlAirPortList); UserControl_ctlAirPortList txtTo1 = (gr.FindControl("txtTo1") as UserControl_ctlAirPortList); dr = dtFlight.NewRow(); dr["travelOrigin"] = txtFrom1.Text; dr["travelDestination"] = txtTo1.Text; dr["departureDate"] = (gr.FindControl("txtDepDate1") as TextBox).Text; dr["PrefDephours"] = (gr.FindControl("cmbDepHours1") as DropDownList).SelectedValue; dr["PrefDepmins"] = (gr.FindControl("cmbDepMins1") as DropDownList).SelectedValue; dtFlight.Rows.Add(dr); strFrom = txtFrom1.Text; strTo = txtTo1.Text; } dr = dtFlight.NewRow(); if (objsender != null) { if (objsender.SelectedValue == "1") { if (strTo != "") { dr["travelOrigin"] = strTo; } if (strFrom != "") { dr["travelDestination"] = strFrom; } } } dtFlight.Rows.Add(dr); GrdFlight.DataSource = dtFlight; GrdFlight.DataBind(); } }
private void MakeFlightList() { try { BLL_TRV_QuoteRequest Qr = new BLL_TRV_QuoteRequest(); DataTable dtFlight = CreateDtFlight(); DataRow dr = dtFlight.NewRow(); DataSet dsReqst = Qr.Get_Request_Ticket_Details(Convert.ToInt32(Request.QueryString["RequestID"].ToString())); dr["ID"] = System.Guid.NewGuid().ToString(); dr["FlightStatus"] = "Confirm"; if (dsReqst.Tables[0].Rows.Count > 0) { dr["DepartureDate"] = dsReqst.Tables[0].Rows[0]["DepartureDate"].ToString(); dr["TravelClass"] = dsReqst.Tables[0].Rows[0]["classOfTravel"].ToString(); dr["ArrivalDate"] = dsReqst.Tables[0].Rows[0]["DepartureDate"].ToString(); } if (dsReqst.Tables[1].Rows.Count > 0) { dr["From"] = dsReqst.Tables[1].Rows[0]["travelOrigin"].ToString(); dr["To"] = dsReqst.Tables[1].Rows[0]["travelDestination"].ToString(); } dr["TravelClass"] = "Economy"; dr["FlightStatus"] = "Confirm"; dr["ArrHour"] = "0"; dr["ArrMin"] = "0"; dr["DepHour"] = "0"; dr["DepMin"] = "0"; dtFlight.Rows.Add(dr); // ViewState["DataTable"] = dtFlight; GrdFlight.DataSource = dtFlight; GrdFlight.DataBind(); } catch { } }
protected void btnFillFlightDataForAmadeus_Click(object s, EventArgs e) { try { string js = "HideInsertDataFromAgents();"; ScriptManager.RegisterStartupScript(this, this.GetType(), "closewindow-overlay", js, true); string[] arrFlightDetails = txtAmadeusContent.Text.Split('\n'); StringBuilder strFlight = new StringBuilder(), strFrom = new StringBuilder(), strTo = new StringBuilder(), StrDeptDt = new StringBuilder(), strArrDt = new StringBuilder(), strClass = new StringBuilder(), strStatus = new StringBuilder(); StringBuilder DepDT_Time = new StringBuilder(); StringBuilder ArrDT_Time = new StringBuilder(); StringBuilder Locator = new StringBuilder(); DataTable dtFlight = CreateDtFlight(); DataRow dr = null; foreach (GridViewRow grFlt in GrdFlight.Rows) { if ((grFlt.FindControl("txtFlight") as TextBox).Text.Trim() != "") { dr = dtFlight.NewRow(); dr["ID"] = GrdFlight.DataKeys[grFlt.RowIndex].Values["ID"].ToString(); dr["Flight"] = (grFlt.FindControl("txtFlight") as TextBox).Text; dr["From"] = (grFlt.FindControl("txtFrom") as TextBox).Text; dr["To"] = (grFlt.FindControl("txtTo") as TextBox).Text; dr["FlightStatus"] = (grFlt.FindControl("cmbFlightStatus") as DropDownList).SelectedValue; dr["DepartureDate"] = (grFlt.FindControl("txtDeparureDate") as TextBox).Text; dr["DepHour"] = (grFlt.FindControl("cmbDepHours") as DropDownList).SelectedItem.Value; dr["DepMin"] = (grFlt.FindControl("cmbDepMins") as DropDownList).SelectedItem.Value; dr["ArrivalDate"] = (grFlt.FindControl("txtArrivalDate") as TextBox).Text; dr["ArrHour"] = (grFlt.FindControl("cmbArrHours") as DropDownList).SelectedItem.Value; dr["ArrMin"] = (grFlt.FindControl("cmbArrMins") as DropDownList).SelectedItem.Value; dr["Locator"] = (grFlt.FindControl("txtAirlineLocator") as TextBox).Text; dr["Remarks"] = (grFlt.FindControl("txtFlightRemark") as TextBox).Text; dr["TravelClass"] = (grFlt.FindControl("cmbTravelClass") as DropDownList).SelectedValue; dtFlight.Rows.Add(dr); } } foreach (string strSingleFlight in arrFlightDetails) { strFlight.Clear(); strFrom.Clear(); strTo.Clear(); StrDeptDt.Clear(); strArrDt.Clear(); strClass.Clear(); strStatus.Clear(); DepDT_Time.Clear(); ArrDT_Time.Clear(); Locator.Clear(); if (strSingleFlight.Trim() != "") { int i = 0; foreach (char ch in strSingleFlight.Trim()) { if (i < 8) { strFlight.Append(ch); } else if (i > 8 && i < 14) { StrDeptDt.Append(ch); } else if (i > 16 && i < 20) { strFrom.Append(ch); } else if (i > 19 && i < 23) { strTo.Append(ch); } else if (i == 23) { string fltsts = strSingleFlight[24].ToString() + strSingleFlight[25].ToString(); if (fltsts == "HK") { strStatus.Append("Confirm"); } else { strStatus.Append("Waitlist"); } } else if (i > 28 && i < 33) { DepDT_Time.Append(ch); } else if (i > 33 && i < 38) { ArrDT_Time.Append(ch); } else if (i > 39 && i < 45) { strArrDt.Append(ch); } else if (i == 47) { if (ch.ToString() == "E") { strClass.Append("Economy"); } } else if (i > 49 && i <= 59) { Locator.Append(ch); } i++; } // create a new row in datatable dr = dtFlight.NewRow(); dr["ID"] = System.Guid.NewGuid().ToString(); dr["TravelClass"] = strClass.ToString(); dr["FlightStatus"] = strStatus.ToString(); dr["ArrHour"] = int.Parse(ArrDT_Time.ToString().Substring(0, 2)); dr["ArrMin"] = int.Parse(ArrDT_Time.ToString().Substring(2, 2)); dr["DepHour"] = int.Parse(DepDT_Time.ToString().Substring(0, 2)); dr["DepMin"] = int.Parse(DepDT_Time.ToString().Substring(2, 2)); dr["Flight"] = strFlight.ToString(); dr["From"] = strFrom.ToString(); dr["To"] = strTo.ToString(); dr["DepartureDate"] = StrDeptDt.ToString().Substring(0, 2) + "-" + StrDeptDt.ToString().Substring(2, 3) + "-" + DateTime.Now.Year.ToString(); dr["ArrivalDate"] = strArrDt.ToString().Substring(0, 2) + "-" + strArrDt.ToString().Substring(2, 3) + "-" + DateTime.Now.Year.ToString(); dr["Locator"] = Locator.ToString(); dtFlight.Rows.Add(dr); } } if (dtFlight.Rows.Count > 0) { GrdFlight.DataSource = dtFlight; GrdFlight.DataBind(); } } catch { MakeFlightList(); lblerrorMsg.Visible = true; lblerrorMsg.Text = "Segment related data population failed. Please enter data in correct format or enter segment data manually."; } }