private void Window_Loaded(object sender, RoutedEventArgs e)
{
//setting up variables
int intCounter;
int intNumberOfRecords;
try
{
//setting up controls
cboMultipleProblems.Items.Add("Select");
cboMultipleProblems.Items.Add("Yes");
cboMultipleProblems.Items.Add("No");
cboMultipleProblems.SelectedIndex = 0;
cboNewProblem.Items.Add("Select");
cboNewProblem.Items.Add("Yes");
cboNewProblem.Items.Add("No");
cboNewProblem.SelectedIndex = 0;
dgrResults.IsEnabled = false;
MainWindow.gintProblemID = -1;
TheFindOpenTrailerProblemsByTrailerIDDataSet = TheTrailerProblemClass.FindOpenTrailerProblemsByTrailerID(MainWindow.gintTrailerID);
intNumberOfRecords = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID.Rows.Count - 1;
gintWarehouseEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID;
MainWindow.gstrInspectionProblem = "";
if (intNumberOfRecords < 0)
{
cboNewProblem.SelectedIndex = 1;
cboNewProblem.IsEnabled = false;
dgrResults.IsEnabled = false;
}
else
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
ExistingTrailerProblemsDataSet.existingtrailerproblemsRow NewProblemRow = TheExistingTrailerProblemsDataSet.existingtrailerproblems.NewexistingtrailerproblemsRow();
NewProblemRow.ProblemID = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].ProblemID;
NewProblemRow.ProblemReported = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].ProblemReported;
NewProblemRow.TransactionDate = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].TransactionDate;
TheExistingTrailerProblemsDataSet.existingtrailerproblems.Rows.Add(NewProblemRow);
}
}
dgrResults.ItemsSource = TheExistingTrailerProblemsDataSet.existingtrailerproblems;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Inspection Trailer Problems // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
public FindOpenTrailerProblemsByTrailerIDDataSet FindOpenTrailerProblemsByTrailerID(int intTrailerID)
{
try
{
aFindOpenTrailerProblemsByTrailerIDDataSet = new FindOpenTrailerProblemsByTrailerIDDataSet();
aFindOpenTrailerProblemsByTrailerIDTableAdapter = new FindOpenTrailerProblemsByTrailerIDDataSetTableAdapters.FindOpenTrailerProblemByTrailerIDTableAdapter();
aFindOpenTrailerProblemsByTrailerIDTableAdapter.Fill(aFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID, intTrailerID);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Trailer Problems Class // Find Open Trailer Problems By Trailer ID " + Ex.Message);
}
return(aFindOpenTrailerProblemsByTrailerIDDataSet);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
int intCounter;
int intNumberOfRecords;
try
{
cboNewProblem.Items.Add("Select");
cboNewProblem.Items.Add("Yes");
cboNewProblem.Items.Add("No");
cboNewProblem.SelectedIndex = 0;
dgrCurrentProblems.IsEnabled = false;
MainWindow.gintProblemID = -1;
TheFindOpenTrailerProblemsByTrailerIDDataSet = TheTrailerProblemClass.FindOpenTrailerProblemsByTrailerID(MainWindow.gintTrailerID);
intNumberOfRecords = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID.Rows.Count - 1;
if (intNumberOfRecords < 0)
{
cboNewProblem.SelectedIndex = 1;
cboNewProblem.IsEnabled = false;
dgrCurrentProblems.IsEnabled = false;
}
else
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
ExistingTrailerProblemsDataSet.existingtrailerproblemsRow NewProblemRow = TheExistingTrailerProblemsDataSet.existingtrailerproblems.NewexistingtrailerproblemsRow();
NewProblemRow.ProblemID = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].ProblemID;
NewProblemRow.ProblemReported = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].ProblemReported;
NewProblemRow.TransactionDate = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].TransactionDate;
TheExistingTrailerProblemsDataSet.existingtrailerproblems.Rows.Add(NewProblemRow);
}
}
dgrCurrentProblems.ItemsSource = TheExistingTrailerProblemsDataSet.existingtrailerproblems;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Daily Vehicle Data Entry // Trailer Inspection Problems // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
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 btnFind_Click(object sender, RoutedEventArgs e)
{
string strTrailerNumber;
int intRecordsReturned;
int intCounter;
int intNumberOfRecords;
string strFullName;
try
{
strTrailerNumber = txtEnterTrailerNumber.Text;
TheOpenTrailerProblemsDataSet.opentrailerproblems.Rows.Clear();
if (strTrailerNumber.Length < 4)
{
TheMessagesClass.ErrorMessage("The Trailer Number is to Short");
return;
}
TheFindTrailerByTrailerNumberDataSet = TheTrailersClass.FindTrailerByTrailerNumber(strTrailerNumber);
intRecordsReturned = TheFindTrailerByTrailerNumberDataSet.FindTrailerByTrailerNumber.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage("The Trailer Was Not Found");
return;
}
MainWindow.gintTrailerID = TheFindTrailerByTrailerNumberDataSet.FindTrailerByTrailerNumber[0].TrailerID;
TheFindOpenTrailerProblemsByTrailerIDDataSet = TheTrailerProblemClass.FindOpenTrailerProblemsByTrailerID(MainWindow.gintTrailerID);
intNumberOfRecords = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strFullName = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].FirstName + " ";
strFullName += TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].LastName;
OpenTrailerProblemsDataSet.opentrailerproblemsRow NewProblemRow = TheOpenTrailerProblemsDataSet.opentrailerproblems.NewopentrailerproblemsRow();
NewProblemRow.Employee = strFullName;
NewProblemRow.ProblemID = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].ProblemID;
NewProblemRow.ReportedProblem = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].ProblemReported;
NewProblemRow.TransactionDate = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID[intCounter].TransactionDate;
TheOpenTrailerProblemsDataSet.opentrailerproblems.Rows.Add(NewProblemRow);
}
}
dgrProblems.ItemsSource = TheOpenTrailerProblemsDataSet.opentrailerproblems;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Update Trailer Problems // Find Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void expProcess_Expanded(object sender, RoutedEventArgs e)
{
//setting local variables
bool blnFatalError = false;
DateTime datTransactionDate = DateTime.Now;
string strTrailerProblem;
string strErrorMessage = "";
int intTrailerProblemLength;
try
{
if (cboNewProblem.SelectedIndex == 0)
{
blnFatalError = true;
strErrorMessage += "New Problem Was Not Selected\n";
}
strTrailerProblem = txtEnterProblem.Text;
intTrailerProblemLength = strTrailerProblem.Length;
if (intTrailerProblemLength < 10)
{
blnFatalError = true;
strErrorMessage += "The Problem Entered Is Not Long Enough\n";
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
if (cboNewProblem.SelectedIndex == 1)
{
blnFatalError = TheTrailerProblemClass.InsertTrailerProblem(MainWindow.gintTrailerID, datTransactionDate, MainWindow.gintWarehouseEmployeeID, strTrailerProblem, 1001);
if (blnFatalError == true)
{
throw new Exception();
}
TheFindTrailerProblemByDateMatchDataSet = TheTrailerProblemClass.FindTrailerProblemByDateMatch(datTransactionDate);
MainWindow.gintProblemID = TheFindTrailerProblemByDateMatchDataSet.FindTrailerProblemByDateMatch[0].ProblemID;
}
if (MainWindow.gintProblemID == -1)
{
TheMessagesClass.ErrorMessage("A Problem was not Selected");
return;
}
blnFatalError = TheTrailerProblemUpdateClass.InsertTrailerProblemUpdate(MainWindow.gintProblemID, MainWindow.gintWarehouseEmployeeID, strTrailerProblem);
if (blnFatalError == true)
{
throw new Exception();
}
TheMessagesClass.InformationMessage("Problem Was Entered");
MainWindow.gstrInspectionProblem += strTrailerProblem + "\n";
MainWindow.gintProblemID = 0;
txtEnterProblem.Text = "";
TheFindOpenTrailerProblemsByTrailerIDDataSet = TheTrailerProblemClass.FindOpenTrailerProblemsByTrailerID(MainWindow.gintTrailerID);
dgrCurrentProblems.ItemsSource = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID;
cboNewProblem.IsEnabled = true;
cboNewProblem.SelectedIndex = 0;
Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay Communications // Inspection Trailer Problem // Process Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
TheFindOpenTrailerProblemsByTrailerIDDataSet = TheTrailerProblemClass.FindOpenTrailerProblemsByTrailerID(MainWindow.gintTrailerID);
dgrResults.ItemsSource = TheFindOpenTrailerProblemsByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID;
}
