public int Insert(Treatment aTreatment)
{
string query = "insert into treatment_tbl values ('"+aTreatment.DiseaseId+"','"+aTreatment.PatientId+"','"+aTreatment.MedicineId+"','"+aTreatment.Dose+"','"+aTreatment.BeforeAfter+"','"+aTreatment.MedicineQty+"','"+aTreatment.Note+"','"+aTreatment.Date+"','"+aTreatment.Count+"','"+aTreatment.CenterId+"')";
SqlConnection aConnection = new SqlConnection(conncetionStr);
SqlCommand aCommand = new SqlCommand(query, aConnection);
aConnection.Open();
int rowAffect = aCommand.ExecuteNonQuery();
aConnection.Close();
return rowAffect;
}
public string GetTreatment(int number, Treatment newTreatment)
{
string html = "<div>";
html += "<h3>Treatment " + number + " </h3>";
html += "<p>Date: " + newTreatment.Date + " </p>";
html += "<p>Doctor Name: " + newTreatment.DoctorId+ " </p>";
// html += "<p>Treatment Date: " + newTreatment.TreatmentDate + " </p>";
// html += "<p>Observation: " + newTreatment.Observation + " </p>";
string prescription = GetPrescription(newTreatment, number);
html += prescription + "</div>";
return html;
}
public string GetPrescription(Treatment newTreatment, int number)
{
string code = "<div><table cellspacing=\"0\" cellpadding=\"4\" style=\"color:#333333;width:802px;border-collapse:collapse;\"><tbody><tr style=\"color:White;background-color:#5D7B9D;font-weight:bold;\"><th >Disease</th><th >Medicine</th><th>Dose</th><th>Before/After Meal</th><th>Quantity</th><th>Note</th></tr>";
//List<Prescription> newPrescriptions = aCenterManager.NewPrescriptions(newTreatment);
List<Treatment> treatment = aCenterManager.GetTreatmentList(patientID);
foreach (Prescription prescription in newPrescriptions)
{
code += "<tr>";
code += "<td> " + prescription.DiseaseName + " </td>";
code += "<td> " + prescription.MedicineName + " </td>";
code += "<td> " + prescription.Dose + " </td>";
code += "<td> " + prescription.mealTime + " </td>";
code += "<td> " + prescription.Quantity + " </td>";
code += "<td> " + prescription.Note + " </td>";
code += "</tr>";
}
code += "</tbody></table></div>";
return code;
}
public void Insert(Treatment aTreatment)
{
aTreatementGateway.Insert(aTreatment);
}
public void showPrescription()
{
if (!result)
{
GetJSONdata();
}
Treatment aTreatment = new Treatment();
aTreatment.VoterId= voterIdTextBox.Text;
string patientID = aPatientManager.GetPatientId(voterIdTextBox.Text);
List<Treatment> treatment = aCenterManager.GetTreatmentList(patientID);
ViewState["Treatment"] = treatment;
int count = 1;
foreach (Treatment aNewTreatment in treatment)
{
mainHtml += GetTreatment(count, aNewTreatment);
count++;
}
Content.InnerHtml = mainHtml;
}
public List<Treatment> GetTreatmentList(string id)
{
string query = "select * from treatment_tbl WHERE patient_id = '"+id+"'";
List<Treatment> aList = new List<Treatment>();
Treatment aTreatment = new Treatment();
SqlConnection aConnection = new SqlConnection(conncetionStr);
SqlCommand aCommand = new SqlCommand(query, aConnection);
aConnection.Open();
SqlDataReader aReader = aCommand.ExecuteReader();
while (aReader.Read())
{
aTreatment.PatientId = aReader["patient_id"].ToString();
aTreatment.DiseaseId = Convert.ToInt32(aReader["disease_id"].ToString());
aTreatment.Date = aReader["treatment_date"].ToString();
aList.Add(aTreatment);
}
aReader.Close();
aConnection.Close();
return aList;
}
protected void addButton_Click(object sender, EventArgs e)
{
Treatment aTreatment = new Treatment();
aTreatment.DiseaseId = aDiseaseManager.GetDiseaseId(diseaseDropDownList.Text);
aTreatment.PatientId = voterIdTextBox.Text;
aTreatment.MedicineId = aMedicineManager.GetMedicineIdByName(medicineDropDownList.Text);
aTreatment.Dose = doseDropDownList.Text;
if (RadioButton1.Checked == true)
{
aTreatment.BeforeAfter = "Before Meal";
}
else
{
aTreatment.BeforeAfter = "After Meal";
}
aTreatment.MedicineQty = Convert.ToInt32(quantityTextBox.Text);
aTreatment.Note = noteTextBox.Text;
aTreatment.Date = dateTextBox.Text;
aTreatment.Count = Convert.ToInt32(serviceNumberTextBox.Text)+1;
aTreatment.CenterId = Convert.ToInt32(Session["center_id"].ToString());
//
if (aCenterMedicineRelationManager.GetMedicineQty(Convert.ToInt32(Session["center_id"].ToString()),
aTreatment.MedicineId) < Convert.ToInt32(quantityTextBox.Text))
{
Label16.Text = "Out Of stock ";
}
else
{
AddTreatementInQueue(aTreatment);
AddTreatmentInViewState(aTreatment);
}
}
public void AddTreatementInQueue(Treatment aTreatment)
{
if (ViewState["TreatmentList"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["TreatmentList"];
DataRow drCurrentRow = null;
if (dtCurrentTable.Rows.Count > 0)
{
for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
{
drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow["disease"] = diseaseDropDownList.Text;
drCurrentRow["medicine"] = medicineDropDownList.Text;
drCurrentRow["dose"] = doseDropDownList.Text;
drCurrentRow["Before/After"] = aTreatment.BeforeAfter;
drCurrentRow["quantity"] = quantityTextBox.Text;
drCurrentRow["note"] = noteTextBox.Text;
}
if (dtCurrentTable.Rows[0][0].ToString() == "")
{
dtCurrentTable.Rows[0].Delete();
dtCurrentTable.AcceptChanges();
}
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState["TreatmentList"] = dtCurrentTable;
treatmentGridView.DataSource = dtCurrentTable;
treatmentGridView.DataBind();
}
}
}
public void AddTreatmentInViewState(Treatment aTreatment)
{
if (ViewState["Treatment"] == null)
{
List <Treatment> aList = new List<Treatment>();
aList.Add(aTreatment);
ViewState["Treatment"] = aList;
}
else
{
List <Treatment> aList = new List<Treatment>();
aList = (List<Treatment>) ViewState["Treatment"];
aList.Add(aTreatment);
ViewState["Treatment"] = aList;
}
}
