//Retrieve all data from PatientRequestTest table//
public virtual List<PatientTestRequest> GetAllTestRequest()
{
SqlConnection connection = new SqlConnection(Connection);
string query = "SELECT *FROM [PatientRequestTest]";
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
List<PatientTestRequest> TestRequestList = new List<PatientTestRequest>();
if (reader.HasRows)
{
while (reader.Read())
{
int patientId = (int)reader["PatientID"];
int testID = (int)reader["TestID"];
PatientTestRequest TestRequest = new PatientTestRequest(patientId, testID);
TestRequestList.Add(TestRequest);
}
reader.Close();
}
connection.Close();
return TestRequestList;
}
public bool IsPatientExist(PatientTestRequest patient)
{
int countPatient = patientTestRequestGateway.GetPatientByMobile(patient.ContactNumber);
if (countPatient != 0)
{
return(true);
}
else
{
return(false);
}
}
// Add data in PatientRequestTest table//
public virtual int AddTestRequest(PatientTestRequest testRequest)
{
SqlConnection connection = new SqlConnection(Connection);
string query = "INSERT INTO [PatientRequestTest] VALUES(@PatientID,@TestID)";
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@PatientID", testRequest.patientID);
command.Parameters.AddWithValue("@TestID", testRequest.TestID);
int rowAffected = command.ExecuteNonQuery();
return rowAffected;
}
private void SavePatientTestInfo()
{
TestDetails testDetails = new TestDetails();
PatientTestRequest patientTestRequest = new PatientTestRequest();
if (ViewState["TestsSetup"] != null)
{
DataTable currentTable = (DataTable)ViewState["TestsSetup"];
for (int i = 0; i < currentTable.Rows.Count; i++)
{
testDetails.TestName = currentTable.Rows[i][1].ToString();
patientTestRequest.ContactNumber = mobileNoTextBox.Text;
patientTestRequestManager.SavePatientTest(patientTestRequest, testDetails);
}
}
}
public int SavePatientTest(PatientTestRequest patientTest, TestDetails testDetails)
{
SqlConnection connection = new SqlConnection(connectionDB);
string query = "exec spInsertPatientTest '" + testDetails.TestName + "','" +
patientTest.ContactNumber + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public int SavePatient(PatientTestRequest patientInfo)
{
SqlConnection connection = new SqlConnection(connectionDB);
string query = "INSERT INTO PatientInformation VALUES ('" + patientInfo.PatientName + "','" +
patientInfo.PatientBirthDate + "','" + patientInfo.ContactNumber + "')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
protected void btnTestRequst_Click(object sender, EventArgs e)
{
testList = (List <Tests>)ViewState["Test"];
string name = txtPatientName.Text;
DateTime dateOfBirth = Convert.ToDateTime(txtDateOfBirth.Text);
int mobileNo = Convert.ToInt32(txtMobileNo.Text);
HiddenField1.Value = patientManager.Get8Digits();
string billNo = HiddenField1.Value;
DateTime billDate = System.DateTime.Now;
decimal totalFee = testList.Sum(x => x.testFee);
decimal PaidBill = 0;
Patients patient = new Patients(name, dateOfBirth, mobileNo, billNo, billDate, totalFee, PaidBill);
try
{
patientManager.AddPatient(patient);
}
catch (Exception exception)
{
lblMessage.Visible = true;
lblMessage.Text = exception.Message;
}
int PatientId = patientManager.GetAllPatient().Max(x => x.ID);
foreach (var test in testList)
{
int patientID = PatientId;
int testID = test.ID;
PatientTestRequest testRequest = new PatientTestRequest(patientID, testID);
TestRequestManager.AddTestRequest(testRequest);
}
Clear();
Generate_PDF();
}
protected void requestEntryButton_Click(object sender, EventArgs e)
{
string patientName = patientNameTextBox.Text;
DateTime dateOfBirth = Convert.ToDateTime(birthDateTextBox.Value);
string mobileNo = mobileNoTextBox.Text;
PatientTestRequest patientInfo = new PatientTestRequest(patientName, dateOfBirth, mobileNo);
if (CheckRequiredField())
{
if (patientTestRequestManager.IsPatientExist(patientInfo))
{
SavePatientTestInfo();
SaveBillAmount();
InvoiceReport();
}
else
{
patientTestRequestManager.SavePatient(patientInfo);
SavePatientTestInfo();
SaveBillAmount();
InvoiceReport();
}
}
}
public override int AddTestRequest(PatientTestRequest testRequest)
{
return(base.AddTestRequest(testRequest));
}
public int SavePatientTest(PatientTestRequest testpatientTest, TestDetails testDetails)
{
return(patientTestRequestGateway.SavePatientTest(testpatientTest, testDetails));
}
public int SavePatient(PatientTestRequest patientInfo)
{
return(patientTestRequestGateway.SavePatient(patientInfo));
}
