public List <PatientTestVM> AddTests()
{
PatientTestVM aPatientVm = new PatientTestVM();
aPatientVm.TestName = selectTestDropDownList.SelectedItem.Text;
aPatientVm.TestId = Convert.ToInt32(selectTestDropDownList.SelectedValue);
aPatientVm.Fee = Convert.ToDouble(feeTextBox.Text);
if (ViewState["name"] == null)
{
List <PatientTestVM> tests = new List <PatientTestVM>();
tests.Add(aPatientVm);
ViewState["name"] = tests;
}
else
{
List <PatientTestVM> tests = (List <PatientTestVM>)ViewState["name"];
tests.Add(aPatientVm);
ViewState["name"] = tests;
}
return((List <PatientTestVM>)ViewState["name"]);
}
public int Save2(PatientTestVM patientTestVm)
{
Query = "Insert into PatientTest Values(@testId, @patientId, @entryDate)";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Command.Parameters.Clear();
Command.Parameters.Add("testId", SqlDbType.Int);
Command.Parameters["testId"].Value = patientTestVm.TestId;
Command.Parameters.Add("patientId", SqlDbType.Int);
Command.Parameters["patientId"].Value = patientTestVm.PatientId;
Command.Parameters.Add("entryDate", SqlDbType.Date);
Command.Parameters["entryDate"].Value = patientTestVm.EntryDate;
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public int Save2(PatientTestVM patientTestVm)
{
int rowAffected = aTestRequestGateway.Save2(patientTestVm);
return(rowAffected);
}
