private void BindBuildingUnitNumbers(int BuildingNo)
 {
     try
     {
         DataTable dt = ProjectLeadOccupantsData.GetBuildingUnitNumbers(BuildingNo);
         if (dt.Rows.Count > 0)
         {
             ddlUnitNumber.Items.Clear();
             ddlUnitNumber.DataSource     = dt;
             ddlUnitNumber.DataValueField = "LeadUnitID";
             ddlUnitNumber.DataTextField  = "Unit";
             ddlUnitNumber.DataBind();
             ddlUnitNumber.Items.Insert(0, new ListItem("Select", "NA"));
         }
         else
         {
             ddlUnitNumber.Items.Clear();
             ddlUnitNumber.Items.Insert(0, new ListItem("No Units Found", "NA"));
         }
     }
     catch (Exception ex)
     {
         LogError(Pagename, "BindBuildingNumbers", "", ex.Message);
     }
 }