private void Update(DataGridCommandEventArgs e) { string strName = dtbConfig.Rows[e.Item.ItemIndex]["Name"].ToString(); string strDescription = dtbConfig.Rows[e.Item.ItemIndex]["Description"].ToString(); bool noRichText = ((strName == "Number_Of_Quiz_Questions") || (strName == "css") || (strName == "ShowDetailedHelp") || (strName == "Student_Summary_Subject") || (strName == "Overdue_Summary_Subject")); string strValue = null; if (noRichText) { strValue = ((TextBox)dgrConfig.Items[(int)e.Item.ItemIndex].FindControl("txtValue_Edit2")).Text; } else { strValue = ((TextEditor)dgrConfig.Items[(int)e.Item.ItemIndex].FindControl("txtValue_Edit")).Text; } // Perform business update OrganisationConfig objOrgConfig = new OrganisationConfig(); objOrgConfig.Update(0, strName, strDescription, strValue); // Done Response.Redirect("EmailDefault.aspx"); }
private void GetData() { if (dtbConfig == null) { OrganisationConfig objOrgConfig = new OrganisationConfig(); dtbConfig = objOrgConfig.GetList(UserContext.UserData.OrgID); } }
private void GetData() { if (dtbConfig == null) { OrganisationConfig objOrgConfig = new OrganisationConfig(); dtbConfig = objOrgConfig.GetList(0); } }
public void certemail(int intUserID, int intCourseID, int intProfileID) { int orgid; BusinessServices.User objUser = new BusinessServices.User(); DataTable dtUser = objUser.GetUser(intUserID); Int32.TryParse(dtUser.Rows[0]["OrganisationID"].ToString(), out orgid); string username = dtUser.Rows[0]["UserName"].ToString(); BusinessServices.AppConfig objAppConfig = new BusinessServices.AppConfig(); DataTable dtbAppConfig = objAppConfig.GetList(); string strHostname = HttpContext.Current.Request.Url.Authority.ToString(); bool isSSL = bool.Parse(dtbAppConfig.Select("Name='SSL'")[0]["Value"].ToString()); string strUrl = null; if (strHostname.ToLower().Equals("127.0.0.2")) { strUrl = "https://" + strHostname; } else { strUrl = "http://" + strHostname; } strUrl = "https://" + strHostname; //WriteErrorLog(strUrl.ToString()); OrganisationConfig objOrgConfig = new OrganisationConfig(); string strCss = objOrgConfig.GetOne(orgid, "css"); string pdfFileName = "cert_" + username + "_" + intCourseID.ToString() + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf"; bool status = HtmlToPdf.WKHtmlToPdf(strUrl + @"/Certificate.aspx?courseid=" + intCourseID + "&profileid=" + intProfileID + "&userid=" + intUserID + "&orgid=" + orgid + "&css=" + strCss, pdfFileName); string filename = ""; if (status) { filename = HttpContext.Current.Server.MapPath(ConfigurationSettings.AppSettings["WorkingFolder"]) + "\\" + pdfFileName; } else { ErrorLog objError = new ErrorLog(new Exception("Course completion certificate"), ErrorLevel.Medium, "DefaultQuiz.cs", "GenerateCourseCompletionCertificate", "Course completion certificate generation failed: " + pdfFileName); } sendCertEmail(intUserID, intCourseID, orgid, filename); try { FileInfo fileinfo = new FileInfo(filename); if (fileinfo.Exists) { File.Delete(filename); } } catch (Exception e) { ErrorLog objError = new ErrorLog(e, ErrorLevel.Medium, "DefaultQuiz.cs", "DeleteCourseCompletionCertificate", "Course completion certificate deletion failed: " + pdfFileName); } }
private void Delete(DataGridCommandEventArgs e) { // Gather Values int intOrganisationID = UserContext.UserData.OrgID; string strName = dtbConfig.Rows[e.Item.ItemIndex]["Name"].ToString(); // Perform business update OrganisationConfig objOrgConfig = new OrganisationConfig(); objOrgConfig.Delete(intOrganisationID, strName); // Done Response.Redirect("OrganisationConfiguration.aspx"); }
/// <summary> /// Style sheet for printing. /// </summary> //protected System.Web.UI.HtmlControls.HtmlGenericControl lnkStyleSheetPrint; protected void Page_Load(object sender, System.EventArgs e) { string strCss = ""; // If the organisation is known try { OrganisationConfig objOrgConfig = new OrganisationConfig(); strCss = objOrgConfig.GetOne(Utilities.UserContext.UserData.OrgID, "css"); // If its an empty string then use the application name if (strCss.Length == 0) { strCss = Utilities.ApplicationSettings.StyleSheet; } // append '.css' if requied if (!strCss.ToLower().EndsWith(".css")) { strCss += ".css"; } strCss = "/general/css/" + strCss; // Update the stylesheet link lnkStyleSheet.Attributes.Add("href", strCss); } // If the organisation isnt known then default css is used. catch { // Update the stylesheet link strCss = Utilities.ApplicationSettings.StyleSheet; // append '.css' if requied if (!strCss.ToLower().EndsWith(".css")) { strCss += ".css"; } strCss = "/general/css/" + strCss; lnkStyleSheet.Attributes.Add("href", strCss); } // Style sheet link for printing //lnkStyleSheetPrint.Attributes.Add("href","/General/css/PrintFriendly.css"); }
protected void Page_Load(object sender, System.EventArgs e) { OrganisationConfig objOrgConfig = new OrganisationConfig(); string strShow = objOrgConfig.GetOne(Utilities.UserContext.UserData.OrgID, "ShowDetailedHelp"); if (strShow[0].ToString().ToLower() == "y") { string strKey = this.Attributes["Key"].ToString(); string strDesc = this.Attributes["Desc"].ToString(); this.lnkToHelpFile.Text = strDesc; this.lnkToHelpFile.NavigateUrl = "/Help.aspx#" + strKey; } else { this.lnkToHelpFile.Visible = false; } }
private string GetEmailBody(EmailReportType emailReportType) { OrganisationConfig objOrgConfig = new OrganisationConfig(); BusinessServices.AppConfig objAppConfig = new BusinessServices.AppConfig(); string strEmailBody=""; switch (emailReportType) { case EmailReportType.Email_Incomplete_CPD_User: { strEmailBody = objOrgConfig.GetOne(UserContext.UserData.OrgID,"Email_Incomplete_CPD_User"); break; } case EmailReportType.Email_Incomplete_CPD_Administrator: { strEmailBody = objOrgConfig.GetOne(UserContext.UserData.OrgID,"Email_Incomplete_CPD_Administrator"); break; } } // switch // Get the application conffiguration details DataTable dtbAppConfig = objAppConfig.GetList(); // Setup the email body foreach (DataRow drwAppConfig in dtbAppConfig.Rows) { if (drwAppConfig.ItemArray[0].ToString().ToUpper()=="APPNAME") { strEmailBody = strEmailBody.Replace("%APP_NAME%",drwAppConfig.ItemArray[1].ToString()); } } strEmailBody = strEmailBody.Replace("<BR>",Environment.NewLine); return (strEmailBody); }
public static void sendCertEmail(int userid, int courseid, int orgid, string certPath) { Organisation org = new Organisation(); AppConfig a = new AppConfig(); if (!org.orgMailFlagConfig(orgid, 0, userid) && a.getConfigValue("SEND_AUTO_EMAILS").ToUpper().Equals("YES")) { User usr = new User(); DataTable dtUser = usr.GetUser(userid); MailAddress emailTo = new MailAddress(dtUser.Rows[0]["Email"].ToString()); string strEmailFrom = null; using (StoredProcedure sp = new StoredProcedure("prcUser_GetAdministratorsEmailAddress", StoredProcedure.CreateInputParam("@UserId", SqlDbType.Int, userid)) ) { strEmailFrom = sp.ExecuteScalar().ToString(); } MailAddress emailFrom = new MailAddress(strEmailFrom); MailMessage emailCert = new MailMessage(emailFrom, emailTo); OrganisationConfig orgConfig = new OrganisationConfig(); Course course = new Course(); DataTable dtCourse = course.GetCourse(courseid, orgid); Email eml = new Email(); string strEmailBody = orgConfig.GetOne(orgid, "Course_Completion_Certificate"); eml.SetEmailBody(strEmailBody, userid, dtCourse.Rows[0]["Name"].ToString(), "", "", "", "", "", "", ""); strEmailBody = eml.getEmailBody(); emailCert.Body = strEmailBody; emailCert.Subject = eml.emailHeaderSub("%APP_NAME% - " + dtCourse.Rows[0]["Name"].ToString()); Attachment cert = new Attachment(certPath); if (!certPath.Equals("")) { emailCert.Attachments.Add(cert); } emailCert.IsBodyHtml = true; emailCert.From = new MailAddress(getOnBehalfOfEmail()); emailCert.Sender = emailFrom; //SmtpClient client = new SmtpClient(); string MailServer = (string)HttpContext.Current.Application["MailServer"]; SmtpClient SmtpMail = new SmtpClient(MailServer); SmtpMail.Credentials = new System.Net.NetworkCredential(); //.CredentialCache.DefaultNetworkCredentials; emailCert.Headers.Add("Reply-To", emailCert.Sender.ToString()); //for IIS7 and below emailCert.ReplyTo = emailCert.Sender; //for IIS7.5 and above //SmtpClient smtp = new SmtpClient(); //smtp.Host = "smtp.nsw.exemail.com.au"; //smtp.Port = 25; //smtp.UseDefaultCredentials = false; ////smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network; //smtp.DeliveryMethod = SmtpDeliveryMethod.Network; ////smtp.Credentials = new NetworkCredential("custadmin", "decemBer25TH1"); //smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "abcd-1234"); //smtp.EnableSsl = true; ////smtp.EnableSsl = false; //smtp.Timeout = 20000; try { SmtpMail.Send(emailCert); //smtp.Send(emailCert); eml.LogSentEmail(dtUser.Rows[0]["Email"].ToString(), dtUser.Rows[0]["FirstName"].ToString() + " " + dtUser.Rows[0]["LastName"].ToString(), emailFrom.Address, emailFrom.Address, "", "", emailCert.Subject, emailCert.Body, orgid, userid); } catch (Exception e) { // General Exception occured, log it ErrorLog objError = new ErrorLog(e, ErrorLevel.Medium, "DefaultQuiz.cs", "SendCourseCompletionCertificateEmail", "Course completion send email failed: " + certPath); } //SmtpClient client = new SmtpClient(); //client.Send(emailCert); finally { cert.ContentStream.Close(); } } }