private void btnFind_Click(object sender, RoutedEventArgs e) { //setting local variables string strPartNumber; int intRecordsReturned; try { //data validation strPartNumber = txtEnterPartNumber.Text; if (strPartNumber == "") { TheMessagesClass.ErrorMessage("Part Number Was Not Entered"); return; } //checking to see if the part number exists within the part table //checking JDE Part Number TheFindPartByJDEPartNumberDataSet = ThePartNumberClass.FindPartByJDEPartNumber(strPartNumber); intRecordsReturned = TheFindPartByJDEPartNumberDataSet.FindPartByJDEPartNumber.Rows.Count; if (intRecordsReturned > 0) { TheMessagesClass.InformationMessage("The Part Currently Exists Within The Part Number Table"); return; } //checking part number TheFindPartByPartNumberDataSet = ThePartNumberClass.FindPartByPartNumber(strPartNumber); intRecordsReturned = TheFindPartByPartNumberDataSet.FindPartByPartNumber.Rows.Count; if (intRecordsReturned > 0) { TheMessagesClass.InformationMessage("The Part Currently Exists Within The Part Number Table"); return; } TheFindPartFromMasterPartListByJDEPartNumberDataSet = ThePartNumberClass.FindPartFromMasterPartListByJDEPartNumber(strPartNumber); intRecordsReturned = TheFindPartFromMasterPartListByJDEPartNumberDataSet.FindPartFromMasterPartListByJDEPartNumber.Rows.Count; if (intRecordsReturned == 0) { TheFindPartFromMasterPartListByPartNumberDataSet = ThePartNumberClass.FindPartFromMasterPartListByPartNumber(strPartNumber); intRecordsReturned = TheFindPartFromMasterPartListByPartNumberDataSet.FindPartFromMasterPartListByPartNumber.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.ErrorMessage("The Part Number Entered is not in the Master Part List"); return; } else { txtDescription.Text = TheFindPartFromMasterPartListByPartNumberDataSet.FindPartFromMasterPartListByPartNumber[0].PartDescription; txtJDEPartNumber.Text = TheFindPartFromMasterPartListByPartNumberDataSet.FindPartFromMasterPartListByPartNumber[0].JDEPartNumber; txtPartID.Text = Convert.ToString(TheFindPartFromMasterPartListByPartNumberDataSet.FindPartFromMasterPartListByPartNumber[0].PartID); txtPartNumber.Text = TheFindPartFromMasterPartListByPartNumberDataSet.FindPartFromMasterPartListByPartNumber[0].PartNumber; txtPrice.Text = Convert.ToString(TheFindPartFromMasterPartListByPartNumberDataSet.FindPartFromMasterPartListByPartNumber[0].Price); } } else { txtDescription.Text = TheFindPartFromMasterPartListByJDEPartNumberDataSet.FindPartFromMasterPartListByJDEPartNumber[0].PartDescription; txtJDEPartNumber.Text = TheFindPartFromMasterPartListByJDEPartNumberDataSet.FindPartFromMasterPartListByJDEPartNumber[0].JDEPartNumber; txtPartID.Text = Convert.ToString(TheFindPartFromMasterPartListByJDEPartNumberDataSet.FindPartFromMasterPartListByJDEPartNumber[0].PartID); txtPartNumber.Text = TheFindPartFromMasterPartListByJDEPartNumberDataSet.FindPartFromMasterPartListByJDEPartNumber[0].PartNumber; txtPrice.Text = Convert.ToString(TheFindPartFromMasterPartListByJDEPartNumberDataSet.FindPartFromMasterPartListByJDEPartNumber[0].Price); } } catch (Exception Ex) { TheEventlogClass.InsertEventLogEntry(DateTime.Now, "Add Parts Part From Master List Find Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void mitSave_Click(object sender, RoutedEventArgs e) { //setting local variables string strPartNumber; int intRecordsReturned; bool blnFatalError = false; try { //data validation strPartNumber = txtEnterPartNumber.Text; if (strPartNumber == "") { TheMessagesClass.ErrorMessage("Part Number Was Not Entered"); return; } //checking to see if the part number exists within the part table //checking JDE Part Number TheFindPartByJDEPartNumberDataSet = ThePartNumberClass.FindPartByJDEPartNumber(strPartNumber); intRecordsReturned = TheFindPartByJDEPartNumberDataSet.FindPartByJDEPartNumber.Rows.Count; if (intRecordsReturned > 0) { TheMessagesClass.InformationMessage("The Part Currently Exists Within The Part Number Table"); return; } //checking part number TheFindPartByPartNumberDataSet = ThePartNumberClass.FindPartByPartNumber(strPartNumber); intRecordsReturned = TheFindPartByPartNumberDataSet.FindPartByPartNumber.Rows.Count; if (intRecordsReturned > 0) { TheMessagesClass.InformationMessage("The Part Currently Exists Within The Part Number Table"); return; } TheFindPartFromMasterPartListByJDEPartNumberDataSet = ThePartNumberClass.FindPartFromMasterPartListByJDEPartNumber(strPartNumber); intRecordsReturned = TheFindPartFromMasterPartListByJDEPartNumberDataSet.FindPartFromMasterPartListByJDEPartNumber.Rows.Count; if (intRecordsReturned == 0) { TheFindPartFromMasterPartListByPartNumberDataSet = ThePartNumberClass.FindPartFromMasterPartListByPartNumber(strPartNumber); intRecordsReturned = TheFindPartFromMasterPartListByPartNumberDataSet.FindPartFromMasterPartListByPartNumber.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.ErrorMessage("The Part Number Entered is not in the Master Part List"); return; } } blnFatalError = ThePartNumberClass.InsertPartIntoPartNumbers(Convert.ToInt32(txtPartID.Text), txtPartNumber.Text, txtJDEPartNumber.Text, txtDescription.Text, float.Parse(txtPrice.Text)); if (blnFatalError == true) { throw new Exception(); } TheMessagesClass.InformationMessage("The Part Number Has Been Added"); ClearControls(); } catch (Exception Ex) { TheEventlogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Add Part From Master List // Save Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void mitSave_Click(object sender, RoutedEventArgs e) { //setting local variables bool blnFatalError = false; bool blnThereIsAProblem = false; string strErrorMessage = ""; string strValueForValidation; string strPartNumber; string strJDEPartNumber; string strDescription; string strCharterPart; double douPrice = 0; int intRecordsReturned; try { //beginning data validation strPartNumber = txtPartNumber.Text; if (strPartNumber == "") { strErrorMessage += "The Part Number Was Not Entered\n"; blnFatalError = true; } strJDEPartNumber = txtJDEPartNumber.Text; if (strJDEPartNumber == "") { strErrorMessage += "The JDE Part Number Was Not Entered\n"; blnFatalError = true; } strDescription = txtDescription.Text; if (strDescription == "") { blnFatalError = true; strErrorMessage += "The Description Was Not Entered\n"; } strCharterPart = txtCharter.Text; blnThereIsAProblem = TheDataValidationClass.VerifyYesNoData(strCharterPart); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Charter Part in not a Yes or No\n"; } strValueForValidation = txtPrice.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDoubleData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Price is not a Valid Format\n"; } else { douPrice = Convert.ToDouble(strValueForValidation); } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } //checking to see if the part number exists TheFindPartByPartNumberDataSet = ThePartNumberClass.FindPartByPartNumber(strPartNumber); intRecordsReturned = TheFindPartByPartNumberDataSet.FindPartByPartNumber.Rows.Count; if (intRecordsReturned > 0) { TheMessagesClass.ErrorMessage("Part Number Exists"); return; } if (strJDEPartNumber != "NOT REQUIRED") { TheFindPartByJDEPartNumberDataSet = ThePartNumberClass.FindPartByJDEPartNumber(strJDEPartNumber); if (intRecordsReturned > 0) { TheMessagesClass.ErrorMessage("JDE Part Number Exists"); return; } } //searching the master parts list TheFindPartFromMasterPartListByPartNumberDataSet = ThePartNumberClass.FindPartFromMasterPartListByPartNumber(strPartNumber); intRecordsReturned = TheFindPartFromMasterPartListByPartNumberDataSet.FindPartFromMasterPartListByPartNumber.Rows.Count; if (intRecordsReturned > 0) { TheMessagesClass.ErrorMessage("Part Number Exists with the Master Part List Table"); return; } if (strJDEPartNumber != "NOT REQUIRED") { TheFindPartFromMasterPartLitByJDEPartNumberDataSet = ThePartNumberClass.FindPartFromMasterPartListByJDEPartNumber(strJDEPartNumber); if (intRecordsReturned > 0) { TheMessagesClass.ErrorMessage("JDE Part Number Exists within the Master Part List"); return; } } //saving the record blnFatalError = ThePartNumberClass.InsertPartIntoPartNumbers(-1, strPartNumber, strJDEPartNumber, strDescription, float.Parse(txtPrice.Text)); if (blnFatalError == true) { throw new Exception(); } ClearControls(); SetControlsReadOnly(true); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Add Part // Save Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }