public void SavePrescription(Prescription aTreatment,int treatmentID)
{
string query = "INSERT INTO Prescription_tbl(MedicineID,DiseaseID,Dose,Quantity,MealTime,Note,TreatmentID)VALUES('" + aTreatment.MedicineID + "','" + aTreatment.DiseaseID + "','" + aTreatment.Dose+ "','" + aTreatment.Quantity + "','"+aTreatment.mealTime+"','"+aTreatment.Note+"','"+treatmentID+"')";
aGateway.command.CommandText = query;
aGateway.sqlConnection.Open();
aGateway.command.ExecuteNonQuery();
aGateway.sqlConnection.Close();
}
public void TreatmentSave()
{
List<Prescription> treatmentList = (List<Prescription>)ViewState["TreatmentGiven"];
Prescription newTreatment = new Prescription();
newTreatment.DiseaseID = int.Parse(diseaseDropDownList.SelectedItem.Value);
newTreatment.MedicineID = int.Parse(medicineDropDownList.SelectedItem.Value);
newTreatment.Quantity = int.Parse(qtyGivenTextBox.Text);
newTreatment.Note = noteTextBox.Text;
newTreatment.Dose = doseTextBox.Text;
if (afterMealRadioButton.Checked)
{
newTreatment.mealTime = "After Meal";
}
else
{
newTreatment.mealTime = "Before Meal";
}
treatmentList.Add(newTreatment);
ViewState["TreatmentGiven"] = treatmentList;
}
public List<Prescription> GetPrescription(Treatment treatment)
{
aGateway.command.CommandText = "SELECT * FROM Prescription_tbl WHERE TreatmentID='" + treatment.ID + "'";
aGateway.sqlConnection.Open();
SqlDataReader reader = aGateway.command.ExecuteReader();
List<Prescription> newPrescriptions=new List<Prescription>();
while (reader.Read())
{
Prescription aPrescription=new Prescription();
aPrescription.MedicineID= int.Parse(reader["MedicineID"].ToString());
aPrescription.DiseaseID = int.Parse(reader["DiseaseID"].ToString());
aPrescription.Dose = reader["Dose"].ToString();
aPrescription.Quantity = int.Parse(reader["Quantity"].ToString());
aPrescription.mealTime = reader["MealTime"].ToString();
aPrescription.Note = reader["Note"].ToString();
newPrescriptions.Add(aPrescription);
}
reader.Close();
aGateway.sqlConnection.Close();
return newPrescriptions;
}