protected void btnSave_Click(object sender, EventArgs e) { if (Request["flg"].ToString() == "1") { if (txtSubject.Text.Trim() != "" && txtBody.Text.Trim() != "") { WebinarEmailBE objWebinarEmailBE1 = new WebinarEmailBE(); objWebinarEmailBE1.WebinarID = Convert.ToInt32(hWebinarID.Value); objWebinarEmailBE1.Subject = txtSubject.Text.Trim(); objWebinarEmailBE1.EmailContent = txtBody.Text.Trim(); objWebinarEmailBE1.RequestType = "Email a Friend"; objEmailDA.SaveWebinarEmail(objWebinarEmailBE1); objWebinarDA.SaveWebinarAudience(Convert.ToInt32(hWebinarID.Value), "Email", (Convert.ToInt32(ClientConfigMaster.Audi_Component_EmailFriend)).ToString()); if (!ClientScript.IsStartupScriptRegistered("alert")) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "CloseAndReload();", true); } } } else { objWebinarDA.SaveWebinarAudience(Convert.ToInt32(hWebinarID.Value), "Email", "0"); if (!ClientScript.IsStartupScriptRegistered("alert")) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "CloseAndReload();", true); } } }
public void SaveDefaultEmailAFriendContent(int languageID,int WebinarID) { List<WebinarEmailBE> objWebinarEmailBE = GetWebinarEmailDefault(languageID, "Email a Friend"); if (objWebinarEmailBE.Count > 0) { WebinarEmailBE objWebEmail = new WebinarEmailBE(); objWebEmail.Subject = objWebinarEmailBE[0].Subject; if (objWebinarEmailBE[0].EmailContent.IndexOf("##AUDI_URL##") > 0) { WebinarDA objWebDA = new WebinarDA(); List<WebinarURLs> objURL = objWebDA.GetWebinarURLsDA(WebinarID); objWebEmail.EmailContent = objWebinarEmailBE[0].EmailContent.Replace("##AUDI_URL##", Constant.WebinarViewerBaseURL + objURL[0].AudienceInterfaceURL); } else objWebEmail.EmailContent = objWebinarEmailBE[0].EmailContent; objWebEmail.RequestType = "Email a Friend"; objWebEmail.WebinarID = WebinarID; SaveWebinarEmail(objWebEmail); } }
public void SaveWebinarEmail(WebinarEmailBE objWebinarEmailBE, bool isInsert = false) { string sql1 = ""; if (!isInsert) sql1 = DBEmailQuery.sqlWebinarEmailUpdate; else sql1 = DBEmailQuery.sqlWebinarEmailInsert; try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { MySqlCommand sqlCmd = new MySqlCommand(sql1, sqlCon); sqlCon.Open(); sqlCmd.CommandType = CommandType.Text; sqlCmd.Parameters.Add(new MySqlParameter("@emailSubject", objWebinarEmailBE.Subject)); sqlCmd.Parameters.Add(new MySqlParameter("@emailContent", objWebinarEmailBE.EmailContent)); sqlCmd.Parameters.Add(new MySqlParameter("@isSystemReq", objWebinarEmailBE.IsSystemReq)); sqlCmd.Parameters.Add(new MySqlParameter("@isCalenderAddition", objWebinarEmailBE.IsOutlookLink)); sqlCmd.Parameters.Add(new MySqlParameter("@emailType", objWebinarEmailBE.RequestType)); sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", objWebinarEmailBE.WebinarID)); sqlCmd.ExecuteNonQuery(); sqlCon.Close(); } } catch (Exception ex) { throw; } }
private void SaveEmail(string emlContent, string emlSubject, string rType, int WebinarID) { WebinarEmailBE objWebBE1 = new WebinarEmailBE(); objWebBE1.EmailContent = emlContent; objWebBE1.RequestType = rType; objWebBE1.Subject = emlSubject; objWebBE1.WebinarID = WebinarID; //objWebBE1.IsAdditionalWebinar = false; objWebBE1.IsOutlookLink = chkOutlook.Checked; objWebBE1.IsSystemReq = chkSysReq.Checked; objEmailDA.SaveWebinarEmail(objWebBE1); }