void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select * from Reservation_M where customer_id in(select customer_id from customer_M where email='" + Session["Email"].ToString() + "' )");
gf.fill_grid(ds, grdreservation_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Package_M.Package_Id,Package_Name,Price,No_Of_Days,City_Id,Type,Travel_Mode,Hotel_id from Package_M");
gf.fill_grid(ds, grdpackage_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Hotel_M.Hotel_Id ,Hotel_Name ,Star,Address_Line1,Address_Line2,Address_Line3,City,Pincode,ContactNumber1,ContactNumber2,Email from Hotel_M");
gf.fill_grid(ds, grdhotel_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Train_M.Train_Id,Train_Type,Train_Time,Train_No from Train_M");
gf.fill_grid(ds, grdtrain_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Customer_Travel_T.Reservation_Id,NumberOfSeats,Travel_DateTime,TourFrom,TourTo,Tpid from Customer_Travel_T where reservation_id in(select reservation_id from reservation_M where customer_id = (select customer_id from customer_M where email='" + Session["Email"].ToString() + "'))");
gf.fill_grid(ds, grdcustomertravelt);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Bus_M.Bus_Id,Bus_Details ,Fuel_Type , Bus_Name ,Registration_No ,Seats_Appears from Bus_M");
gf.fill_grid(ds, grdbus_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select City_M.City_Id 'City Id',City_Name 'City Name', State_Name 'State Name' from City_M,State_M where City_M.State_Id=State_M.State_Id");
gf.fill_grid(ds, grdcity_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select TravelPackage_M.Tpid,Package_Id,Bus_Id,Train_Id,Plane_Id,car_id,RatePerSeat from TravelPackage_M");
gf.fill_grid(ds, grdtravelpackage_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Car_M.Car_Id ,Car_Details,Fuel_Type,Car_Name,Car_Registrationnumber from Car_M");
gf.fill_grid(ds, grdcar_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Plane_M.Plane_Id,Plane_Name,Business_Seat,Economy_Seat from Plane_M");
gf.fill_grid(ds, grdplane_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select State_M.State_Id 'State_Id',State_Name 'State_Name' from State_M");
gf.fill_grid(ds, grdstate_m);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Payment_T.Reservation_Id,Payment_Type,Payment_Date,Amount,BankName from Payment_T,Customer_Travel_T where Customer_Travel_T.Reservation_Id=Payment_T.Reservation_Id and Payment_T.reservation_id in(select reservation_id from reservation_M where customer_id = (select customer_id from customer_M where email='" + Session["Email"].ToString() + "'))");
gf.fill_grid(ds, grdpayment_t);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select Reservation_T.Reservation_Id,First_Name,Middle_Name,Last_Name,BirthDate,AadharNo,Gender from Reservation_T,Reservation_M where Reservation_T.Reservation_id=Reservation_M.Reservation_id and customer_id=(select customer_id from customer_M where email='" + Session["Email"].ToString() + "' )");
gf.fill_grid(ds, grdreservation_t);
}
void bindgrid()
{
DataSet ds = new DataSet();
ds = cn.select("select feedback.email,Feedback_description,date from feedback");
gf.fill_grid(ds, grdfeedback);
}
void bindgrid()
{
DataSet ds = new DataSet();
if (Session["Type"].ToString() == "A")
{
ds = cn.select("select Customer_M.Customer_Id,First_Name, Middle_Name,Last_Name,Address_Line1,Address_Line2,Address_Line3,City,Pincode,Contact_No1,Contact_No2,Email,BirthDate,Gender,Aadhar_No,Password,Confirm_Password,Questionid,Securityanswer from Customer_M");
}
else if (Session["Type"].ToString() == "C")
{
ds = cn.select("select Customer_M.Customer_Id,First_Name, Middle_Name,Last_Name,Address_Line1,Address_Line2,Address_Line3,City,Pincode,Contact_No1,Contact_No2,Email,BirthDate,Gender,Aadhar_No,Password,Confirm_Password,Questionid,Securityanswer from Customer_M where Email='" + Session["Email"].ToString() + "'");
}
else
{
ds = cn.select("select Customer_M.Customer_Id,First_Name, Middle_Name,Last_Name,Address_Line1,Address_Line2,Address_Line3,City,Pincode,Contact_No1,Contact_No2,Email,BirthDate,Gender,Aadhar_No,Password,Confirm_Password,Questionid,Securityanswer from Customer_M where 1=2");
}
gf.fill_grid(ds, grdcustomer_m);
}