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