private void saveUser()
{
// save changes to the user record..
WebUser webUser = new WebUser();
webUser.userid = m_idref;
webUser.firstname = txtUserFirstname.Text;
webUser.lastname = txtUserLastname.Text;
webUser.emailaddress = txtUserEMail.Text;
// network..
webUser.apploginname = txtUserLoginName.Text;
webUser.apppassword = txtUserPassword.Text;
// roles ..
webUser.isnewhire = chkIsNewHire.Checked;
webUser.isleader = chkIsLeader.Checked;
webUser.isadmin = chkIsAdmin.Checked;
webUser.issuperadmin = chkIsSuperAdmin.Checked;
// submit changes to db now..
int newId = m_data.saveUser(webUser);
//audit trail
if (m_idref == 0)
{
m_data.auditEvent(cConstants.eventUserNew, newId);
}
else
{
m_data.auditEvent(cConstants.eventUserEdit, newId);
}
if (newId != 0)
{
Response.Redirect("~/admin/users");
}
}
private void initPage()
{
_webUser = cSecurity.getUser();
_selectedReport = cTools.cStrExt(Page.RouteData.Values["reportref"]);
GridView1.Visible = false; // hide the report when things change onscreen - eg different ddn selection
}
private void preInitApp()
{
webUser = cSecurity.getUser();
}
public static void handleEvent(int eventId, int surveyId)
{
// open up the db
cData m_data = new cData();
if (!m_data.openDB())
{
return;
}
/*
* load up the audit details & convert id's to text
*/
SurveySummaryData survey = m_data.loadSurvey(surveyId);
LocationData location = m_data.loadLocation(survey.locationid);
ClientData client = m_data.loadClient(location.clientid);
// convert id's to text
string sqlCmd = "SELECT templatename FROM templates WHERE templateid=" + survey.templateid;
string templateName = m_data.runSql(sqlCmd);
string jobRef = client.clientname + " - " + location.businessunit + " - " + location.locationname + " - " + templateName + " - " + survey.dateofaudit;
/*
* Set up the email, SMTP settings and links to the job
*/
//load up the standard template file.
string emailTemplate = loadTemplateFile();
if (emailTemplate == string.Empty)
{
return;
}
// get our email server settings..
string emailSenderName = cTools.cStrExt(ConfigurationManager.AppSettings["SenderName"]);
string emailSenderEmail = cTools.cStrExt(ConfigurationManager.AppSettings["SenderEMail"]);
string emailRootFolder = cTools.cStrExt(ConfigurationManager.AppSettings["EmailFolder"]);
int notifyUserOnSendToHQ = cTools.cIntExt(ConfigurationManager.AppSettings["NotifyUserOnSendToHQ"]);
string emailSubjectLine = string.Empty;
string emailHtml = string.Empty;
string notificationsBlock = string.Empty;
string sendToEmail = string.Empty;
string sendToName = string.Empty;
string siteUrl = "http://" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"];
if (siteUrl.Contains("localhost"))
{
siteUrl += "/coylegroup"; // dev server
}
string linkToJob = siteUrl + "/audit/summary/" + surveyId; // all notification links go to summary page..
/*
* Customise the email depending on what action was just taken
*/
switch (eventId)
{
case cConstants.eventSurveyConsultantChanged_Notification:
emailSubjectLine = "Audit Notification: Contractor Assigned";
notificationsBlock = "You have been assigned as the <b>Contractor</b> for the following audit.";
if (survey.auditorid != 0)
{
WebUser userDetails = m_data.loadUser(survey.auditorid);
sendToEmail = userDetails.emailaddress;
sendToName = userDetails.firstname;
}
break;
case cConstants.eventQuestionSubmitToHQ_Notification:
emailSubjectLine = "Audit Notification: For Internal Review";
notificationsBlock = "This audit has been <b>Sent to HQ</b> for internal review.";
if (notifyUserOnSendToHQ != 0)
{
WebUser userDetails = m_data.loadUser(notifyUserOnSendToHQ);
sendToEmail = userDetails.emailaddress;
sendToName = userDetails.firstname;
}
break;
case cConstants.eventSurveyStatusReadyForClientReview_Notification:
emailSubjectLine = "Audit Notification: Pending Client Approval";
notificationsBlock = "An audit is available <b>Pending Client Approval</b>";
if (survey.client_mgruserid != 0)
{
WebUser userDetails = m_data.loadUser(survey.client_mgruserid);
sendToEmail = userDetails.emailaddress;
sendToName = userDetails.firstname;
}
break;
case cConstants.eventClientApprovalAccept_Notification:
emailSubjectLine = "Audit Notification: Approved by Client";
notificationsBlock = "This audit has been <b>Approved by the Client</b>.";
if (survey.client_approvalcomments != "")
{
notificationsBlock += "<br><br>Client Comments:<br>" +
"<i>" + survey.client_approvalcomments + "</i>";
}
if (notifyUserOnSendToHQ != 0)
{
WebUser userDetails = m_data.loadUser(notifyUserOnSendToHQ);
sendToEmail = userDetails.emailaddress;
sendToName = userDetails.firstname;
}
break;
case cConstants.eventClientApprovalReject_Notification:
emailSubjectLine = "Audit Notification: Rejected by Client";
notificationsBlock = "This audit has been <b>Rejected by the Client</b>.";
if (survey.client_approvalcomments != "")
{
notificationsBlock += "<br><br>Client Comments:<br>" +
"<i>" + survey.client_approvalcomments + "</i>";
}
if (notifyUserOnSendToHQ != 0)
{
WebUser userDetails = m_data.loadUser(notifyUserOnSendToHQ);
sendToEmail = userDetails.emailaddress;
sendToName = userDetails.firstname;
}
break;
case cConstants.eventClientResponsesClosed_NotifyClientMgr:
emailSubjectLine = "Audit Notification: All Client Actions Closed";
notificationsBlock = "Congratulations - All action items have been <b>closed</b> on this audit.";
if (survey.client_mgruserid != 0)
{
WebUser userDetails = m_data.loadUser(survey.client_mgruserid);
sendToEmail = userDetails.emailaddress;
sendToName = userDetails.firstname;
}
break;
case cConstants.eventClientResponsesClosed_NotifyClientAdmin:
emailSubjectLine = "Audit Notification: All Client Actions Closed";
notificationsBlock = "Congratulations - All action items have been <b>closed</b> on this audit.";
// don't send if no admin user set or if it's the same as the manager..
if (survey.client_adminuserid != 0 && survey.client_adminuserid != survey.client_mgruserid)
{
WebUser userDetails = m_data.loadUser(survey.client_adminuserid);
sendToEmail = userDetails.emailaddress;
sendToName = userDetails.firstname;
}
break;
}
// while testing...
// sendToName += " (" + sendToEmail + ")";
// sendToEmail = "*****@*****.**";
// if no email associated with this task then off ye go..
if (sendToEmail == string.Empty)
{
return;
}
// record in the audit trail that we've handled this notification
string auditEntry = string.Format("To: {0} ({1})\n{2}",
sendToName, sendToEmail, notificationsBlock);
m_data.auditEvent(eventId, surveyId, auditEntry);
// start with a fresh template & replace with content for this user
emailHtml = emailTemplate;
emailHtml = emailHtml.Replace("%sendtoname%", sendToName);
emailHtml = emailHtml.Replace("%content%", notificationsBlock);
emailHtml = emailHtml.Replace("%datestamp%", cTools.cDateAndShortTime(DateTime.Now));
emailHtml = emailHtml.Replace("%linktojob%", linkToJob);
emailHtml = emailHtml.Replace("%jobref%", jobRef);
// set up today's email folder..
string folderName = String.Format("{0}/{1}",
emailRootFolder,
DateTime.Now.ToString("ddMMMyyyy")); // folder changes daily
System.IO.Directory.CreateDirectory(folderName);
string mailFilename = String.Format("{0}/notifications_{1}.htm",
folderName,
sendToEmail); // append all emails for person per day to one file
// write the file to the local server for later retrieval
cFiles.writeFile(mailFilename, emailHtml, true);
// send the email now..we store the output in a subfolder in the logs if enabled
cTools.log("Sending notification email to: " + sendToEmail);
// send the email now..unless it's on my dev machine..
if (!siteUrl.Contains("localhost"))
{
cMailer.sendMail(sendToName, sendToEmail, emailSenderName, emailSenderEmail, emailSubjectLine, emailHtml);
}
// send me a copy..
cMailer.sendMail("Gary Alerts", "*****@*****.**", emailSenderName, emailSenderEmail, emailSubjectLine, emailHtml);
// cleanup
m_data.closeDB();
}