protected void btnPreLogin_Click(object sender, EventArgs e) { if (hPreview.Value == "0") { if (txtPreEmail.Text != "") { WebinarDA objWebinarDA = new WebinarDA(); List<Registrants> objReg = objWebinarDA.GetWebinarRegistrantDetail(Convert.ToInt32(hWebinarID.Value), txtPreEmail.Text.Trim()); if (objReg.Count > 0) { List<WebinarURLs> objURL = new List<WebinarURLs>(); objURL = objWebinarDA.GetWebinarURLsDA(Convert.ToInt32(hWebinarID.Value)); if (objURL.Count > 0) { if (objURL[0].AudienceInterfaceURL != "") Response.Redirect(Constant.WebinarViewerBaseURL + objURL[0].AudienceInterfaceURL); } } else { lblError.Text = "Login failed - no registered email exist for this webinar"; } } } }
public void DeleteBriefcaseContentDocs(int WebinarID, int clientID) { //public List<WebinarResource> getWebinarResoures(int webinarID, string resourceType) WebinarDA objWebinarDA = new WebinarDA(); List<WebinarResource> objRes = objWebinarDA.getWebinarResoures(WebinarID, "'Content Doc'"); for (int idx = 0; idx < objRes.Count; idx++) { removeDocumentFromRepositary(objRes[idx].DocID, clientID, "WebinarDocs"); objWebinarDA.DeleteRegFormResources(WebinarID, objRes[idx].DocID); } }
protected void btnUpload_Click(object sender, EventArgs e) { int docID = 0; DocAccess objDocAccess = new DocAccess(); WebinarDA objWebinarDA = new WebinarDA(); docID = objDocAccess.saveFiles(Request, "PRESENTATION", Convert.ToInt32(Session["ClientID"]), Convert.ToInt32(Session["UserID"])); if (docID > 0) { objWebinarDA.UpdateRegPageVideo(docID, Convert.ToInt32(hWebinarID.Value)); hDocID.Value = docID.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { if (Page.RouteData.Values["Id"] != null) { setPlaceHolder(true); WebinarDA objWebinarDA = new WebinarDA(); string URLkey = Page.RouteData.Values["Id"].ToString(); int WebinarID = objWebinarDA.getWebinarIDFromURLKey("REg", URLkey); if (WebinarID != 0) { List<WebinarBE> objWebDetail = objWebinarDA.GetWebinarDetailDA(WebinarID); if (objWebDetail.Count > 0) { lblWebinarTitle.Text = objWebDetail[0].Title; lblWebinarDesc.Text = objWebDetail[0].Description; //Pass values to DateTime user controls MasterDA objMas = new MasterDA(); List<TimeZoneBE> tmzone = objMas.getTimeZoneName(objWebDetail[0].TimeZoneID); if (tmzone.Count > 0) plDateTime1.WebinarDateTime = objWebDetail[0].StartDate.ToLongDateString() + "<br>" + Convert.ToDateTime(objWebDetail[0].StartTime).ToLongTimeString() + "<br>" + tmzone[0].TimeZoneName; else plDateTime1.WebinarDateTime = objWebDetail[0].StartDate.ToLongDateString() + "<br>" + Convert.ToDateTime(objWebDetail[0].StartTime).ToLongTimeString(); } List<WebinarTheme> objWT = objWebinarDA.getWebinarTheme(WebinarID); if (objWT.Count > 0) { layoutCSS.Href = "~/Styles/layout/layout" + objWT[0].ThemeLayoutID.ToString() + ".css"; lblWebinarTitle.ForeColor = System.Drawing.ColorTranslator.FromHtml(objWT[0].PriThemeColor); lblWebinarDesc.ForeColor = System.Drawing.ColorTranslator.FromHtml(objWT[0].SecThemeColor); regPage.Style.Add("font-family",objWT[0].ThemeFontName); regPage.Style.Add("font-size", "12px"); //Pass values to Logo user control plLogos1.WebinarID = objWT[0].WebinarID; //plLogos1.LogoID1 = objWT[0].LogoID1; //plLogos1.LogoID2 = objWT[0].LogoID2; plLogos1.HeaderType = objWT[0].HeaderType; //Pass values to registration form user controls plRegForm1.WebinarID = WebinarID.ToString(); //Pass values to Presenter user controls plRegPresenter1.WebinarID = WebinarID.ToString(); } } else setPlaceHolder(false); } else setPlaceHolder(false); } }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { if (Page.RouteData.Values["Id"] != null) { WebinarDA objWebinarDA = new WebinarDA(); string URLkey = Page.RouteData.Values["Id"].ToString(); bool isPreview = false; // URLkey.Split(new char[] { '_' }); if (URLkey.IndexOf("_") > 1) { isPreview = true; ArrayList arr = objUtil.StringToArrayList(URLkey, new char[] { '_' }); if (arr.Count > 1) { ArrayList arr1 = objUtil.StringToArrayList(arr[0].ToString(), new char[] { '$' }); layoutCSS.Href = "~/Styles/layout/theme" + arr1[1].ToString() + ".css"; } URLkey = arr[1].ToString(); } int WebinarID = objWebinarDA.getWebinarIDFromURLKey("AUD", URLkey); if (WebinarID != 0) { List<WebinarBE> objWebDetail = objWebinarDA.GetWebinarDetailDA(WebinarID); if (objWebDetail.Count > 0) { lblWebinarTitle.Text = objWebDetail[0].Title; lblWebinarDesc.Text = objWebDetail[0].Description; if (DateTime.Compare(objWebDetail[0].StartDate, DateTime.Now) != -1) { MasterDA objMas = new MasterDA(); List<TimeZoneBE> tmzone = objMas.getTimeZoneName(objWebDetail[0].TimeZoneID); if (tmzone.Count > 0) ltrInstruction.Text = "This presentation will begin on " + objWebDetail[0].StartDate.ToLongDateString() + " at " + Convert.ToDateTime(objWebDetail[0].StartTime).ToString("h:mm tt") + " " + tmzone[0].ShortTimeZoneName + ".<br />" + "<br />Audience members may arrive 15 minutes in advance of this time."; else ltrInstruction.Text = "This presentation will begin on " + objWebDetail[0].StartDate.ToLongDateString() + " at " + Convert.ToDateTime(objWebDetail[0].StartTime).ToString("h:mm tt") + "<br />" + "<br />Audience members may arrive 15 minutes in advance of this time."; } else { ltrInstruction.Text = "This is past event..."; btnLaunch.Visible = false; } plRegPresenter1.WebinarID = WebinarID.ToString(); if (!isPreview) { List<WebinarTheme> objWebTheme = objWebinarDA.getWebinarTheme(WebinarID); if (objWebTheme.Count > 0) layoutCSS.Href = "~/Styles/layout/theme" + objWebTheme[0].ThemeLayoutID.ToString() + ".css"; } List<WebinarResource> objWRes = objWebinarDA.getRegFormResoures(WebinarID); if (objWRes.Count > 0) { plLogos1.WebinarID = WebinarID; if (objWRes[0].ResourceType.ToUpper() == "BANNER") dvTitle.Visible = false; } else dvLogo.Visible = false; } //List<WebinarTheme> objWT = objWebinarDA.getWebinarTheme(WebinarID); //if (objWT.Count > 0) //{ // //lblWebinarTitle.ForeColor = System.Drawing.ColorTranslator.FromHtml(objWT[0].PriThemeColor); // //lblWebinarDesc.ForeColor = System.Drawing.ColorTranslator.FromHtml(objWT[0].SecThemeColor); // plLogos1.LogoID1 = objWT[0].LogoID1; // plLogos1.LogoID2 = objWT[0].LogoID2; // plLogos1.HeaderType = objWT[0].HeaderType; // //Pass values to Presenter user controls //} } } } }
public string getEmailRptHeader(int webinarID) { WebinarDA objWebinarDA = new WebinarDA(); List<WebinarResource> objWRes = objWebinarDA.getRegFormResoures(webinarID); int Rec = objWRes.Count; StringBuilder sb = new StringBuilder("<table width='100%'><tr>"); DocumentDA objDocDA = new DocumentDA(); if (Rec > 0) { if (objWRes[0].ResourceType.ToUpper() == "BANNER") { //sb.Append("<td><img src='" + Common.Constant.BaseURL + "Pages/logo/" + objWRes[0].DocID.ToString() + "'></td>"); sb.Append("<td><img src='" + objDocDA.GetDocumentPath(Convert.ToInt32(objWRes[0].DocID), true, true) + "'></td>"); } else { Rec = (int)(100 / objWRes.Count); for (int idx = 0; idx < objWRes.Count; idx++) { if (idx == objWRes.Count-1) sb.Append("<td valign=middle width='" + Rec.ToString() + "%' align='right'><img src='" + objDocDA.GetDocumentPath(Convert.ToInt32(objWRes[idx].DocID), true, true) + "'></td>"); else { if (idx % 2 != 0 && idx != 0) sb.Append("<td valign=middle width='" + Rec.ToString() + "%' align='center'><img src='" + objDocDA.GetDocumentPath(Convert.ToInt32(objWRes[idx].DocID), true, true) + "'></td>"); else sb.Append("<td valign=middle width='" + Rec.ToString() + "%' ><img src='" + objDocDA.GetDocumentPath(Convert.ToInt32(objWRes[idx].DocID), true, true) + "'></td>"); } } } } sb.Append("</tr></table>"); return sb.ToString(); }
public void UpdatePresenterProfileDoc(int docID, int userID) { try { string sql1 = string.Empty; WebinarDA objDocDA = new WebinarDA(); List<PresenterBE> objP1 = objDocDA.GetPresenterDetail(userID); if (objP1.Count > 0) sql1 = DBQuery.sqlUserPresenterProfileDocUpdate; else sql1 = DBQuery.sqlUserPresenterProfileDocInsert; using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { { using (MySqlCommand sqlCmd = new MySqlCommand(sql1, sqlCon)) { sqlCmd.CommandType = CommandType.Text; sqlCmd.Parameters.Add(new MySqlParameter("@imgDocID", docID)); sqlCmd.Parameters.Add(new MySqlParameter("@userID", userID)); sqlCmd.Connection = sqlCon; sqlCmd.Connection.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Connection.Close(); } } } } catch (Exception ex) { throw ex; } }
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); } }
private void popPresenter() { WebinarDA objWebinarDA = new WebinarDA(); List<PresenterBE> objPresenter = objWebinarDA.GetWebinarPresenterDetail(Convert.ToInt32(hWebinarID.Value), true); //rpPresenterList.DataSource = objPresenter; //rpPresenterList.DataBind(); tgrdPresenterList.DataSource = objPresenter; tgrdPresenterList.DataBind(); }
private void updateHeader(string headerType) { int docID = 0; DocAccess objDocAccess = new DocAccess(); WebinarDA objWebinarDA = new WebinarDA(); switch (headerType) { case "Logo1": docID = objDocAccess.saveFiles(Request, "Logo", Convert.ToInt32(Session["ClientID"]), Convert.ToInt32(Session["UserID"])); objWebinarDA.SaveWebinarTheme("Logo1", docID, Convert.ToInt32(hWebinarID.Value)); break; case "Logo2": docID = objDocAccess.saveFiles(Request, "Logo", Convert.ToInt32(Session["ClientID"]), Convert.ToInt32(Session["UserID"])); objWebinarDA.SaveWebinarTheme("Logo2", docID, Convert.ToInt32(hWebinarID.Value)); break; case "Banner": docID = objDocAccess.saveFiles(Request, "Logo", Convert.ToInt32(Session["ClientID"]), Convert.ToInt32(Session["UserID"])); objWebinarDA.SaveWebinarTheme("BANNER", docID, Convert.ToInt32(hWebinarID.Value)); break; } getThemeDetails(); }
public void GetWebinarEmailSettings() { // Reminder Emails if (hWebinarID.Value != "") { CheckBox chk; RadComboBox rdd1, rdd2; HiddenField hRem; List<RegistrantEmailSettingBO> objRegSetting = new List<RegistrantEmailSettingBO>(); objRegSetting = objEmailDA.GetRegistrantEmailSetting(Convert.ToInt32(hWebinarID.Value), "Reminder Email"); if (objRegSetting.Count > 0) { for (int idx = 1; idx <= objRegSetting.Count; idx++) { chk = (CheckBox)this.FindControl("chkRem" + idx.ToString()); if (chk != null) { chk.Checked = true; hRem = (HiddenField)this.FindControl("hRem" + idx.ToString()); hRem.Value = objRegSetting[idx - 1].setID.ToString(); rdd1 = (RadComboBox)this.FindControl("ddRem" + idx.ToString() + "Value"); rdd1.SelectedValue = objRegSetting[idx - 1].intervalValue.ToString(); rdd2 = (RadComboBox)this.FindControl("ddRem" + idx.ToString() + "Type"); rdd2.SelectedValue = objRegSetting[idx - 1].intervalType.ToString(); } } } //Follow-up Email - Attended objRegSetting = objEmailDA.GetRegistrantEmailSetting(Convert.ToInt32(hWebinarID.Value), "Follow-up Email - Attended"); if (objRegSetting.Count > 0) { chkFollowAttendee.Checked = true; hFollowAttendee.Value = objRegSetting[0].setID.ToString(); ddFollowAttendValue.SelectedValue = objRegSetting[0].intervalValue.ToString(); ddFollowAttendType.SelectedValue = objRegSetting[0].intervalType.ToString(); } //Follow-up Email - Non-Attended objRegSetting = objEmailDA.GetRegistrantEmailSetting(Convert.ToInt32(hWebinarID.Value), "Follow-up Email - Non-Attended"); if (objRegSetting.Count > 0) { chkFollowNonAttendee.Checked = true; hFollowNonAttendee.Value = objRegSetting[0].setID.ToString(); ddFollowNonAttendValue.SelectedValue = objRegSetting[0].intervalValue.ToString(); ddFollowNonAttendType.SelectedValue = objRegSetting[0].intervalType.ToString(); } // Registrant Updates List<RegistrantUpdateBO> objRegUpdate = objEmailDA.GetRegistrantUpdate(Convert.ToInt32(hWebinarID.Value)); if (objRegUpdate.Count > 0) { chkEmailRegularUpdate.Checked = objRegUpdate[0].IsRegularUpdate; chkEmailWhenRegistered.Checked = objRegUpdate[0].IsUpdateWhenRegister; rtEmailRegularTime.SelectedDate = Convert.ToDateTime(objRegUpdate[0].UpdateTime); ddEmailRegularDay.SelectedValue = objRegUpdate[0].UpdateWeekday.ToString(); txtEmailRegularToRedirect.Text = objRegUpdate[0].updateToEmails; } WebinarDA objWebDA = new WebinarDA(); List<WebinarNotification> objWebNotify = objWebDA.getWebinarNotification(Convert.ToInt32(hWebinarID.Value)); if (objWebNotify.Count > 0) { chkSendAll.Checked = objWebNotify[0].isConfirmEmailAllReg; hRegConfirmEmailContentID.Value = objWebNotify[0].RegConfirmEmailContentID.ToString(); hReminderEmailContentID.Value = objWebNotify[0].ReminderEmailContentID.ToString(); hFollowupAEmailContentID.Value = objWebNotify[0].FollowupAEmailContentID.ToString(); hFollowupNAEmailContentID.Value = objWebNotify[0].FollowupNAEmailContentID.ToString(); //Need to take this part to registration page //hInviteContentID.Value = objWebNotify[0].InvitationContentID.ToString(); } //Feature ID 32 - Webinar Invite if (Session["PREMIUM_FEATURE"].ToString().IndexOf(",32,") < 0) { spPre1.Visible = true; chkEmailRegularUpdate.Enabled = false; chkEmailWhenRegistered.Enabled = false; } } }
private void GetLogoBanner() { WebinarDA objWebinarDA = new WebinarDA(); List<WebinarResource> objWRes = objWebinarDA.getRegFormResoures(intWebinarID); int Rec = objWRes.Count; if (Rec > 0) { HtmlTableRow trImageRow = new HtmlTableRow(); if (objWRes[0].ResourceType == "BANNER") { //phBanner.Visible = true; //imgBanner.Src = "~/handler/showImage.ashx?ID=" + objWRes[idx].DocID.ToString(); HtmlTableCell tdImageCell = new HtmlTableCell(); HyperLink imgLogo = new HyperLink(); imgLogo.ID = "id0"; imgLogo.ImageUrl = "~/handler/showImage.ashx?ID=" + objWRes[0].DocID.ToString(); imgLogo.ToolTip = objWRes[0].LogoUrlName.ToString(); imgLogo.NavigateUrl = objWRes[0].LogoUrl.ToString(); imgLogo.Target = "_blank"; tdImageCell.Controls.Add(imgLogo); trImageRow.Cells.Add(tdImageCell); tLogo.Rows.Add(trImageRow); } else { //phLogo.Visible = true; //Rec = (int) Math.Round(100 / objWRes.Count); Rec = (int)(100 / objWRes.Count); for (int idx = 0; idx < objWRes.Count; idx++) { HtmlTableCell tdImageCell = new HtmlTableCell(); HyperLink imgLogo = new HyperLink(); imgLogo.ID = "id" + idx.ToString(); imgLogo.ImageUrl = "~/handler/showImage.ashx?ID=" + objWRes[idx].DocID.ToString(); imgLogo.ToolTip = objWRes[idx].LogoUrlName.ToString(); imgLogo.NavigateUrl = objWRes[idx].LogoUrl.ToString(); imgLogo.Target = "_blank"; tdImageCell.Controls.Add(imgLogo); trImageRow.Cells.Add(tdImageCell); trImageRow.Cells[idx].VAlign = "middle"; trImageRow.Cells[idx].Width = Rec.ToString() + "%"; if (idx == objWRes.Count-1) trImageRow.Cells[idx].Align = "right"; else { if (idx % 2 != 0 && idx != 0) trImageRow.Cells[idx].Align = "center"; else trImageRow.Cells[idx].Align = "left"; } } tLogo.Rows.Add(trImageRow); } } }