void AssignDrug() { Console.WriteLine("List Of Drugs."); Program obj = new Program(); obj.DrugList(); Console.Write("\nEnter Drug name to assign to the patient : "); var drugName = Console.ReadLine(); Console.WriteLine("\nList Of Patients."); obj.PatientList(); Console.Write("\nEnter Patient name to assign Drug : "); var patientName = Console.ReadLine(); var isDrugAddedCount = db.Drugs.Where(t => t.DrugName == drugName); var isPatientAddedCount = db.Patients.Where(t => t.PatientName == patientName); if (isDrugAddedCount.Count() >= 1 && isPatientAddedCount.Count() >= 1) { var isDrugAdded = db.Drugs.First(t => t.DrugName == drugName); var isPatientAdded = db.Patients.First(t => t.PatientName == patientName); Console.Write("Enter time to take Medicine : "); var drugTime = Console.ReadLine(); PatientDrug patientDrug = new PatientDrug(isDrugAdded.DrugId, isPatientAdded.PatientId, drugName); db.PatientDrugs.Add(patientDrug); db.SaveChanges(); Console.WriteLine("Medicine Assigned to Patient"); } else { Console.WriteLine("Drug or Patient is not Added"); } }
public ActionResult DeleteConfirmed(int id) { PatientDrug patientDrug = db.PatientDrugs.Find(id); db.PatientDrugs.Remove(patientDrug); db.SaveChanges(); return(RedirectToAction("Index")); }
public void UpdateDrugs(PatientDrug[] drugs, Patient patientToUpdate, HttpRequest request) { for (var cursor = 0; cursor < drugs.Length; cursor++) { PatientDrug drug = drugs[cursor]; if (drug.ID == 0) { drug.PatientId = patientToUpdate.ID; string[] sideEffectsIDs = request.Form["Drugs[" + cursor + "].SideEffects"]; var sideEffectsItems = _context.SideEffects.Where(se => sideEffectsIDs.Contains(se.ID.ToString())); foreach (var sideEffect in sideEffectsItems) { PatientDrugSideEffect drugSideEffect = new PatientDrugSideEffect(); drugSideEffect.PatientDrug = drugs[cursor]; drugSideEffect.SideEffect = sideEffect; drugs[cursor].SideEffects.Add(drugSideEffect); } _context.Update(drug); } else { //var drugToUpdate = patientToUpdate.PatientDrugs.SingleOrDefault(pd => pd.ID == drug.ID); string[] sideEffectsIDs = request.Form["Drugs[" + cursor + "].SideEffects"]; var drugToUpdate = _context.PatientDrugs.Include(pd => pd.SideEffects). SingleOrDefault(pd => pd.ID == drug.ID); var sideEffectsItems = _context.SideEffects.Where(se => sideEffectsIDs.Contains(se.ID.ToString())); var uiSelectedIds = sideEffectsIDs.Select(int.Parse).ToList(); var toDeleteEffectIds = drugToUpdate.SelectedEffectsIds.Except(uiSelectedIds); var toInsertEffectIds = uiSelectedIds.Except(drugToUpdate.SelectedEffectsIds); if (toDeleteEffectIds.Count() > 0) { _context.PatientDrugSideEffects. RemoveRange(_context.PatientDrugSideEffects. Where(pdse => toDeleteEffectIds.Contains(pdse.SideEffectId) && pdse.PatientDrugId == drugToUpdate.ID)); } if (toInsertEffectIds.Count() > 0) { var sideEffectsNewItems = _context.SideEffects.Where(se => toInsertEffectIds.Contains(se.ID)); foreach (var sideEffect in sideEffectsNewItems) { PatientDrugSideEffect drugSideEffect = new PatientDrugSideEffect(); drugSideEffect.PatientDrug = drugs[cursor]; drugSideEffect.SideEffect = sideEffect; drugToUpdate.SideEffects.Add(drugSideEffect); } } drugToUpdate.StartDate = drug.StartDate; drugToUpdate.EndDate = drug.EndDate; drugToUpdate.DrugId = drug.DrugId; _context.Update(drugToUpdate); } } }
public ActionResult Edit([Bind(Include = "PatientDrugID,PatientID,DrugID")] PatientDrug patientDrug) { if (ModelState.IsValid) { db.Entry(patientDrug).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DrugID = new SelectList(db.Drugs, "DrugID", "DrugName", patientDrug.DrugID); ViewBag.PatientID = new SelectList(db.Patients, "PatientID", "FirstName", patientDrug.PatientID); return(View(patientDrug)); }
// GET: PatientDrugs/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PatientDrug patientDrug = db.PatientDrugs.Find(id); if (patientDrug == null) { return(HttpNotFound()); } return(View(patientDrug)); }
// GET: PatientDrugs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PatientDrug patientDrug = db.PatientDrugs.Find(id); if (patientDrug == null) { return(HttpNotFound()); } ViewBag.DrugID = new SelectList(db.Drugs, "DrugID", "DrugName", patientDrug.DrugID); ViewBag.PatientID = new SelectList(db.Patients, "PatientID", "FirstName", patientDrug.PatientID); return(View(patientDrug)); }