protected void Button10_Click(object sender, EventArgs e)
        {
            SqlDataSource P1_SqlDataSource_Save = (SqlDataSource)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("P1_SqlDataSource_Save");

            P1_SqlDataSource_Save.Insert();

            HiddenField   HiddenField_Visited_StafEmpId0      = (HiddenField)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("HiddenField_Visited_StafEmpId0");
            HiddenField   HiddenField_Vehicle_Requisition_Id0 = (HiddenField)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("HiddenField_Vehicle_Requisition_Id0");
            GridView      GridView9      = (GridView)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("GridView9");
            SqlDataSource SqlDataSource2 = (SqlDataSource)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("SqlDataSource2");

            for (int i = 0; i < GridView9.Rows.Count; i++)
            {
                HiddenField HiddenField_Visited_StafEmpId      = (HiddenField)GridView9.Rows[i].FindControl("HiddenField_Visited_StafEmpId");
                HiddenField HiddenField_Vehicle_Requisition_Id = (HiddenField)GridView9.Rows[i].FindControl("HiddenField_Vehicle_Requisition_Id");
                CheckBox    CheckBox1 = (CheckBox)GridView9.Rows[i].FindControl("CheckBox1");

                if (CheckBox1.Checked)
                {
                    HiddenField_Visited_StafEmpId0.Value      = HiddenField_Visited_StafEmpId.Value;
                    HiddenField_Vehicle_Requisition_Id0.Value = HiddenField_Vehicle_Requisition_Id.Value;
                    SqlDataSource2.Insert();
                }
            }
            GridView      GridView8 = (GridView)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("GridView8");
            HiddenField   HiddenField_VFType_Id0        = (HiddenField)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("HiddenField_VFType_Id0");
            HiddenField   HiddenField_VF_Current        = (HiddenField)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("HiddenField_VF_Current");
            SqlDataSource P1A_SqlDataSource_CurrentFuel = (SqlDataSource)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("P1A_SqlDataSource_CurrentFuel");

            for (int j = 0; j < GridView8.Rows.Count; j++)
            {
                HiddenField HiddenField_VFType_Id = (HiddenField)GridView8.Rows[j].FindControl("HiddenField_VFType_Id");
                TextBox     TextBox1 = (TextBox)GridView8.Rows[j].FindControl("TextBox1");
                HiddenField_VFType_Id0.Value = HiddenField_VFType_Id.Value;
                HiddenField_VF_Current.Value = TextBox1.Text;
                P1A_SqlDataSource_CurrentFuel.Insert();
            }


            P1_GridViewAllreadyReservedV.DataBind();
        }
        protected void WebDateChooser1_ValueChanged(object sender, EventArgs e)
        {
            //WebDateChooser1.Value = DateTime.Now;
            //DateTime d = Convert.ToDateTime(WebDateChooser1.Value);
            DateTime d = DateTime.ParseExact(WebDateChooser1.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);

            P1_HiddenField_StartTime.Value = d.ToShortDateString() + " 12:01:00 AM";
            P1_HiddenField_EndTime.Value   = d.ToShortDateString() + " 11:59:59 PM";
            //P1_DropDownList_Name.DataBind();
            //P1_DropDownList_Name.Items.Insert(0, "All");
            //P1_DropDownList_Name.Items[0].Value = "0";
            //P1_DropDownList_Vehicle.DataBind();
            //P1_DropDownList_Vehicle.Items.Insert(0, "All");
            //P1_DropDownList_Vehicle.Items[0].Value = "0";
            //P1_DropDownList_Driver.DataBind();
            //P1_DropDownList_Driver.Items.Insert(0, "All");
            //P1_DropDownList_Driver.Items[0].Value = "0";

            //P1_DropDownList_Destination.DataBind();
            //P1_DropDownList_Destination.Items.Insert(0, "All");
            //P1_DropDownList_Destination.Items[0].Value = "0";
            P1_GridViewAllreadyReservedV.DataBind();
        }