protected void addButton_Click(object sender, EventArgs e) { saveButton.Visible = true; 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["CenterId"].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 = "Medicine Stock Limited!"; } else { megLabel.Text = ""; 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; }
protected void saveButton_Click(object sender, EventArgs e) { int districtId = int.Parse(Session["DistrictId"].ToString()); 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); AllClear(); } else { megLabel.Text = patientManager.SavePatient(aPatient); AllClear(); } aPatient.Id = patientManager.GetPatientId(aPatient); int centerId = int.Parse(Session["CenterId"].ToString()); patientManager.PatientCenterTblValue(aPatient.Id, centerId, districtId); Treatment aTreatment = new Treatment(); aTreatment.Observation = observationTextBox.Text; aTreatment.DoctorId = int.Parse(doctorDropDownList.SelectedValue); string date = Request.Form["bday"]; int year = int.Parse(date.Substring(0, 4)); int month = int.Parse(date.Substring(5, 2)); int day = int.Parse(date.Substring(8, 2)); aTreatment.Date = year + "-" + month + "-" + day; 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); } }
protected void showButton_Click(object sender, EventArgs e) { Patient aPatient = new Patient(); aPatient.VoterId = nationalIdTextBox.Text; GetPatientInformation(aPatient.VoterId); aPatient.Id = patientManager.GetPatientId(aPatient); aPatient.ServiceTimes = patientManager.GetServiceTimes(aPatient); if (aPatient.ServiceTimes < 1) { megLabel.Text = "Didn't take any treatment!"; pdfButton.Visible =false; } else { int count = 0; List<Treatment> ObservationList = treatmentManager.GetObservationList(aPatient); foreach (var observation in ObservationList) { count++; string centerName = centerManager.GetCenterName(observation.CenterId); string Date = observation.Date; string DoctorName = doctorManager.GetDoctorName(observation.DoctorId); string Observation = observation.Observation; List<Treatment> treatmentList = treatmentManager.GetTreatmentList(observation.ObservationId); List<Treatment> aTreatmentList= new List<Treatment>(); foreach (var treatment in treatmentList) { string diseaseName= diseaseManager.GetDiseaseName(treatment.DiseaseId); string medicineName = medicineManager.GetMedicineName(treatment.MedicineId); Treatment aTreatment = new Treatment(); aTreatment.NameOfDisease = diseaseName; aTreatment.NameOfMedicine = medicineName; aTreatment.Dose = treatment.Dose; aTreatment.TakenTime = treatment.TakenTime; aTreatment.Quantity = treatment.Quantity; aTreatment.Note = treatment.Note; aTreatmentList.Add(aTreatment); } ShowAllTreatment(centerName, Date, DoctorName, Observation, count, aTreatmentList); } pdfButton.Visible = true; } }
protected void pdfButton_Click(object sender, EventArgs e) { Document doc = new Document(PageSize.A4, 36, 72, 108, 180); string path = @"D:\"; PdfWriter.GetInstance(doc, new FileStream(path + "/Treatment.pdf", FileMode.Create)); doc.Open(); Voter aVoter = new Voter(); aVoter.Id=nationalIdTextBox.Text; aVoter.Name = nameTextBox.Text; aVoter.Address = addressTextBox.Text; Paragraph paragraph = new Paragraph(); paragraph.Add("National Id : " + aVoter.Id); paragraph.Add(Environment.NewLine); paragraph.Add("Name : " + aVoter.Name); paragraph.Add(Environment.NewLine); paragraph.Add("Address :" + aVoter.Address); paragraph.Add(Environment.NewLine); paragraph.Add(Environment.NewLine); doc.Add(paragraph); Patient aPatient = new Patient(); aPatient.VoterId = nationalIdTextBox.Text; GetPatientInformation(aPatient.VoterId); aPatient.Id = patientManager.GetPatientId(aPatient); int count = 0; List<Treatment> ObservationList = treatmentManager.GetObservationList(aPatient); foreach (var observation in ObservationList) { count++; PdfPTable table = new PdfPTable(1); Paragraph aParagraph = new Paragraph(); Chunk chunk = new Chunk("Treatment-" + count, FontFactory.GetFont("dax-black")); chunk.SetUnderline(0.5f, -1.5f); doc.Add(chunk); string centerName = centerManager.GetCenterName(observation.CenterId); aParagraph.Add("Center Name : " + centerName); aParagraph.Add(Environment.NewLine); string Date = observation.Date; aParagraph.Add("Date : " + Date); aParagraph.Add(Environment.NewLine); string DoctorName = doctorManager.GetDoctorName(observation.DoctorId); aParagraph.Add("Doctor Name : " + DoctorName); aParagraph.Add(Environment.NewLine); string Observation = observation.Observation; aParagraph.Add("Observation : " + Observation); aParagraph.Add(Environment.NewLine); table.AddCell(aParagraph); doc.Add(table); List<Treatment> treatmentList = treatmentManager.GetTreatmentList(observation.ObservationId); List<Treatment> aTreatmentList = new List<Treatment>(); foreach (var treatment in treatmentList) { string diseaseName = diseaseManager.GetDiseaseName(treatment.DiseaseId); string medicineName = medicineManager.GetMedicineName(treatment.MedicineId); Treatment aTreatment = new Treatment(); aTreatment.NameOfDisease = diseaseName; aTreatment.NameOfMedicine = medicineName; aTreatment.Dose = treatment.Dose; aTreatment.TakenTime = treatment.TakenTime; aTreatment.Quantity = treatment.Quantity; aTreatment.Note = treatment.Note; aTreatmentList.Add(aTreatment); } ShowAllTreatment(centerName, Date, DoctorName, Observation, count, aTreatmentList); PdfPTable aTable = new PdfPTable(6); aTable.AddCell("Disease"); aTable.AddCell("Medicine"); aTable.AddCell("Dose"); aTable.AddCell("Before/After meal"); aTable.AddCell("Quantity"); aTable.AddCell("Note"); foreach (var eachTreatment in aTreatmentList) { aTable.AddCell(eachTreatment.NameOfDisease); aTable.AddCell(eachTreatment.NameOfMedicine); aTable.AddCell(eachTreatment.Dose); aTable.AddCell(eachTreatment.TakenTime); aTable.AddCell(eachTreatment.Quantity.ToString()); aTable.AddCell(eachTreatment.Note); } doc.Add(aTable); } doc.Close(); Response.Redirect("OpenPdfUI.aspx"); megLabel.Text = "PDF Creation Successful!"; }
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); }
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(); }