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());
}
}
