public void UpdateTrailersInYardDB(TrailersInYardDataSet aTrailersInYardDataSet)
 {
     try
     {
         aTrailersInYardTableAdapter = new TrailersInYardDataSetTableAdapters.trailersinyardTableAdapter();
         aTrailersInYardTableAdapter.Update(aTrailersInYardDataSet.trailersinyard);
     }
     catch (Exception Ex)
     {
         TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Trailers In Yard Class // Update Trailers In Yard DB " + Ex.Message);
     }
 }
        public TrailersInYardDataSet GetTrailersInYardInfo()
        {
            try
            {
                aTrailersInYardDataSet      = new TrailersInYardDataSet();
                aTrailersInYardTableAdapter = new TrailersInYardDataSetTableAdapters.trailersinyardTableAdapter();
                aTrailersInYardTableAdapter.Fill(aTrailersInYardDataSet.trailersinyard);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Trailers In Yard Class // Get Trailers In Yard Info " + Ex.Message);
            }

            return(aTrailersInYardDataSet);
        }