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);
}
