protected void dropdownFYear_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (Session["lastSelectedCountryIndex"] != null)
     {
         dropdownFYear.SelectedIndex = Convert.ToInt32((Session["lastSelectedCountryIndex"]).ToString());
         if (dropdownFYear.SelectedIndex != -1)
         {
             selectedText1 = dropdownFYear.SelectedItem.Text;
             DataTable dt = new DataTable();
             dt = ddo.FilterFY(selectedText1, selectedText2, selectedText3);
             rptr.DataSource = dt;
             rptr.DataBind();
             Session["lastSelectedCountryIndex"] = null;
         }
     }
     if (Session["lastSelectedCountryIndex"] == null)
     {
         if (dropdownFYear.SelectedIndex != -1)
         {
             DataTable dt = new DataTable();
             if (dropdownSupplier.SelectedIndex != 0)
             {
                 if (dropdownWareHouse.SelectedIndex != 0)
                 {
                     selectedText1   = dropdownFYear.SelectedItem.Text;
                     selectedText2   = dropdownSupplier.SelectedItem.Text;
                     selectedText3   = dropdownWareHouse.SelectedItem.Text;
                     dt              = ddo.FilterSupplier(selectedText1, selectedText2, selectedText3);
                     rptr.DataSource = dt;
                     rptr.DataBind();
                 }
                 else
                 {
                     selectedText1   = dropdownFYear.SelectedItem.Text;
                     selectedText2   = dropdownSupplier.SelectedItem.Text;
                     dt              = ddo.FilterSupplier(selectedText1, selectedText2, selectedText3);
                     rptr.DataSource = dt;
                     rptr.DataBind();
                 }
             }
             else
             {
                 if (dropdownWareHouse.SelectedIndex != 0)
                 {
                     selectedText1   = dropdownFYear.SelectedItem.Text;
                     selectedText3   = dropdownWareHouse.SelectedItem.Text;
                     dt              = ddo.FilterFY(selectedText1, selectedText2, selectedText3);
                     rptr.DataSource = dt;
                     rptr.DataBind();
                 }
                 else
                 {
                     selectedText1   = dropdownFYear.SelectedItem.Text;
                     dt              = ddo.FilterFY(selectedText1, selectedText2, selectedText3);
                     rptr.DataSource = dt;
                     rptr.DataBind();
                 }
             }
         }
     }
 }