public ActionResult Add(Health.Areas.Prescription.Models.Prescription model) { PrescriptionContext pc = new PrescriptionContext(); HealthDB.Model.Prescription p = new HealthDB.Model.Prescription(); p.DoctorId = model.PrescribedByUserId; p.Dosage = model.Strength; p.DrugName = model.DrugName; if (model.GroupName != null) p.GroupName = model.GroupName; p.Instruction = model.Direction; p.Invoice = DateTime.Today.Year.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Day.ToString() + "_" + model.PatientUserId + "_" + model.PrescribedByUserId; p.PatientId = model.PatientUserId; p.PharmacistId = model.PharmacistUserId; p.PrescriptionTypeId = model.PrescriptionTypeId; p.Quantity = model.Quantity; p.PrescriptionStatusId = 1; pc.Prescriptions.InsertOnSubmit(p); IEnumerable<DrugName> DrugNames = from drugs in pc.DrugNames where drugs.Name == model.DrugName select drugs; if (DrugNames == null) { DrugName dn = new DrugName(); dn.Name = model.DrugName; pc.DrugNames.InsertOnSubmit(dn); } pc.SubmitChanges(); model = GetPrescription(model.PatientUserId, model.PrescribedByUserId, DateTime.Today.Year.ToString() + DateTime.Today.Month.ToString() + DateTime.Today.Day.ToString() + "_" + model.PatientUserId + "_" + model.PrescribedByUserId, model); return View(model); }
public ActionResult Delete (int id, int PatientID, int DoctorID) { PrescriptionContext pc = new PrescriptionContext(); HealthDB.Model.Prescription p = (from Prescriptions in pc.Prescriptions where Prescriptions.Id == id select Prescriptions).FirstOrDefault(); pc.Prescriptions.DeleteOnSubmit(p); pc.SubmitChanges(); return RedirectToAction("Add", "Prescription", new { PatientID = PatientID, DoctorID = DoctorID}); }
public ActionResult Order(int PatientID, int DoctorID, string InvoiceId) { PrescriptionContext pc = new PrescriptionContext(); IEnumerable<HealthDB.Model.Prescription> ps = from Prescriptions in pc.Prescriptions where Prescriptions.Invoice == InvoiceId select Prescriptions; foreach (var p in ps) { p.PrescriptionStatusId = 2; } pc.SubmitChanges(); Models.Prescription model = new Models.Prescription(); model = GetPrescription(PatientID, DoctorID, InvoiceId, model); return View(model); }
private Models.Prescription GetPrescription(int PatientID, int DoctorID, string InvoiceId, Models.Prescription model) { ListboxHelper g = new ListboxHelper(); model.getAllPrescriptionTypes = g.GetAllPrescriptionType(); model.Patient = GetUser(PatientID); model.Doctor = GetUser(DoctorID); model.PatientUserId = PatientID; model.PrescribedByUserId = DoctorID; model.InvoiceId = InvoiceId; List<Drug> Drugs = new List<Drug>(); PrescriptionContext pc = new PrescriptionContext(); IEnumerable<HealthDB.Model.Prescription> ps = from Prescriptions in pc.Prescriptions where Prescriptions.Invoice == InvoiceId select Prescriptions; foreach (var p in ps) { Drug d = new Drug(); d.Id = p.Id; d.Direction = p.Instruction; d.DrugName = p.DrugName; d.GroupName = p.GroupName; d.PrescriptionType = (from PrescriptionTypes in pc.PrescriptionTypes where PrescriptionTypes.Id == p.PrescriptionTypeId select PrescriptionTypes.Name).FirstOrDefault(); d.Quantity = p.Quantity; d.Strength = p.Dosage; Drugs.Add(d); } model.Drugs = Drugs.OrderBy(ds => ds.PrescriptionType + ds.GroupName + ds.DrugName).ToList(); return model; }
public JsonResult AutoCompleteDrugName(string DrugName) { List<string> DrugNameList = new List<string>(); if (DrugName.ToString().Length >= 3) { PrescriptionContext PrescriptionContext = new PrescriptionContext(); DrugNameList = (from drugs in PrescriptionContext.DrugNames where drugs.Name.Contains(DrugName) select drugs.Name).ToList(); } return Json(DrugNameList, JsonRequestBehavior.AllowGet); }