public string UpdateServiceTimes(Patient aPatient) { int value = patientGateway.UpdateServiceTimes(aPatient); if (value > 0) { return "Patient Has Been Saved"; } else return "Failed"; }
public string SavePatient(Patient aPatient) { int value = patientGateway.SavePatient(aPatient); if (value > 0) { return "Patient Has Been Saved"; } else return "Failed"; }
public int SaveObservation(Treatment aTreatment, Patient aPatient, int centerId) { int observationId = 0; string query = "INSERT INTO ObservationTBL VALUES('" + aTreatment.Observation + "','" + aTreatment.Date + "','" + aPatient.Id + "','" + centerId + "','" + aTreatment.DoctorId + "')"; SqlConnection connection = new SqlConnection(connectionString); SqlCommand command = new SqlCommand(query, connection); connection.Open(); command.ExecuteNonQuery(); query = "SELECT * FROM ObservationTBL"; command = new SqlCommand(query, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { observationId = int.Parse(reader["Id"].ToString()); } reader.Close(); connection.Close(); return observationId; }
public List<Treatment> GetObservationList(Patient aPatient) { List<Treatment> observationList = new List<Treatment>(); string query = "SELECT * FROM ObservationTBL WHERE PatientId='" + aPatient.Id + "'"; SqlConnection connection = new SqlConnection(connectionString); SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Treatment aTreatment = new Treatment(); aTreatment.ObservationId = int.Parse(reader["Id"].ToString()); aTreatment.Observation = reader["Observation"].ToString(); aTreatment.Date = reader["Date"].ToString(); aTreatment.CenterId = int.Parse(reader["CenterId"].ToString()); aTreatment.DoctorId = int.Parse(reader["DoctorId"].ToString()); observationList.Add(aTreatment); } reader.Close(); connection.Close(); return observationList; }
public bool IfPatientExists(Patient aPatient) { return patientGateway.IfPatientExists(aPatient); }
public int GetServiceTimes(Patient aPatient) { patientGateway.GetPatientId(aPatient); return patientGateway.ServiceTime; }
public int GetPatientId(Patient aPatient) { return patientGateway.GetPatientId(aPatient); }
public int SaveObservation(Treatment aTreatment, Patient aPatient, int centerId) { return treatmentGateway.SaveObservation(aTreatment, aPatient, centerId); }
public List<Treatment> GetObservationList(Patient aPatient) { return treatmentGateway.GetObservationList(aPatient); }
protected void saveButton_Click(object sender, EventArgs e) { Patient aPatient = new Patient(); aPatient.VoterId = voterIdTextBox.Text; int count = int.Parse(serviceGivenTextBox.Text); aPatient.ServiceTimes = count + 1; if (patientManager.IfPatientExists(aPatient)) { megLabel.Text = patientManager.UpdateServiceTimes(aPatient); } else { megLabel.Text = patientManager.SavePatient(aPatient); } aPatient.Id = patientManager.GetPatientId(aPatient); int centerId = int.Parse(Session["Center_Id"].ToString()); patientManager.PatientCenterTblValue(aPatient.Id, centerId); Treatment aTreatment = new Treatment(); aTreatment.Observation = observationTextBox.Text; aTreatment.DoctorId = int.Parse(doctorDropDownList.SelectedValue); aTreatment.Date = Request.Form["bday"]; int observationId = treatmentManager.SaveObservation(aTreatment, aPatient, centerId); foreach (var treatment in TreatmentList) { Treatment newTreatment = new Treatment(); newTreatment.DiseaseId = treatment.DiseaseId; newTreatment.MedicineId = treatment.MedicineId; newTreatment.Dose = treatment.Dose; newTreatment.Quantity = treatment.Quantity; newTreatment.Note = treatment.Note; newTreatment.TakenTime = treatment.TakenTime; treatmentManager.SaveTreatment(newTreatment, observationId); } }