public FindProjectByProjectNameDataSet FindProjectByProjectName(string strProjectName)
{
try
{
aFindProjectByProjectNameDataSet = new FindProjectByProjectNameDataSet();
aFindProjectByProjectNameTableAdpater = new FindProjectByProjectNameDataSetTableAdapters.FindProjectByProjectNameTableAdapter();
aFindProjectByProjectNameTableAdpater.Fill(aFindProjectByProjectNameDataSet.FindProjectByProjectName, strProjectName);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Project Class // Find Project By Project Name " + Ex.Message);
}
return(aFindProjectByProjectNameDataSet);
}
private void txtEnterProject_TextChanged(object sender, TextChangedEventArgs e)
{
string strProjectName;
int intLength;
strProjectName = txtEnterProject.Text;
intLength = strProjectName.Length;
if (intLength > 3)
{
TheFindProjectByProjectNameDataSet = TheProjectClass.FindProjectByProjectName(strProjectName);
dgrResults.ItemsSource = TheFindProjectByProjectNameDataSet.FindProjectByProjectName;
}
}
private void btnFind_Click(object sender, RoutedEventArgs e)
{
//setting up locak variables
string strProject;
int intRecordsReturned;
strProject = txtEnterProject.Text;
TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strProject);
intRecordsReturned = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID.Rows.Count;
if (intRecordsReturned > 0)
{
dgrResults.ItemsSource = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID;
}
else
{
TheFindProjectByProjectNameDataSet = TheProjectClass.FindProjectByProjectName(strProject);
dgrResults.ItemsSource = TheFindProjectByProjectNameDataSet.FindProjectByProjectName;
}
}
private void AddSaveRecord()
{
//setting local variables
string strPartNumber;
string strProject;
int intPartID = 0;
string strMSRNumber = "NOT REQUIRED";
string strValueForValidation;
int intQuantity = 0;
bool blnThereIsAProblem = false;
bool blnFatalError = false;
string strErrorMessage = "";
int intRecordsFound;
bool blnProjectNotFound = false;
bool blnPartNotFound = true;
bool blnKeyWordNotFound;
int intTotalQuantity;
int intProjectID = 0;
string strJDEPartNumber = "";
int intEmployeeID = 0;
int intEnterEmployeeID = 0;
try
{
if (btnAdd.Content.ToString() == "Add")
{
//loading controls
txtDateEntryComplete.Text = "NO";
txtDate.Text = Convert.ToString(DateTime.Now);
btnAdd.Content = "Save";
}
else
{
if (MainWindow.gstrMenuSelection == "Issue")
{
if (cboSelectEmployee.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "Employee Was Not Selected\n";
}
}
//data validation
strProject = txtProjectID.Text;
if (strProject == "")
{
blnFatalError = true;
strErrorMessage += "Project ID Was Not Entered\n";
}
else
{
TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strProject);
intRecordsFound = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID.Rows.Count;
if (intRecordsFound == 0)
{
TheFindProjectByProjectNameDataSet = TheProjectClass.FindProjectByProjectName(strProject);
intRecordsFound = TheFindProjectByProjectNameDataSet.FindProjectByProjectName.Rows.Count;
if (intRecordsFound == 0)
{
blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strProject);
if (blnThereIsAProblem == true)
{
blnProjectNotFound = true;
}
else
{
TheFindProjectByProjectIDDataSet = TheProjectClass.FindProjectByProjectID(Convert.ToInt32(strProject));
intRecordsFound = TheFindProjectByProjectIDDataSet.FindProjectByProjectID.Rows.Count;
if (intRecordsFound == 0)
{
blnProjectNotFound = true;
}
else
{
intProjectID = TheFindProjectByProjectIDDataSet.FindProjectByProjectID[0].ProjectID;
strProject = TheFindProjectByProjectIDDataSet.FindProjectByProjectID[0].AssignedProjectID;
}
}
}
else
{
strProject = TheFindProjectByProjectNameDataSet.FindProjectByProjectName[0].AssignedProjectID;
intProjectID = TheFindProjectByProjectNameDataSet.FindProjectByProjectName[0].ProjectID;
}
}
else
{
intProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID;
}
if (blnProjectNotFound == true)
{
blnFatalError = true;
strErrorMessage += "Project Was Not Found\n";
}
}
if (MainWindow.gstrMenuSelection == "Receive")
{
strMSRNumber = txtMSRPONumber.Text;
if (strMSRNumber == "")
{
blnFatalError = true;
strErrorMessage += "MSR or PO Number Was Not Entered\n";
}
else if (strMSRNumber == "NO MSR NUMBER PROVIDED")
{
blnFatalError = true;
strErrorMessage += "NO MSR NUMBER PROVIDED Cannot Be Entered\n";
}
}
strPartNumber = txtPartNumber.Text;
if (strPartNumber == "")
{
blnFatalError = true;
strErrorMessage += "Part Number Was Not Entered\n";
}
else
{
blnPartNotFound = true;
blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strPartNumber);
if (blnThereIsAProblem == false)
{
intPartID = Convert.ToInt32(strPartNumber);
TheFindPartByPartIDDataSet = ThePartNumberClass.FindPartByPartID(intPartID);
intRecordsFound = TheFindPartByPartIDDataSet.FindPartByPartID.Rows.Count;
if (intRecordsFound == 1)
{
blnPartNotFound = false;
strPartNumber = TheFindPartByPartIDDataSet.FindPartByPartID[0].PartNumber;
strJDEPartNumber = TheFindPartByPartIDDataSet.FindPartByPartID[0].JDEPartNumber;
}
}
if (blnPartNotFound == true)
{
TheFindPartByPartNumberDataSet = ThePartNumberClass.FindPartByPartNumber(strPartNumber);
intRecordsFound = TheFindPartByPartNumberDataSet.FindPartByPartNumber.Rows.Count;
if (intRecordsFound == 1)
{
blnPartNotFound = false;
intPartID = TheFindPartByPartNumberDataSet.FindPartByPartNumber[0].PartID;
strJDEPartNumber = TheFindPartByPartNumberDataSet.FindPartByPartNumber[0].JDEPartNumber;
}
if (blnPartNotFound == true)
{
TheFindPartByJDEPartNumber = ThePartNumberClass.FindPartByJDEPartNumber(strPartNumber);
intRecordsFound = TheFindPartByJDEPartNumber.FindPartByJDEPartNumber.Rows.Count;
if (intRecordsFound == 1)
{
blnPartNotFound = false;
intPartID = TheFindPartByJDEPartNumber.FindPartByJDEPartNumber[0].PartID;
strPartNumber = TheFindPartByJDEPartNumber.FindPartByJDEPartNumber[0].PartNumber;
strJDEPartNumber = TheFindPartByJDEPartNumber.FindPartByJDEPartNumber[0].JDEPartNumber;
}
}
}
if (MainWindow.gstrWarehouseName != "TRAINING")
{
//checking to see if non charter number
blnKeyWordNotFound = TheKeyWordClass.FindKeyWord("JH", MainWindow.gstrWarehouseName);
if (blnKeyWordNotFound == true)
{
if (strJDEPartNumber == "NOT REQUIRED")
{
blnFatalError = true;
strErrorMessage += "Using Non Charter Part Number for Charter Warehouse\n";
}
if (strJDEPartNumber == "NOT PROVIDED")
{
blnFatalError = true;
strErrorMessage += "Using Non Charter Part Number for Charter Warehouse\n";
}
}
}
if (blnPartNotFound == true)
{
blnFatalError = true;
strErrorMessage += "Part Number Not Found\n";
}
}
//validating the Quantity
strValueForValidation = txtQuantity.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Quantity Entered is not an Integer\n";
}
else
{
intQuantity = Convert.ToInt32(strValueForValidation);
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
//checking quantity for issuing
if (MainWindow.gstrMenuSelection == "Issue")
{
TheFindWarehouseInventoryPartDataSet = TheInventoryClass.FindWarehouseInventoryPart(intPartID, MainWindow.gintWarehouseID);
intRecordsFound = TheFindWarehouseInventoryPartDataSet.FindWarehouseInventoryPart.Rows.Count;
if (intRecordsFound == 0)
{
intTotalQuantity = 0;
}
else
{
intTotalQuantity = TheFindWarehouseInventoryPartDataSet.FindWarehouseInventoryPart[0].Quantity;
}
intTotalQuantity = CalculateWIPCount(intPartID, MainWindow.gintWarehouseID, intTotalQuantity);
if (intQuantity > intTotalQuantity)
{
TheMessagesClass.ErrorMessage("The Quantity Issued is greater than the Quantity On The Shelf");
return;
}
}
if (MainWindow.gstrMenuSelection == "Issue")
{
intEmployeeID = gintSelectedEmployeeID;
intEnterEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID;
}
else
{
intEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID;
}
blnFatalError = TheInventoryWIPClass.InsertDataEntryWIP(MainWindow.gintSessionID, intPartID, strPartNumber, intProjectID, strProject, strMSRNumber, MainWindow.gintWarehouseID, intQuantity, intEmployeeID, MainWindow.gstrMenuSelection.ToUpper());
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("There Has Been A Problem. Contact IT");
return;
}
ClearControls();
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Enter Inventory \\ Enter Material \\ Add Button During Save " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void mitSave_Click(object sender, RoutedEventArgs e)
{
string strAssignedProjectID;
string strProjectName;
bool blnFatalError = false;
string strErrorMessage = "";
int intRecordsReturned;
bool blnDIDExists;
bool blnNameExists;
try
{
//beginning data validation
strAssignedProjectID = txtAssignedProjectID.Text;
strProjectName = txtProjectName.Text;
blnDIDExists = false;
blnNameExists = false;
if (strAssignedProjectID == "")
{
blnFatalError = true;
strErrorMessage += "The Assigned Project ID Was Not Entered\n";
}
if (strProjectName == "")
{
blnFatalError = true;
strErrorMessage += "The Project Name Was Not Entered\n";
}
else
{
TheFindProjectByProjectNameDataSet = TheProjectClass.FindProjectByProjectName(strProjectName);
intRecordsReturned = TheFindProjectByProjectNameDataSet.FindProjectByProjectName.Rows.Count;
if (intRecordsReturned > 0)
{
blnNameExists = true;
}
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strAssignedProjectID);
intRecordsReturned = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID.Rows.Count;
if (intRecordsReturned > 0)
{
blnDIDExists = true;
}
if ((blnDIDExists == true) && (blnNameExists == true))
{
TheMessagesClass.ErrorMessage("This Project Currently Exists");
return;
}
blnFatalError = TheProjectClass.InsertProject(strAssignedProjectID, strProjectName);
if (blnFatalError == true)
{
throw new Exception();
}
TheMessagesClass.InformationMessage("The Project Has Been Saved");
txtAssignedProjectID.Text = "";
txtProjectName.Text = "";
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Add Project // Save Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
