public FindVehicleMainForAssignedOfficeDataSet FindVehicleMainForAssignedOffice(string strAssignedOffice)
{
try
{
aFindVehicleMainForAssignedOfficeDataSet = new FindVehicleMainForAssignedOfficeDataSet();
aFindVehicleMainForAssignedOfficeTableAdapter = new FindVehicleMainForAssignedOfficeDataSetTableAdapters.FindVehicleMainForAssignedOfficeTableAdapter();
aFindVehicleMainForAssignedOfficeTableAdapter.Fill(aFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice, strAssignedOffice);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Vehicle Main Class // Find Vehicle Main For Assigned Office " + Ex.Message);
}
return(aFindVehicleMainForAssignedOfficeDataSet);
}
private void mitGenerateReport_Click(object sender, RoutedEventArgs e)
{
int intCounter;
int intNumberOfRecords;
int intRecordsReturned;
DateTime datStartDate;
DateTime datEndDated;
DateTime datLimitDate;
string strAssignedOffice;
int intVehicleID;
bool blnItemFound;
try
{
TheHistoricalExceptionDataSet.vehicleexception.Rows.Clear();
strAssignedOffice = txtOfficeName.Text;
if (strAssignedOffice == "")
{
TheMessagesClass.ErrorMessage("Assigned Office Was Not Entered");
return;
}
TheFindVehicleMainForAssignedOfficeDataSet = TheVehicleMainClass.FindVehicleMainForAssignedOffice(strAssignedOffice);
intNumberOfRecords = TheFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice.Rows.Count - 1;
if (intNumberOfRecords < 0)
{
TheMessagesClass.ErrorMessage("The Assigned Office Does Not Exist");
return;
}
datLimitDate = DateTime.Now;
datLimitDate = TheDateSearchClass.RemoveTime(datLimitDate);
datStartDate = TheDateSearchClass.SubtractingDays(datLimitDate, 90);
while (datStartDate < datLimitDate)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
blnItemFound = false;
datEndDated = TheDateSearchClass.AddingDays(datStartDate, 1);
intVehicleID = TheFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice[intCounter].VehicleID;
TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSete = TheInspectionClass.FindDailyVehicleInspectionByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDated);
intRecordsReturned = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSete.FindDailyVehicleInspectionsByVehicleIDAndDateRange.Rows.Count;
if (intRecordsReturned > 0)
{
blnItemFound = true;
}
else
{
TheFindVehicleInYardByVehicleIDAndDateRangeDataSet = TheVehiclesInYardClass.FindVehiclesInYardByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDated);
intRecordsReturned = TheFindVehicleInYardByVehicleIDAndDateRangeDataSet.FindVehiclesInYardByVehicleIDAndDateRange.Rows.Count;
if (intRecordsReturned > 0)
{
blnItemFound = true;
}
}
if (blnItemFound == false)
{
HistoricalExceptionsDataSet.vehicleexceptionRow NewVehicleRow = TheHistoricalExceptionDataSet.vehicleexception.NewvehicleexceptionRow();
NewVehicleRow.AssignedOffice = strAssignedOffice;
NewVehicleRow.FirstName = TheFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice[intCounter].FirstName;
NewVehicleRow.LastName = TheFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice[intCounter].LastName;
NewVehicleRow.InspectionDate = datStartDate;
NewVehicleRow.VehicleID = intVehicleID;
NewVehicleRow.VehicleNumber = TheFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice[intCounter].VehicleNumber;
TheHistoricalExceptionDataSet.vehicleexception.Rows.Add(NewVehicleRow);
}
}
datStartDate = TheDateSearchClass.AddingDays(datStartDate, 1);
if (datStartDate.DayOfWeek == DayOfWeek.Saturday)
{
datStartDate = TheDateSearchClass.AddingDays(datStartDate, 2);
}
else if (datStartDate.DayOfWeek == DayOfWeek.Sunday)
{
datStartDate = TheDateSearchClass.AddingDays(datStartDate, 1);
}
}
dgrResults.ItemsSource = TheHistoricalExceptionDataSet.vehicleexception;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Historical Vehicle Exception Report // Generate Report " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
