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