private int SaveToEmailJob(string toEmail) { EmailBE objEmailBE = new EmailBE(); EmailDA objEmailDA = new EmailDA(); objEmailBE.isToEmailRef = false; objEmailBE.RequestStatus = "No-delay"; objEmailBE.RequestType = "Presenter Contact Emailing"; // "Webinar Registrant Emailing"; objEmailBE.Subject = "Webinar Presenter Contact"; objEmailBE.SubmittedBy = Convert.ToInt32(Session["UserID"]); objEmailBE.ToEmail = toEmail; objEmailBE.FromEmail = Session["EmailID"].ToString(); objEmailBE.EmailContent = objEmailing.getHTMLFormattedWebinarPresenterContact("Presenter Contact", Convert.ToInt32(hWebinarID.Value)); return objEmailDA.SaveEmailRequest(objEmailBE); }
protected void btnReview_Click(object sender, EventArgs e) { lblError1.Text = ""; if (txtReviewerEmail.Text.Trim() != "") { if (objUtil.isEmailsValid(txtReviewerEmail.Text.Trim(), new char[] { ';' })) { EmailBE objEmailBE = new EmailBE(); EmailDA objEmailDA = new EmailDA(); int emlReqID = 0; objEmailBE.isToEmailRef = true; objEmailBE.RequestStatus = "No-delay"; objEmailBE.RequestType = "Thank You for registering"; // "Webinar Registrant Emailing"; objEmailBE.Subject = "Thank You for registering content for review"; // txtSubject.Text; objEmailBE.SubmittedBy = Convert.ToInt32(Session["UserID"]); objEmailBE.ToEmail = ""; objEmailBE.FromEmail = Session["EmailID"].ToString(); objEmailBE.EmailContent = "<b>Following are the content for review</b><br><br>" + redtThankContent.Content; emlReqID = objEmailDA.SaveEmailRequest(objEmailBE); objEmailDA.SaveToEmail(new EmailTo { EmailRequestID = emlReqID, ToEmails = txtReviewerEmail.Text.Trim(), ToType = "" }); lblError1.Text = "Emailed to reviewer(s)"; } else { lblError1.Text = "One or more entered reviewer's email is invalid"; } } else lblError1.Text = "Reviewer email(s) is missing"; }
private int SaveEmail(string requestType, string subject, string toEmail, string emailContent) { EmailBE objEmailBE = new EmailBE(); EmailDA objEmailDA = new EmailDA(); objEmailBE.isToEmailRef = true; objEmailBE.RequestStatus = "No-delay"; objEmailBE.RequestType = requestType; // "Webinar Registrant Emailing"; objEmailBE.Subject = subject; // txtSubject.Text; objEmailBE.SubmittedBy = Convert.ToInt32(Session["UserID"]); objEmailBE.ToEmail = toEmail; objEmailBE.FromEmail = Session["EmailID"].ToString(); objEmailBE.EmailContent = emailContent; return objEmailDA.SaveEmailRequest(objEmailBE); }
private int SaveToEmailJob(string emailID) { EmailBE objEmailBE = new EmailBE(); EmailDA objEmailDA = new EmailDA(); EmailApp objEmailing = new EmailApp(); string emlContent = objEmailing.getHTMLFormattedPasswdChangeNotify(emailID); objEmailBE.isToEmailRef = false; objEmailBE.RequestStatus = "No-delay"; objEmailBE.RequestType = "Password Changed"; objEmailBE.Subject = "Password Changed Notification"; objEmailBE.SubmittedBy = 0; objEmailBE.ToEmail = emailID; objEmailBE.FromEmail = "*****@*****.**"; objEmailBE.EmailContent = emlContent; return objEmailDA.SaveEmailRequest(objEmailBE); }
private int SaveToEmailJob(string emailID, string genPasswd) { EmailBE objEmailBE = new EmailBE(); EmailDA objEmailDA = new EmailDA(); EmailApp objEmailing = new EmailApp(); string emlContent = objEmailing.getHTMLFormattedNewAccountNotify(emailID, genPasswd, DateTime.Now.ToString()); objEmailBE.isToEmailRef = false; objEmailBE.RequestStatus = "No-delay"; objEmailBE.RequestType = "New User Account"; objEmailBE.Subject = "Welcome to SnapSession!"; objEmailBE.SubmittedBy = Convert.ToInt32(Session["UserID"]); objEmailBE.ToEmail = emailID; objEmailBE.FromEmail = "*****@*****.**"; objEmailBE.EmailContent = emlContent; return objEmailDA.SaveEmailRequest(objEmailBE); }
public int SaveEmailRequest(EmailBE objEmailBE) { int requestID = 0; try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { //MySqlCommand sqlCmd = new MySqlCommand(DBEmailQuery.sqlRequestInsert, sqlCon); MySqlCommand sqlCmd = new MySqlCommand("spSaveEmailingRequest", sqlCon); sqlCon.Open(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add(new MySqlParameter("pMailType", objEmailBE.RequestType)); sqlCmd.Parameters.Add(new MySqlParameter("pSubject", objEmailBE.Subject)); sqlCmd.Parameters.Add(new MySqlParameter("pEmailContent", objEmailBE.EmailContent)); sqlCmd.Parameters.Add(new MySqlParameter("pFromEmail", objEmailBE.FromEmail)); sqlCmd.Parameters.Add(new MySqlParameter("pFromName", objEmailBE.FromName)); sqlCmd.Parameters.Add(new MySqlParameter("pIsToEmailRef", objEmailBE.isToEmailRef)); sqlCmd.Parameters.Add(new MySqlParameter("pToEmail", objEmailBE.ToEmail)); sqlCmd.Parameters.Add(new MySqlParameter("pToEmailName", objEmailBE.ToEmailName)); sqlCmd.Parameters.Add(new MySqlParameter("pSubmittedBy", objEmailBE.SubmittedBy)); sqlCmd.Parameters.Add(new MySqlParameter("pRequestStatus", objEmailBE.RequestStatus)); //sqlCmd.ExecuteNonQuery(); //sqlCmd = new MySqlCommand("SELECT LAST_INSERT_ID()", sqlCon); //sqlCmd.CommandType = CommandType.Text; MySqlDataReader reader = sqlCmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); requestID = Convert.ToInt32(reader.GetValue(0)); } reader.Close(); reader = null; sqlCon.Close(); } } catch (Exception ex) { throw; } return requestID; }
private int SaveToEmailJob(string toEmail, string chkTyp) { EmailBE objEmailBE = new EmailBE(); EmailDA objEmailDA = new EmailDA(); objEmailBE.isToEmailRef = false; objEmailBE.RequestStatus = "No-delay"; objEmailBE.RequestType = hReqType.Value; // "Webinar Registrant Emailing"; objEmailBE.Subject = chkTyp + " : " + txtSubject.Text; objEmailBE.SubmittedBy = Convert.ToInt32(Session["UserID"]); objEmailBE.ToEmail = toEmail; objEmailBE.FromEmail = Session["EmailID"].ToString(); objEmailBE.EmailContent = objEmailing.getFormedEmailContent(redtRemEmail.Content, hReqType.Value, Convert.ToInt32(hWebinarID.Value)); return objEmailDA.SaveEmailRequest(objEmailBE); }
//private EmailBE GetWebinarContent(string ReqType, int webinarID) //{ // EmailBE objEmailBE = new EmailBE(); // string tplValue = ""; // if (objWBEmail.Count > 0) // { // objEmailBE.EmailContent = objWBEmail[0].EmailContent; // objEmailBE.FromEmail = ""; // objEmailBE.RequestType = objWBEmail[0].RequestType; // objEmailBE.Subject = objWBEmail[0].Subject; // } //} private EmailBE GetWebinarContent(string ReqType, string emailSubject, string tplFileName) { EmailBE objEmailBE = new EmailBE(); string tplValue = ""; hWebinarID.Value = Request["ID"].ToString(); List<WebinarEmailBE> objWBEmail = objEmailDA.GetWebinarEmail(Convert.ToInt32(hWebinarID.Value), ReqType); if (objWBEmail.Count == 0) { TemplateMgmt objTemplateMgmt = new TemplateMgmt(); tplValue = objTemplateMgmt.GetReminderEmail(Constant.DocTemplate + tplFileName); SaveEmail(tplValue, emailSubject, ReqType, Convert.ToInt32(hWebinarID.Value)); objEmailBE.EmailContent = tplValue; objEmailBE.FromEmail = ""; objEmailBE.RequestType = ReqType; objEmailBE.Subject = emailSubject; } else { objEmailBE.EmailContent = objWBEmail[0].EmailContent; objEmailBE.FromEmail = ""; objEmailBE.RequestType = objWBEmail[0].RequestType; objEmailBE.Subject = objWBEmail[0].Subject; } return objEmailBE; }
private int SaveToEmailJob(string toEmail, string reqTyp) { EmailBE objEmailBE = new EmailBE(); EmailDA objEmailDA = new EmailDA(); EmailApp objEmailing = new EmailApp(); string emlContent = string.Empty; string frEmail = string.Empty; string subject = string.Empty; switch (reqTyp) { case "Webinar Invitation": int webinarID = Convert.ToInt32(hWebinarID.Value); List<WebinarEmailBE> objWBEmail = new List<WebinarEmailBE>(); objWBEmail = objEmailDA.GetWebinarEmail(webinarID, reqTyp); emlContent = objEmailing.getHTMLFormattedEmailContent(objWBEmail[0].EmailContent, objWBEmail[0].RequestType, webinarID); emlContent = objEmailing.getFormedEmailContent(emlContent, reqTyp, webinarID); frEmail = Session["EmailID"].ToString(); subject = "Webinar Invitation"; break; case "Campaign Tracking": emlContent = objEmailing.getHTMLFormattedGeneralEmail(reqTyp, Convert.ToInt32(Session["Client_LanguageID"])); frEmail = "*****@*****.**"; subject = "SnapSession Webinar Campaign Tracking"; break; case "Connect Your Registration": emlContent = objEmailing.getHTMLFormattedGeneralEmail(reqTyp, Convert.ToInt32(Session["Client_LanguageID"])); frEmail = "*****@*****.**"; subject = "SnapSession Connect Your Registration"; break; } objEmailBE.isToEmailRef = false; objEmailBE.RequestStatus = "No-delay"; objEmailBE.RequestType = reqTyp; objEmailBE.Subject = subject; objEmailBE.SubmittedBy = Convert.ToInt32(Session["UserID"]); objEmailBE.ToEmail = toEmail; objEmailBE.FromEmail = frEmail; objEmailBE.EmailContent = emlContent; return objEmailDA.SaveEmailRequest(objEmailBE); }
protected void btnSendEmail_Click(object sender, EventArgs e) { lblError.Text = ""; if (txtSubject.Text == "" || redEmailRegistrants.Content == "") lblError.Text = "Subject or email content cannot be empty"; else { if (chkDidNotAttend.Checked || chkAttended.Checked || chkAttendedLive.Checked || chkOnDemand.Checked || chkRegistered.Checked) { lblError.Text = ""; EmailBE objEmailBE = new EmailBE(); EmailDA objEmailDA = new EmailDA(); //objEmailBE.isToEmailRef = true; //objEmailBE.RequestStatus = "Queued"; //objEmailBE.RequestType = "Webinar Registrant Emailing"; //objEmailBE.Subject = txtSubject.Text; //objEmailBE.SubmittedBy = Convert.ToInt32(Session["UserID"]); //if (txtSendMeEmailAddress.Text != "") // objEmailBE.ToEmail = txtSendMeEmailAddress.Text; //objEmailBE.FromEmail = Session["EmailID"].ToString(); //objEmailBE.EmailContent = redEmailRegistrants.Content; //int requestID = objEmailDA.SaveEmailRequest(objEmailBE); int requestID = SaveEmail("Webinar Registrant Emailing", txtSubject.Text.Trim(), txtSendMeEmailAddress.Text.Trim(), redEmailRegistrants.Content); if (requestID != 0) { List<EmailAddressBO> objEmailAddress = new List<EmailAddressBO>(); if (chkDidNotAttend.Checked) { objEmailAddress = objEmailDA.GetToEmailAddress(Convert.ToInt32(hWebinarID.Value), "NOTATTENDED"); UpdateToEmails(objEmailAddress, "Email Registrant - NotAttended", requestID); } if (chkAttended.Checked) { objEmailAddress = objEmailDA.GetToEmailAddress(Convert.ToInt32(hWebinarID.Value), "ATTENDED"); UpdateToEmails(objEmailAddress, "Email Registrant - Attended", requestID); } if (chkAttendedLive.Checked) { objEmailAddress = objEmailDA.GetToEmailAddress(Convert.ToInt32(hWebinarID.Value), "LIVE"); UpdateToEmails(objEmailAddress, "Email Registrant - Attended Live", requestID); } if (chkOnDemand.Checked) { objEmailAddress = objEmailDA.GetToEmailAddress(Convert.ToInt32(hWebinarID.Value), "ONDEMAND"); UpdateToEmails(objEmailAddress, "Email Registrant - Attended Ondemand", requestID); } if (chkRegistered.Checked) { objEmailAddress = objEmailDA.GetToEmailAddress(Convert.ToInt32(hWebinarID.Value), "REGISTERED"); UpdateToEmails(objEmailAddress, "Email Registrant - All registered", requestID); } lblError.Text = "Successfully emailed to selected registrant group"; lblError.CssClass = "msgSuccess"; } } else { lblError.Text = "At least one registration group has to be selected"; } } }