public static ReferringPractice getPractice(PatientLogModel db, string PracID) { int ID = Convert.ToInt32(PracID); ReferringPractice prac = (from r in db.ReferringPractices where r.PracID == ID select r).Single(); return(prac); }
public ActionResult DeleteConfirmed(int id) { ReferringPractice referringPractice = db.ReferringPractices.Find(id); db.ReferringPractices.Remove(referringPractice); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "PracID,PracName,Address1,Address2,Address3,City,State,Zip,Phone,Fax,Email,OfficeManager,Other,PDFPassword,EmailNotification,FaxNotification")] ReferringPractice referringPractice) { if (ModelState.IsValid) { db.Entry(referringPractice).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(referringPractice)); }
public JsonResult jsonSubmitCommunicationMethod(ReferringPractice prac) { string result = ""; ReferringPractice newPrac = DataCollections.getPractice(db, prac.PracID); newPrac.EmailNotification = prac.EmailNotification; newPrac.FaxNotification = prac.FaxNotification; DataSubmissions.SavePractice(db, newPrac); result = "Communication Methods Saved"; return(Json(result)); }
// GET: ReferringPractice/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ReferringPractice referringPractice = db.ReferringPractices.Find(id); if (referringPractice == null) { return(HttpNotFound()); } return(View(referringPractice)); }
public static void SavePractice(PatientLogModel db, ReferringPractice prac) { ReferringPractice practice = (from r in db.ReferringPractices where r.PracID == prac.PracID select r).FirstOrDefault(); //If user preference query returns a value, update it. If not, create a new entry in the db if (practice != null) { db.Entry(practice).State = EntityState.Modified; } else { db.ReferringPractices.Add(prac); } db.SaveChanges(); }
public JsonResult jsonSubmitPracticeInformation(ReferringPractice prac) { string result = ""; ReferringPractice newPrac = DataCollections.getPractice(db, prac.PracID); newPrac.Address1 = prac.Address1; newPrac.Address2 = prac.Address2; newPrac.Address3 = prac.Address3; newPrac.City = prac.City; newPrac.State = prac.State; newPrac.Zip = prac.Zip; newPrac.Phone = prac.Phone; newPrac.Fax = prac.Fax; newPrac.Email = prac.Email; newPrac.OfficeManager = prac.OfficeManager; newPrac.Other = prac.Other; newPrac.PDFPassword = prac.PDFPassword; DataSubmissions.SavePractice(db, newPrac); result = "Practice Information Saved"; return(Json(result)); }
private void sendCommunications(string ids) { List <int> listofID = new List <int>(); string[] splitList; splitList = ids.Split(new char[] { ',' }); foreach (string i in splitList) { int theID = Convert.ToInt32(i); //Query patient record PatientLog pat = db.PatientLogs.Find(theID); //Determine fax type from table string faxType = (from f in db.FaxServiceTypes where f.Service == pat.ServiceType select f.FaxType).Single() + "Notice"; //Break apart PCP name string[] splitName; splitName = pat.PCP_Practice.Split(new char[] { ',' }); string pcpName = splitName[1] + " " + splitName[0]; string firstname = splitName[1].Trim(); //LINQ doesn't like arrays, throws error string lastname = splitName[0].Trim(); string pcpID = (from u in db.Users where u.FirstName == firstname && u.LastName == lastname select u.UserID).Single(); //Get practice info of PCP, default to AIMS otherwise ReferringPractice prac = new ReferringPractice(); try { prac = (from p in db.ReferringPractices join r in db.RefPracUsers on p.PracID equals r.PracID where r.UserID == pcpID select p).Single(); } catch { prac.Fax = "248-354-4807"; prac.FaxNotification = true; } //Create new reportviewer object and set parameters ReportViewer report = new ReportViewer(); report.ProcessingMode = ProcessingMode.Local; report.LocalReport.ReportPath = Server.MapPath("~") + "AdDisNotice\\" + faxType + pat.Hospital + ".rdlc"; //Cannot perform ToShortDateString on pat.ServiceDate because of DateTime? type DateTime thed = new DateTime(); thed = Convert.ToDateTime(pat.ServiceDate); DateTime birth = new DateTime(); //Null values will cause the reportviewer control to error out try { birth = Convert.ToDateTime(pat.DOB); } catch { birth = DateTime.Parse("1/1/1900"); } if (pat.PatientName == null) { pat.PatientName = ""; } if (pat.Comments == null) { pat.Comments = ""; } if (pat.MRN_FIN == null) { pat.MRN_FIN = ""; } ReportParameter dateparam = new ReportParameter("Date", thed.ToShortDateString()); ReportParameter faxparam = new ReportParameter("Fax", prac.Fax); ReportParameter faxtoparam = new ReportParameter("FaxTo", pcpName); ReportParameter dischargeparam = new ReportParameter("DischargeDate", thed.ToShortDateString()); ReportParameter patientparam = new ReportParameter("Patient", pat.PatientName); ReportParameter treatmentparam = new ReportParameter("Treatment", pat.Comments); ReportParameter mrnparam = new ReportParameter("MRN", pat.MRN_FIN); ReportParameter physicianparam = new ReportParameter("Physician", HubSecurity.getLoggedInDisplayName()); ReportParameter dobparam = new ReportParameter("DOB", birth.ToShortDateString()); ReportParameterCollection theparams = new ReportParameterCollection() { dateparam, faxparam, faxtoparam, dischargeparam, patientparam, treatmentparam, mrnparam, physicianparam, dobparam }; report.LocalReport.SetParameters(theparams); report.LocalReport.Refresh(); string notificationTypes = ""; if (prac.FaxNotification == true) { notificationTypes += "Fax;"; } if (prac.EmailNotification == true) { notificationTypes += "Email;"; } GenerateComms gcomm = new GenerateComms(); gcomm.SendFax(faxType, report, FAX_FOLDER, prac.Fax, pat.Hospital, HubSecurity.getLoggedInUserID(), pcpID, pcpName, pat.ID, pat.PatientName, pat.Comments, "", notificationTypes, birth.ToShortDateString(), prac.PDFPassword, pat.Hospital + faxType, prac.Email, ""); } }
public static ReferringPractice getPractice(PatientLogModel db, int PracID) { ReferringPractice prac = (from r in db.ReferringPractices where r.PracID == PracID select r).Single(); return(prac); }