public FindActiveVehicleMainByLocationDataSet FindActiveVehicleMainByLocation(string strAssignedOffice)
{
try
{
aFindActiveVehicleMainByLocationDataSet = new FindActiveVehicleMainByLocationDataSet();
aFindActiveVehicleMainByLocationTableAdapter = new FindActiveVehicleMainByLocationDataSetTableAdapters.FindActiveVehicleMainByLocationTableAdapter();
aFindActiveVehicleMainByLocationTableAdapter.Fill(aFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation, strAssignedOffice);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Vehicle Main Class // Find Active Vehicle Main By Location " + Ex.Message);
}
return(aFindActiveVehicleMainByLocationDataSet);
}
private void cboSelectLocation_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int intSelectedIndex;
string strAssignedOffice;
int intCounter;
int intNumberOfRecords;
try
{
intSelectedIndex = cboSelectLocation.SelectedIndex - 2;
TheActiveVehicleDataSet.activevehicles.Rows.Clear();
if (intSelectedIndex == -1)
{
TheFindActiveVehicleMainDataSet = TheVehicleMainClass.FindActiveVehicleMain();
intNumberOfRecords = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
ActiveVehicleDataSet.activevehiclesRow NewVehicleRow = TheActiveVehicleDataSet.activevehicles.NewactivevehiclesRow();
NewVehicleRow.AssignedOffice = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].AssignedOffice;
NewVehicleRow.FirstName = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].FirstName;
NewVehicleRow.LastName = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].LastName;
NewVehicleRow.LicensePlate = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].LicensePlate;
NewVehicleRow.VehicleID = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].VehicleID;
NewVehicleRow.VehicleMake = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].VehicleMake;
NewVehicleRow.VehicleModel = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].VehicleModel;
NewVehicleRow.VehicleNumber = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].VehicleNumber;
NewVehicleRow.VehicleYear = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].VehicleYear;
NewVehicleRow.VINNumber = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].VINNumber;
TheActiveVehicleDataSet.activevehicles.Rows.Add(NewVehicleRow);
}
}
}
else if (intSelectedIndex > -1)
{
strAssignedOffice = TheFindWarehouseDataSet.FindWarehouses[intSelectedIndex].FirstName;
TheFindActiveVehicleMainByLocationDataSet = TheVehicleMainClass.FindActiveVehicleMainByLocation(strAssignedOffice);
intNumberOfRecords = TheFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
ActiveVehicleDataSet.activevehiclesRow NewVehicleRow = TheActiveVehicleDataSet.activevehicles.NewactivevehiclesRow();
NewVehicleRow.AssignedOffice = strAssignedOffice;
NewVehicleRow.FirstName = TheFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation[intCounter].FirstName;
NewVehicleRow.LastName = TheFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation[intCounter].LastName;
NewVehicleRow.LicensePlate = TheFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation[intCounter].LicensePlate;
NewVehicleRow.VehicleID = TheFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation[intCounter].VehicleID;
NewVehicleRow.VehicleMake = TheFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation[intCounter].VehicleMake;
NewVehicleRow.VehicleModel = TheFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation[intCounter].VehicleModel;
NewVehicleRow.VehicleNumber = TheFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation[intCounter].VehicleNumber;
NewVehicleRow.VehicleYear = TheFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation[intCounter].VehicleYear;
NewVehicleRow.VINNumber = TheFindActiveVehicleMainByLocationDataSet.FindActiveVehicleMainByLocation[intCounter].VINNumber;
TheActiveVehicleDataSet.activevehicles.Rows.Add(NewVehicleRow);
}
}
}
dgrVehicleRoster.ItemsSource = TheActiveVehicleDataSet.activevehicles;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Vehicle Roster // Combo Box Selection " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}