public static void NotifySupervisor(Audit audit) { if (audit.Type == Audit5sAdministration || audit.Type == Audit5sLpaProduction) { var supervisorLogin = GetTargetSupervisorLogin(audit.Type, audit.Target); var fileName = $"Audit_ID{audit.Id}_{DateTime.Now.ToString("yyyyMMdd")}.pdf"; var subject = $"Ended audit {audit.TypeName} | {audit.Target}"; var body = ""; var email = AppUser.GetUserMail(supervisorLogin); if (email == null) { throw new Exception("You can not send an e-mail with the report - no e-mail in the system / wrong format!"); } var report = GetXtraReport(audit, Languages.Default); using (MemoryStream stream = new MemoryStream()) { report.ExportToPdf(stream); stream.Position = 0; var attach = new Attachment(stream, fileName, "application/pdf"); MailUtils.SendEmail(subject, body, new List <string> { email }, new List <Attachment> { attach }); } } }
protected void gvUsers_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { var newUsername = Utils.ConvertToTrimmedString(e.NewValues["username"]); var newName = Utils.ConvertToTrimmedString(e.NewValues["name"]); var newLastName = Utils.ConvertToTrimmedString(e.NewValues["lastname"]); var newEmail = Utils.ConvertToTrimmedString(e.NewValues["email"]); if (newUsername == null || newName == null || newLastName == null || newEmail == null) { throw new Exception("Complete all fields!"); } newUsername = newUsername.ToLower(); newEmail = newEmail.ToLower(); if (!MailUtils.EmailAddressValid(newEmail)) { throw new Exception("Email is not valid!"); } UserManagement.UserRegister(newUsername, newName, newLastName, newEmail); }
public AppUser(string userName) { this.UserName = (userName != null) ? userName.ToUpper().Trim() : null; this.Exist = false; if (this.UserName != null && UserExist(userName)) { this.Exist = true; string query = @"SELECT [Name], [LastName], [Email] FROM [aspnet_Users] WHERE [LoweredUserName] = @username;"; var parameters = new Dictionary <string, object>() { { "username", userName.ToLower().Trim() } }; var result = DatabaseUtils.ExecuteSelectQuery(query, parameters, DatabaseUtils.ConnectionTarget.Services); if (result != null) { this.Email = Convert.ToString(result.Rows[0]["Email"]); this.Email = (MailUtils.EmailAddressValid(this.Email)) ? this.Email.ToLower().Trim() : null; this.FirstName = Convert.ToString(result.Rows[0]["Name"]); this.FirstName = (this.FirstName != null) ? this.FirstName.Trim() : null; this.LastName = Convert.ToString(result.Rows[0]["LastName"]); this.LastName = (this.LastName != null) ? this.LastName.Trim() : null; this.FullName = this.FirstName + " " + this.LastName; this.FullName = (!string.IsNullOrWhiteSpace(this.FullName)) ? this.FullName.Trim() : null; } } }
public void SendEmailWithPdf(string lang) { var fileName = $"Audit_ID{this.Id}_{DateTime.Now.ToString("yyyyMMdd")}.pdf"; var subject = $"Printout {this.TypeName} | {this.Target}"; var body = ""; var email = AppUser.GetUserMail(this.AuditorLogin); if (email == null) { throw new Exception("You can not send an e-mail with the report - no e-mail in the system / wrong format!"); } var report = AuditTypes.GetXtraReport(this, lang); using (MemoryStream stream = new MemoryStream()) { report.ExportToPdf(stream); stream.Position = 0; var attach = new Attachment(stream, fileName, "application/pdf"); MailUtils.SendEmail(subject, body, new List <string> { email }, new List <Attachment> { attach }); } throw new Exception("An email with a PDF printout has been sent! Check your inbox!"); }
private static void SendChangePasswordNotification(string username, string password) { var subject = $"Account {username.ToUpper()} password reseted!"; var body = $"Your new password: {password}"; var email = AppUser.GetUserMail(username); MailUtils.SendEmail(subject, body, new List <string> { email }); }
private static void SendUnlockNotification(string username) { var subject = $"Account {username.ToUpper()} unlocked!"; var body = string.Empty; var email = AppUser.GetUserMail(username); MailUtils.SendEmail(subject, body, new List <string> { email }); }
private static void SendRegisterNotification(string username, string password) { var subject = $"Account {username.ToUpper()} creation!"; var body = $"Your password: {password}"; var email = AppUser.GetUserMail(username); MailUtils.SendEmail(subject, body, new List <string> { email }); }
public static string GetUserMail(string userName) { if (string.IsNullOrWhiteSpace(userName)) { return(null); } string query = @"SELECT [Email] FROM [aspnet_Users] WHERE [LoweredUserName] = @username;"; var parameters = new Dictionary <string, object>() { { "username", userName.ToLower().Trim() } }; var result = Convert.ToString(DatabaseUtils.ExecuteScalarSelectQuery(query, parameters, DatabaseUtils.ConnectionTarget.Services)); return((MailUtils.EmailAddressValid(result)) ? result.ToLower().Trim() : null); }
protected void gvUsers_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { var newUsername = Utils.ConvertToTrimmedString(e.NewValues["username"]); var oldUsername = Utils.ConvertToTrimmedString(e.OldValues["username"]); var newName = Utils.ConvertToTrimmedString(e.NewValues["name"]); var newLastName = Utils.ConvertToTrimmedString(e.NewValues["lastname"]); var newEmail = Utils.ConvertToTrimmedString(e.NewValues["email"]); if (oldUsername == null) { throw new Exception("System error!"); } if (newUsername == null || newName == null || newLastName == null || newEmail == null) { throw new Exception("Complete all fields!"); } oldUsername = oldUsername.ToLower(); newUsername = newUsername.ToLower(); newEmail = newEmail.ToLower(); if (newUsername != oldUsername) { throw new Exception("Username cannot be changed!"); } if (!MailUtils.EmailAddressValid(newEmail)) { throw new Exception("Email is not valid!"); } UserManagement.UserUpdate(newUsername, newName, newLastName, newEmail); }