private void addResults(string results, string technician) { LabTest.LabTest labtest = new LabTest.LabTest(); labtest.results = results; labtest.techID = technician; bool success = labtest.SubmitTestResults(labTestID, labtest, this); if (success == true) { CustomMessageBox cm = new CustomMessageBox("Successfully Submited Test Results", this, gotoLabTests); removeErrors(); ClearField(); cm.Show(); } }
public bool SubmitTestResults(int labTestID, LabTest labtest, Form form) { bool isSuccess = false; //Step 1: Create database connection string query, conn = new SqlConnection(myconnstring); try { string qry = @" UPDATE [PremiereCareHospital].[dbo].Lab_Test SET tech_id=@tech_id, results=@results, status_id=@status WHERE test_id = @labTestID "; cmd = new SqlCommand(qry, conn); cmd.Parameters.AddWithValue("@results", labtest.results); cmd.Parameters.AddWithValue("@tech_id", labtest.techID); cmd.Parameters.AddWithValue("@status", 2); cmd.Parameters.AddWithValue("@labTestID", labTestID); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } return(isSuccess); }
public bool CreateLabRequest(LabTest labtest, Form form) { bool isSuccess = false; //Step 1: Create database connection string query, conn = new SqlConnection(myconnstring); try { string qry = @"INSERT INTO [PremiereCareHospital].[dbo].Lab_Test (test_id, doc_id, appointment_id) VALUES(NEXT VALUE FOR lab_test_seq, @doctor, @appointment)"; cmd = new SqlCommand(qry, conn); cmd.Parameters.AddWithValue("@doctor", labtest.docID); cmd.Parameters.AddWithValue("@appointment", labtest.appointmentID); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } return(isSuccess); }