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