/*Public Function GetImplantActivity(strIsotope As String, vAssayActivity As Variant, vAssayDate As Variant) As Variant * Dim dImplantDate As Date * GetImplantActivity = Null * If IsNumeric(vAssayActivity) Then * If IsDate(vAssayDate) Then * If objPatient.ImplantDate <> vbNullString Then * dImplantDate = objPatient.ImplantDate * If dImplantDate <> MISSING_DATE Then * Select Case strIsotope * Case "Iodine", "I-125", "I125" * 'half-life * GetImplantActivity = CSng(vAssayActivity) * 0.5 ^ ((dImplantDate - CDate(vAssayDate)) / 59.4) * Case "Palladium", "Pd-103", "Pd103" * GetImplantActivity = CSng(vAssayActivity) * 0.5 ^ ((dImplantDate - CDate(vAssayDate)) / 16.97) * End Select * End If * End If * End If * End If * Exit_Procedure: * Exit Function*/ /// <summary> /// /// If this is too slow/performance hit, then move function to back end. /// </summary> /// <param name="isotope"></param> /// <param name="assayActivity"></param> /// <param name="assayDate"></param> /// <returns></returns> public static object GetCurrentActivity(string isotope, string assayActivity, string assayDate) { object currentActivity = System.DBNull.Value; if (PageUtil.IsInteger(assayActivity) || PageUtil.IsDecimal(assayActivity)) { if (PageUtil.IsDate(assayDate)) { DateTime d1, d2; d1 = System.DateTime.Now; d2 = Convert.ToDateTime(assayDate); TimeSpan ts = d1 - d2; int days = ts.Days; //GetCurrentActivity = sngAssayActivity * 0.5 ^ ((Date - dAssayDate) / 59.4) if (isotope.Equals("Iodine") || isotope.Equals("I-125") || isotope.Equals("I125")) { double Itotal = Convert.ToDouble(assayActivity) * (Math.Pow(0.5, (days / 59.4))); currentActivity = Math.Round(Itotal, 6).ToString(); // could remove this to store full value in db and round to six places on output } else if (isotope.Equals("Palladium") || isotope.Equals("Pd-103") || isotope.Equals("Pd103")) { double Ptotal = Convert.ToDouble(assayActivity) * (Math.Pow(0.5, (days / 16.97))); currentActivity = Math.Round(Ptotal, 6).ToString(); } } } return(currentActivity); }
protected override void Page_Load(object sender, EventArgs e) { base.SetPatientLabels(Name, MRN); if (!String.IsNullOrEmpty(FuMonth)) { if (FuMonth.Equals("0")) { Period.Text = "Pre-Op"; } else { Period.Text = FuMonth + " Month"; } } Patient pt = new Patient(); pt.Get(PatientId); if (pt[Patient.PtBirthDate] != null && PageUtil.IsDate(pt[Patient.PtBirthDate].ToString())) { DateTime dob = DateTime.Parse(pt[Patient.PtBirthDate].ToString()); DOBDay.Text = dob.Day.ToString(); DOBMonth.Text = dob.Month.ToString(); DOBYear.Text = dob.Year.ToString(); } }
/* 'actual seeds assigned to patient * If IsNumeric(txtSeedStrength) Then * If IsNumeric(txtNumSeeds) Then * txtTotalActivity = CSng(txtNumSeeds) * CSng(txtSeedStrength) * blnDosimetrySaved = False * Else * blnComplete = False * End If * 'reccommended activity calculated above * 'see if actual is greater than recommended, should be about 100-110% * If IsNumeric(txtRecTotActivity) Then * If IsNumeric(txtTotalActivity) And CSng(txtRecTotActivity) > 0 Then * txtPercentActivity = CSng(txtTotalActivity) / CSng(txtRecTotActivity) * blnDosimetrySaved = False * Else * blnComplete = False * End If * Else * blnComplete = False * End If * Else * blnComplete = False * End If */ /// <summary> /// /// </summary> /// <param name="isotope"></param> /// <param name="assayActivity"></param> /// <param name="assayDate"></param> /// <param name="implantDate"></param> /// <returns></returns> public static string GetImplantActivity(string isotope, string assayActivity, string assayDate, string implantDate) { string implantActivity = ""; if (PageUtil.IsInteger(assayActivity) || PageUtil.IsDecimal(assayActivity)) { if (PageUtil.IsDate(assayDate) && PageUtil.IsDate(implantDate)) { DateTime d1, d2; d1 = Convert.ToDateTime(implantDate); //implant date comes from BrachyDate field in Brachy table d2 = Convert.ToDateTime(assayDate); TimeSpan ts = d1 - d2; int days = ts.Days; //GetCurrentActivity = sngAssayActivity * 0.5 ^ ((Date - dAssayDate) / 59.4) if (isotope.Equals("Iodine") || isotope.Equals("I-125") || isotope.Equals("I125")) { double Itotal = Convert.ToDouble(assayActivity) * (Math.Pow(0.5, (days / 59.4))); implantActivity = Math.Round(Itotal, 6).ToString(); // could remove this to store full value in db and round to six places on output } else if (isotope.Equals("Palladium") || isotope.Equals("Pd-103") || isotope.Equals("Pd103")) { double Ptotal = Convert.ToDouble(assayActivity) * (Math.Pow(0.5, (days / 16.97))); implantActivity = Math.Round(Ptotal, 6).ToString(); } } } return(implantActivity); }
protected void UpdateUserRecord(int userId) { object deactivateDate; if (PageUtil.IsDate(Request.Form["DeactivateDate"])) { deactivateDate = DateTime.Parse(Request.Form["DeactivateDate"].ToString()); } else { deactivateDate = System.DBNull.Value; } User u = new User(); u.Get(userId); u[BOL.User.UserFirstName] = UserFirstName.Value; u[BOL.User.UserLastName] = UserLastName.Value; u[BOL.User.UserName] = UserName.Value; u[BOL.User.UserEmail] = UserEmail.Value; u[BOL.User.UserEmployeeId] = UserEmployeeId.Value; u[BOL.User.DeactivatedTime] = deactivateDate; u.Save(); # region pre v5.0 //UserDa da = new UserDa(); //object deactivateDate; //Caisis.Security.SecurityController sc = new Caisis.Security.SecurityController(); //bool returnVal = da.UpdateUserRecord(userId, Request.Form["UserName"], Request.Form["UserFirstName"], Request.Form["UserLastName"], Request.Form["UserEmail"], deactivateDate, sc.GetUserName()); //return returnVal; # endregion
protected override void Page_Load(object sender, EventArgs e) { base.SetPatientLabels(Name, MRN); Patient pt = new Patient(); pt.Get(PatientId); if (pt[Patient.PtBirthDate] != null && PageUtil.IsDate(pt[Patient.PtBirthDate].ToString())) { DateTime dob = DateTime.Parse(pt[Patient.PtBirthDate].ToString()); DOBDay.Text = dob.Day.ToString(); DOBMonth.Text = dob.Month.ToString(); DOBYear.Text = dob.Year.ToString(); } }
private void SetUpTimePeriod() { bool setFromDate = false; bool setToDate = false; PageUtil.AddCalendarFunction(txtFromDateCal, txtFromDate); PageUtil.AddCalendarFunction(txtToDateCal, txtToDate); if (!Page.IsPostBack) { toDate = DateTime.Now; fromDate = toDate.AddDays(-30); setFromDate = true; setToDate = true; } else { if (PageUtil.IsDate(txtFromDate.Value)) { fromDate = DateTime.Parse(txtFromDate.Value); setFromDate = true; } if (PageUtil.IsDate(txtToDate.Value)) { toDate = DateTime.Parse(txtToDate.Value); setToDate = true; } } if (setFromDate) { txtFromDate.Value = PageUtil.ObjToDateString(fromDate); } else { txtFromDate.Value = ""; } if (setToDate) { txtToDate.Value = PageUtil.ObjToDateString(toDate); } else { txtToDate.Value = ""; } }
public bool ValidateDates() { string sDateFrom = this.dateFrom.Value; string sDateTo = this.dateTo.Value; if (!string.IsNullOrEmpty(sDateFrom)) { if (sDateFrom.Length > 0 && !PageUtil.IsDate(sDateFrom)) { return(false); } } if (!string.IsNullOrEmpty(sDateTo)) { if (sDateTo.Length > 0 && !PageUtil.IsDate(sDateTo)) { return(false); } } return(true); }
override protected void Page_Load(object sender, System.EventArgs e) { base.Page_Load(sender, e); valMsg.Text = ""; SelectUserName.Attributes.Add("onchange", "this.form." + SelectSubmitted.ClientID + ".value = 'true'; this.form.submit();"); //DeleteBtn.Attributes.Add("onClick", "confirmDelete();"); if (Page.IsPostBack) { //check if form is submitted from select box or to add/delete if (Request.Form["SelectSubmitted"] != null && Request.Form["SelectSubmitted"].Equals("true")) { //select box submitted form, populate forms fields //UserDa da = new UserDa(); //DataSet userDs = da.GetByUserId( int.Parse(Request.Form["SelectUserName"])); //DataRow userDr = userDs.Tables[0].Rows[0]; User userDr = new User(); userDr.Get(int.Parse(Request.Form["SelectUserName"])); UserName.Value = userDr["UserName"].ToString(); UserEmail.Value = userDr["UserEmail"].ToString(); UserFirstName.Value = userDr["UserFirstName"].ToString(); UserLastName.Value = userDr["UserLastName"].ToString(); UserEmployeeId.Value = userDr[BOL.User.UserEmployeeId].ToString(); // set deactivate checkbox and time is not null string dDate = ""; if (userDr["DeactivatedTime"] != null && PageUtil.IsDate(userDr["DeactivatedTime"].ToString())) { dDate = ((DateTime)userDr["DeactivatedTime"]).ToShortDateString(); } DeactivateDate.Value = dDate; if (userDr["DeactivatedTime"] != null && userDr["DeactivatedTime"].ToString().Length > 0) { Deactivate.Checked = true; } else { Deactivate.Checked = false; } FormTable.Visible = true; SelectSubmitted.Value = "false"; } } //page just loaded, show select with usernames else { this.SetUserDropDown(); FormTable.Visible = false; } }
protected bool ValidateUpdate() { bool returnVal = true; valMsg.Text = ""; // if selected, check that deactivate date is the correct format if (Request.Form["Deactivate"] != null && Request.Form["Deactivate"].Equals("yes")) { if (Request.Form["DeactivateDate"] == null || Request.Form["DeactivateDate"].Length < 4 || !PageUtil.IsDate(Request.Form["DeactivateDate"])) { valMsg.Text += "Error: Deactivate date not in DateFormat"; return(returnVal = false); } } //TODO: set valMsg if problem. check for duplicate usernames return(returnVal); }
private void ShowReport(string useReport) { if (useReport.Length < 1) { showReportInfo = true; return; } DataSet ds = new DataSet(); bool bindData = true; AdminReportsDa da = new AdminReportsDa(); ReportConfiguration rprt = reportConfigurations[useReport]; string datasetSql = CacheManager.GetDatasetSQL(System.Web.HttpContext.Current.Session[SessionKey.DatasetId]); if (rprt.UseGenericReportFormat) { bindData = true; lblPageTitle.Text = rprt.Title; string paramName = null; string paramValue = null; if (lblAdditionalFiltering.Text != "N/A") { paramName = lblAdditionalFiltering.Text; if (txtAdditionalFilter1.CssClass != "DisplayNone") { paramValue = txtAdditionalFilter1.Text; } else { paramValue = ddlAdditionalFilter1.SelectedItem.Text; } } if (Request.QueryString["paramValue"] != null && Request.Cookies["AdminReportUseQuerystring"].Value == "true") { paramValue = Request.QueryString["paramValue"]; paramName = Request.QueryString["paramName"]; lblAdditionalFiltering.Text = paramName; txtAdditionalFilter1.Text = paramValue; } if (rprt.UseTimePeriod) { ds = da.GetAdminReport(null, rprt.StoredProcedure, paramName, paramValue, txtFromDate.Value, txtToDate.Value, false); } else { ds = da.GetAdminReport(null, rprt.StoredProcedure, paramName, paramValue, false); } } else { #region userSummary if (useReport == "UserSummary") { if (ddlReportMenu.SelectedValue != "UserSummary") { if (Page.IsPostBack || Request.QueryString["report"] == null || Request.QueryString["report"].ToString() != "UserSummary") { return; } } lblAdminReportInfo.Visible = false; lblAdminPage.Visible = true; dgAdminReport.Visible = false; string iUserId; string userName, userFirstName, userLastName, userEmail, enteredBy, updatedBy; string enteredTime, updatedTime, deactivatedTime; TimeSpan timespan; Label lblAdminReportSubHeading2 = new Label(); lblAdminPage.Controls.Add(lblAdminReportSubHeading2); if (Request.QueryString["paramName"] == "userName" && Request.Cookies["AdminReportUseQuerystring"].Value == "true") { userName = Request.QueryString["paramValue"]; } else { userName = txtAdditionalFilter1.Text; } ds = da.GetUserInfo(userName); if (ds.Tables[0].Rows.Count != 1) { lblAdminReportSubHeading2.Text = "No matching user found."; lblAdminReportSubHeading2.Visible = true; } else { //TODO FIX "username" etc iUserId = ds.Tables[0].Rows[0]["UserId"].ToString(); userName = ds.Tables[0].Rows[0]["UserName"].ToString(); userFirstName = ds.Tables[0].Rows[0]["UserFirstName"].ToString(); userLastName = ds.Tables[0].Rows[0]["UserLastName"].ToString(); userEmail = ds.Tables[0].Rows[0]["UserEmail"].ToString(); enteredBy = ds.Tables[0].Rows[0]["EnteredBy"].ToString(); updatedBy = ds.Tables[0].Rows[0]["UpdatedBy"].ToString(); enteredTime = ds.Tables[0].Rows[0]["EnteredTime"].ToString(); updatedTime = ds.Tables[0].Rows[0]["UpdatedTime"].ToString(); if (PageUtil.IsDate(updatedTime)) { timespan = DateTime.Now - DateTime.Parse(updatedTime); } else { timespan = DateTime.Now - DateTime.Parse(enteredTime); } deactivatedTime = ds.Tables[0].Rows[0]["DeactivatedTime"].ToString(); lblPageTitle.Text = "User Summary: " + userName; lblAdminReportSubHeading2.Text = "<table><tr><td width=100>First name:</td><td>" + userFirstName + "</td></tr>" + "<tr><td>Last name:</td><td>" + userLastName + "</td></tr>" + "<tr><td>Email:</td><td><a href=\"mailto:" + userEmail + "\">" + userEmail + "</a></td></tr>" + "<tr><td>Entered time:</td><td>" + enteredTime + "</td></tr>" + "<tr><td>Entered by:</td><td>" + enteredBy + "</td></tr>" + "<tr><td>Updated time:</td><td>" + updatedTime + "</td></tr>" + "<tr><td>Updated by:</td><td>" + updatedBy + "</td></tr>" + "<tr><td>Days since update:</td><td>" + timespan.Days.ToString() + "</td></tr>" + "<tr><td>Deactivated time:</td><td>" + deactivatedTime + "</td></tr></tr></table><br><br>" + "<b>Last 5 logins for this user:</b> <br>"; lblAdminReportSubHeading2.Visible = true; Label lblAdminReportSubHeading3 = new Label(); DataGrid dgAdminReport01 = new DataGrid(); lblAdminPage.Controls.Add(dgAdminReport01); lblAdminPage.Controls.Add(lblAdminReportSubHeading3); ds = da.GetUsersLastFiveLogins(userName); if (ds.Tables[0].Rows.Count < 1) { lblAdminReportSubHeading2.Text += "<br>No logins for this user.<br><br>"; bindData = false; dgAdminReport01.Visible = false; } else { dgAdminReport01.AutoGenerateColumns = true; dgAdminReport01.DataSource = ds.Tables[0].DefaultView; dgAdminReport01.DataBind(); dgAdminReport01.Width = 630; dgAdminReport01.CssClass = "DatagridTable"; lblAdminReportSubHeading3.Text = "<a href=AdminSectionReports.aspx?report=LoginsForUser¶mValue=" + userName + "¶mName=userName onClick=\"javascript:setUseQueryStringCookie();\">View all logins for this user.</a><br><br>"; } lblAdminReportSubHeading3.Visible = true; lblAdminReportSubHeading3.Text += "<b>Last 5 patient views for this user:</B> <br>"; lblAdminPage.Controls.Add(lblAdminReportSubHeading3); DataGrid dgAdminReport2 = new DataGrid(); lblAdminPage.Controls.Add(dgAdminReport2); DataSet ds2 = new DataSet(); ds2 = da.GetUsersLastFivePatientViews(iUserId); dgAdminReport2.Width = 630; dgAdminReport2.Visible = true; Label lblAdminReportSubHeading4 = new Label(); lblAdminPage.Controls.Add(lblAdminReportSubHeading4); if (ds2.Tables[0].Rows.Count < 1) { dgAdminReport2.Visible = false; lblAdminReportSubHeading3.Text += "<br>No patient views for this user."; } else { dgAdminReport2.AutoGenerateColumns = true; dgAdminReport2.DataSource = ds2.Tables[0].DefaultView; dgAdminReport2.DataBind(); lblAdminReportSubHeading4.Visible = true; lblAdminReportSubHeading4.Text = "<a href=AdminSectionReports.aspx?report=PatientsViewsByUser¶mValue=" + userName + "¶mName=userName onClick=\"javascript:setUseQueryStringCookie()\">View all patient views for this user.</a>"; } /*user record changes*/ DataGrid dgAdminReport3 = new DataGrid(); lblAdminPage.Controls.Add(dgAdminReport3); DataSet ds3 = new DataSet(); ds3 = da.GetUsersLastFiveRecordChanges(iUserId); dgAdminReport3.Width = 630; dgAdminReport3.Visible = true; lblAdminReportSubHeading4.Text += "<br><br><b>Last 5 user record changes:</b> <br>"; Label lblAdminReportSubHeading5 = new Label(); if (ds3.Tables[0].Rows.Count < 1) { dgAdminReport3.Visible = false; lblAdminReportSubHeading4.Text += "<br>No patient views for this user."; } else { dgAdminReport3.AutoGenerateColumns = true; dgAdminReport3.DataSource = ds3.Tables[0].DefaultView; dgAdminReport3.DataBind(); lblAdminReportSubHeading5.Visible = true; lblAdminReportSubHeading5.Text = "<a href=AdminSectionReports.aspx?report=UsersRecordChanges¶mValue=" + userName + "¶mName=userName onClick=\"javascript:setUseQueryStringCookie()\">View all record changes for this user.</a><br>"; } lblAdminPage.Controls.Add(lblAdminReportSubHeading5); /*users groups*/ DataGrid dgAdminReport4 = new DataGrid(); lblAdminPage.Controls.Add(dgAdminReport4); DataSet ds4 = new DataSet(); ds4 = da.GetAdminReport(null, "spRptAdminGetAUsersGroups", "UserId", iUserId, false); dgAdminReport4.Width = 630; dgAdminReport4.Visible = true; lblAdminReportSubHeading5.Text += "<br><br><b>This user belongs to the following groups: </b><br>"; if (ds4.Tables[0].Rows.Count < 1) { dgAdminReport4.Visible = false; lblAdminReportSubHeading5.Text += "<br>This user does not belong to any group."; } else { dgAdminReport4.AutoGenerateColumns = true; dgAdminReport4.DataSource = ds4.Tables[0].DefaultView; dgAdminReport4.DataBind(); } } bindData = false; } #endregion } if (bindData) { doBindData(ds); btnExport.Enabled = true; } }