public ActionResult jsonSubmitPatient(PatientLog patientLog) { try { if (ModelState.IsValid) { PatientLog sourcePatient; sourcePatient = (from p in db.PatientLogs where p.ID == patientLog.ID select p).Single(); sourcePatient.Notes = patientLog.Notes; sourcePatient.FaceSheet = patientLog.FaceSheet; db.Entry(sourcePatient).State = EntityState.Modified; db.SaveChanges(); return(Content("Patient information has been saved successfully!")); } else { return(Content("Model state is not valid.")); } } catch (Exception ex) { return(Content(ex.Message)); } }
//Saves specialties to all of admins practices public static void SaveSpecialties(PatientLogModel db, List <RefPracSpecialty> specialties, string practiceAdmin) { List <int> ids = new List <int>(); ids = (from a in db.RefPracAdmins where a.UserID == practiceAdmin select a.PracID).ToList(); foreach (int id in ids) { bool exists = (from s in db.RefPracSpecialties where s.PracID == id select s.ID).Any(); if (exists) { foreach (RefPracSpecialty spec in specialties) { RefPracSpecialty oldSpec = (from s in db.RefPracSpecialties where s.PracID == id && s.Specialty == spec.Specialty select s).Single(); oldSpec.FirstChoice = spec.FirstChoice; oldSpec.Backup = spec.Backup; oldSpec.Comments = spec.Comments; db.Entry(oldSpec).State = EntityState.Modified; } } else { foreach (RefPracSpecialty spec in specialties) { spec.PracID = id; db.RefPracSpecialties.Add(spec); } } } db.SaveChanges(); }
public static void SavePreferences(PatientLogModel db, string controller, string viewModel, Dictionary <string, string> values) { if (values.Count > 0) { string userID = HubSecurity.getLoggedInUserID(); foreach (KeyValuePair <string, string> entry in values) { UserPreference preference = (from u in db.UserPreferences where u.Controller == controller && u.ViewModel == viewModel && u.FilterName == entry.Key && u.UserID == userID select u).FirstOrDefault(); //If user preference query returns a value, update it. If not, create a new entry in the db if (preference != null) { preference.FilterValue = entry.Value; db.Entry(preference).State = EntityState.Modified; } else { preference = new UserPreference(); preference.Controller = controller; preference.ViewModel = viewModel; preference.FilterName = entry.Key; preference.FilterValue = entry.Value; preference.UserID = userID; db.UserPreferences.Add(preference); } } db.SaveChanges(); } }
//private static string getController() //{ // try // { // return HttpContext.Current.Request.FilePath.Substring(1, HttpContext.Current.Request.FilePath.LastIndexOf("/") - 1); // } // catch (Exception ex) // { // return "getControllerErrored"; // } //} //private static string getPage() //{ // try // { // return HttpContext.Current.Request.FilePath.Substring(HttpContext.Current.Request.FilePath.LastIndexOf("/") + 1); // } // catch (Exception ex) // { // return "getPageErrored"; // } //} public static int CreateFavorite(PatientLogModel db, string users, string hospitals, string types, string name, bool isDefault) { ScheduleFavorite fave = new ScheduleFavorite(); fave.Users = users; fave.Hospital = hospitals; fave.Types = types; fave.Name = name; fave.Default = isDefault; fave.UserID = HubSecurity.getLoggedInUserID(); //If this entry is set to be default, make sure all current ones get default put to false if (isDefault) { List <int> ids = (from f in db.ScheduleFavorites where f.UserID == fave.UserID select f.ID).ToList(); foreach (int id in ids) { ScheduleFavorite f = db.ScheduleFavorites.Find(id); f.Default = false; db.Entry(f).State = EntityState.Modified; } } db.ScheduleFavorites.Add(fave); db.SaveChanges(); return(fave.ID); }
public static int MassEditSchedule(PatientLogModel db, List <string> users, List <string> hosps, List <string> types, DateTime start, DateTime end, string criteria, string change) { DateTime newStart = start.Date + new TimeSpan(0, 0, 0); DateTime newEnd = end.Date + new TimeSpan(23, 59, 59); int count; IQueryable <ScheduleWorkArea> toEdit = from w in db.ScheduleWorkAreas where w.StartTime >= newStart && w.StartTime <= newEnd select w; if (users.Any()) { toEdit = toEdit.Where(w => users.Contains(w.UserID)); } if (hosps.Any()) { toEdit = toEdit.Where(w => hosps.Contains(w.HospitalShortName)); } if (types.Any()) { toEdit = toEdit.Where(w => types.Contains(w.ScheduleType)); } count = toEdit.Count(); foreach (ScheduleWorkArea sch in toEdit) { string shortHand = sch.ScheduleType.Substring(sch.ScheduleType.IndexOf("(") + 1); shortHand = shortHand.Substring(0, shortHand.Count() - 1); switch (criteria) { case "Hospital": sch.HospitalShortName = change; sch.Title = sch.HospitalShortName + "-" + shortHand + "-" + sch.UserID.Substring(1); break; case "StartTime": sch.StartTime = DateTime.Parse(change); break; case "EndTime": sch.EndTime = DateTime.Parse(change); break; case "ScheduleType": sch.ScheduleType = change; sch.Title = sch.HospitalShortName + "-" + shortHand + "-" + sch.UserID.Substring(1); break; case "UserID": sch.UserID = change; sch.Title = sch.HospitalShortName + "-" + shortHand + "-" + sch.UserID.Substring(1); break; } db.Entry(sch).State = EntityState.Modified; } db.SaveChanges(); return(count); }
private void UpdateStatus(PCPCommunication comm, string status) { PatientLogModel db = new PatientLogModel(); comm.CommStatus = status; db.Entry(comm).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); db.Dispose(); }
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 static void SetDailyRepeatSchedule(PatientLogModel db, string user, string hospital, string type, DateTime start, DateTime end, int interval, DateTime repeatTo) //{ //} public static string SetDefaultFavorite(PatientLogModel db, string id) { string userid = HubSecurity.getLoggedInUserID(); string ret; int newID = Convert.ToInt32(id); List <ScheduleFavorite> query = (from f in db.ScheduleFavorites where f.UserID == userid select f).ToList(); foreach (ScheduleFavorite f in query) { f.Default = false; db.Entry(f).State = EntityState.Modified; } ScheduleFavorite newD = db.ScheduleFavorites.Find(newID); ret = newD.Name; newD.Default = true; db.Entry(newD).State = EntityState.Modified; db.SaveChanges(); return(ret); }
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 async Task <ActionResult> Edit([Bind(Include = "ID,Physician,Hospital,PCP_Practice,MRN_FIN,PatientName,DateCreated,ServiceType,Comments,LastUpdated,ServiceDate,RoomNo,AIMSComments,FaceSheet,Notes,AIMSBillingCodes,DOB,Gender,PatientClass")] PatientLog patientLog) { if (ModelState.IsValid) { patientLog.LastUpdated = DateTime.Now; db.Entry(patientLog).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(patientLog)); }
public static void SavePatient(PatientLogModel db, PatientLog patient) { patient.LastUpdated = DateTime.Now; db.Entry(patient).State = EntityState.Modified; //db.Audits.Add(new Audit //{ // Action = "Update", // FunctionUsed = "SavePatient(PatientLog)", // UserID = HubSecurity.getLoggedInUserID(), // TargetIDs = patient.ID.ToString(), // Controller = getController(), // Page = getPage(), // TimeStamp = DateTime.Now //}); db.SaveChanges(); }
public static void SavePatients(PatientLogModel db, PatientLog[] patient) { //string ids = ""; foreach (PatientLog pat in patient) { pat.LastUpdated = DateTime.Now; db.Entry(pat).State = EntityState.Modified; //ids += pat.ID.ToString() + ","; } //db.Audits.Add(new Audit //{ // Action = "Update", // FunctionUsed = "SavePatients(PatientLog[])", // UserID = HubSecurity.getLoggedInUserID(), // TargetIDs = ids.Substring(0, ids.Length - 1), // Controller = getController(), // Page = getPage(), // TimeStamp = DateTime.Now //}); db.SaveChanges(); }
//Saves specialties public static void SaveSpecialties(PatientLogModel db, List <RefPracSpecialty> specialties) { //Zero ID indicates this has never been saved to the database before if (specialties[0].ID == 0) { foreach (RefPracSpecialty spec in specialties) { db.RefPracSpecialties.Add(spec); } } else { foreach (RefPracSpecialty spec in specialties) { RefPracSpecialty oldSpec = (from s in db.RefPracSpecialties where s.ID == spec.ID select s).Single(); oldSpec.FirstChoice = spec.FirstChoice; oldSpec.Backup = spec.Backup; oldSpec.Comments = spec.Comments; db.Entry(oldSpec).State = EntityState.Modified; } } db.SaveChanges(); }
public static void SavePreference(PatientLogModel db, string controller, string viewModel, string filterName, string filterValue) { string userID = HubSecurity.getLoggedInUserID(); UserPreference preference = (from u in db.UserPreferences where u.Controller == controller && u.ViewModel == viewModel && u.FilterName == filterName && u.UserID == userID select u).FirstOrDefault(); //If user preference query returns a value, update it. If not, create a new entry in the db if (preference != null) { preference.FilterValue = filterValue; db.Entry(preference).State = EntityState.Modified; } else { preference.Controller = controller; preference.ViewModel = viewModel; preference.FilterName = filterName; preference.FilterValue = filterValue; preference.UserID = userID; db.UserPreferences.Add(preference); } //Decided to leave this outside of the function so that it is only called once, supposed to be more efficient //db.SaveChanges(); }
public JsonResult jsonImportFileCommit(HttpPostedFileBase file, string columns, bool copyDayBefore, bool sourceListFinal, string hospital) { file.SaveAs("C:\\Data\\PatientAssignment\\" + file.FileName); FileInfo savedFile = new FileInfo("C:\\Data\\PatientAssignment\\" + file.FileName); DataTable result = new DataTable(); ExcelPackage pack = new ExcelPackage(savedFile); result = ToDataTable(pack); DateTime srvDate = DateTime.Now.Date + new TimeSpan(00, 00, 00); string[] splitColumns = columns.Split(new char[] { ',' }); List <string> listMRNs = new List <string>(); //List of imported MRN's used to evaluate whether the record should be deleted if sourceListFinal is true string[] dcs = new string[] { "DC - STD", "DC - EXT" }; //Copies from day before if selected to do so if (copyDayBefore) { DateTime dayBefore = srvDate.AddDays(-1); var query = from p in db.PatientLogs where p.ServiceDate == dayBefore && p.Hospital == hospital && !dcs.Contains(p.ServiceType) select p; foreach (PatientLog pat in query) { pat.ServiceDate = srvDate; pat.ServiceType = "Assigned"; db.PatientLogs.Add(pat); } db.SaveChanges(); } DataValidations validate = new DataValidations(); //Parses the Excel spreadsheet to create a Patient object for (int i = 0; i < result.Rows.Count; i++) { PatientLog patient = new PatientLog(); for (int j = 0; j < splitColumns.Length; j++) { switch (splitColumns[j]) { case "Comments": patient.Comments = result.Rows[i][j].ToString(); break; case "DOB": try { patient.DOB = DateTime.Parse(result.Rows[i][j].ToString()); } catch { patient.DOB = DateTime.Parse("1/1/1900"); } break; case "Gender": patient.Gender = validate.checkGender(db, result.Rows[i][j].ToString()); break; case "Hospital": patient.Hospital = result.Rows[i][j].ToString(); break; case "MRN_FIN": patient.MRN_FIN = result.Rows[i][j].ToString(); listMRNs.Add(patient.MRN_FIN); break; case "PatientClass": patient.PatientClass = result.Rows[i][j].ToString(); break; case "PatientName": patient.PatientName = result.Rows[i][j].ToString(); break; case "PCP_Practice": patient.PCP_Practice = validate.checkPCPandHosp(db, result.Rows[i][j].ToString(), hospital); break; case "Physician": patient.Physician = validate.checkAIMSPhyAndHosp(db, result.Rows[i][j].ToString(), hospital); break; case "RoomNo": patient.RoomNo = result.Rows[i][j].ToString(); break; case "ServiceDate": try { patient.ServiceDate = DateTime.Parse(result.Rows[i][j].ToString()); } catch { patient.ServiceDate = DateTime.Parse(DateTime.Now.ToShortDateString()); } break; case "ServiceType": patient.ServiceType = result.Rows[i][j].ToString(); break; } } patient.Hospital = hospital; if (patient.ServiceDate == null) { patient.ServiceDate = srvDate; } //Set default service type if none exists if (patient.ServiceType == null || patient.ServiceType == "") { patient.ServiceType = "Assigned"; } //Detect if patient already exists bool alreadyExists = (from p in db.PatientLogs where p.PatientName == patient.PatientName && p.MRN_FIN == patient.MRN_FIN && p.ServiceDate == patient.ServiceDate select p).Any(); //If does not exist, add, otherwise check if sourceFinalList is true and evaluate eligibility if (!alreadyExists) { //Set physician to unassigned if none exists if (patient.Physician == null || patient.Physician == "") { patient.Physician = "Unassigned"; } patient.DateCreated = DateTime.Now; db.PatientLogs.Add(patient); } else { PatientLog oldData = (from p in db.PatientLogs where p.PatientName == patient.PatientName && p.MRN_FIN == patient.MRN_FIN && p.ServiceDate == patient.ServiceDate select p).First(); if (patient.Comments != null && patient.Comments != "") { oldData.Comments = patient.Comments; } if (patient.DOB != null) { oldData.DOB = patient.DOB; } if (patient.Gender != null && patient.Gender != "") { oldData.Gender = patient.Gender; } if (patient.Hospital != null && patient.Hospital != "") { oldData.Hospital = patient.Hospital; } if (patient.PatientClass != null && patient.PatientClass != "") { oldData.PatientClass = patient.PatientClass; } if (patient.PCP_Practice != null && patient.PCP_Practice != "") { oldData.PCP_Practice = patient.PCP_Practice; } if (patient.Physician != null && patient.Physician != "") { oldData.Physician = patient.Physician; } if (patient.RoomNo != null && patient.RoomNo != "") { oldData.RoomNo = patient.RoomNo; } if (patient.ServiceType != null && patient.ServiceType != "") { oldData.ServiceType = patient.ServiceType; } db.Entry(oldData).State = EntityState.Modified; //oldData = MergePatient(oldData, patient); //db.SaveChanges(); } //patient.Hospital = hospital; //importList.Add(patient); } db.SaveChanges(); //If sourceListFinal is true and this MRN is not found, it is deleted if (sourceListFinal) { var todaysPatients = from p in db.PatientLogs where p.ServiceDate == srvDate && p.Hospital == hospital && !dcs.Contains(p.ServiceType) select p; foreach (PatientLog pat in todaysPatients) { if (!listMRNs.Contains(pat.MRN_FIN)) { db.PatientLogs.Remove(pat); } } } db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); }