private void submitData(QCDQESubmitData _submitData) { SqlConnection conn = new SqlConnection(holder.RepairConnectionString); SqlCommand cmd = new SqlCommand(_submitData.SubmitQuery, conn); try { var sLogString = "Attemping to submit the data with the following parameters to the TechnicianSubmission Table:\n"; conn.Open(); cmd.Parameters.AddWithValue("@quality", _submitData.QualityTech); cmd.Parameters.AddWithValue("@submissionStatus", _submitData.SubmissionStatus); cmd.Parameters.AddWithValue("@QCDQEComments", _submitData.QCDQEComments); cmd.Parameters.AddWithValue("@QCDQEDateSubmit", _submitData.QCDQEDateSubmit); cmd.ExecuteNonQuery(); conn.Close(); for (int i = 0; i < cmd.Parameters.Count; i++) { var paramName = cmd.Parameters[i].ToString(); if (string.IsNullOrEmpty(cmd.Parameters[i].Value.ToString())) { sLogString += paramName + ": N/A\n"; } else { sLogString += $"{paramName}: {cmd.Parameters[i].Value.ToString()}\n"; } } sVar.LogHandler.CreateLogAction(sLogString, csLogging.LogState.SUBMISSIONDETAILS); sVar.LogHandler.CreateLogAction("Submission Successful!", csLogging.LogState.NOTE); MessageBox.Show("The QC/DQE submission was successful.", "Success", MessageBoxButton.OK, MessageBoxImage.Information); resetForm(true); } catch (Exception ex) { if (conn != null) { conn.Close(); } MessageBox.Show("There was an issue submitting the data.\nError Message: " + ex.Message, "Submission Error", MessageBoxButton.OK, MessageBoxImage.Error); sVar.LogHandler.CreateLogAction($"Error attempting to submit the data.\nError Message: {ex.Message}\nStack Trace: {ex.StackTrace}", csLogging.LogState.ERROR); } }
private QCDQESubmitData prepDataForSubmission(string _submitStatus) { QCDQESubmitData _submitInfo = new QCDQESubmitData(); if ((bool)cbxScanSwitch.IsChecked) { _submitInfo.SubmitQuery = "UPDATE TechnicianSubmission SET Quality = @quality, SubmissionStatus = @submissionStatus, QCDQEComments = @QCDQEComments, QCDQEDateSubmitted = @QCDQEDateSubmit " + "WHERE ID = '" + ScannedUnitInformation.ID + "'"; } else { _submitInfo.SubmitQuery = "UPDATE TechnicianSubmission SET Quality = @quality, SubmissionStatus = @submissionStatus, QCDQEComments = @QCDQEComments, QCDQEDateSubmitted = @QCDQEDateSubmit " + "WHERE SaveID = '" + txtRepairBarcode.Text.TrimEnd() + "'"; } _submitInfo.QualityTech = prepTechForSubmission(); _submitInfo.QCDQEComments = prepareCommentsForSubmission(); _submitInfo.SubmissionStatus = _submitStatus; _submitInfo.QCDQEDateSubmit = DateTime.Now; return(_submitInfo); }
private void submitButtonClicks(string submissionStatus) { bool bCanSubmit = false; if (!string.IsNullOrEmpty(txtRepairBarcode.Text) && ScannedUnitInformation.LoadSuccessful) { if (ScannedUnitInformation.QCandDQEComments != null && !string.IsNullOrEmpty(new TextRange(rtbQCDQEComments.Document.ContentStart, rtbQCDQEComments.Document.ContentEnd).Text.ToString().Trim())) { string _qcComments = new TextRange(rtbQCDQEComments.Document.ContentStart, rtbQCDQEComments.Document.ContentEnd).Text.ToString().Trim(); if (_qcComments.Length != ScannedUnitInformation.QCandDQEComments.FullTechComments.Length) { bCanSubmit = true; } else { MessageBox.Show("Unable to submit. No new QC/DQE comments have been entered.", "Submission Criteria Not Met", MessageBoxButton.OK, MessageBoxImage.Information); bCanSubmit = false; } } else if (string.IsNullOrEmpty(new TextRange(rtbQCDQEComments.Document.ContentStart, rtbQCDQEComments.Document.ContentEnd).Text.ToString().Trim())) { MessageBox.Show("Unable to submit. No QC/DQE comments have been entered.", "Submission Criteria Not Met", MessageBoxButton.OK, MessageBoxImage.Information); } } else { if (!ScannedUnitInformation.LoadSuccessful) { MessageBox.Show("Unable to submit due to no unit being scanned in.", "Submission Criteria Not Met", MessageBoxButton.OK, MessageBoxImage.Information); } } if (bCanSubmit) { QCDQESubmitData sd = prepDataForSubmission(submissionStatus); submitData(sd); } }