private void Window_Loaded(object sender, RoutedEventArgs e)
{
try
{
TheFindVehicleProblemByProblemIDDataSet = TheVehicleProblemClass.FindVehicleMainProblemByProblemID(MainWindow.gintProblemID);
txtVehicleProblem.Text = TheFindVehicleProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].Problem;
txtVehicleNumber.Text = TheFindVehicleProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].VehicleNumber;
TheFindVehicleProblemDocumentationByProblemIDDataSet = TheVehicleProblemDocumentClass.FindVehicleProblemDocumentationByProblemID(MainWindow.gintProblemID);
dgrResults.ItemsSource = TheFindVehicleProblemDocumentationByProblemIDDataSet.FindVehicleProblemDocumentationByProblemID;
cboSelectDocumentType.Items.Add("Select Document Type");
cboSelectDocumentType.Items.Add("DOCUMENT");
cboSelectDocumentType.Items.Add("PICTURE");
cboSelectDocumentType.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Load View Vehicle Problem Documentation // Window Loaded " + 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 BtnUploadDocument_Click(object sender, RoutedEventArgs e)
{
//setting local variables
DateTime datTransactionDate = DateTime.Now;
string strDocumentPath = "";
string strDocumentType;
bool blnRightFormat = false;
long intResult;
string strNewLocation = "";
string strTransactionName;
bool blnFatalError;
string strVehicleNumber;
string strProblem;
try
{
strDocumentType = cboSelectDocumentType.SelectedItem.ToString();
strVehicleNumber = TheFindVehicleProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].VehicleNumber;
strProblem = TheFindVehicleProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].Problem;
strTransactionName = strVehicleNumber + " " + strProblem + " ";
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.FileName = "Document"; // Default file name
// Show open file dialog box
Nullable <bool> result = dlg.ShowDialog();
// Process open file dialog box results
if (result == true)
{
// Open document
strDocumentPath = dlg.FileName.ToUpper();
}
else
{
return;
}
if (strDocumentPath.Contains("JPG"))
{
if (gstrDocumentType == "PICTURE")
{
blnRightFormat = true;
}
}
else if (strDocumentPath.Contains("PDF"))
{
if (gstrDocumentType == "DOCUMENT")
{
blnRightFormat = true;
}
}
if (blnRightFormat == false)
{
TheMessagesClass.ErrorMessage("File Type is not Correct");
return;
}
if (strDocumentType == "DOCUMENT")
{
datTransactionDate = DateTime.Now;
intResult = datTransactionDate.Year * 10000000000 + datTransactionDate.Month * 100000000 + datTransactionDate.Day * 1000000 + datTransactionDate.Hour * 10000 + datTransactionDate.Minute * 100 + datTransactionDate.Second;
strTransactionName += Convert.ToString(intResult);
strNewLocation = "\\\\bjc\\shares\\Documents\\WAREHOUSE\\WhseTrac\\VehicleProblemFiles\\" + strTransactionName + ".pdf";
}
if (strDocumentType == "PICTURE")
{
datTransactionDate = DateTime.Now;
intResult = datTransactionDate.Year * 10000000000 + datTransactionDate.Month * 100000000 + datTransactionDate.Day * 1000000 + datTransactionDate.Hour * 10000 + datTransactionDate.Minute * 100 + datTransactionDate.Second;
strTransactionName += Convert.ToString(intResult);
strNewLocation = "\\\\bjc\\shares\\Documents\\WAREHOUSE\\WhseTrac\\VehicleProblemFiles\\" + strTransactionName + ".jpg";
}
System.IO.File.Copy(strDocumentPath, strNewLocation);
blnFatalError = TheVehicleProblemDocumentClass.InsertVehicleProblemDocumentation(datTransactionDate, MainWindow.gintVehicleID, MainWindow.gintProblemID, strDocumentType, strNewLocation);
if (blnFatalError == true)
{
throw new Exception();
}
TheFindVehicleProblemDocumentationByProblemIDDataSet = TheVehicleProblemDocumentClass.FindVehicleProblemDocumentationByProblemID(MainWindow.gintProblemID);
dgrResults.ItemsSource = TheFindVehicleProblemDocumentationByProblemIDDataSet.FindVehicleProblemDocumentationByProblemID;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Report Tool Problem // Add Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//setting local variables
int intCounter;
int intNumberOfRecords;
try
{
TheFindVehicleMainProblemByProblemIDDataSet = TheVehicleProblemClass.FindVehicleMainProblemByProblemID(MainWindow.gintProblemID);
txtProblemID.Text = Convert.ToString(TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].ProblemID);
txtProblem.Text = TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].Problem;
txtTransactionDate.Text = Convert.ToString(TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].TransactionDAte);
txtVendor.Text = TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].VendorName;
if (TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].IsInvoiceIDNull() == false)
{
gintInvoiceID = TheFindVehicleMainProblemByProblemIDDataSet.FindVehicleMainProblemByProblemID[0].InvoiceID;
}
else
{
gintInvoiceID = -1;
}
TheFindVehicleMainProblemUpdateByProblemIDDataSet = TheVehicleProblemClass.FindVehicleMainProblemUpdateByProblemID(MainWindow.gintProblemID);
intNumberOfRecords = TheFindVehicleMainProblemUpdateByProblemIDDataSet.FindVehicleMainProblemUpdateByProblemID.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
SelectedProblemUpdatesDataSet.selectedproblemupdatesRow NewUpdateRow = TheSelectedProblemUpdatesDataSet.selectedproblemupdates.NewselectedproblemupdatesRow();
NewUpdateRow.Date = TheFindVehicleMainProblemUpdateByProblemIDDataSet.FindVehicleMainProblemUpdateByProblemID[intCounter].TransactionDate;
NewUpdateRow.FirstName = TheFindVehicleMainProblemUpdateByProblemIDDataSet.FindVehicleMainProblemUpdateByProblemID[intCounter].FirstName;
NewUpdateRow.LastName = TheFindVehicleMainProblemUpdateByProblemIDDataSet.FindVehicleMainProblemUpdateByProblemID[intCounter].LastName;
NewUpdateRow.Updates = TheFindVehicleMainProblemUpdateByProblemIDDataSet.FindVehicleMainProblemUpdateByProblemID[intCounter].ProblemUpdate;
TheSelectedProblemUpdatesDataSet.selectedproblemupdates.Rows.Add(NewUpdateRow);
}
dgrProblemUpdates.ItemsSource = TheSelectedProblemUpdatesDataSet.selectedproblemupdates;
TheFindVehicleProblemDocumentationByProblemID = TheVehicleProblemDocumentClass.FindVehicleProblemDocumentationByProblemID(MainWindow.gintProblemID);
intNumberOfRecords = TheFindVehicleProblemDocumentationByProblemID.FindVehicleProblemDocumentationByProblemID.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
SelectedProblemDocumentationDataSet.problemdocumentationRow NewDocumentRow = TheSelectedProblemDocumentationDataSet.problemdocumentation.NewproblemdocumentationRow();
NewDocumentRow.Date = TheFindVehicleProblemDocumentationByProblemID.FindVehicleProblemDocumentationByProblemID[intCounter].TransactionDate;
NewDocumentRow.DocumentType = TheFindVehicleProblemDocumentationByProblemID.FindVehicleProblemDocumentationByProblemID[intCounter].DocumentType;
NewDocumentRow.DocumentPath = TheFindVehicleProblemDocumentationByProblemID.FindVehicleProblemDocumentationByProblemID[intCounter].DocumentPath;
TheSelectedProblemDocumentationDataSet.problemdocumentation.Rows.Add(NewDocumentRow);
}
}
TheFindVehicleByInvoiceIDDataSet = TheVehicleProblemDocumentClass.FindVehicleInvoiceByInvoiceID(gintInvoiceID);
intNumberOfRecords = TheFindVehicleByInvoiceIDDataSet.FindVehicleInvoiceByInvoiceID.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
SelectedProblemDocumentationDataSet.problemdocumentationRow NewDocumentRow = TheSelectedProblemDocumentationDataSet.problemdocumentation.NewproblemdocumentationRow();
NewDocumentRow.Date = TheFindVehicleByInvoiceIDDataSet.FindVehicleInvoiceByInvoiceID[intCounter].InvoiceDate;
NewDocumentRow.DocumentType = "INVOICE";
NewDocumentRow.DocumentPath = TheFindVehicleByInvoiceIDDataSet.FindVehicleInvoiceByInvoiceID[intCounter].InvoicePath;
TheSelectedProblemDocumentationDataSet.problemdocumentation.Rows.Add(NewDocumentRow);
}
}
dgrProblemDocumentation.ItemsSource = TheSelectedProblemDocumentationDataSet.problemdocumentation;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // View Selected Vehicle Problem // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}