private string GetEmailAddress(int UserID) { var email = ""; var ds = Users.GetUserByUserID(UserID); if (ds != null && ds.Tables[0].Rows.Count > 0) { email = ds.Tables[0].Rows[0]["Email"].ToString(); } return(email); }
protected override void PageLoadEvent(object sender, System.EventArgs e) { tr_password.Visible = false; //mgUserRole.ItemCSSClass = "ArtYellow"; //mgUserRole.TblCSSClass = "tblGridYellow"; //txtPassword.Text = ""; if (IsPostBack == false) { //btnSave.Attributes["onclick"] = "javascript:return confirm('Are you sure you want to save the record and send email to the user with login info?');"; txtFirstName.SetReadOnly(); txtLastName.SetReadOnly(); txtMI.SetReadOnly(); txtEmail.SetReadOnly(); //ToolTip="read-only field txtFirstName.ToolTip = "read-only field"; txtLastName.ToolTip = "read-only field"; txtMI.ToolTip = "read-only field"; txtEmail.ToolTip = "read-only field"; } lblError.Text = ""; lblError.CssClass = "error"; //int iID = 0; if (IsPostBack == false) { ddlDefAppl.Enabled = false; try { // load all NCS users FillCombos("user_new"); ddlUsers.Items.Insert(0, "- select -"); // load User Roles FillCombos("role"); // load Organizations FillCombos("org"); ddlOrg.Items.Insert(0, "- select -"); if (Request.QueryString["mode"] == "pswd") { td_rb.Visible = false; lnkHelp.Visible = false; var iUserID = Convert.ToInt32(Session["User_ID"]); if (iUserID != 0) { var ds = UsersBO.GetUserByUserID(iUserID); hUserID.Value = ds.Tables[0].Rows[0]["UserID"].ToString(); txtEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString(); txtFirstName.Text = ds.Tables[0].Rows[0]["FirstName"].ToString(); txtLastName.Text = ds.Tables[0].Rows[0]["LastName"].ToString(); txtMI.Text = ds.Tables[0].Rows[0]["MiddleInitial"].ToString(); txtPhone.Text = ds.Tables[0].Rows[0]["Phone"].ToString(); txtPassword.Text = ds.Tables[0].Rows[0]["Password"].ToString().Trim(); hPassword.Value = txtPassword.Text; var sActive = ds.Tables[0].Rows[0]["Active"].ToString(); if (sActive.Trim().ToLower() == "true") { sActive = "Active"; } else { sActive = "Inactive"; } DisplayComboSelectedItem(ddlActive, sActive, "t"); DisplayComboSelectedItem(ddlDefAppl, ds.Tables[0].Rows[0]["DefaultApplication"].ToString(), "v"); var sRoles = ds.Tables[0].Rows[0]["RoleCode"].ToString(); var arrRoles = sRoles.Split(new char[] { '|' }); var sRoleCode = ""; for (var j = 0; j < mgUserRole.Table.Rows.Count; j++) { sRoleCode = mgUserRole.Table.Rows[j][0].ToString(); foreach (var s in arrRoles) { if (sRoleCode == s) { mgUserRole.SelectedIndex = j; } } } DisplayComboSelectedItem(ddlOrg, ds.Tables[0].Rows[0]["Organization"].ToString(), "v"); tr_user.Visible = false; txtFirstName.Enabled = false; txtLastName.Enabled = false; txtMI.Enabled = false; txtPhone.Enabled = false; ddlOrg.Enabled = false; //mgUserRole.EnableMultiGrid(false); tr_user_role.AddDisplayNone(); ddlActive.Enabled = false; ddlDefAppl.Enabled = false; pswd_help.Visible = false; phone_help.Visible = false; tr_note.Visible = false; btnReset.Visible = false; lblTitle.Text = "Change Password"; txtPassword.CssClass = "regBldBlueTextRedBorder"; lblError.Text = DisplayMessage("Please enter your new password and click 'Save'", false); //string sUR = ""; //foreach (int i in mgUserRole.SelectedIndexes) //{ // sUR = mgUserRole.Table.Rows[i][0].ToString(); // if (sUR == "95" || sUR == "96" || sUR == "97" || sUR == "98" || sUR == "99" || sUR == "100") // { // //bNeedPassword = true; // break; // } // else // { // //bNeedPassword = false; // txtPassword.Text = "n/a"; // //txtPassword.Enabled = false; // } //} } else { throw new Exception("ULO System can not change your password. Please call your administrator"); } //Session["User_ID"] //GetUserByUserID } } catch (Exception ex) { lblError.Text = DisplayMessage("Error: " + ex.Message, true); } } }
private void SendEmailOnReassigRequest(int intItemID, string sOldOrgCode, string sNewOrgCode, string sOldOrganization, string sNewOrganization, int iOldReviewerID, int iNewReviewerID, string sComments, string ActionType) { // if (Settings.Default.SendEmailOnAllTypeOfAssignments) { var sOldReviewerName = ""; var sNewReviewerName = ""; var sMessageText = ""; var sDocNum = ""; var sSentToAdmins = ""; var sSentTo = ""; var sSubject = ""; var iCnt = 0; var sNewReviewerEmail = ""; // here we need to send email message to all BA's on Reassign/Reroute request ***SM // get Old User name by ID if (iOldReviewerID != 0) { var ds = Users.GetUserByUserID(iOldReviewerID); sOldReviewerName = ds.Tables[0].Rows[0]["FirstName"].ToString() + " " + ds.Tables[0].Rows[0]["LastName"].ToString(); } // get New User name by ID //if (ActionType == "5") //{ if (iNewReviewerID != 0) { var ds = Users.GetUserByUserID(iNewReviewerID); sNewReviewerName = ds.Tables[0].Rows[0]["FirstName"].ToString() + " " + ds.Tables[0].Rows[0]["LastName"].ToString(); sNewReviewerEmail = ds.Tables[0].Rows[0]["Email"].ToString(); } //} // get doc number by OItemID if (intItemID != 0) { var items = Item.GetDocNumByItemID(intItemID); sDocNum = items.First(); } var sMessageHeader = "<font color='red'>*** This is an auto-generated email. Please do not reply or forward to ***</font><br><br>"; if (ActionType == "5") { sSubject = "Re-Assign/Re-Route Request for the ULO document " + sDocNum; sMessageText = sMessageHeader + "New reassign/reroute reguest has been placed for the ULO document '" + sDocNum + "'.<br><br>"; sMessageText = sMessageText + "Original Reviewer: " + sOldReviewerName + ".<br>"; sMessageText = sMessageText + "Original Organization: " + sOldOrganization + " : " + sOldOrgCode + ".<br><br>"; sMessageText = sMessageText + "Suggested Reviewer: " + sNewReviewerName + ".<br>"; sMessageText = sMessageText + "Suggested Organization: " + sNewOrganization + " : " + sNewOrgCode + ".<br><br>"; sMessageText = sMessageText + "Reroute/Reassign Comments:<br><br>"; sMessageText = sMessageText + sComments + "'.<br><br>"; sMessageText = sMessageText + "To confirm or modify rerouting, please login to <a href='http://dotnetweb.pbsncr.gsa.gov/OpenItems/ReviewOpenItems.aspx' >ULO Application</a>.<p>"; sMessageText = sMessageText + "For more information, go to the <a href='http://dotnetweb.pbsncr.gsa.gov/OpenItems/docs/UserManual.doc'>ULO (Open Items) User Manual.</a><p>"; sMessageText = sMessageText + "<font color='red'>Attention</font>: Please use the Internet Explorer (IE) browser instead of the Chrome browser.<p>"; sMessageText = sMessageText + "Thank you.<p><p>"; sMessageText = sMessageText + "(Ref # " + ActionType + ")"; Admin.SendCustomEmailToBDAdmins(sMessageText, sSubject, out sSentToAdmins, out iCnt); } else if (ActionType == "4" || ActionType == "3" || ActionType == "10") { if (ActionType == "4" || ActionType == "3") { sSubject = "New Open Items have been assigned to you."; sMessageText = sMessageHeader + "New Open Items have been assigned to you.<br><br>"; } else //10 { sSubject = "New Open Items have been assigned to you by Budget Division Administrator as a result of reroute request."; sMessageText = sMessageHeader + "New Open Items have been assigned to you by Budget Division Administrator as a result of reroute request.<br><br>"; } sMessageText = sMessageText + "Reroute/Reassign Comments:<br><br>"; sMessageText = sMessageText + sComments + "'.<br><br>"; sMessageText = sMessageText + "Please login and review your workload in <a href='http://dotnetweb.pbsncr.gsa.gov/OpenItems/ReviewOpenItems.aspx' >ULO Application.</a><p>"; sMessageText = sMessageText + "For more information, go to the <a href='http://dotnetweb.pbsncr.gsa.gov/OpenItems/docs/UserManual.doc'>ULO (Open Items) User Manual.</a><p>"; sMessageText = sMessageText + "<font color='red'>Attention</font>: Please use the Internet Explorer (IE) browser instead of the Chrome browser.<p>"; sMessageText = sMessageText + "Thank you.<p><p>"; sMessageText = sMessageText + "(Ref # " + ActionType + ")"; Admin.SendCustomEmail(sNewReviewerEmail, sMessageText, sSubject, out sSentTo, out iCnt); } else if (ActionType == "16" || ActionType == "19") { sSubject = "New Open Items for validation have been assigned to you"; sMessageText = sMessageHeader + "New Open Items for validation have been assigned to you.<br><br>"; sMessageText = sMessageText + "Reroute/Reassign Comments:<br><br>"; sMessageText = sMessageText + sComments + "'.<br><br>"; sMessageText = sMessageText + "Please login and review your workload in <a href='http://dotnetweb.pbsncr.gsa.gov/OpenItems/ReviewOpenItems.aspx' >ULO Application.</a><p>"; sMessageText = sMessageText + "For more information, go to the <a href='http://dotnetweb.pbsncr.gsa.gov/OpenItems/docs/UserManual.doc'>ULO (Open Items) User Manual.</a><p>"; sMessageText = sMessageText + "<font color='red'>Attention</font>: Please use the Internet Explorer (IE) browser instead of the Chrome browser.<p>"; sMessageText = sMessageText + "Thank you.<p><p>"; sMessageText = sMessageText + "(Ref # " + ActionType + ")"; Admin.SendCustomEmail(sNewReviewerEmail, sMessageText, sSubject, out sSentTo, out iCnt); } } }