public static string GetSiteSetting(string _settingcode) { string returnval = String.Empty; using (MySqlConnection conn = new MySqlConnection(PortalUtility.GetConnectionString("default"))) { conn.Open(); returnval = GetSiteSetting(_settingcode, conn); conn.Close(); } return(returnval); }
public static string SendEmail(string _subject, string _body, string _mailto, string _mailfrom, string _fromdisplayname) { string error = String.Empty; string smtpuser = String.Empty; string smtppass = String.Empty; try { using (MySqlConnection conn = new MySqlConnection(PortalUtility.GetConnectionString("default"))) { conn.Open(); smtpuser = GetSiteSetting("ContactUsername", conn); smtppass = GetSiteSetting("ContactPassword", conn); if (String.IsNullOrEmpty(_mailfrom)) { _mailfrom = GetSiteSetting("ContactFrom", conn); } if (String.IsNullOrEmpty(_mailto)) { _mailto = GetSiteSetting("ContactTo", conn); } conn.Close(); } MailMessage mailmsg = new MailMessage(); mailmsg.To.Add(_mailto); mailmsg.Subject = _subject; mailmsg.Body = _body; mailmsg.From = new MailAddress(_mailfrom, _fromdisplayname); if (HttpContext.Current.Request.ServerVariables["SERVER_NAME"] == "localhost") { return(String.Empty); //mailmsg.To.Clear(); //mailmsg.To.Add("alternate email to"); } SmtpClient client = new SmtpClient(); client.Credentials = new System.Net.NetworkCredential(smtpuser, smtppass); client.Send(mailmsg); } catch (Exception ex) { error = ex.Message; } return(error); }
/// <summary> /// Get the user's role from the database /// </summary> /// <param name="userid">User id to look up</param> /// <returns>string of roles delimited by |</returns> /// <remarks>This method is only called if the roles are not found in a cookie</remarks> private string GetUserRoles(string userid) { string rolelist = string.Empty; //build a delimited string of the roles using (MySqlConnection conn = new MySqlConnection(PortalUtility.GetConnectionString("default"))) { conn.Open(); MySqlCommand cmd = new MySqlCommand("Security_Select_UserRoles", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pUsername", userid); using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { rolelist += dr["RoleName"].ToString() + "|"; } } conn.Close(); } rolelist = rolelist.TrimEnd('|'); return(rolelist); }