private void gridbind()
{
da = new SqlDataAdapter("select P_Id,P_B_Id,PackageType,PackageCategory,Country,City,NoOfDays,Amount,Convert(varchar,BookingDate,106) As BookingDate,Description from PackageBookingDetails where BookingDate between '" + TextBox1.Text + "' and '" + TextBox2.Text + "'", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewPackageBooking.DataSource = dt;
GridViewPackageBooking.AllowPaging = true;
GridViewPackageBooking.DataBind();
Label4.Text = "";
}
else
{
GridViewPackageBooking.DataSource = "";
GridViewPackageBooking.AllowPaging = false;
GridViewPackageBooking.DataBind();
Label4.Text = "Bookings Is not Available";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string userid = Session["Userid"].ToString();
con = new SqlConnection(ConfigurationManager.AppSettings["con"]);
da = new SqlDataAdapter("select P_Id,P_B_Id,PackageType,PackageCategory,Country,City,NoOfDays,Amount,Convert(varchar,BookingDate,106) As BookingDate,Description from PackageBookingDetails where UserId='" + userid + "'", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewPackageBooking.DataSource = dt;
GridViewTransportBooking.AllowPaging = true;
GridViewPackageBooking.DataBind();
}
else
{
GridViewPackageBooking.DataSource = "";
GridViewTransportBooking.AllowPaging = false;
GridViewPackageBooking.DataBind();
da = new SqlDataAdapter("select T_Id,T_B_Id,To_Country,To_City,From_Country,From_City,Convert(varchar,Date,106)As Date,Time,NoOfPerson,Amount,Convert(varchar,BookingDate,106) As BookingDate,Description from TransportBookingDetails where UserId='" + userid + "'", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewTransportBooking.DataSource = dt;
GridViewTransportBooking.AllowPaging = true;
GridViewTransportBooking.DataBind();
}
else
{
GridViewTransportBooking.DataSource = "";
GridViewTransportBooking.AllowPaging = false;
GridViewTransportBooking.DataBind();
}
da = new SqlDataAdapter("select H_Id,H_B_Id,Room_Category,NoOfPerson,Convert(varchar,CheckInDate,106) As CheckInDate,Convert(varchar,CheckOutDate,106) As CheckOutDate,Amount,Convert(varchar,BookingDate,106)As BookingDate,Description from HotelBookingDetails where UserId='" + userid + "'", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewHotelBooking.DataSource = dt;
GridViewTransportBooking.AllowPaging = true;
GridViewHotelBooking.DataBind();
}
else
{
GridViewHotelBooking.DataSource = "";
GridViewTransportBooking.AllowPaging = false;
GridViewHotelBooking.DataBind();
}
da = new SqlDataAdapter("select HR_Id,HR_B_Id,NumberOfPerson,Convert(varchar,CheckInDate,106) As CheckInDate,Convert(varchar,CheckOutDate,106) As CheckOutDate,Amount,Convert(varchar,BookingDate,106)As BookingDate,Description from HomestayResortBookingDetails where UserId='" + userid + "'", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewHomestayBooking.DataSource = dt;
GridViewTransportBooking.AllowPaging = true;
GridViewHomestayBooking.DataBind();
}
else
{
GridViewHomestayBooking.DataSource = "";
GridViewTransportBooking.AllowPaging = false;
GridViewHomestayBooking.DataBind();
}
}
}