public FindActiveSortedTrailersDataSet FindActiveSortedTrailers() { try { aFindActiveSortedTrailersDataSet = new FindActiveSortedTrailersDataSet(); aFindActiveSortedTrailersTableAdapter = new FindActiveSortedTrailersDataSetTableAdapters.FindActiveSortedTrailersTableAdapter(); aFindActiveSortedTrailersTableAdapter.Fill(aFindActiveSortedTrailersDataSet.FindActiveSortedTrailers); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Trailers Class // Find Active Sorted Trailers " + Ex.Message); } return(aFindActiveSortedTrailersDataSet); }
private void LoadGrid() { int intCounter; int intNumberOfRecords; int intLocationID; try { TheTrailerRosterDataSet.trailerroster.Rows.Clear(); TheFindActiveSortedTrailersDataSet = TheTrailersClass.FindActiveSortedTrailers(); intNumberOfRecords = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intLocationID = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].LocationID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intLocationID); TrailerRosterDataSet.trailerrosterRow NewTrailerRow = TheTrailerRosterDataSet.trailerroster.NewtrailerrosterRow(); NewTrailerRow.AssignedOffice = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; NewTrailerRow.LastName = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].LastName; NewTrailerRow.FirstName = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].FirstName; NewTrailerRow.LicensePlate = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].LicensePlate; NewTrailerRow.Notes = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].TrailerNotes; NewTrailerRow.TrailerDescription = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].TrailerDescription; NewTrailerRow.TrailerID = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].TrailerID; NewTrailerRow.TrailerNumber = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].TrailerNumber; NewTrailerRow.TrailerType = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].TrailerCategory; NewTrailerRow.VINNumber = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].VINNumber; TheTrailerRosterDataSet.trailerroster.Rows.Add(NewTrailerRow); } dgrResults.ItemsSource = TheTrailerRosterDataSet.trailerroster; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Trailer Roster // Load Grid " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }