public void UpdateTrailerHistoryDB(TrailerHistoryDataSet aTrailerHistoryDataSet)
 {
     try
     {
         aTrailerHistoryTableAdapter = new TrailerHistoryDataSetTableAdapters.trailerhistoryTableAdapter();
         aTrailerHistoryTableAdapter.Update(aTrailerHistoryDataSet.trailerhistory);
     }
     catch (Exception Ex)
     {
         TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Trailer History Class // Update Trailer History DB " + Ex.Message);
     }
 }
        public TrailerHistoryDataSet GetTrailerHistoryInfo()
        {
            try
            {
                aTrailerHistoryDataSet      = new TrailerHistoryDataSet();
                aTrailerHistoryTableAdapter = new TrailerHistoryDataSetTableAdapters.trailerhistoryTableAdapter();
                aTrailerHistoryTableAdapter.Fill(aTrailerHistoryDataSet.trailerhistory);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Trailer History Class // Get Trailer History Info " + Ex.Message);
            }

            return(aTrailerHistoryDataSet);
        }