public void UpdateDesignProjectsSurveyorDB(DesignProjectsSurveyorDataSet aDesignProjectsSurveyorDataSet)
 {
     try
     {
         aDesignProjectsSurveyorTableAdapter = new DesignProjectsSurveyorDataSetTableAdapters.designprojectsurveyorTableAdapter();
         aDesignProjectsSurveyorTableAdapter.Update(aDesignProjectsSurveyorDataSet.designprojectsurveyor);
     }
     catch (Exception Ex)
     {
         TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Design Surveyor Class // Update Design Projects Surveyor DB" + Ex.Message);
     }
 }
        public DesignProjectsSurveyorDataSet GetDesignProjectsSurveyorInfo()
        {
            try
            {
                aDesignProjectsSurveyorDataSet      = new DesignProjectsSurveyorDataSet();
                aDesignProjectsSurveyorTableAdapter = new DesignProjectsSurveyorDataSetTableAdapters.designprojectsurveyorTableAdapter();
                aDesignProjectsSurveyorTableAdapter.Fill(aDesignProjectsSurveyorDataSet.designprojectsurveyor);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Design Surveyor Class // Get Design Projects Surveyor Info " + Ex.Message);
            }

            return(aDesignProjectsSurveyorDataSet);
        }