/// <summary>
 /// Method is used to bind Oil major dropdown
 /// </summary>
 public void FillOilMajorDropdown()
 {
     try
     {
         DataSet        dsOilMajor = new DataSet();
         BLL_Crew_Admin objCrew    = new BLL_Crew_Admin();
         dsOilMajor = objCrew.GetOilMajor();
         if (dsOilMajor.Tables.Count > 0)
         {
             if (dsOilMajor.Tables[0].Rows.Count > 0)
             {
                 ddlOilMajor.DataSource     = dsOilMajor.Tables[0];
                 ddlOilMajor.DataTextField  = dsOilMajor.Tables[0].Columns["Display_Name"].ToString();
                 ddlOilMajor.DataValueField = dsOilMajor.Tables[0].Columns["ID"].ToString();
                 ddlOilMajor.DataBind();
                 ddlOilMajor.Items.Insert(0, new ListItem("-SELECT-", "0"));
             }
         }
     }
     catch (Exception ex)
     {
         UDFLib.WriteExceptionLog(ex);
     }
 }