public FindActiveTrailerByTrailerNumberDataSet FindActiveTrailerByTrailerNumber(string strTrailerNumber)
{
try
{
aFindActiveTrailerByTrailerNumberDataSet = new FindActiveTrailerByTrailerNumberDataSet();
aFindActiveTrailerByTrailerNumberTableAdapter = new FindActiveTrailerByTrailerNumberDataSetTableAdapters.FindActiveTrailerByTrailerNumberTableAdapter();
aFindActiveTrailerByTrailerNumberTableAdapter.Fill(aFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber, strTrailerNumber);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Trailers Class // Find Active Trailer By Trailer Number " + Ex.Message);
}
return(aFindActiveTrailerByTrailerNumberDataSet);
}
private void btnFind_Click(object sender, RoutedEventArgs e)
{
string strTrailerNumber;
int intRecordsReturned;
string strFullName;
try
{
strTrailerNumber = txtEnterTrailerNumber.Text;
if (strTrailerNumber == "")
{
TheMessagesClass.ErrorMessage("Trailer Number Was Not Entered");
return;
}
TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber);
intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("Trailer Not Found");
return;
}
MainWindow.gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID;
txtTrailerDescription.Text = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerDescription;
txtTrailerID.Text = Convert.ToString(MainWindow.gintTrailerID);
txtTrailerNotes.Text = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerNotes;
strFullName = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].FirstName + " ";
strFullName += TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].LastName;
txtEmployeeName.Text = strFullName;
TheFindOpenTrailerProblemByTrailerIDDataSet = TheTrailerProblemClass.FindOpenTrailerProblemsByTrailerID(MainWindow.gintTrailerID);
dgrResults.ItemsSource = TheFindOpenTrailerProblemByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Update Trailer Problem // Find Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void btnProcess_Click(object sender, RoutedEventArgs e)
{
//setting up variables
string strTrailerNumber;
int intRecordsReturned;
bool blnFatalError = false;
try
{
strTrailerNumber = txtEnterTrailerNumber.Text;
if (strTrailerNumber == "")
{
TheMessagesClass.ErrorMessage("Trailer Number Not Found");
return;
}
TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber);
intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("The Trailer Was Not Found");
return;
}
MainWindow.gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID;
blnFatalError = TheTrailersInYardClass.InsertTrailerInYard(MainWindow.gintTrailerID);
if (blnFatalError == true)
{
throw new Exception();
}
txtEnterTrailerNumber.Text = "";
txtEnterTrailerNumber.Focus();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Trailers In Yard // Process Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void TxtEnterTrailerNumber_TextChanged(object sender, TextChangedEventArgs e)
{
string strTrailerNumber;
int intLength;
int intRecordsReturned;
try
{
strTrailerNumber = txtEnterTrailerNumber.Text;
intLength = strTrailerNumber.Length;
if (intLength == 4)
{
TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber);
intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count;
if (intRecordsReturned > 0)
{
LoadTrailerInformation();
}
}
else if (intLength == 6)
{
TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber);
intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("The Trailer Was Not Found");
return;
}
}
cboSelectVendor.IsEnabled = true;
btnCheckOpenProblems.IsEnabled = true;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Create Trailer Problem // Enter Trailer Number Textbox " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void mitImportExcel_Click(object sender, RoutedEventArgs e)
{
Excel.Application xlDropOrder;
Excel.Workbook xlDropBook;
Excel.Worksheet xlDropSheet;
Excel.Range range;
int intColumnRange = 0;
int intCounter;
int intNumberOfRecords;
int intRecordsReturned;
try
{
TheNewTrailerDataSet.newtrailers.Rows.Clear();
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.FileName = "Document"; // Default file name
dlg.DefaultExt = ".xlsx"; // Default file extension
dlg.Filter = "Excel (.xlsx)|*.xlsx"; // Filter files by extension
// Show open file dialog box
Nullable <bool> result = dlg.ShowDialog();
// Process open file dialog box results
if (result == true)
{
// Open document
string filename = dlg.FileName;
}
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
xlDropOrder = new Excel.Application();
xlDropBook = xlDropOrder.Workbooks.Open(dlg.FileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlDropSheet = (Excel.Worksheet)xlDropOrder.Worksheets.get_Item(1);
range = xlDropSheet.UsedRange;
intNumberOfRecords = range.Rows.Count;
intColumnRange = range.Columns.Count;
for (intCounter = 2; intCounter <= intNumberOfRecords; intCounter++)
{
gstrTrailerNumber = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2);
gstrTrailerNumber = gstrTrailerNumber.Substring(4);
TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(gstrTrailerNumber);
intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count;
if (intRecordsReturned == 0)
{
gstrAssignedOffice = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper();
gstrTrailerDescription = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper();
gstrTrailerCategory = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper();
gstrLicensePlate = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper();
gstrVINNumber = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper();
gintLocationID = FindLocationID(gstrAssignedOffice);
TheFindTrailerCategoryByCategoryDataSet = TheTrailerCategoryClass.FindTrailerCategoryByCategory(gstrTrailerCategory);
gintCategoryID = TheFindTrailerCategoryByCategoryDataSet.FindTrailerCategoryByCategory[0].CategoryID;
NewTrailerDataSet.newtrailersRow NewTrailerRow = TheNewTrailerDataSet.newtrailers.NewnewtrailersRow();
NewTrailerRow.CategoryID = gintCategoryID;
NewTrailerRow.LicensePlate = gstrLicensePlate;
NewTrailerRow.Location = gstrAssignedOffice;
NewTrailerRow.LocationID = gintLocationID;
NewTrailerRow.TrailerCategory = gstrTrailerCategory;
NewTrailerRow.TrailerDescription = gstrTrailerDescription;
NewTrailerRow.TrailerNumber = gstrTrailerNumber;
NewTrailerRow.VINNumber = gstrVINNumber;
TheNewTrailerDataSet.newtrailers.Rows.Add(NewTrailerRow);
}
}
PleaseWait.Close();
dgrTrailers.ItemsSource = TheNewTrailerDataSet.newtrailers;
mitSave.IsEnabled = true;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Import Trailers // Import Excel Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void txtTrailerNumber_TextChanged(object sender, TextChangedEventArgs e)
{
string strTrailerNumber;
int intLength;
int intRecordsReturned;
string strFullName;
try
{
strTrailerNumber = txtTrailerNumber.Text;
intLength = strTrailerNumber.Length;
if (intLength == 4)
{
TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber);
intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count;
if (intRecordsReturned > 0)
{
gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID;
strFullName = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].FirstName + " ";
strFullName += TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].LastName;
txtTrailerCurrentEmployee.Text = strFullName;
txtTrailerEnterLastName.IsEnabled = true;
}
else if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("Trailer Number Not Found");
return;
}
}
else if (intLength == 6)
{
TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber);
intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count;
if (intRecordsReturned > 0)
{
gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID;
strFullName = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].FirstName + " ";
strFullName += TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].LastName;
txtTrailerCurrentEmployee.Text = strFullName;
txtTrailerEnterLastName.IsEnabled = true;
}
else if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("Trailer Number Not Found");
return;
}
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Daily Vehicle Data Entry // Main Window // Trailer Number Text Box " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void txtEnterName_TextChanged(object sender, TextChangedEventArgs e)
{
string strEnteredData;
int intLength;
int intCounter;
int intNumberOfRecords;
try
{
strEnteredData = txtEnterName.Text;
intLength = strEnteredData.Length;
if (gblnTrailerNumber == true)
{
if ((intLength == 4) || (intLength >= 6))
{
TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strEnteredData);
intNumberOfRecords = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count;
if (intNumberOfRecords < 1)
{
TheMessagesClass.ErrorMessage("Trailer Was Not Found");
return;
}
MainWindow.gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID;
gstrTrailerNumber = strEnteredData;
}
}
else if (gblnEmployee == true)
{
if (intLength > 2)
{
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Employee");
TheComboEmployeeDataSet = TheEmployeeClass.FillEmployeeComboBox(strEnteredData);
intNumberOfRecords = TheComboEmployeeDataSet.employees.Rows.Count - 1;
if (intNumberOfRecords < 0)
{
TheMessagesClass.ErrorMessage("Employee Not Found");
return;
}
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectEmployee.Items.Add(TheComboEmployeeDataSet.employees[intCounter].FullName);
}
cboSelectEmployee.SelectedIndex = 0;
}
}
}
catch (Exception Ex)
{
TheEventLogclass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Daily Trailer Inspection Report // Enter Name Text Change " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
