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());
}
}
