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