public void ModifyTestResults(TestResultdetails testresultdetails) { try { SqlConnection _sqlConnection = ConnectionHandler.GetConnection(); SqlCommand _sqlCommand = new SqlCommand(); _sqlCommand.CommandType = CommandType.Text; _sqlCommand.Connection = _sqlConnection; _sqlCommand.CommandText = "update MedicalTestHistory set servicedate=@servicedate,testresultdate=@testresultdate,diag1_normal_value=@diag1_normal_value,diag1_actual_value=@diag1_actual_value,diag2_normal_value=@diag2_normal_value,diag2_actual_value=@diag2_actual_value,diag3_normal_value=@diag3_normal_value,diag3_actual_value=@diag3_actual_value,diag4_normal_value=@diag4_normal_value,diag4_actual_value=@diag4_actual_value,diag5_normal_value=@diag5_normal_value,diag5_actual_value=@diag5_actual_value,diag6_normal_value=@diag6_normal_value,diag6_actual_value=@diag6_actual_value,doctor_comments=@doctor_comments,otherinfo=@otherinfo"; // _sqlCommand.Parameters.AddWithValue("@MedicareService", medicareservices.Medicare_service1); _sqlCommand.Parameters.AddWithValue("@servicedate", testresultdetails.Servicedate); _sqlCommand.Parameters.AddWithValue("@testresultdate", testresultdetails.Testresultdate); _sqlCommand.Parameters.AddWithValue("@diag1_normal_value", testresultdetails.Diag1_normal_value); _sqlCommand.Parameters.AddWithValue("@diag1_actual_value", testresultdetails.Diag1_actual_value); _sqlCommand.Parameters.AddWithValue("@diag2_normal_value", testresultdetails.Diag2_normal_value); _sqlCommand.Parameters.AddWithValue("@diag2_actual_value", testresultdetails.Diag2_actual_value); _sqlCommand.Parameters.AddWithValue("@diag3_normal_value", testresultdetails.Diag3_normal_value); _sqlCommand.Parameters.AddWithValue("@diag3_actual_value", testresultdetails.Diag3_actual_value); _sqlCommand.Parameters.AddWithValue("@diag4_normal_value", testresultdetails.Diag4_normal_value); _sqlCommand.Parameters.AddWithValue("@diag4_actual_value", testresultdetails.Diag4_actual_value); _sqlCommand.Parameters.AddWithValue("@diag5_normal_value", testresultdetails.Diag5_normal_value); _sqlCommand.Parameters.AddWithValue("@diag5_actual_value", testresultdetails.Diag5_actual_value); _sqlCommand.Parameters.AddWithValue("@diag6_normal_value", testresultdetails.Diag6_normal_value); _sqlCommand.Parameters.AddWithValue("@diag6_actual_value", testresultdetails.Diag6_actual_value); _sqlCommand.Parameters.AddWithValue("@doctor_comments", testresultdetails.Doctor_comments); _sqlCommand.Parameters.AddWithValue("@otherinfo", testresultdetails.Otherinfo); } catch (Exception ex) { } }
protected void testresultssubmit_Click(object sender, EventArgs e) { BALAccounts Bal = new BALAccounts(); TestResultdetails testresultdetails = new TestResultdetails { PatientId1 = int.Parse(ddlpatient.SelectedItem.Value), Doctorid = int.Parse(ddldoctor.SelectedItem.Value), MedicareService = int.Parse(ddlmedicareservices.SelectedItem.Value), AgentId = int.Parse(ddlagent.SelectedItem.Value), Servicedate = txtservicedate.Text, Testresultdate = txttestresultdate.Text, Diag1_normal_value = txtdiag1_normal_value.Text, Diag1_actual_value = txtdiag1_actual_value.Text, Diag2_normal_value = txtdiag2_normal_value.Text, Diag2_actual_value = txtdiag2_actual_value.Text, Diag3_normal_value = txtdiag3_normal_value.Text, Diag3_actual_value = txtdiag3_actual_value.Text, Diag4_normal_value = txtdiag4_normal_value.Text, Diag4_actual_value = txtdiag4_actual_value.Text, Diag5_normal_value = txtdiag5_normal_value.Text, Diag5_actual_value = txtdiag5_actual_value.Text, Diag6_normal_value = txtdiag6_normal_value.Text, Diag6_actual_value = txtdiag6_actual_value.Text, Doctor_comments = txtDoctorComments.Text, Otherinfo = txtOtherInformation.Text }; Bal.addtestresults(testresultdetails); }
public void AddTestResults(TestResultdetails testresultdetails) { try { SqlConnection _sqlConnection = ConnectionHandler.GetConnection(); SqlCommand _sqlCommand = new SqlCommand(); _sqlCommand.Connection = _sqlConnection; _sqlCommand.CommandType = CommandType.StoredProcedure; _sqlCommand.CommandText = "addtestresults"; //_sqlCommand.Parameters.AddWithValue("@reportId", testresultdetails.ReportId); _sqlCommand.Parameters.AddWithValue("@PatientId", testresultdetails.PatientId1); _sqlCommand.Parameters.AddWithValue("@doctorid", testresultdetails.Doctorid); _sqlCommand.Parameters.AddWithValue("@medicareService", testresultdetails.MedicareService); _sqlCommand.Parameters.AddWithValue("@agentId", testresultdetails.AgentId); _sqlCommand.Parameters.AddWithValue("@servicedate", testresultdetails.Servicedate); _sqlCommand.Parameters.AddWithValue("@testresultdate", testresultdetails.Testresultdate); _sqlCommand.Parameters.AddWithValue("@diag1_normal_value", testresultdetails.Diag1_normal_value); _sqlCommand.Parameters.AddWithValue("@diag1_actual_value", testresultdetails.Diag1_actual_value); _sqlCommand.Parameters.AddWithValue("@diag2_normal_value", testresultdetails.Diag2_normal_value); _sqlCommand.Parameters.AddWithValue("@diag2_actual_value", testresultdetails.Diag2_actual_value); _sqlCommand.Parameters.AddWithValue("@diag3_normal_value", testresultdetails.Diag3_normal_value); _sqlCommand.Parameters.AddWithValue("@diag3_actual_value", testresultdetails.Diag3_actual_value); _sqlCommand.Parameters.AddWithValue("@diag4_normal_value", testresultdetails.Diag4_normal_value); _sqlCommand.Parameters.AddWithValue("@diag4_actual_value", testresultdetails.Diag4_actual_value); _sqlCommand.Parameters.AddWithValue("@diag5_normal_value", testresultdetails.Diag5_normal_value); _sqlCommand.Parameters.AddWithValue("@diag5_actual_value", testresultdetails.Diag5_actual_value); _sqlCommand.Parameters.AddWithValue("@diag6_normal_value", testresultdetails.Diag6_normal_value); _sqlCommand.Parameters.AddWithValue("@diag6_actual_value", testresultdetails.Diag6_actual_value); _sqlCommand.Parameters.AddWithValue("@doctor_comments", testresultdetails.Doctor_comments); _sqlCommand.Parameters.AddWithValue("@otherinfo", testresultdetails.Otherinfo); _sqlConnection.Open(); int result = _sqlCommand.ExecuteNonQuery(); _sqlConnection.Close(); } catch (Exception ex) { } }
public void addtestresults(TestResultdetails testresults) { testresultssql.AddTestResults(testresults); }
public void modifytestresults(TestResultdetails testresults) { testresultssql.ModifyTestResults(testresults); }