public int SaveTreatment(Treatment aTreatment) { string query = "INSERT INTO tbl_treatment VALUES ('" + aTreatment.Observation + "','" +aTreatment.ServiceDate+ "','" + aTreatment.DoctorId + "','" + aTreatment.DiseaseId + "', '" +aTreatment.MedicineId+ "', '" + aTreatment.Dose+ "', '" +aTreatment.Quantity+ "', '" +aTreatment.Note+ "', '" +aTreatment.DoseType+ "', '" + aTreatment.CenterId+ "', '" +aTreatment.ServiceTakenId+ "')"; ASqlConnection.Open(); ASqlCommand = new SqlCommand(query, ASqlConnection); //ASqlCommand.Parameters.Add("@serviceDate", SqlDbType.DateTime).Value = aTreatment.ServiceDate; int rowAffected = ASqlCommand.ExecuteNonQuery(); ASqlConnection.Close(); return rowAffected; }
public void SaveTreatment(Treatment aTreatment) { aTreatmentDbGateway.SaveTreatment(aTreatment); }
protected void saveButton_Click(object sender, EventArgs e) { Patient aPatient = new Patient(); var diseaseList = diseaseName.Value; diseaseName.Value = ""; string[] disease = diseaseList.Split(','); var medicineList = medicineName.Value; medicineName.Value = ""; string[] medicine = medicineList.Split(','); var doseList = medicineDose.Value; medicineDose.Value = ""; string[] dose = doseList.Split(','); var doseRuleList = medicineDoseType.Value; medicineDoseType.Value = ""; string[] doseRule = doseRuleList.Split(','); var quantityList = medicineQuantityGiven.Value; medicineQuantityGiven.Value = ""; string[] quantity = quantityList.Split(','); var noteList = notes.Value; notes.Value = ""; string[] note = noteList.Split(','); string[] address = addressTextBox.Text.Split(' '); string districtName = address[address.Length - 1]; aPatient.VoterId = Convert.ToInt64(voterIdTextBox.Text); aPatient.DistrictId = aDistrictAndThanaManager.FindDistrict(districtName).Id; aPatientManager.SaveService(aPatient); Treatment aTreatment = new Treatment(); aTreatment.ServiceTakenId = aPatientManager.GetServiceTakenId(); aTreatment.Observation = observationTextBox.Text; aTreatment.ServiceDate = DateTime.Parse(dateTextBox.Value); aTreatment.DoctorId = Convert.ToInt32(doctorDropDownList.SelectedValue); aTreatment.CenterId = Convert.ToInt32(Session["CenterId"]); for (int i = 0; i < disease.Length - 1; i++) { Disease aDisease = aDiseaseManager.Find(disease[i]); aTreatment.DiseaseId = aDisease.Id; Medicine aMedicine = aMedicineManager.Find(medicine[i]); aTreatment.MedicineId = aMedicine.Id; aTreatment.Dose = dose[i]; aTreatment.DoseType = doseRule[i]; aTreatment.Quantity = Convert.ToInt32(quantity[i]); aTreatment.Note = note[i]; aTreatmentManager.SaveTreatment(aTreatment); MedicineStockInCenter aMedicineStockInCenter = new MedicineStockInCenter(); aMedicineStockInCenter.MedicineId = aTreatment.MedicineId; aMedicineStockInCenter.Quantity = aTreatment.Quantity; aMedicineStockInCenter.CenterId = aTreatment.CenterId; aMedicineManager.DeductMedicineFromCenter(aMedicineStockInCenter); } }