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);
}
}
}