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