private void txtEnterBJCNumber_TextChanged(object sender, TextChangedEventArgs e)
{
//setting local variables
string strValueForValidation;
int intBJCLength;
int intRecordsReturned;
//data validation
strValueForValidation = txtEnterBJCNumber.Text;
intBJCLength = strValueForValidation.Length;
if (intBJCLength >= 4)
{
MainWindow.gstrVehicleNumber = strValueForValidation;
TheFindVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber);
intRecordsReturned = TheFindVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
else if (intBJCLength >= 6)
{
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("Vehicle Not Found");
return;
}
}
}
}
private void TxtVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
//setting local variables
string strVehicleNumber;
int intLength;
int intRecordsReturned;
strVehicleNumber = txtVehicleNumber.Text;
intLength = strVehicleNumber.Length;
gblnVehicleFound = false;
if ((intLength == 4) || (intLength == 6))
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
gblnVehicleFound = true;
}
else if (intRecordsReturned == 0)
{
if (intLength == 6)
{
TheMessagesClass.ErrorMessage("Vehicle Not Found");
return;
}
}
}
}
private void btnFind_Click(object sender, RoutedEventArgs e)
{
//setting up the variables
string strVehicleNumber;
int intRecordsReturned;
try
{
strVehicleNumber = txtEnterVehicleNumber.Text;
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("The Vehicle Not Found");
return;
}
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindAllVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemClass.FindAllVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
dgrVehicleProblems.ItemsSource = TheFindAllVehicleMainProblemsByVehicleIDDataSet.FindAllVehicleMainProblemsByVehicleID;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Edit Vehicle Problems // Find Button " + Ex.Message);
}
}
private void cboBodyDamageReported_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int intSelectedIndex;
int intRecordsReturned;
intSelectedIndex = cboBodyDamageReported.SelectedIndex;
if (intSelectedIndex > 0)
{
MainWindow.gstrVehicleNumber = txtEnterBJCNumber.Text;
TheFindVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber);
intRecordsReturned = TheFindVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("Vehicle Number Not Found");
return;
}
if (intSelectedIndex == 1)
{
ReportBodyDamage ReportBodyDamage = new ReportBodyDamage();
ReportBodyDamage.ShowDialog();
}
}
}
private void btnFindVehicle_Click(object sender, RoutedEventArgs e)
{
int intRecordsReturned;
string strVehicleNumber;
int intCounter;
int intNumberOfRecords;
string strWarehouse;
int intSelectedIndex = 0;
try
{
strVehicleNumber = txtEnterVehicleNumber.Text;
if (strVehicleNumber.Length < 2)
{
TheMessagesClass.ErrorMessage("The Vehicle Number is not Correct");
return;
}
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("Vehicle Was Not Found");
return;
}
strWarehouse = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].AssignedOffice;
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
if (strWarehouse == TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName)
{
intSelectedIndex = intCounter + 1;
}
}
cboSelectWarehouse.SelectedIndex = intSelectedIndex;
txtmake.Text = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleMake;
txtModel.Text = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleModel;
txtNotes.Text = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].Notes;
txtVinNumber.Text = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VINNumber;
txtYear.Text = Convert.ToString(TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleYear);
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
cboSelectWarehouse.IsEnabled = true;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Change Vehicle Location // Find Vehicle Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void txtVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
string strVehicleNumber;
int intLength;
int intRecordsReturned;
bool blnVehicleFound;
strVehicleNumber = txtVehicleNumber.Text;
intLength = strVehicleNumber.Length;
blnVehicleFound = false;
if (intLength == 4)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
blnVehicleFound = true;
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
}
else if (intLength == 6)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
blnVehicleFound = true;
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
else
{
TheMessagesClass.ErrorMessage("Vehicle Number Not Found");
return;
}
}
else if (intLength > 6)
{
TheMessagesClass.ErrorMessage("To Many Characters for a Vehicle Number");
return;
}
if (blnVehicleFound == true)
{
TheFindOpenvehicleMainProblemByVehicleIDDataSet = TheVehicleProblemClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
dgrResults.ItemsSource = TheFindOpenvehicleMainProblemByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID;
dgrResults.IsEnabled = true;
}
}
private void txtVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
//checking vehicle number
string strVehicleNumber;
int intLength;
int intRecordsReturned;
try
{
strVehicleNumber = txtVehicleNumber.Text;
intLength = strVehicleNumber.Length;
if (intLength == 4)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheMessagesClass.InformationMessage("Vehicle Found");
}
}
else if (intLength == 6)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("Vehicle Not Found");
return;
}
else if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
}
else if (intLength > 6)
{
TheMessagesClass.ErrorMessage("This is not the Correct Format for a Vehicle");
return;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Create JSI Entry // Vehicle Number Text Box " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void txtVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
//setting up the variables
int intRecordsReturned;
int intLength;
gblnVehicleFound = false;
MainWindow.gstrVehicleNumber = txtVehicleNumber.Text;
intLength = MainWindow.gstrVehicleNumber.Length;
if (intLength == 4)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheMessagesClass.InformationMessage("Vehicle was Found");
gblnVehicleFound = true;
}
}
else if (intLength == 6)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheMessagesClass.InformationMessage("Vehicle was Found");
gblnVehicleFound = true;
}
else
{
TheMessagesClass.ErrorMessage("Vehicle Was Not Found");
return;
}
}
else if (intLength > 6)
{
TheMessagesClass.ErrorMessage("Vehicle Was Not Found, To Many Characters");
return;
}
}
private void btnProcess_Click(object sender, RoutedEventArgs e)
{
//setting up local variables
DateTime datTransactionDate = DateTime.Now;
string strVehicleNumber = "";
bool blnFatalError = false;
int intRecordsReturned;
int intVehicleID;
try
{
strVehicleNumber = txtEnterVehicleNumber.Text;
if (strVehicleNumber.Length < 4)
{
TheMessagesClass.ErrorMessage("The Vehicle Number is not Long Enough");
return;
}
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("Vehicle Not Found");
return;
}
intVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
blnFatalError = TheVehicleInYardClass.InsertVehicleInYard(datTransactionDate, intVehicleID);
if (blnFatalError == true)
{
throw new Exception();
}
txtEnterVehicleNumber.Text = "";
txtEnterVehicleNumber.Focus();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Vehicles In Yard // Process Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
public FindActiveVehicleMainByVehicleNumberDataSet FindActiveVehicleMainByVehicleNumber(string strVehicleNumber)
{
try
{
aFindActiveVehicleMainByVehicleNumberDataSet = new FindActiveVehicleMainByVehicleNumberDataSet();
aFindActiveVehicleMainByVehicleNumberTableAdapter = new FindActiveVehicleMainByVehicleNumberDataSetTableAdapters.FindActiveVehicleMainByVehicleNumberTableAdapter();
aFindActiveVehicleMainByVehicleNumberTableAdapter.Fill(aFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber, strVehicleNumber);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Vehicle Main Class // Find Active Vehicle Main By Vehicle Number " + Ex.Message);
}
return(aFindActiveVehicleMainByVehicleNumberDataSet);
}
private void txtVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
//setting variables
string strVehicleNumber;
bool blnFatalError = false;
int intRecordsReturned;
int intLength;
strVehicleNumber = txtVehicleNumber.Text;
intLength = strVehicleNumber.Length;
if (intLength >= 4)
{
blnFatalError = TheDataValidationClass.VerifyTextData(strVehicleNumber);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Vehicle Number Entered Is not Integer");
return;
}
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(MainWindow.gintVehicleID);
intRecordsReturned = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID.Rows.Count;
if (intRecordsReturned == 0)
{
txtCurrentFirstName.Text = "Not Assigned";
txtCurrentLastName.Text = "Not Assigned";
}
else
{
txtCurrentFirstName.Text = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].FirstName;
txtCurrentLastName.Text = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName;
}
cboSelectEmployee.IsEnabled = true;
}
}
}
private void btnFindVehicle_Click(object sender, RoutedEventArgs e)
{
//setting local variables
string strVehicleNumber;
int intRecordsReturned;
strVehicleNumber = txtEnterVehicleNumber.Text;
mitProccess.IsEnabled = false;
cboSelectCompletion.SelectedIndex = 0;
if (strVehicleNumber == "")
{
TheMessagesClass.ErrorMessage("Vehicle Number Was Not Entered");
return;
}
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("Vehicle Number Was Not Found");
return;
}
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
MainWindow.TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
intRecordsReturned = MainWindow.TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID.Rows.Count;
if (intRecordsReturned > 0)
{
SelectExistingWorkOrder SelectExistingWorkOrder = new SelectExistingWorkOrder();
SelectExistingWorkOrder.ShowDialog();
}
txtOilChangeDate.Text = Convert.ToString(TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].OilChangeDate);
txtOilChangeOdometer.Text = Convert.ToString(TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].OilChangeOdometer);
gintOldOdometerReading = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].OilChangeOdometer;
txtVehicleMake.Text = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleMake;
txtVehicleModel.Text = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleModel;
txtVehicleYear.Text = Convert.ToString(TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleYear);
SetControlsReadOnly(false);
}
private bool FindVehicle(string strVehicleNumber)
{
bool blnItemFound = false;
int intRecordsReturned;
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
blnItemFound = true;
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
return(blnItemFound);
}
private void mitProcess_Click(object sender, RoutedEventArgs e)
{
string strVehicleNumber;
int intRecordReturns;
int intVehicleID;
bool blnFatalError = false;
try
{
strVehicleNumber = txtEnterVehicleNumber.Text;
if (strVehicleNumber == "")
{
TheMessagesClass.ErrorMessage("Vehicle Number Was Not Entered");
return;
}
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordReturns = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordReturns == 0)
{
TheMessagesClass.ErrorMessage("Vehicle Number Was Not Found");
return;
}
intVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
blnFatalError = TheVehicleMainClass.UpdateVehicleMainActive(intVehicleID, false);
if (blnFatalError == true)
{
throw new Exception();
}
TheMessagesClass.InformationMessage("Vehicle Has Been Retired");
txtEnterVehicleNumber.Text = "";
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Retive Vehicle // Process Number " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void btnFind_Click(object sender, RoutedEventArgs e)
{
int intRecordsReturned;
gstrVehicleNumber = txtVehicleNumber.Text;
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(gstrVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("The Vehicle Number Entered does not Exist");
return;
}
TheFindAllBulkToolsForVehicleDataSet = TheVehicleBulkToolsClass.FindAllBulkToolsForVehicle(gstrVehicleNumber);
dgrResults.ItemsSource = TheFindAllBulkToolsForVehicleDataSet.FindAllBulkToolsForVehicle;
}
private void TxtVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
int intLength;
int intRecordsReturned;
try
{
MainWindow.gstrVehicleNumber = txtVehicleNumber.Text;
intLength = MainWindow.gstrVehicleNumber.Length;
if ((intLength == 4) || (intLength == 6))
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
if (intLength == 6)
{
TheMessagesClass.ErrorMessage("Vehicle Number Not Found");
}
return;
}
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
mitGetVehicleInvoiceInformation.IsEnabled = true;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Vehicle Problem Invoice Report // Vehicle Number Text Changed Event " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//local variables
int intInvoiceID;
string strProblemUpdates = "";
int intCounter;
int intNumberOfRecords;
string strVendorName;
string strVehicleNumber;
try
{
TheFindVehicleMainProblemByProblemIDDataSet = TheVehicleProblemClass.FindVehicleMainProblemByProblemID(MainWindow.gintProblemID);
txtProblemID.Text = Convert.ToString(TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].ProblemID);
txtTransactionDate.Text = Convert.ToString(TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].TransactionDAte);
txtProblem.Text = TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].Problem;
txtProblemStatus.Text = TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].ProblemStatus;
strVehicleNumber = TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].VehicleNumber;
TheFindActiveVehicleByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
MainWindow.gintVehicleID = TheFindActiveVehicleByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
strVendorName = TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].VendorName;
TheFindVendorByVendorNameDataSet = TheVendorsClass.FindVendorByVendorName(strVendorName);
MainWindow.gintVendorID = TheFindVendorByVendorNameDataSet.FindVendorByVendorName[0].VendorID;
if (TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].IsProblemResolutionNull() == false)
{
txtProblemResolution.Text = TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].ProblemResolution;
}
if (TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].IsInvoiceIDNull() == false)
{
intInvoiceID = TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].InvoiceID;
if (intInvoiceID > 999)
{
TheFindVehicleInvoiceByInvoiceIDDataSet = TheVehicleProblemDocumentClass.FindVehicleInvoiceByInvoiceID(intInvoiceID);
txtInvoiceAmount.Text = Convert.ToString(TheFindVehicleInvoiceByInvoiceIDDataSet.FindVehicleInvoiceByInvoiceID[0].InvoiceAmount);
txtInvoicePath.Text = TheFindVehicleInvoiceByInvoiceIDDataSet.FindVehicleInvoiceByInvoiceID[0].InvoicePath;
}
}
TheFindVehicleMainProblemUpdateByProblemIDDataSet = TheVehicleProblemClass.FindVehicleMainProblemUpdateByProblemID(MainWindow.gintProblemID);
intNumberOfRecords = TheFindVehicleMainProblemUpdateByProblemIDDataSet.FindVehicleMainProblemUpdateByProblemID.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strProblemUpdates += Convert.ToString(TheFindVehicleMainProblemUpdateByProblemIDDataSet.FindVehicleMainProblemUpdateByProblemID[intCounter].TransactionDate);
strProblemUpdates += " ";
strProblemUpdates += TheFindVehicleMainProblemUpdateByProblemIDDataSet.FindVehicleMainProblemUpdateByProblemID[intCounter].ProblemUpdate;
strProblemUpdates += "\n\n";
}
}
txtCurrentUpdates.Text = strProblemUpdates;
TheFindVenicleProblemDocumentationByProblemIDDataSet = TheVehicleProblemDocumentClass.FindVehicleProblemDocumentationByProblemID(MainWindow.gintProblemID);
dgrProblemDocumentation.ItemsSource = TheFindVenicleProblemDocumentationByProblemIDDataSet.FindVehicleProblemDocumentationByProblemID;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Edit Selected Vehicle Problem // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void btnMainProcess_Click(object sender, RoutedEventArgs e)
{
//this will insert into the table
string strValueForValidation = "";
string strErrorMessage = "";
bool blnFatalError = false;
bool blnThereIsAProblem = false;
string strAssignedProjectID;
string strVehicleNumber;
DateTime datTransactionDate = DateTime.Now;
int intRecordsReturned;
DateTime datInspectionDate = DateTime.Now;
int intCounter;
int intNumberOfRecords;
int intEmployeeID;
try
{
strAssignedProjectID = txtAssignedProjectID.Text;
if (strAssignedProjectID == "")
{
blnFatalError = true;
strErrorMessage += "The Project Was Not Entered\n";
}
else
{
TheFindProjectMatrixByCustomerProjectIDDataSet = TheProjectMatrixClass.FindProjectMatrixByCustomerProjectID(strAssignedProjectID);
intRecordsReturned = TheFindProjectMatrixByCustomerProjectIDDataSet.FindProjectMatrixByCustomerProjectID.Rows.Count;
if (intRecordsReturned < 1)
{
TheFindProjectMatrixByAssignedProjectIDDataSet = TheProjectMatrixClass.FindProjectMatrixByAssignedProjectID(strAssignedProjectID);
intRecordsReturned = TheFindProjectMatrixByAssignedProjectIDDataSet.FindProjectMatrixByAssignedProjectID.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintProjectID = TheFindProjectMatrixByAssignedProjectIDDataSet.FindProjectMatrixByAssignedProjectID[0].ProjectID;
}
else if (intRecordsReturned < 1)
{
blnFatalError = true;
strErrorMessage += "The Project Was Not Found\n";
}
}
else
{
MainWindow.gintProjectID = TheFindProjectMatrixByCustomerProjectIDDataSet.FindProjectMatrixByCustomerProjectID[0].ProjectID;
}
}
if (cboSelectEmployee.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
if (cboSelectDepartment.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Department Was Not Selected\n";
}
strVehicleNumber = txtVehicleNumber.Text;
if (strVehicleNumber == "")
{
blnFatalError = true;
strErrorMessage += "Vehicle Number Was Not Entered\n";
}
else
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned < 1)
{
blnFatalError = true;
strErrorMessage += "The Vehicle Number Was Not Found\n";
}
else
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
}
strValueForValidation = txtInspectionDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnFatalError == true)
{
blnFatalError = true;
strErrorMessage += "The Inspection Date is not a Date\n";
}
else
{
datInspectionDate = Convert.ToDateTime(strValueForValidation);
blnThereIsAProblem = TheDataValidationClass.verifyDateRange(datInspectionDate, DateTime.Now);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Inspection is after Today\n";
}
}
if (cboSelectManager.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Manager Was Not Selected\n";
}
if (cboSelectInspector.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Inspector Was Not Selected\n";
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
MainWindow.gdatInspectionDate = datInspectionDate;
intNumberOfRecords = TheJSIEmployeeAssignedDataSet.jsiemployeeassigned.Rows.Count - 1;
if (intNumberOfRecords < 0)
{
TheMessagesClass.ErrorMessage("No Employees Were Added");
return;
}
MainWindow.gintEmployeeID = TheJSIEmployeeAssignedDataSet.jsiemployeeassigned[0].EmployeeID;
blnFatalError = TheJSIMainClass.InsertIntoJSIMain(datTransactionDate, MainWindow.gintProjectID, MainWindow.gintEmployeeID, MainWindow.gintDepartmentID, MainWindow.gintVehicleID, datInspectionDate, MainWindow.gintManagerID, MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, MainWindow.gintInspectingEmployeeID);
if (blnFatalError == true)
{
throw new Exception();
}
TheFindJSIMainByDateMatchDataSet = TheJSIMainClass.FindJSIMainByDateMatch(datTransactionDate);
MainWindow.gintJSITransationID = TheFindJSIMainByDateMatchDataSet.FindJSIMainByDateMatch[0].JSITransactionID;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
blnFatalError = TheJSIMainClass.InsertJSIEmployee(MainWindow.gintJSITransationID, TheJSIEmployeeAssignedDataSet.jsiemployeeassigned[intCounter].EmployeeID, datTransactionDate);
if (blnFatalError == true)
{
throw new Exception();
}
}
blnFatalError = TheEmployeeDataEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Create JSI Entry // JSI Created");
if (blnFatalError == true)
{
throw new Exception();
}
JSIPPEWindow JSIPPEWindow = new JSIPPEWindow();
JSIPPEWindow.ShowDialog();
ResetControls();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Create JSI Entry // Main Process Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
//setting local variables
string strValueForValidation;
string strErrorMessage = "";
bool blnThereIsAProblem = false;
bool blnFatalError = false;
int intCounter;
int intNumberOfRecords;
string strVehicleNumber;
int intRecordsReturned;
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
try
{
TheVehicleHistoryReportDataSet.historyreport.Rows.Clear();
strValueForValidation = txtStartDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Starting Date is not a Date\n";
}
else
{
gdatStartDate = Convert.ToDateTime(strValueForValidation);
}
strValueForValidation = txtEndDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Ending Date is not a Date\n";
}
else
{
gdatEndDate = Convert.ToDateTime(strValueForValidation);
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
else
{
blnFatalError = TheDataValidationClass.verifyDateRange(gdatStartDate, gdatEndDate);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Starting Date is After the Ending Date");
return;
}
}
if (gstrReportType == "DATE RANGE")
{
TheFindVehicleHistoryByDateRangeDataSet = TheVehicleHistoryClass.FindVehicleHistoryByDateRange(gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindVehicleHistoryByDateRangeDataSet.FindVehicleHistoryByDateRange.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
VehicleHistoryReportDataSet.historyreportRow NewHistoryRow = TheVehicleHistoryReportDataSet.historyreport.NewhistoryreportRow();
NewHistoryRow.VehicleNumber = TheFindVehicleHistoryByDateRangeDataSet.FindVehicleHistoryByDateRange[intCounter].VehicleNumber;
NewHistoryRow.FirstName = TheFindVehicleHistoryByDateRangeDataSet.FindVehicleHistoryByDateRange[intCounter].FirstName;
NewHistoryRow.LastName = TheFindVehicleHistoryByDateRangeDataSet.FindVehicleHistoryByDateRange[intCounter].LastName;
NewHistoryRow.TransactionDate = TheFindVehicleHistoryByDateRangeDataSet.FindVehicleHistoryByDateRange[intCounter].TransactionDate;
TheVehicleHistoryReportDataSet.historyreport.Rows.Add(NewHistoryRow);
}
}
if (gstrReportType == "VEHICLE NUMBER")
{
strVehicleNumber = txtSearchInfo.Text;
if (strVehicleNumber == "")
{
TheMessagesClass.ErrorMessage("Vehicle Number Not Entered");
return;
}
else
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("Vehicle Not Found");
return;
}
else
{
gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
}
TheFindVehicleHistoryByVehicleIDAndDateRangeDataSet = TheVehicleHistoryClass.FindVehicleHistoryByVehicleIDAndDateRange(gintVehicleID, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindVehicleHistoryByVehicleIDAndDateRangeDataSet.FindVehicleHistoryByVehicleIDAndDateRange.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
VehicleHistoryReportDataSet.historyreportRow NewHistoryRow = TheVehicleHistoryReportDataSet.historyreport.NewhistoryreportRow();
NewHistoryRow.VehicleNumber = TheFindVehicleHistoryByVehicleIDAndDateRangeDataSet.FindVehicleHistoryByVehicleIDAndDateRange[intCounter].VehicleNumber;
NewHistoryRow.FirstName = TheFindVehicleHistoryByVehicleIDAndDateRangeDataSet.FindVehicleHistoryByVehicleIDAndDateRange[intCounter].FirstName;
NewHistoryRow.LastName = TheFindVehicleHistoryByVehicleIDAndDateRangeDataSet.FindVehicleHistoryByVehicleIDAndDateRange[intCounter].LastName;
NewHistoryRow.TransactionDate = TheFindVehicleHistoryByVehicleIDAndDateRangeDataSet.FindVehicleHistoryByVehicleIDAndDateRange[intCounter].TransactionDate;
TheVehicleHistoryReportDataSet.historyreport.Rows.Add(NewHistoryRow);
}
}
if (gstrReportType == "EMPLOYEE")
{
TheFindVehicleHistoryByEmployeeIDAndDateRangeDataSet = TheVehicleHistoryClass.FindVehicleHistoryByEmployeeIDAndDateRange(gintEmployeeID, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindVehicleHistoryByEmployeeIDAndDateRangeDataSet.FindVehicleHistoryByEmployeeIDAndDateRange.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
VehicleHistoryReportDataSet.historyreportRow NewHistoryRow = TheVehicleHistoryReportDataSet.historyreport.NewhistoryreportRow();
NewHistoryRow.VehicleNumber = TheFindVehicleHistoryByEmployeeIDAndDateRangeDataSet.FindVehicleHistoryByEmployeeIDAndDateRange[intCounter].VehicleNumber;
NewHistoryRow.FirstName = TheFindVehicleHistoryByEmployeeIDAndDateRangeDataSet.FindVehicleHistoryByEmployeeIDAndDateRange[intCounter].FirstName;
NewHistoryRow.LastName = TheFindVehicleHistoryByEmployeeIDAndDateRangeDataSet.FindVehicleHistoryByEmployeeIDAndDateRange[intCounter].LastName;
NewHistoryRow.TransactionDate = TheFindVehicleHistoryByEmployeeIDAndDateRangeDataSet.FindVehicleHistoryByEmployeeIDAndDateRange[intCounter].TransactionDate;
TheVehicleHistoryReportDataSet.historyreport.Rows.Add(NewHistoryRow);
}
}
dgrResults.ItemsSource = TheVehicleHistoryReportDataSet.historyreport;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Vehicle History Report // Search Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
PleaseWait.Close();
}
private void mitProcess_Click(object sender, RoutedEventArgs e)
{
//this will process the information
string strValueForValidation;
bool blnFatalError = false;
bool blnThereIsAProblem = false;
string strErrorMessage = "";
int intRecordsReturned;
try
{
//data validation
MainWindow.gstrVehicleNumber = txtEnterVehicleNumber.Text;
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
blnFatalError = true;
strErrorMessage += "Vehicle Number Not Found\n";
}
else
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(MainWindow.gintVehicleID);
if (TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName == "WAREHOUSE")
{
blnFatalError = true;
strErrorMessage += "Vehicle is Assigned to a Warehouse and\nMust Be Assigned to a Technician\n";
}
}
strValueForValidation = cboEmployee.SelectedItem.ToString();
if (strValueForValidation == "Select Employee")
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
strValueForValidation = txtOdometerReading.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Odometer Reading is not an Integer\n";
}
else
{
MainWindow.gintOdometerReading = Convert.ToInt32(strValueForValidation);
}
if (cboGPSInstalled.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The GPS Installed was not Selected\n";
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
MainWindow.gdatTransactionDate = DateTime.Now;
blnFatalError = TheInspectionsClass.InsertDailyVehicleInspection(MainWindow.gintVehicleID, MainWindow.gdatTransactionDate, MainWindow.gintEmployeeID, MainWindow.gstrInspectionStatus, MainWindow.gintOdometerReading);
if (blnFatalError == true)
{
throw new Exception();
}
blnFatalError = TheVehicleHistoryClass.InsertVehicleHistory(MainWindow.gintVehicleID, MainWindow.gintEmployeeID, MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID);
if (blnFatalError == true)
{
throw new Exception();
}
blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(MainWindow.gintVehicleID, MainWindow.gintEmployeeID);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("There Was a Problem, Contact ID");
return;
}
TheFindDailyVehicleMainInspectionByDateMatchDataSet = TheInspectionsClass.FindDailyVehicleMainInspectionByDateMatch(MainWindow.gdatTransactionDate);
MainWindow.gintInspectionID = TheFindDailyVehicleMainInspectionByDateMatchDataSet.FindDailyVehicleMainInspectionByDateMatch[0].TransactionID;
blnFatalError = TheInspectGPSClass.InsertInspectGPS(MainWindow.gintInspectionID, MainWindow.gstrInspectionType, gblnGPSInstalled);
if (blnFatalError == true)
{
throw new Exception();
}
TheVehicleStatusClass.UpdateVehicleStatus(MainWindow.gintVehicleID, gstrVehicleStatus, DateTime.Now);
if (rdoPassedServiceRequired.IsChecked == true)
{
VehicleInspectionProblem VehicleInspectionProblem = new VehicleInspectionProblem();
VehicleInspectionProblem.ShowDialog();
}
txtEnterVehicleNumber.Text = "";
cboEmployee.Items.Clear();
txtEnterLastName.Text = "";
txtOdometerReading.Text = "";
rdoPassed.IsChecked = false;
rdoPassedServiceRequired.IsChecked = false;
cboBodyDamageReported.SelectedIndex = 0;
cboGPSInstalled.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Vehicle Data Entry // Daily Vehicle Inspection // Process Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void mitProcess_Click(object sender, RoutedEventArgs e)
{
//data validation
string strValueForValidation;
bool blnFatalError = false;
string strErrorMessage = "";
int intRecordsReturned;
int intTransactionID;
try
{
MainWindow.gstrVehicleNumber = txtVehicleNumber.Text;
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
blnFatalError = true;
strErrorMessage += "Vehice Number Not Valid\n";
}
else
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
strValueForValidation = cboSelectEmployee.SelectedItem.ToString();
if (strValueForValidation == "Select Employee")
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
TheFindCurrentVehicleAssignmentByEmployeeIDDataSet = TheVehicleAssignmentClass.FindCurrentVehicleAssignmentByEmployeeID(MainWindow.gintEmployeeID);
intRecordsReturned = TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID.Rows.Count;
if (intRecordsReturned > 0)
{
if (TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].LastName != "WAREHOUSE")
{
TheMessagesClass.ErrorMessage("Employee Is Assigned To Vehicle Number " + TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].VehicleNumber);
return;
}
}
blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(MainWindow.gintVehicleID, MainWindow.gintEmployeeID);
if (blnFatalError == true)
{
throw new Exception();
}
blnFatalError = TheVehicleAssignmentClass.InsertVehicleAssignment(MainWindow.gintVehicleID, MainWindow.gintEmployeeID);
if (blnFatalError == true)
{
throw new Exception();
}
intRecordsReturned = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID.Rows.Count;
if (intRecordsReturned == 1)
{
intTransactionID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].TransactionID;
blnFatalError = TheVehicleAssignmentClass.UpdateCurrentVehicleAssignment(intTransactionID, false);
if (blnFatalError == true)
{
throw new Exception();
}
}
TheMessagesClass.InformationMessage("The Record Has Been Saved");
ResetControls();
txtVehicleNumber.Focus();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Assign Vehicle // Process Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void txtVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
//setting up the variables
int intLenght;
int intRecordsReturned;
bool blnItemFound = false;
int intCounter;
int intNumberOfRecords;
try
{
MainWindow.gstrVehicleNumber = txtVehicleNumber.Text;
intLenght = MainWindow.gstrVehicleNumber.Length;
TheVehicleProblemDataSet.vehicleproblems.Rows.Clear();
TheProblemNotesDataSet.problemnotes.Rows.Clear();
if (intLenght == 4)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
blnItemFound = true;
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
}
else if (intLenght == 6)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
blnItemFound = true;
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
else
{
TheMessagesClass.ErrorMessage("Vehicle Not Found");
return;
}
}
else if (intLenght > 6)
{
TheMessagesClass.ErrorMessage("Too Many Characters for a Vehicle Number");
return;
}
if (blnItemFound == true)
{
TheFindAllVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemClass.FindAllVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
intNumberOfRecords = TheFindAllVehicleMainProblemsByVehicleIDDataSet.FindAllVehicleMainProblemsByVehicleID.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
VehicleProblemDataSet.vehicleproblemsRow NewProblemRow = TheVehicleProblemDataSet.vehicleproblems.NewvehicleproblemsRow();
NewProblemRow.Problem = TheFindAllVehicleMainProblemsByVehicleIDDataSet.FindAllVehicleMainProblemsByVehicleID[intCounter].Problem;
NewProblemRow.ProblemID = TheFindAllVehicleMainProblemsByVehicleIDDataSet.FindAllVehicleMainProblemsByVehicleID[intCounter].ProblemID;
NewProblemRow.Solved = TheFindAllVehicleMainProblemsByVehicleIDDataSet.FindAllVehicleMainProblemsByVehicleID[intCounter].ProblemSolved;
NewProblemRow.TransactionDate = TheFindAllVehicleMainProblemsByVehicleIDDataSet.FindAllVehicleMainProblemsByVehicleID[intCounter].TransactionDate;
if (TheFindAllVehicleMainProblemsByVehicleIDDataSet.FindAllVehicleMainProblemsByVehicleID[intCounter].IsProblemResolutionNull() == true)
{
NewProblemRow.ProblemResolution = "";
}
else
{
NewProblemRow.ProblemResolution = TheFindAllVehicleMainProblemsByVehicleIDDataSet.FindAllVehicleMainProblemsByVehicleID[intCounter].ProblemResolution;
}
TheVehicleProblemDataSet.vehicleproblems.Rows.Add(NewProblemRow);
}
dgrProblems.ItemsSource = TheVehicleProblemDataSet.vehicleproblems;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Vehicle Problem History // Text Box Event " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void mitProcess_Click(object sender, RoutedEventArgs e)
{
//setting local variables
string strVehicleNumber;
int intRecordsReturned;
int intVehicleID;
DateTime datTransactionDate;
bool blnFatalError = false;
DateTime datStartDate = DateTime.Now;
DateTime datEndDate = DateTime.Now;
try
{
strVehicleNumber = txtEnterVehicleNumber.Text;
datStartDate = TheDateSearchClass.RemoveTime(datStartDate);
datEndDate = TheDateSearchClass.AddingDays(datStartDate, 1);
if (strVehicleNumber == "")
{
TheMessagesClass.ErrorMessage("Vehicle Number Was Not Entered");
return;
}
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("The Vehicle Number Entered Does Not Exist");
return;
}
else if (intRecordsReturned == 1)
{
intVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindVehiclesInYardByVehicleIDAndDateRangeDataSet = TheVehicleInYardClass.FindVehiclesInYardByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDate);
intRecordsReturned = TheFindVehiclesInYardByVehicleIDAndDateRangeDataSet.FindVehiclesInYardByVehicleIDAndDateRange.Rows.Count;
if (intRecordsReturned > 0)
{
TheMessagesClass.ErrorMessage("Vehicle Has Already Been Placed In The Yard");
return;
}
datTransactionDate = DateTime.Now;
blnFatalError = TheVehicleInYardClass.InsertVehicleInYard(datTransactionDate, intVehicleID);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("There Was a Problem, Contact IT");
return;
}
}
txtEnterVehicleNumber.Text = "";
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Vehicle In Yard // Process Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private bool VehicleAssignment()
{
//data validation
string strValueForValidation;
bool blnFatalError = false;
string strErrorMessage = "";
int intRecordsReturned;
int intTransactionID;
string strMessage;
string strCaption = "Thank You";
string strHomeOffice = "";
string strSecondVehicleNumber;
int intVehicleID;
int intWarehouseID;
try
{
gstrVehicleNumber = txtVehicleNumber.Text;
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(gstrVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
blnFatalError = true;
strErrorMessage += "Vehice Number Not Valid\n";
}
else
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
strHomeOffice = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].AssignedOffice;
}
strValueForValidation = cboSelectEmployee.SelectedItem.ToString();
if (strValueForValidation == "Select Employee")
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return(blnFatalError);
}
TheFindCurrentVehicleAssignmentByEmployeeIDDataSet = TheVehicleAssignmentClass.FindCurrentVehicleAssignmentByEmployeeID(MainWindow.gintEmployeeID);
intRecordsReturned = TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID.Rows.Count;
if (intRecordsReturned > 0)
{
if (TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].LastName != "WAREHOUSE")
{
intTransactionID = TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].TransactionID;
strMessage = "Employee Is Assigned To Vehicle Number " + TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].VehicleNumber + "\nDo You Want to Sign Out the Employee of " + TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].VehicleNumber;
MessageBoxResult result = MessageBox.Show(strMessage, strCaption, MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
intWarehouseID = FindWarehouseID(strHomeOffice);
strSecondVehicleNumber = TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].VehicleNumber;
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strSecondVehicleNumber);
intVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
blnFatalError = TheVehicleAssignmentClass.UpdateCurrentVehicleAssignment(intTransactionID, false);
if (blnFatalError == true)
{
throw new Exception();
}
blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(intVehicleID, intWarehouseID);
if (blnFatalError == true)
{
throw new Exception();
}
blnFatalError = TheVehicleAssignmentClass.InsertVehicleAssignment(intVehicleID, intWarehouseID);
if (blnFatalError == true)
{
throw new Exception();
}
}
else
{
blnFatalError = true;
return(blnFatalError);
}
}
}
blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(MainWindow.gintVehicleID, MainWindow.gintEmployeeID);
if (blnFatalError == true)
{
throw new Exception();
}
blnFatalError = TheVehicleAssignmentClass.InsertVehicleAssignment(MainWindow.gintVehicleID, MainWindow.gintEmployeeID);
if (blnFatalError == true)
{
throw new Exception();
}
intRecordsReturned = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID.Rows.Count;
if (intRecordsReturned == 1)
{
intTransactionID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].TransactionID;
blnFatalError = TheVehicleAssignmentClass.UpdateCurrentVehicleAssignment(intTransactionID, false);
if (blnFatalError == true)
{
throw new Exception();
}
}
txtEnterDate.Text = Convert.ToString(DateTime.Now);
TheMessagesClass.InformationMessage("The Record Has Been Saved");
txtVehicleNumber.Focus();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Daily Vehicle Data Entry // Vehicle Assignment // Process Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
blnFatalError = true;
}
return(blnFatalError);
}
private void mitSave_Click(object sender, RoutedEventArgs e)
{
string strVehicleNumber;
int intQuantity = 0;
string strValueForValidation;
bool blnFatalError = false;
bool blnThereIsAProblem = false;
int intRecordsReturned;
string strErrorMessage = "";
try
{
//data validation
strVehicleNumber = txtVehicleNumber.Text;
if (strVehicleNumber == "")
{
blnFatalError = true;
strErrorMessage = "Vehicle Number Was Not Addd\n";
}
else
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
blnFatalError = true;
strErrorMessage += "The Vehicle Number Entered was not Found\n";
}
else
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
}
if (cboSelectToolCategory.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "Tool Category Was Not Selected\n";
}
strValueForValidation = txtQuantity.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Quantity is not an Integer\n";
}
else
{
intQuantity = Convert.ToInt32(strValueForValidation);
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
//checking to see if the tool has been put in
TheFindVehicleBulkToolDataSet = TheVehicleBulkToolsClass.FindVehicleBulkTool(strVehicleNumber, MainWindow.gstrToolCategory);
intRecordsReturned = TheFindVehicleBulkToolDataSet.FindVehicleBulkTool.Rows.Count;
if (intRecordsReturned > 0)
{
TheMessagesClass.InformationMessage("The Vehicle Has This Tool Assgined Already, Please\nAdjust The Count on Edit Vehicle Bulk Tool");
return;
}
blnFatalError = TheVehicleBulkToolsClass.InsertVehicleBulkTools(MainWindow.gintVehicleID, MainWindow.gintCategoryID, intQuantity);
if (blnFatalError == true)
{
throw new Exception();
}
ClearVehicleControls();
TheMessagesClass.InformationMessage("The Tool Has Been Entered");
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Add Vehicle Bulk Tools // Save Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void txtVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
string strValueForValidation;
bool blnFatalError = false;
string strVehicleNumber;
int intLength;
int intRecordsReturned;
string strEmployeeGroup;
string strFullName;
try
{
strValueForValidation = txtEnterID.Text;
blnFatalError = TheDataValidationClass.VerifyIntegerData(strValueForValidation);
if (blnFatalError == true)
{
if (gblnRecordSaved == false)
{
TheMessagesClass.ErrorMessage("The Employee ID is not an Integer");
gblnRecordSaved = false;
return;
}
}
else
{
//getting warehouse id
gintWarehouseEmployeeID = Convert.ToInt32(strValueForValidation);
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(gintWarehouseEmployeeID);
intRecordsReturned = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("Employee ID Was Not Found");
return;
}
else
{
strEmployeeGroup = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmployeeGroup;
if (strEmployeeGroup != "WAREHOUSE")
{
if (strEmployeeGroup != "ADMIN")
{
if (strEmployeeGroup != "MANAGERS")
{
TheMessagesClass.ErrorMessage("Employee Is Not a Warehouse Employee");
return;
}
}
}
else
{
expAssignTask.IsEnabled = true;
}
}
}
strVehicleNumber = txtVehicleNumber.Text;
intLength = strVehicleNumber.Length;
if (intLength == 4)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(gintVehicleID);
gintEmployeeID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].EmployeeID;
strFullName = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].FirstName + " ";
strFullName += TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName;
txtCurrentEmployee.Text = strFullName;
txtEnterLastName.IsEnabled = true;
}
}
else if (intLength == 6)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("Vehicle Not Found");
return;
}
gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(gintVehicleID);
gintEmployeeID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].EmployeeID;
strFullName = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].FirstName + " ";
strFullName += TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName;
txtCurrentEmployee.Text = strFullName;
txtEnterLastName.IsEnabled = true;
}
else if (intLength > 6)
{
TheMessagesClass.ErrorMessage("Vehicle Is Not Formated Correctly");
return;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Daily Vehicle Data Entry // Main Window // Vehicle Number Text Box " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void txtEnterVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
//setting local variables
string strVehicleNumber;
int intLength;
int intRecordsReturned;
try
{
strVehicleNumber = txtEnterVehicleNumber.Text;
MainWindow.gstrVehicleNumber = strVehicleNumber;
intLength = strVehicleNumber.Length;
if (intLength == 4)
{
TheFindActivehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemsClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
dgrOpenProblems.ItemsSource = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID;
TheFindVehiclesInShopByVehlcleIDDataSet = TheVehiclesInShopClass.FindVehiclesInShopByVehicleID(MainWindow.gintVehicleID);
intRecordsReturned = TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID.Rows.Count;
if (intRecordsReturned > 0)
{
txtVehicleInyard.Text = "YES With " + TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID[0].VendorName;
}
else
{
txtVehicleInyard.Text = "Not In Shop";
}
}
}
else if (intLength == 6)
{
TheFindActivehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemsClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
dgrOpenProblems.ItemsSource = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID;
TheFindVehiclesInShopByVehlcleIDDataSet = TheVehiclesInShopClass.FindVehiclesInShopByVehicleID(MainWindow.gintVehicleID);
intRecordsReturned = TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID.Rows.Count;
if (intRecordsReturned > 0)
{
txtVehicleInyard.Text = "YES With " + TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID[0].VendorName;
}
else
{
txtVehicleInyard.Text = "Not In Shop";
}
}
else
{
TheMessagesClass.ErrorMessage("Vehicle Not Found");
return;
}
}
else if (intLength > 6)
{
TheMessagesClass.ErrorMessage("Vehicle Number Entered has to Many Characters");
return;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Update Vehicle Problem // Enter Vehicle Textbox " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private bool ProcessDailyVehicleInspection()
{
string strValueForValidation;
bool blnThereIsAProblem = false;
bool blnFatalError = false;
string strErrorMessage = "";
DateTime datTransactionDate = DateTime.Now;
int intRecordsReturned;
string strVehicleNumber;
try
{
strValueForValidation = txtEnterDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Date is not a Date\n";
}
else
{
datTransactionDate = Convert.ToDateTime(strValueForValidation);
}
strValueForValidation = txtEnterID.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strValueForValidation);
if (cboSelectEmployee.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
strVehicleNumber = txtVehicleNumber.Text;
if (strVehicleNumber.Length < 4)
{
blnFatalError = true;
strErrorMessage += "Vehicle Number is not Long Enough\n";
}
else
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned < 1)
{
blnFatalError = true;
strErrorMessage += "The Vehicle Was Not Found\n";
}
else
{
gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
}
strValueForValidation = txtOdometer.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Odometer is not a Integer\n";
}
else
{
gintOdometerReading = Convert.ToInt32(strValueForValidation);
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return(blnFatalError);
}
TheFindDailyVehicleInspectionForGPSDataSet = TheInspectionsClass.FindDailyVehicleInspectionForGPS(gintVehicleID, datTransactionDate, gintEmployeeID, gstrInspectionStatus, gintOdometerReading);
intRecordsReturned = TheFindDailyVehicleInspectionForGPSDataSet.FindDailyVehicleInspectionForGPS.Rows.Count;
if (intRecordsReturned > 0)
{
blnFatalError = true;
TheMessagesClass.ErrorMessage("This Inspection Has Been Entered\n");
return(blnFatalError);
}
if (gstrInspectionStatus == "PASSED")
{
TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemClass.FindOpenVehicleMainProblemsByVehicleID(gintVehicleID);
intRecordsReturned = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID.Rows.Count;
if (intRecordsReturned > 0)
{
blnFatalError = true;
TheMessagesClass.ErrorMessage("There are Open Vehicle Problems, The Inspection Will Not Be Processed");
return(blnFatalError);
}
}
blnFatalError = TheInspectionsClass.InsertDailyVehicleInspection(gintVehicleID, datTransactionDate, gintEmployeeID, gstrInspectionStatus, gintOdometerReading);
if (blnFatalError == true)
{
throw new Exception();
}
blnFatalError = TheVehicleHistoryClass.InsertVehicleHistory(gintVehicleID, gintEmployeeID, gintWarehouseEmployeeID);
if (blnFatalError == true)
{
throw new Exception();
}
TheFindDailyVehicleInspectionForGPSDataSet = TheInspectionsClass.FindDailyVehicleInspectionForGPS(gintVehicleID, datTransactionDate, gintEmployeeID, gstrInspectionStatus, gintOdometerReading);
gintInspectionID = TheFindDailyVehicleInspectionForGPSDataSet.FindDailyVehicleInspectionForGPS[0].TransactionID;
blnFatalError = TheInspectGPSClass.InsertInspectGPS(gintInspectionID, "DAILY", gblnGPSInstalled);
if (blnFatalError == true)
{
throw new Exception();
}
blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(gintVehicleID, gintEmployeeID);
if (blnFatalError == true)
{
throw new Exception();
}
if (gstrInspectionStatus == "PASSED SERVICE REQUIRED")
{
VehicleInspectionProblem VehicleInspectionProblem = new VehicleInspectionProblem();
VehicleInspectionProblem.ShowDialog();
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Daily Vehicle Data Entry // Main Window // Process Daily Vehicle Inspection " + Ex.Message);
blnFatalError = true;
}
return(blnFatalError);
}
private void txtEnterVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
int intLength;
string strVehicleNumber;
int intRecordsReturned;
try
{
strVehicleNumber = txtEnterVehicleNumber.Text;
intLength = strVehicleNumber.Length;
if (intLength == 4)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
dgrOpenProblems.ItemsSource = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID;
mitProcessProblem.IsEnabled = true;
}
}
if (intLength == 6)
{
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
dgrOpenProblems.ItemsSource = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID;
mitProcessProblem.IsEnabled = true;
}
else
{
TheMessagesClass.ErrorMessage("Vehicle Number Not Found");
return;
}
}
if (intLength > 6)
{
TheMessagesClass.ErrorMessage("To Many Characters for a Vehicle Number");
return;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // New Vehicle Problem // Enter Vehicle Number Text Change Event " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void mitProcess_Click(object sender, RoutedEventArgs e)
{
//this will process the information
string strValueForValidation;
bool blnFatalError = false;
bool blnThereIsAProblem = false;
string strErrorMessage = "";
string strVehicleNumber;
int intRecordsReturned;
try
{
strVehicleNumber = txtEnterBJCNumber.Text;
TheFindVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
blnFatalError = true;
strErrorMessage += "Vehicle Number Entered Was Not Found\n";
}
else
{
MainWindow.gintVehicleID = TheFindVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
strValueForValidation = cboEmployee.SelectedItem.ToString();
if (strValueForValidation == "Select Employee")
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
if (rdoFailed.IsChecked == false)
{
if (rdoPassed.IsChecked == false)
{
if (rdoPassedServiceRequired.IsChecked == false)
{
blnFatalError = true;
strErrorMessage += "Passed, Passed Service Required, or Failure Was Not Checked\n";
}
}
}
strValueForValidation = txtOdometerReading.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Odometer Reading is not an Integer\n";
}
else
{
MainWindow.gintOdometerReading = Convert.ToInt32(strValueForValidation);
}
if (cboVehicleCleanliness.SelectedIndex == 0)
{
blnFatalError = true;
strErrorMessage += "Cleanliness Was Not Selected\n";
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
MainWindow.gdatTransactionDate = DateTime.Now;
blnFatalError = TheWeeklyInspectionClass.InsertWeeklyVehicleInspection(MainWindow.gintVehicleID, MainWindow.gdatTransactionDate, MainWindow.gintEmployeeID, MainWindow.gstrInspectionStatus, MainWindow.gintOdometerReading);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("There Was a Problem, Contact ID");
return;
}
TheFindWeeklyVehicleInspectionIDDataSet = TheWeeklyInspectionClass.FindWeelyVehicleInspectionID(MainWindow.gintVehicleID, MainWindow.gintEmployeeID, MainWindow.gintOdometerReading, MainWindow.gdatTransactionDate);
MainWindow.gintInspectionID = TheFindWeeklyVehicleInspectionIDDataSet.FindWeeklyVehicleInspectionID[0].TransactionID;
blnFatalError = TheWeeklyVehicleCleanlinessClass.InsertWeeklyVehicleCleanliness(MainWindow.gintInspectionID, MainWindow.gintVehicleID, gblnVehicleCleanliness, MainWindow.gstrCleanlinessNotes);
if (blnFatalError == true)
{
throw new Exception();
}
if ((rdoFailed.IsChecked == true) || (rdoPassedServiceRequired.IsChecked == true))
{
VehicleInspectionProblem VehicleInspectionProblem = new VehicleInspectionProblem();
VehicleInspectionProblem.ShowDialog();
}
else if (rdoPassed.IsChecked == true)
{
TheFindOpenVehicleProblemsbyVehicleIDDataSet = TheVehicleProblemClass.FindOpenVehicleProblemsbyVehicleID(MainWindow.gintVehicleID);
intRecordsReturned = TheFindOpenVehicleProblemsbyVehicleIDDataSet.FindOpenVehicleProblemsByVehicleID.Rows.Count;
if (intRecordsReturned > 0)
{
TheMessagesClass.ErrorMessage("There Are Open Problems with this Vehicle and\nYou Are Reporting No Problems, Please Correct");
return;
}
}
if (rdoFailed.IsChecked == true)
{
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
TheVehicleStatusClass.UpdateVehicleStatus(MainWindow.gintVehicleID, "DOWN", DateTime.Now);
TheSendEmailClass.EmailMessage(MainWindow.gstrVehicleNumber, MainWindow.gstrVehicleProblem);
PleaseWait.Close();
}
BulkToolsAssignedToVehicle BulkToolsAssignedToVehicle = new BulkToolsAssignedToVehicle();
BulkToolsAssignedToVehicle.ShowDialog();
txtEnterBJCNumber.Text = "";
cboEmployee.Items.Clear();
txtEnterLastName.Text = "";
txtOdometerReading.Text = "";
rdoFailed.IsChecked = false;
rdoPassed.IsChecked = false;
rdoPassedServiceRequired.IsChecked = false;
cboBodyDamageReported.SelectedIndex = 0;
cboVehicleCleanliness.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Manager Weekly Audit Data Entry // Process Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
