protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(ConfigurationManager.AppSettings["con"]);
if (Page.IsPostBack == false)
{
da = new SqlDataAdapter("select * from Hotel_Details order by H_Id desc", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewHotelDetails.DataSource = dt;
GridViewHotelDetails.DataBind();
}
else
{
GridViewHotelDetails.DataSource = "";
GridViewHotelDetails.DataBind();
}
}
if (Page.IsPostBack == false)
{
da = new SqlDataAdapter("select distinct CountryName from CountryCityMaster order by CountryName", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
DropDownCountry.DataSource = dt;
DropDownCountry.DataTextField = "CountryName";
DropDownCountry.DataBind();
DropDownCountry.Items.Insert(0, "Select Country");
DropDownCountry.Items.Insert(dt.Rows.Count + 1, "Other Country");
}
}
if (Page.IsPostBack == false)
{
da = new SqlDataAdapter("select RoomCategory from RoomCategory", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
DropdownCategory.DataSource = dt;
DropdownCategory.DataTextField = "RoomCategory";
DropdownCategory.DataBind();
DropdownCategory.Items.Insert(0, "Select Room");
DropdownCategory.Items.Insert(dt.Rows.Count + 1, "Other Room");
}
}
if (Request.QueryString["P"] == "AMP")
{
hiderow6.Visible = false;
hiderow1.Visible = true;
hiderow2.Visible = true;
hiderow3.Visible = true;
hiderow4.Visible = true;
SubmitButton.Visible = true;
Button1.Visible = false;
titleLabel.Text = "Insert Hotel Detail";
GridViewHotelDetails.Visible = true;
}
else if (Request.QueryString["P"] == "UMP")
{
hiderow6.Visible = true;
hiderow1.Visible = false;
hiderow2.Visible = false;
hiderow3.Visible = false;
hiderow4.Visible = false;
SubmitButton.Visible = false;
Button1.Visible = true;
titleLabel.Text = "Search Hotel";
GridViewHotelDetails.Visible = false;
}
else
{
hiderow6.Visible = true;
hiderow1.Visible = false;
hiderow2.Visible = false;
hiderow3.Visible = false;
hiderow4.Visible = false;
SubmitButton.Visible = false;
Button1.Visible = true;
titleLabel.Text = "Search Hotel";
GridViewHotelDetails.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(ConfigurationManager.AppSettings["con"]);
if (Page.IsPostBack == false)
{
da = new SqlDataAdapter("select T_Id,T_Type,T_Category,T_Name,To_Country,To_City,From_Country,From_City,convert(varchar,Date,106)Date,Time,Amount,Description from Transport_Details order by T_Id DESC", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewTransportDetails.DataSource = dt;
GridViewTransportDetails.DataBind();
}
else
{
GridViewTransportDetails.DataSource = "";
GridViewTransportDetails.DataBind();
}
}
if (Page.IsPostBack == false)
{
da = new SqlDataAdapter("select TransportCategory from TransportCategory", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
DropdownCategory.DataSource = dt;
DropdownCategory.DataTextField = "TransportCategory";
DropdownCategory.DataBind();
DropdownCategory.Items.Insert(0, "Select Transport");
DropdownCategory.Items.Insert(dt.Rows.Count + 1, "Other Transport");
}
}
if (Page.IsPostBack == false)
{
da = new SqlDataAdapter("select distinct CountryName from CountryCityMaster order by CountryName", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
DropDownToCountry.DataSource = dt;
DropDownToCountry.DataTextField = "CountryName";
DropDownToCountry.DataBind();
DropDownToCountry.Items.Insert(0, "Select Country");
DropDownToCountry.Items.Insert(dt.Rows.Count + 1, "Other Country");
}
}
if (Page.IsPostBack == false)
{
da = new SqlDataAdapter("select distinct CountryName from CountryCityMaster order by CountryName", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
DropDownFromCountry.DataSource = dt;
DropDownFromCountry.DataTextField = "CountryName";
DropDownFromCountry.DataBind();
DropDownFromCountry.Items.Insert(0, "Select Country");
DropDownFromCountry.Items.Insert(dt.Rows.Count + 1, "Other Country");
}
}
if (Request.QueryString["P"] == "AMP")
{
hiderow1.Visible = true;
hiderow2.Visible = true;
hiderow3.Visible = true;
hiderow4.Visible = true;
hiderow5.Visible = true;
hiderow6.Visible = true;
hiderow7.Visible = false;
hiderow8.Visible = false;
SubmitButton.Visible = true;
Button1.Visible = false;
titleLabel.Text = "Insert Transport Detail";
GridViewTransportDetails.Visible = true;
}
else if (Request.QueryString["P"] == "UMP")
{
hiderow1.Visible = false;
hiderow2.Visible = false;
hiderow3.Visible = false;
hiderow4.Visible = false;
hiderow5.Visible = false;
hiderow6.Visible = false;
hiderow7.Visible = true;;
hiderow8.Visible = true;
SubmitButton.Visible = false;
Button1.Visible = true;
titleLabel.Text = "Search Transport";
GridViewTransportDetails.Visible = false;
}
else
{
hiderow1.Visible = false;
hiderow2.Visible = false;
hiderow3.Visible = false;
hiderow4.Visible = false;
hiderow5.Visible = false;
hiderow6.Visible = false;
SubmitButton.Visible = false;
Button1.Visible = true;
titleLabel.Text = "Search Transport";
GridViewTransportDetails.Visible = false;
}
}
