public void savePatientMedication() { string durationType = ""; if (rdNumOfDays.Checked == true) { durationType = "N"; } else if (rdDaily.Checked == true) { durationType = "D"; } else if (rdStop.Checked == true) { durationType = "S"; } using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer()) { EDMX.tblPatientMedicationList patMed = new EDMX.tblPatientMedicationList { PatientID = Convert.ToInt32(lblPatientId.Text), MedicationName = txtMedicationName.Text, Dosage = txtDosage.Text, Direction = txtDirection.Text, OrderedBy = txtOrderedBy.Text, StartDate = lblStartDate.Text, EndDate = lblEndDate.Text, DurationType = durationType, Note = txtNotes.Text }; db.tblPatientMedicationLists.Add(patMed); db.SaveChanges(); } }
public void updatePatientMedication(int medId) { using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer()) { EDMX.tblPatientMedicationList patMed = db.tblPatientMedicationLists.Where(x => x.Id == medId).FirstOrDefault(); patMed.MedicationName = txtMedicationName.Text; patMed.Dosage = txtDosage.Text; patMed.Direction = txtDirection.Text; patMed.OrderedBy = txtOrderedBy.Text; patMed.StartDate = lblStartDate.Text; patMed.EndDate = lblEndDate.Text; if (rdNumOfDays.Checked == true) { patMed.DurationType = "N"; } else if (rdDaily.Checked == true) { patMed.DurationType = "D"; } else if (rdStop.Checked == true) { patMed.DurationType = "S"; } patMed.Note = txtNotes.Text; db.SaveChanges(); } }