protected void addButton_Click(object sender, EventArgs e)
{
Treatment aTreatment = new Treatment();
aTreatment.NameOfDisease = diseaseDropDownList.SelectedItem.ToString();
aTreatment.NameOfMedicine = medicineDropDownList.SelectedItem.ToString();
aTreatment.Dose = doseDropDownList.SelectedItem.ToString();
aTreatment.DiseaseId = int.Parse(diseaseDropDownList.SelectedValue);
aTreatment.MedicineId = int.Parse(medicineDropDownList.SelectedValue);
int centerId = int.Parse(Session["Center_Id"].ToString());
if (beforMealRadioButton.Checked)
{
aTreatment.TakenTime = "Before Meal";
}
else
{
aTreatment.TakenTime = "After Meal";
}
aTreatment.Quantity = int.Parse(quantityTextBox.Text);
aTreatment.Note = noteTextBox.Text;
int medicineQuantity = centerMedicineRelationManager.GetCenterMedicineQuantity(centerId, aTreatment.MedicineId);
if (medicineQuantity < aTreatment.Quantity)
{
megLabel.Text = "Stock Limited!";
}
else
{
int newQuantity = medicineQuantity - aTreatment.Quantity;
centerMedicineRelationManager.UpdateCenterMedicineQuantity(centerId, aTreatment.MedicineId, newQuantity);
TreatmentList.Add(aTreatment);
treatmentGridView.DataSource = TreatmentList;
treatmentGridView.DataBind();
}
}
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 List<Treatment> GetTreatmentList(int observationId)
{
List<Treatment> treatmentList = new List<Treatment>();
string query = "SELECT * FROM TreatmentTBL WHERE ObservationId='" + observationId + "'";
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.DiseaseId = int.Parse(reader["DiseaseId"].ToString());
aTreatment.MedicineId = int.Parse(reader["MedicineId"].ToString());
aTreatment.Dose = reader["Dose"].ToString();
aTreatment.TakenTime = reader["TakenTime"].ToString();
aTreatment.Quantity = int.Parse(reader["Quantity"].ToString());
aTreatment.Note = reader["Note"].ToString();
treatmentList.Add(aTreatment);
}
reader.Close();
connection.Close();
return treatmentList;
}
public void SaveTreatment(Treatment aTreatment, int observationId)
{
treatmentGateway.SaveTreatment(aTreatment, observationId);
}
public int SaveObservation(Treatment aTreatment, Patient aPatient, int centerId)
{
return treatmentGateway.SaveObservation(aTreatment, aPatient, centerId);
}
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);
}
}
public void SaveTreatment(Treatment aTreatment, int observationId)
{
string query = "INSERT INTO TreatmentTBL VALUES('" + aTreatment.DiseaseId + "','" + aTreatment.MedicineId + "','" + aTreatment.Dose + "','" + aTreatment.Quantity + "','" + aTreatment.Note + "','" + observationId + "','" + aTreatment.TakenTime + "')";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
