public static List<string> GetCities(string prefixText) { try { DataSet ds = null; if (HttpContext.Current.Session["Cities"] != null) { ds = (DataSet)HttpContext.Current.Session["Cities"]; } else { ClsBAL objBAL = new ClsBAL(); ds = objBAL.GetSourcess(); } string filteringquery = "SourceName LIKE'" + prefixText + "%'"; DataRow[] dr = ds.Tables[0].Select(filteringquery); DataTable dtNew = new DataTable(); dtNew = ds.Tables[0].Clone(); foreach (DataRow drNew in dr) { dtNew.ImportRow(drNew); } List<string> airports = new List<string>(); for (int i = 0; i < dtNew.Rows.Count; i++) { airports.Add(dtNew.Rows[i]["SourceName"].ToString().Trim());//+ " ||| " + dtNew.Rows[i]["ID"].ToString().Trim().ToString()); } return airports; } catch (Exception) { throw; } }
protected void txtTo_TextChanged(object sender, EventArgs e) { DataSet ds = null; if (HttpContext.Current.Session["Cities"] != null) { ds = (DataSet)HttpContext.Current.Session["Cities"]; } else { ClsBAL objBAL = new ClsBAL(); ds = objBAL.GetSourcess(); } string filteringquery = "SourceName LIKE'" + txtTo.Text.ToString() + "%'"; DataRow[] dr = ds.Tables[0].Select(filteringquery); DataTable dtNew = new DataTable(); dtNew = ds.Tables[0].Clone(); foreach (DataRow drNew in dr) { dtNew.ImportRow(drNew); } if (dtNew.Rows.Count >= 1) { HttpContext.Current.Session["ToCityId"] = dtNew.Rows[0]["ID"].ToString(); txtFromDate.Focus(); } else { HttpContext.Current.Session["ToCityId"] = null; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('" + "Please enter valid city." + "');</script>", false); return; } }
protected void Page_Load(object sender, EventArgs e) { objArzooHotelAPILayer = ArzooHotelFactoryManager.GetArzooHotelAPILayerObject(); objArzooHotelAPILayer.UserName = ArzooHotelConstants.USERNAME; objArzooHotelAPILayer.UserId = ArzooHotelConstants.USERID; objArzooHotelAPILayer.UserType = ArzooHotelConstants.USERTYPE; objArzooHotelAPILayer.Password = ArzooHotelConstants.PASSWORD; objArzooHotelAPILayer.PartnerId = ArzooHotelConstants.PARTNERID; //if (!IsPostBack) //{ // BindRemainders(); // BindNotices(); //} try { kesineniDetails = new KesineniDetails(); kesineniDetails.LoginId = KesineniConstants.LoginId; kesineniDetails.PassWord = KesineniConstants.Password; abhiBusDetails = new AbhiBusDetails(); abhiBusDetails.Url = AbhiBusConstants.URL; bitlaDetails = new BitlaDetails(); bitlaDetails.ApiKey = BitlaConstants.API_KEY; bitlaDetails.Url = BitlaConstants.URL; objCommon = new KABCommon(kesineniDetails, abhiBusDetails, bitlaDetails); this.Page.Title = "LoveJourney - Bus - Search"; if (!IsPostBack) { Panel pnl = (Panel)this.Master.FindControl("pnl"); pnl.Visible = false; pnlAdminDomesticFlights.Visible = false; BindRemainders(); // BindNotices(); adminPanelBuses.Visible = false; // CheckPermission("Book Ticket", Session["Role"].ToString()); pnlAdminHotels.Visible = false; #region DomesticFlights // CheckPermission("Domestic Availability", Session["Role"].ToString()); // GetIntFlightsAvailability(); gdvFlights.Visible = true; round.Visible = false; #endregion #region BusesSearch objDataSet = null; if (objDataSet == null) { objBAL = new ClsBAL(); objDataSet = objBAL.GetSourcess(); } if (objDataSet != null) { if (objDataSet.Tables.Count > 0) { if (objDataSet.Tables[0].Rows.Count > 0) { ddlSources.DataSource = objDataSet.Tables[0]; ddlSources.DataTextField = "SourceName"; ddlSources.DataValueField = "ID"; ddlSources.DataBind(); ddlSources.Items.Insert(0, "----------"); ddlDestinations.Items.Clear(); ddlDestinations.Items.Insert(0, "----------"); } } } ddlSources.SelectedValue = ddlSources.Items.FindByText("Hyderabad").Value; ddlSources_SelectedIndexChanged(sender, e); ddlDestinations.SelectedValue = ddlDestinations.Items.FindByText("Bangalore").Value; Session["DOJ"] = txtFromDate.Text.ToString(); Session["From"] = ddlSources.SelectedItem.Text.ToString(); Session["To"] = ddlDestinations.SelectedItem.Text.ToString(); #endregion } } catch (Exception) { throw; } }