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