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