public PrintQueueEntryList(bool include) { includePrinted = include ? 1 : 0; constructor_args = null; this.pc = new ParameterCollection(); pc.Add("includePrinted", includePrinted); }
/**************************************************************************************************/ public override void BackgroundLoadWork() { ParameterCollection pc = new ParameterCollection(); pc.Add("clinicId", clinicId); DoLoadWithSpAndParams("sp_3_LoadAtRisk", pc); DoLoadWithSpAndParams("sp_3_LoadDashboardCounts", pc); }
private void btnOK_Click(object sender, EventArgs e) { Utilities.ParameterCollection pc = new RiskApps3.Utilities.ParameterCollection(); pc.Add("MRN", txtMRN.Text); if ((retName != patientName) && (!String.IsNullOrEmpty(retName))) { errorProvider1.SetError(txtName, "Name and MRN discrepency found!"); StringBuilder sb = new StringBuilder(); sb.Append("There is an MRN associated with "); sb.Append("\"" + retName + "\" "); sb.Append("would you like to save appointment with patient identified name: "); sb.Append(patientName + "?"); txtInstructions.Text = sb.ToString(); retName = patientName; } else { //Test if mrn in text box changed from last iteration if (txtMRN.Text != patientEnteredMRN) { txtInstructions.Text = "Is this correct?"; patientEnteredMRN = txtMRN.Text; } else { retMRN = txtMRN.Text; this.Close(); } } }
public void SetLabels(int id, string mutProb, string name, string relationship) { relId = id; //old v2 way: //testingWillingnessComboBox.Text = // Patient.getRelativeValueFromDB("tblRiskDataRelatives", "testingWillingness", relId); RelativeValueHolder relValHolder = new RelativeValueHolder(""); ParameterCollection pc = new ParameterCollection("unitnum", SessionManager.Instance.GetActivePatient().unitnum); pc.Add("relativeid", relId); pc.Add("table", "tblRiskDataRelatives"); pc.Add("column", "testingWillingness"); relValHolder.DoLoadWithSpAndParams("sp_3_LoadRelativeValue", pc); testingWillingnessComboBox.Text = relValHolder.relativeValue; if (string.IsNullOrEmpty(mutProb) == false) { try { brcapro = (int)Math.Round(double.Parse(mutProb)); if (brcapro > 0) { BrcaLabel.Text = brcapro.ToString() + "%"; } else { BrcaLabel.Text = ""; } } catch { } } else { BrcaLabel.Text = ""; } // You might well not know the mother's name (e.g.) if (!String.IsNullOrEmpty(name)) { if (name.Contains(" ")) { string[] tokens = name.Split(' '); if (name.Contains(',')) name = tokens[1].Replace(",",""); else name = tokens[0]; } //NameLabel.Text = name; RelationshipLabel.Text = name; } else { RelationshipLabel.Text = relationship; } RelationshipLabel.Text = RelationshipLabel.Text.Replace(" ", Environment.NewLine); int delta = this.Height - RelationshipLabel.Height; RelationshipLabel.Location = new Point(RelationshipLabel.Location.X, delta / 2); }
/**************************************************************************************************/ public override void BackgroundLoadWork() { ParameterCollection pc = new ParameterCollection(); pc.Add("clinicId", clinicId); dt = new DataTable(); SqlDataReader dr = BCDB2.Instance.ExecuteReaderSPWithParams("sp_3_LoadMyPatientsQueue", pc); dt.Load(dr); }
public static void UpdateBigQueueByMrn(string mrn) { if (string.IsNullOrEmpty(mrn) == false) { ParameterCollection pc = new ParameterCollection("unitnum", mrn); BCDB2.Instance.RunSPWithParams("sp_3_populateBigQueue", pc); } }
public PatientsByGroup(string userLogin, string groupName) { this.constructor_args = new object[] { }; this.pc = new ParameterCollection(); this.userLogin = userLogin; this.groupName = groupName; }
/**************************************************************************************************/ public override void BackgroundPersistWork(HraModelChangedEventArgs e) { var pc = new ParameterCollection(); pc.Add("unitnum", unitnum); DoPersistWithSpAndParams(e, "sp_3_Save_PedigreeAnnotations", ref pc); }
/**************************************************************************************************/ public override void BackgroundLoadWork() { //dt = BCDB2.Instance.getDataTable(@"SELECT * from tblBigQueue where BreastHRQ = 1"); ParameterCollection pc = new ParameterCollection(); pc.Add("clinicId", clinicId); dt = new DataTable(); SqlDataReader dr = BCDB2.Instance.ExecuteReaderSPWithParams("sp_3_LoadModerateBreastRiskQueue", pc); dt.Load(dr); }
/**************************************************************************************************/ public override void BackgroundLoadWork() { ParameterCollection pc = new ParameterCollection("unitnum", theProband.unitnum); pc.Add("apptid", theProband.apptid); DoLoadWithSpAndParams("sp_3_LoadProcHx", pc); breastBx.BackgroundLoadWork(); base.BackgroundLoadWork(); }
/**************************************************************************************************/ public override void BackgroundPersistWork(HraModelChangedEventArgs e) { ParameterCollection pc = new ParameterCollection(); pc.Add("unitnum", theProband.unitnum); pc.Add("apptid", theProband.apptid); DoPersistWithSpAndParams(e, "sp_3_Save_ProcHx", ref pc); }
/**************************************************************************************************/ public override void BackgroundLoadWork() { //fill the local datatable object //dt = BCDB2.Instance.getDataTable(@"SELECT * from tblBigQueue where BeingFollowedInRiskClinic = 1"); ParameterCollection pc = new ParameterCollection(); pc.Add("clinicId", clinicId); dt = new DataTable(); SqlDataReader dr = BCDB2.Instance.ExecuteReaderSPWithParams("sp_3_LoadBeingFollowedQueue", pc); dt.Load(dr); }
/**************************************************************************************************/ public override void BackgroundPersistWork(HraModelChangedEventArgs e) { ParameterCollection pc = new ParameterCollection(); pc.Add("unitnum", owner.person.owningFHx.proband.unitnum); pc.Add("relativeID", owner.person.relativeID); pc.Add("apptid", owner.person.owningFHx.proband.apptid); DoPersistWithSpAndParams(e, "sp_3_Save_Nation", ref pc); }
/*******************************************************************************/ public override void BackgroundPersistWork(HraModelChangedEventArgs e) { ParameterCollection pc = new ParameterCollection(); pc.Add("paragraphID", paragraphID); pc.Add("providerID", providerID); DoPersistWithSpAndParams(e, "sp_3_Save_ProviderParagraph", ref pc); }
/**************************************************************************************************/ public override void BackgroundLoadWork() { //fill the local datatable object //dt = BCDB2.Instance.getDataTable(@"SELECT * from tblBigQueue where NumTestedFamilyMembers > 0"); ParameterCollection pc = new ParameterCollection(); pc.Add("clinicId", clinicId); dt = new DataTable(); SqlDataReader dr = BCDB2.Instance.ExecuteReaderSPWithParams("sp_3_LoadBrcaPositiveQueue", pc); dt.Load(dr); }
/**************************************************************************************************/ public override void BackgroundLoadWork() { //fill the local datatable object //dt = BCDB2.Instance.getDataTable(@"SELECT * from tblBigQueue where MaxLifetimeScore > 20.0"); ParameterCollection pc = new ParameterCollection(); pc.Add("clinicId", clinicId); dt = new DataTable(); SqlDataReader dr = BCDB2.Instance.ExecuteReaderSPWithParams("sp_3_LoadHighRiskLifetimeBreastQueue", pc); dt.Load(dr); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { System.Collections.ArrayList appts = (System.Collections.ArrayList)(e.Argument); foreach (object o in appts) { TestAppointment to = (TestAppointment)o; Utilities.ParameterCollection pc = new RiskApps3.Utilities.ParameterCollection(); pc.Add("apptID", to.apptID); BCDB2.Instance.RunSPWithParams("sp_AddTestPatientExclusion", pc); } }
/**************************************************************************************************/ public override void BackgroundLoadWork() { ParameterCollection pc = new ParameterCollection(); pc.Add("clinicId", clinicId); pc.Add("when", date); //pc.Add("groupName", groupName); //pc.Add("userLogin", SessionManager.Instance.ActiveUser.userLogin); DoLoadWithSpAndParams("sp_3_GetMyPatientCounts", pc); }
//a customized persistence method for TcRiskByAge items public void PersistFullObject(HraModelChangedEventArgs e, string unitnum, int apptid, string version, DateTime? BMRS_EffectiveTime, Int64? BMRS_RequestId) { ParameterCollection pc = new ParameterCollection(); pc.Add("unitnum", unitnum); pc.Add("apptid", apptid); pc.Add("version", version); pc.Add("BMRS_EffectiveTime", BMRS_EffectiveTime); pc.Add("BMRS_RequestId", BMRS_RequestId); DoPersistWithSpAndParams(e, "sp_3_Save_TcRiskByAge", ref pc); }
/**************************************************************************************************/ public override void BackgroundLoadWork() { ParameterCollection pc = new ParameterCollection(); pc.Add("clinicId", clinicId); pc.Add("startTime", startTime); pc.Add("endTime", endTime); pc.Add("type", type); pc.Add("output", output); DoLoadWithSpAndParams("sp_3_LoadBreastImagingDashboardElement", pc); pc.Clear(); pc.Add("type", type); DoLoadWithSpAndParams("sp_3_LoadFilterDescription", pc); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { LegacyCoreAPI.StartWorkingWithAppointment(apptid, ""); ParameterCollection pc = new ParameterCollection(); pc.Add("application", "RiskApps3"); pc.Add("userLogin", SessionManager.Instance.ActiveUser.userLogin); pc.Add("machineName", System.Environment.MachineName); pc.Add("message", "Accessed appointment"); pc.Add("apptID", apptid); BCDB2.Instance.RunSPWithParams("sp_3_AuditUserActivity", pc); }
/**************************************************************************************************/ public override void BackgroundLoadWork() { //(optionally) update the big queue table in the database ParameterCollection pc = new ParameterCollection(); if (forceUpdate != null) { pc.Add("forceUpdate", forceUpdate); } DoLoadWithSpAndParams("sp_3_UpdateQueueDataWhenOld", pc); forceUpdate = null; //fill the local datatable object dt = BCDB2.Instance.getDataTable(@"SELECT * from tblBigQueue"); }
private void deleteBackgroundWorker_DoWork(object sender, DoWorkEventArgs e) { System.Collections.ArrayList appts = (System.Collections.ArrayList)(e.Argument); foreach (object o in appts) { TestAppointment to = (TestAppointment)o; Utilities.ParameterCollection pc = new RiskApps3.Utilities.ParameterCollection(); pc.Add("apptID", to.apptID); pc.Add("purgeAuditData", 0); pc.Add("userLoginID", SessionManager.Instance.ActiveUser.userLogin); pc.Add("machineNameID", System.Environment.MachineName); pc.Add("applicationID", "RiskApps3 - DeleteTestAppointmentsPopup"); BCDB2.Instance.RunSPWithParams("sp_deleteWebAppointment", pc); } }
private string GetAreaProvidersByRelId(int r) { string retval = ""; if (proband != null) { string sqlStr = "SELECT zipcode, city, state FROM tblRelativeDetails WHERE relativeID=@relativeID AND apptID=@apptID"; ParameterCollection pc = new ParameterCollection(); pc.Add("relativeID", r); pc.Add("apptID", proband.apptid); DbDataReader reader = BCDB2.Instance.ExecuteReaderWithParams(sqlStr, pc); bool hasZipCode = false; String zipcode = ""; String city = ""; String state = ""; if (reader.Read()) { zipcode = reader.GetValue(0).ToString(); city = reader.GetValue(1).ToString(); state = reader.GetValue(2).ToString(); } reader.Close(); if (zipcode != "") { hasZipCode = ZipCodes.isValidZip(zipcode); } else { zipcode = ZipCodes.getZipCode(city, state); if (zipcode != "") { hasZipCode = ZipCodes.isValidZip(zipcode); } } if (hasZipCode) { retval = GetAreaProvidersByZipCode(zipcode); } } return retval; }
/**************************************************************************************************/ public override void BackgroundPersistWork(HraModelChangedEventArgs e) { ParameterCollection pc = new ParameterCollection(); try { pc.Add("ID", ID); pc.Add("parameterValue", parameterValue); SqlDataReader reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_3_SetQueueParameter", pc); } catch (Exception ee) { Logger.Instance.WriteToLog("Error saving QueueParameter: \r\n" + ee.InnerException.ToString()); } }
public static bool isValidZip(String zipcode) { bool validZip = false; String sqlStr = "SELECT city FROM lkpZipCodes WHERE zipcode=@zipcode"; ParameterCollection pc = new ParameterCollection(); pc.Add("zipcode", zipcode); DbDataReader reader = BCDB2.Instance.ExecuteReaderWithParams(sqlStr, pc); if (reader.Read()) { validZip = true; } reader.Close(); return validZip; }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { //RiskAppCore.Globals.setApptID(apptid); //RiskAppCore.ApptUtils.MarkApptStartedAndPullForward(); //SessionManager.Instance.GetActivePatient().hra_state = Model.HraObject.States.NULL; LegacyCoreAPI.StartWorkingWithAppointment(apptid,""); SessionManager.Instance.GetActivePatient().BackgroundLoadWork(); ParameterCollection pc = new ParameterCollection(); pc.Add("application", "RiskApps3"); pc.Add("userLogin", SessionManager.Instance.ActiveUser.userLogin); pc.Add("machineName", System.Environment.MachineName); pc.Add("message", "Accessed appointment"); pc.Add("apptID", apptid); BCDB2.Instance.RunSPWithParams("sp_3_AuditUserActivity", pc); }
public static double getDistance(String zipcode1, String zipcode2) { String lat1 = ""; String long1 = ""; String lat2 = ""; String long2 = ""; // get lat and long for first zipcode String sqlStr = "SELECT latitude, longitude FROM lkpZipCodes WHERE zipcode=@zipcode"; ParameterCollection pc = new ParameterCollection(); pc.Add("zipcode", zipcode1); DbDataReader reader =BCDB2.Instance.ExecuteReaderWithParams(sqlStr, pc); while (reader.Read()) { lat1 = reader.GetValue(0).ToString(); long1 = reader.GetValue(1).ToString(); } reader.Close(); // get lat and long for second zipcode sqlStr = "SELECT latitude, longitude FROM lkpZipCodes WHERE zipcode=@zipcode"; pc = new ParameterCollection(); pc.Add("zipcode", zipcode2); reader = BCDB2.Instance.ExecuteReaderWithParams(sqlStr, pc); while (reader.Read()) { lat2 = reader.GetValue(0).ToString(); long2 = reader.GetValue(1).ToString(); } reader.Close(); if (lat1 == "" || long1 == "" || lat2 == "" || long2 == "") { return 0.0; } double latitude1 = Double.Parse(lat1); double longitude1 = Double.Parse(long1); double latitude2 = Double.Parse(lat2); double longitude2 = Double.Parse(long2); return Haversine(latitude1, longitude1, latitude2, longitude2); }
public override void BackgroundLoadWork() { int output; if (mode == RiskApps3.View.Reporting.RiskElementControl.Mode.Incidence) output = 2; else output = 3; ParameterCollection pc = new ParameterCollection(); pc.Add("clinicId", clinicId); pc.Add("startTime", startTime); pc.Add("endTime", endTime); pc.Add("type", type); pc.Add("output", output); SqlDataReader dr = BCDB2.Instance.ExecuteReaderSPWithParams("sp_3_LoadBreastImagingDashboardElement", pc); dt = new DataTable(); dt.Load(dr); }
public static String getZipCode(String city, string state) { String zipcode = ""; String sqlStr = "SELECT zipcode FROM lkpZipCodes WHERE city=@city AND state=@state"; ParameterCollection pc = new ParameterCollection(); pc.Add("city",city); pc.Add("state",state); DbDataReader reader = BCDB2.Instance.ExecuteReaderWithParams(sqlStr, pc); if (reader.Read()) { zipcode = reader.GetValue(0).ToString(); } reader.Close(); return zipcode; }
public override void BackgroundLoadWork() { Claus_Table = ""; RelOne = ""; RelTwo = ""; ParameterCollection pc = new ParameterCollection("unitnum", unitnum); pc.Add("apptid", apptid); DoLoadWithSpAndParams("sp_3_LoadClausRiskFactors", pc); }
public bool AuthenticateUser(string username, string password, out string msg, out string fullName) { RA.User u = null; bool result = false; SessionManager.Instance.MetaData.Users.BackgroundListLoad(); fullName = string.Empty; var users = SessionManager.Instance.MetaData.Users; bool validUser = users.Any(x => ((RA.User)x).userLogin.ToLower() == username.ToLower()); if (validUser) { u = (RA.User)(users.First(x => ((RA.User)x).userLogin.ToLower() == username.ToLower())); } String encryptedPassword = RiskAppCore.User.encryptPassword(password); bool authenticated = false; int numFailedAttempts = 0; int numMaxFailures = 5; int lockoutPeriod = 0; string lockoutMsg = ""; RiskApps3.Utilities.ParameterCollection pc = new RiskApps3.Utilities.ParameterCollection(); pc.Add("ntLoginName", ""); pc.Add("userLogin", (u != null) ? u.userLogin : username); pc.Add("userPassword", encryptedPassword); SqlDataReader reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_Authenticate_User", pc); if (reader != null) { if (reader.Read()) { authenticated = (bool)reader.GetSqlBoolean(0); numFailedAttempts = (int)reader.GetInt32(1); numMaxFailures = (int)reader.GetInt32(2); lockoutPeriod = (int)reader.GetInt32(3); } reader.Close(); } if ((!validUser) || (!authenticated)) //note that if they're not a valid user they won't be authenticated, but we've updated the failed count and timeout values { if (lockoutPeriod > 0) { lockoutMsg = "\r\nLogin attempts will be blocked for " + lockoutPeriod.ToString() + " minute" + ((lockoutPeriod > 1) ? "s." : "."); } else { lockoutMsg = "\r\nYou have made " + numFailedAttempts.ToString() + " failed Login attempt" + ((numFailedAttempts > 1) ? "s" : "") + " of a maximum " + numMaxFailures.ToString() + " allowed."; } } msg = lockoutMsg; if (numFailedAttempts == 1) { msg = "You have provided an incorrect username or password.\r\nPlease correct your password or try a different user." + lockoutMsg; } result = (validUser && authenticated); if (result) { SessionManager.Instance.ActiveUser = u; HraObject.AuditUserLogin(u.userLogin); fullName = u.User_userFullName; _hraSessionManager.SetRaActiveUser(username); } return(result); }
private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e) { List <Appointment> appts = (List <Appointment>)e.Argument; try { foreach (object o in appts) { Appointment appt = (Appointment)o; if (appt.CloudWebQueueState == CREATE_NEW_APPT || appt.CloudWebQueueState == SYNCH_APPT) { backgroundWorker2.ReportProgress(2, "Retrieving Patient Record: " + appt.PatientName + " - " + appt.Dob); XmlNode xml = cloud.FetchPatientRecord(appt.apptID); MemoryStream stm = new MemoryStream(); StreamWriter stw = new StreamWriter(stm); stw.Write(xml.OuterXml); stw.Flush(); stm.Position = 0; backgroundWorker2.ReportProgress(2, "Saving Data: " + appt.PatientName + " - " + appt.Dob); DataContractSerializer ds = new DataContractSerializer(typeof(Patient)); Patient p2 = (Patient)ds.ReadObject(stm); if (appt.CloudWebQueueState == CREATE_NEW_APPT) { SurveyResponse newMRN = (SurveyResponse)p2.SurveyReponses.Find(g => ((SurveyResponse)g).responseTag == "PatientReportedMRN"); if (!String.IsNullOrEmpty(newMRN.SurveyResponse_responseValue)) { using (CloudMRNReconcile reconcileForm = new CloudMRNReconcile(newMRN.SurveyResponse_responseValue, p2.name, p2.apptid, appt.clinicID)) { reconcileForm.ShowDialog(); if ((reconcileForm.retMRN != "Cancel") && (!String.IsNullOrEmpty(reconcileForm.retMRN))) { p2.unitnum = reconcileForm.retMRN; } else { break; } } } Utilities.ParameterCollection pc = new RiskApps3.Utilities.ParameterCollection(); pc.Add("unitnum", p2.unitnum); pc.Add("patientname", p2.name); pc.Add("dob", p2.dob); pc.Add("clinicId", appt.ClinicId); object newApptId = BCDB2.Instance.ExecuteSpWithRetValAndParams("sp_createMasteryAppointment", SqlDbType.Int, pc); p2.apptid = (int)newApptId; } else { if (appt.CloudWebQueueState == SYNCH_APPT) { p2.apptid = appt.CloudWebQueueSynchId; } } p2.FHx.proband = p2; p2.PersistFullObject(new RiskApps3.Model.HraModelChangedEventArgs(null)); if (checkBox4.Checked) { backgroundWorker2.ReportProgress(2, "Marking Complete and updating meta data: " + appt.PatientName + " - " + appt.Dob); ParameterCollection pc = new ParameterCollection("apptID", p2.apptid); BCDB2.Instance.RunSPWithParams("sp_markRiskDataCompleted", pc); } if (checkBox1.Checked) { backgroundWorker2.ReportProgress(2, "Running Risk Models: " + appt.PatientName + " - " + appt.Dob); p2.RecalculateRisk(); ParameterCollection pc = new ParameterCollection("unitnum", p2.unitnum); BCDB2.Instance.RunSPWithParams("sp_3_populateBigQueue", pc); } if (checkBox2.Checked) { backgroundWorker2.ReportProgress(2, "Printing Automation Documents: " + appt.PatientName + " - " + appt.Dob); p2.RunAutomation(); //ParameterCollection printDocArgs = new ParameterCollection(); //printDocArgs.Add("apptid", p2.apptid); //SqlDataReader reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_AutomationHtmlDocsToPrint", printDocArgs); //while (reader.Read()) //{ // int templateID = -1; // if (reader.IsDBNull(0) == false) // { // templateID = reader.GetInt32(0); // } // SessionManager.Instance.SetActivePatientNoCallback(p2.unitnum, p2.apptid); // DocumentTemplate template = new DocumentTemplate(); // template.documentTemplateID = templateID; // template.BackgroundLoadWork(); // template.OpenHTML(); // template.ProcessDocument(); // htmlInProgress = true; // backgroundWorker2.ReportProgress(1, template.htmlText); // while (htmlInProgress) // { // Application.DoEvents(); // Thread.Sleep(500); // } //} } if (checkBox5.Checked) { backgroundWorker2.ReportProgress(2, "Removing Web Survey: " + appt.PatientName + " - " + appt.Dob); backgroundWorker2.ReportProgress(4, appt); cloud.DeleteSurvey(appt.apptID); } backgroundWorker2.ReportProgress(2, "Precessing Queue Documents: " + appt.PatientName + " - " + appt.Dob); if (checkBox3.Checked) { ParameterCollection pc = new ParameterCollection("apptID", p2.apptid); BCDB2.Instance.RunSPWithParams("sp_processQueueDocuments", pc); } } else if (appt.CloudWebQueueState == DELETE_APPT) { backgroundWorker2.ReportProgress(2, "Removing Web Survey: " + appt.PatientName + " - " + appt.Dob); backgroundWorker2.ReportProgress(4, appt); cloud.DeleteSurvey(appt.apptID); } backgroundWorker2.ReportProgress(3, o); } } catch (Exception exc) { Logger.Instance.WriteToLog(exc.ToString()); } }
private void btnCreate_Click(object sender, EventArgs e) { int surveyID = 0; //KeyValuePair<int, string> kvpSurvey; KeyValuePair <int, string> kvpClinic; foreach (KeyValuePair <int, string> pair in surveyDic) { if (pair.Value == cbSurvey.Text) { surveyID = pair.Key; } } int x = 0; if (cbNumPatients.SelectedItem != null) { int i = int.Parse(cbNumPatients.SelectedItem.ToString()); int index = 0; string time; Random random = new Random(); string firstName = ""; string nextUnitNum = createTestUnitnum(); long unitNum = Int64.Parse(nextUnitNum); while (i > x) { RiskApps3.Utilities.ParameterCollection pc = new RiskApps3.Utilities.ParameterCollection(); if (x <= 9) { time = "0" + x.ToString(); } else { time = (x % 60).ToString(); } pc.Add("apptdate", dtAppointmentDate.Value.ToString("MM/dd/yyyy")); pc.Add("appttime", "08:" + time + " AM"); index = random.Next(10000) % names.Count; firstName = names[index]; pc.Add("firstname", firstName); pc.Add("lastname", "Test" + cbSurvey.Text.Replace(" ", "")); pc.Add("gender", "F"); pc.Add("dob", "09/23/1970"); pc.Add("email", "*****@*****.**"); pc.Add("address1", (i * 10).ToString() + " Broadway"); pc.Add("city", "Cambridge"); pc.Add("state", "MA"); pc.Add("zip", "02473"); pc.Add("phone", "6175551212"); pc.Add("emailaddress", "*****@*****.**"); pc.Add("sendByEmail", 1); pc.Add("machinename", "test"); pc.Add("preferredInstitutionName", "test"); if (cbClinic.SelectedItem != null) { kvpClinic = (KeyValuePair <int, string>)cbClinic.SelectedItem; pc.Add("clinicID", kvpClinic.Key); } else { pc.Add("clinicID", 1); // default } pc.Add("unitnum", unitNum.ToString()); pc.Add("createdby", cbSurvey.Text); pc.Add("insertApptWebRecord", 1); pc.Add("surveyID", surveyID); BCDB2.Instance.ExecuteReaderSPWithParams("sp_createApptFromSchedService", pc); unitNum++; x++; } } this.Close(); }
public void automate() { if (status != null) { try { //status.LogHeartbeat(this.Text); } catch (Exception ex) { // Logger.Instance.WriteToLog(ex.ToString()); } } List <int> apptIDs = new List <int>(); /*********************** get appointments to automate ********************/ SqlDataReader reader; string CustomAutomationString = Configurator.getNodeValue("DatabaseInfo", "AUTOMATION_SQL"); if (string.IsNullOrEmpty(CustomAutomationString) == false) { reader = BCDB2.Instance.ExecuteReader(CustomAutomationString); } else { reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_Automation", null); } try { while (reader.Read()) { if (reader.IsDBNull(0) == false) { apptIDs.Add(reader.GetInt32(0)); } } } catch (Exception e) { Logger.Instance.WriteToLog("Error getting appointment IDs: " + e.ToString()); } finally { if (reader != null) { reader.Close(); } } if (apptIDs.Count == 0) { ProcessingThread.ReportProgress(0, "No appointments are marked for automation - " + DateTime.Now.ToString()); return; } /*********************** automation cycle ********************/ foreach (int apptid in apptIDs) { if (ProcessingThread.CancellationPending) { return; } ProcessingThread.ReportProgress(0, "Running automation for appt: " + apptid.ToString() + "."); /*********************** Get Unitnum & set active patient ********************/ string unitnum = ""; ParameterCollection pc = new ParameterCollection("apptID", apptid); using (reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_3_GetUnitnum", pc)) //ExecuteReader("SELECT unitnum FROM tblAppointments WHERE apptID = " + apptid)) { if (reader != null && reader.Read()) { unitnum = reader.GetValue(0).ToString(); } } //StatusReport sr = new StatusReport(); //sr.apptid = apptid; //sr.description = "Started Automation cycle"; //ProcessingThread.ReportProgress(300, sr); //StatusReport sr = (StatusReport)e.UserState; //if (status != null) //{ try { //temp debug //status.LogStatus(this.Text, // "Automation", // "Ok", // "tarted Automation cycle " + apptid.ToString()); } catch (Exception ex) { Logger.Instance.WriteToLog(ex.ToString()); } //} SessionManager.Instance.SetActivePatientNoCallback(unitnum, (int)apptid); /*********************** Risk Calculations ********************/ try { ProcessingThread.ReportProgress(1, "Running risk calculations for appointment: " + apptid.ToString() + "."); SessionManager.Instance.GetActivePatient().RecalculateRisk(); } catch (Exception e) { ProcessingThread.ReportProgress(1, "Risk calculations FAILED for appointment: " + apptid.ToString() + ". " + e.ToString()); } /*********************** Update BigQueue ********************/ try { ProcessingThread.ReportProgress(1, "Updating BigQueue for appointment: " + apptid.ToString() + "."); pc = new ParameterCollection("unitnum", unitnum); BCDB2.Instance.RunSPWithParams("sp_3_populateBigQueue", pc); } catch (Exception e) { ProcessingThread.ReportProgress(1, "Updating BigQueue FAILED for appointment: " + apptid.ToString() + ". " + e.ToString()); } /*********************** Process Queue Documents ********************/ ProcessingThread.ReportProgress(1, "Processing Queue Documents for appointment: " + apptid.ToString() + "."); pc = new ParameterCollection("apptID", apptid); BCDB2.Instance.RunSPWithParams("sp_processQueueDocuments", pc); /*********************** Process Automation Save Documents ********************/ ProcessingThread.ReportProgress(1, "Processing Auto Save Documents: " + apptid.ToString() + "."); ApptUtils.saveAutomationDocumentsToPrintQueue(apptid); /*********************** Run Automation Stored Procedures ********************/ ProcessingThread.ReportProgress(1, "Run Automation Stored Procedures : " + apptid.ToString() + "."); ApptUtils.runAutomationStoredProcedures(apptid); /*********************** export HL7 files ********************/ ProcessingThread.ReportProgress(1, "Export HL7 File: " + apptid.ToString() + "."); RiskService.exportHL7File(apptid); /*********************** Print Documents ********************/ try { ProcessingThread.ReportProgress(1, "Printing documents for appointment: " + apptid.ToString() + "."); ParameterCollection printDocArgs = new ParameterCollection(); printDocArgs.Add("apptid", apptid); reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_AutomationHtmlDocsToPrint", printDocArgs); int templateID = -1; string printer = ""; while (reader.Read()) { if (reader.IsDBNull(0) == false) { templateID = reader.GetInt32(0); } if (reader.IsDBNull(1) == false) { printer = reader.GetString(1); } if (templateID > 0) { if (string.IsNullOrEmpty(printer) == false) { if (printer.ToUpper() != "NO_PRINT") { ProcessingThread.ReportProgress(1, "Printing templateID " + templateID.ToString() + " for apptID " + apptid.ToString() + "."); HtmlDocument hdoc = new HtmlDocument(templateID, unitnum, apptid); hdoc.targetPrinter = printer; hdoc.apptid = apptid; htmlInProgress = true; //try //{ // ////temp debug // //status.LogStatus(this.Text, // // "Automation", // // "Ok", // // "Appt " + hdoc.apptid.ToString() + " Sent doc " + hdoc.template.documentTemplateID.ToString() + " to " + hdoc.targetPrinter); //} //catch (Exception ex) { Logger.Instance.WriteToLog(ex.ToString()); } if (status != null) { try { status.LogStatus(this.Text, "Automation", "Ok", "Appt " + hdoc.apptid.ToString() + " Sent doc " + hdoc.template.documentTemplateID.ToString() + " to " + hdoc.targetPrinter); } catch (System.Web.Services.Protocols.SoapException e) { //do nothing } catch (Exception ex) { Logger.Instance.WriteToLog(ex.ToString()); } } ProcessingThread.ReportProgress(100, hdoc); while (htmlInProgress) { Thread.Sleep(100); } string sqlStr = "INSERT INTO tblDocuments([apptID],[documentTemplateID],[created],[createdBy]) VALUES(" + hdoc.apptid.ToString() + "," + hdoc.template.documentTemplateID + "," + "'" + DateTime.Now + "','AUTOMATION');"; BCDB2.Instance.ExecuteNonQuery(sqlStr); } } } } } catch (Exception e) { ProcessingThread.ReportProgress(1, "Printing FAILED for appointment: " + apptid.ToString() + ". " + e.ToString()); } finally { if (reader != null) { reader.Close(); } } /*********************** Mark as printed to complete automation ********************/ try { String sqlStr = "UPDATE tblRiskData SET printed = 1 WHERE apptid = " + apptid.ToString() + ";"; BCDB2.Instance.ExecuteNonQuery(sqlStr); } catch (Exception e) { ProcessingThread.ReportProgress(1, ("Automation - unable to update appt id=" + apptid.ToString() + " printed=1.\n" + e.ToString())); } ProcessingThread.ReportProgress(200, ""); } }
private void loginButton_Click(object sender, EventArgs e) { string lockoutMsg = ""; User u = null; bool validUser = users.Any(x => ((User)x).userLogin.ToLower() == usernameTextBox.Text.ToLower()); if (validUser) { u = (User)(users.First(x => ((User)x).userLogin.ToLower() == usernameTextBox.Text.ToLower())); } // begin jdg 10/30/15 NameValueCollection values = Configurator.GetConfig("AppSettings"); if (values != null) { LDAPSecurityContext = values["SecurityContext"]; } if (String.IsNullOrEmpty(LDAPSecurityContext)) { LDAPSecurityContext = "Off"; } bool bLDAPSuccess = false; bool bLDAP = (((LDAPSecurityContext.ToUpper() == "MACHINE") || (LDAPSecurityContext.ToUpper() == "DOMAIN")) ? true : false); try { if (bLDAP) { switch (LDAPSecurityContext.ToUpper()) { case "MACHINE": using (var context = new PrincipalContext(ContextType.Machine)) { if (context.ValidateCredentials(usernameTextBox.Text, passwordTextBox.Text)) { bLDAPSuccess = true; } } break; case "DOMAIN": using (var context = new PrincipalContext(ContextType.Domain)) { if (context.ValidateCredentials(usernameTextBox.Text, passwordTextBox.Text)) { bLDAPSuccess = true; } } break; default: break; } } } catch (Exception excLDAP) { RiskApps3.Utilities.Logger.Instance.WriteToLog("LDAP Authentication failed for user " + usernameTextBox.Text + " for this reason: " + excLDAP.ToString()); } // end jdg 10/30/15 String encryptedPassword = RiskAppCore.User.encryptPassword(passwordTextBox.Text); bool authenticated = false; int numFailedAttempts = 0; int numMaxFailures = 5; int lockoutPeriod = 0; lockoutMsg = ""; Utilities.ParameterCollection pc = new Utilities.ParameterCollection(); pc.Add("ntLoginName", DBUtils.makeSQLSafe(ntUser)); pc.Add("userLogin", DBUtils.makeSQLSafe((u != null) ? u.userLogin : usernameTextBox.Text)); //if (SessionManager.Instance.MetaData.Globals.encryptPasswords) if ((SessionManager.Instance.MetaData.Globals.encryptPasswords) && (!bLDAP)) { pc.Add("userPassword", DBUtils.makeSQLSafe(encryptedPassword)); } else { pc.Add("userPassword", DBUtils.makeSQLSafe(passwordTextBox.Text)); } // begin jdg 10/30/15 pc.Add("bLDAP", (bLDAP ? 1 : 0)); pc.Add("bLDAPSuccess", (bLDAPSuccess ? 1 : 0)); // end jdg 10/30/15 SqlDataReader reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_Authenticate_User", pc); if (reader != null) { if (reader.Read()) { authenticated = (bool)reader.GetSqlBoolean(0); numFailedAttempts = (int)reader.GetInt32(1); numMaxFailures = (int)reader.GetInt32(2); lockoutPeriod = (int)reader.GetInt32(3); } reader.Close(); } if ((!validUser) || (!authenticated)) //note that if they're not a valid user they won't be authenticated, but we've updated the failed count and timeout values { if (lockoutPeriod > 0) { lockoutMsg = "\r\nLogin attempts will be blocked for " + lockoutPeriod.ToString() + " minute" + ((lockoutPeriod > 1) ? "s." : "."); } else { lockoutMsg = "\r\nYou have made " + numFailedAttempts.ToString() + " failed Login attempt" + ((numFailedAttempts > 1) ? "s" : "") + " of a maximum " + numMaxFailures.ToString() + " allowed."; } } if (validUser && authenticated) { //see if user is forced to change password if (!bLDAP) // jdg 10/30/15 { if (ApplicationUtils.checkPasswordForceChange(u.userLogin)) { String username = usernameTextBox.Text; SessionManager.Instance.MetaData.Users.BackgroundListLoad(); passwordTextBox.Text = ""; usernameTextBox.Text = username; this.DialogResult = System.Windows.Forms.DialogResult.None; return; } if (ApplicationUtils.checkPasswordDateOK(u.userLogin) == false) { String username = usernameTextBox.Text; SessionManager.Instance.MetaData.Users.BackgroundListLoad(); passwordTextBox.Text = ""; usernameTextBox.Text = username; this.DialogResult = System.Windows.Forms.DialogResult.None; return; } } roleID = RiskAppCore.User.fetchUserRoleID(u.userLogin); roleName = RiskAppCore.User.fetchUserRoleName(u.userLogin); switch (roleName) { case "Tablet": RiskAppCore.ErrorMessages.Show(RiskAppCore.ErrorMessages.ROLE_ACCESS_DENIED); return; default: break; } SessionManager.Instance.ActiveUser = u; InitUserGUIPrefs(u); u.UserClinicList.user_login = u.userLogin; u.UserClinicList.AddHandlersWithLoad(null, UserClinicListLoaded, null); //DialogResult = DialogResult.OK; HraObject.AuditUserLogin(u.userLogin); stopWatch.Stop(); // Get the elapsed time as a TimeSpan value. TimeSpan ts = stopWatch.Elapsed; if (ts.TotalSeconds < requiredSplashTime) { progressBar1.Style = ProgressBarStyle.Blocks; progressBar1.Value = progressBar1.Maximum; progressBar1.Refresh(); Application.DoEvents(); Thread.Sleep((int)(1000 * (requiredSplashTime - ts.TotalSeconds))); } return; } if (numFailedAttempts == 1) { MessageBox.Show( "You have provided an incorrect username or password.\r\nPlease correct your password or try a different user." + lockoutMsg, "Incorrect Username/Password", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (numFailedAttempts > 1) { MessageBox.Show( lockoutMsg, "Incorrect Username/Password", MessageBoxButtons.OK, MessageBoxIcon.Information); } return; }
public void PersistFullObject(HraModelChangedEventArgs e, string unitnum, int apptid) { ParameterCollection pc = new ParameterCollection(); pc.Add("unitnum", unitnum); pc.Add("apptid", apptid); DoPersistWithSpAndParams(e, "sp_3_Save_ClausParameters", ref pc); }
private void btnCreate_Click(object sender, EventArgs e) { int surveyID = 0; //KeyValuePair<int, string> kvpSurvey; KeyValuePair<int, string> kvpClinic; foreach (KeyValuePair<int, string> pair in surveyDic) { if (pair.Value == cbSurvey.Text) { surveyID = pair.Key; } } int x = 0; if (cbNumPatients.SelectedItem != null) { int i = int.Parse(cbNumPatients.SelectedItem.ToString()); int index = 0; string time; Random random = new Random(); string firstName = ""; string nextUnitNum = createTestUnitnum(); long unitNum = Int64.Parse(nextUnitNum); while (i > x) { RiskApps3.Utilities.ParameterCollection pc = new RiskApps3.Utilities.ParameterCollection(); if (x <= 9) { time = "0" + x.ToString(); } else { time = (x % 60).ToString(); } pc.Add("apptdate", dtAppointmentDate.Value.ToString("MM/dd/yyyy")); pc.Add("appttime", "08:" + time + " AM"); index = random.Next(10000) % names.Count; firstName = names[index]; pc.Add("firstname", firstName); pc.Add("lastname", "Test" + cbSurvey.Text.Replace(" ","")); pc.Add("gender", "F"); pc.Add("dob", "09/23/1970"); pc.Add("email", "*****@*****.**"); pc.Add("address1", (i * 10).ToString() + " Broadway"); pc.Add("city", "Cambridge"); pc.Add("state", "MA"); pc.Add("zip", "02473"); pc.Add("phone", "6175551212"); pc.Add("emailaddress", "*****@*****.**"); pc.Add("sendByEmail", 1); pc.Add("machinename", "test"); pc.Add("preferredInstitutionName", "test"); if(cbClinic.SelectedItem != null) { kvpClinic = (KeyValuePair<int, string>)cbClinic.SelectedItem; pc.Add("clinicID", kvpClinic.Key); } else { pc.Add("clinicID", 1); // default } pc.Add("unitnum", unitNum.ToString()); pc.Add("createdby", cbSurvey.Text); pc.Add("insertApptWebRecord", 1); pc.Add("surveyID", surveyID); BCDB2.Instance.ExecuteReaderSPWithParams("sp_createApptFromSchedService", pc); unitNum++; x++; } } this.Close(); }
public void CreateTestPatients(int NoOfPatients, string dtAppointmentDate, int surveyID, string SurveyName, int clinicID) { List <string> names = new List <string> { "Mary", "Jane", "Sylvia", "Ruth", "Penelope", "Fernanda", "Gertrude", "Tiffany", "Cher", "Elizabeth", "Rene", "Chloe", "Rapunzel", "Ashley", "Jessica", "Emily", "Sarah", "Samantha", "Brittany", "Amanda", "Elizabeth", "Taylor", "Margarete", "Stephanie", "Kayley", "Laura", "Jennifer", "Rachel", "Anna", "Nicole", "Amber", "Alexis", "Courtney", "Victoria", "Daniela", "Adelheid", "Rebecca", "Jasmine", "Katherine", "Melissa", "Alexandra", "Brianna", "Chelsea", "Michaela", "Morgan", "Kelsey", "Tiffany", "Kimberley", "Christine", "Madison", "Heather", "Selby", "Anna", "Mary", "Mary", "Alison", "Sarah", "Laura", "Andrea", "Olivia", "Erin", "Hayley", "Abigail", "Katherine", "Jordan", "Natalie", "Vanessa", "Kelly", "Brooke", "Erica", "Christine", "Julia", "Crystal", "Amata", "Katherine", "Mary", "Lindsay", "Paige", "Cassandra", "Sidney", "Katherine", "Katherine", "Katherine", "Emma", "Shannon", "Angela", "Gabriele", "Jacqueline", "Johanna", "Jacqueline", "Mary", "Adelheid", "Brianna", "Alexandra", "Destiny", "Miranda", "Monica", "Brittany", "Katherine", "Savannah", "Sierra", "Sabrina", "Brianna", "Whitney", "Carla", "Mary", "Magdalena", "Erica", "Grace", "Diana", "Leah", "Angelica", "Lindsay", "Christine", "Katherine", "Cynthia", "Margarete", "Cheyenne", "Mackenzie", "Margarete", "Veronica", "Melanie", "Bailey", "Christine", "Blanche", "Elizabeth", "Holly", "Christine", "Alexandra", "Ariela", "Bethany", "Hayley", "Leslie", "April", "Casey", "Brenda", "Katherine", "Julia", "Patrizia", "Autumn", "Karin", "Gabriele", "Brandy", "Anna", "Rachel", "Kendra", "Karin", "Dominika", "Valerie", "Desiree", "Cara", "Carla", "Clare", "Tara", "Adriana", "Kayley", "Natalie", "Michaela", "Chloe", "Jocelyn", "Kylie", "Crystal", "Hayley", "Katherine", "Alison", "Anna", "Sophia", "Daisy", "Rebecca", "Daniela", "Juliana", "Cassidy", "Alexandra", "Raven", "Jade", "Angela", "Summer", "Edeltraud", "Gabriele", "Chelsea", "Alexandra", "Adriana", "Katherine", "Claudia", "Monica", "Margarete", "Johanna", "Christine", "Faith", "Michaela", "Brandy", "Ciara", "Michaela", "Mallory", "Christine", "Diana", "Jessenia", "Ashley", "Cynthia", "Mercedes", "Adelheid", "Regina", "Lydia", "Felizia", "Mackenzie", "Zoe", "Brigitte", "Mary", "Priska", "Carla", "Cassandra", "Denise", "Jasmine", "Victoria", "Isabella", "Selina", "Diamond", "Evelyn", "Anna", "Amelia", "Christine", "Alison", "Tabitha", "Abigail", "Ashley", "Lacey", "Jasmine", "Isabella", "Asia", "Candace", "Ciara", "Sierra", "Colleen", "Jacqueline", "Carla", "Hope", "Linda", "Noemi", "Helen", "Mary", "Theresa", "Meredith", "Guadalupe", "Johanna", "Renate", "Nicole", "Kendall", "Jasmine", "Tamara", "Brittany", "Justine", "Theresa", "Susanne", "Tatjana", "Tiara", "Daniela", "Maja", "Adriana", "Genesis", "Rose", "Myra", "Kelly", "Casey", "Candace", "Clare", "Aubrey", "Adriana", "Nina", "Theresa" }; int x = 0; if (NoOfPatients != 0) { int i = NoOfPatients; int index = 0; string time; Random random = new Random(); string firstName = ""; string nextUnitNum = createTestUnitnum(); long unitNum = Int64.Parse(nextUnitNum); while (i > x) { RiskApps3.Utilities.ParameterCollection pc = new RiskApps3.Utilities.ParameterCollection(); if (x <= 9) { time = "0" + x.ToString(); } else { time = (x % 60).ToString(); } pc.Add("apptdate", Convert.ToDateTime(dtAppointmentDate).ToString("MM/dd/yyyy")); pc.Add("appttime", "08:" + time + " AM"); index = random.Next(10000) % names.Count; firstName = names[index]; pc.Add("firstname", firstName); pc.Add("lastname", "Test" + SurveyName.Replace(" ", "")); pc.Add("gender", "F"); pc.Add("dob", "09/23/1970"); pc.Add("email", "*****@*****.**"); pc.Add("address1", (i * 10).ToString() + " Broadway"); pc.Add("city", "Cambridge"); pc.Add("state", "MA"); pc.Add("zip", "02473"); pc.Add("phone", "6175551212"); pc.Add("emailaddress", "*****@*****.**"); pc.Add("sendByEmail", 1); pc.Add("machinename", "test"); pc.Add("preferredInstitutionName", "test"); if (clinicID != null && clinicID != 0) { pc.Add("clinicID", clinicID); } else { pc.Add("clinicID", 1); // default } pc.Add("unitnum", unitNum.ToString()); pc.Add("createdby", SurveyName); pc.Add("insertApptWebRecord", 0); pc.Add("surveyID", surveyID); BCDB2.Instance.ExecuteReaderSPWithParams("sp_createApptFromSchedService", pc); unitNum++; x++; } } }