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