protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { if (Page.RouteData.Values["Id"] != null) { EBirdUtility objUtil = new EBirdUtility(); setPlaceHolder(true); string URLkey = Page.RouteData.Values["Id"].ToString(); bool isPreview = false; URLkey.Split(new char[] { '_' }); if (URLkey.IndexOf("_") > 1) { Response.Redirect("/Regpreview/" + URLkey); Response.End(); isPreview = true; if (isPreview == true) { btnRefCol1.Visible = false; Predummy3.Visible = true; } else { btnRefCol1.Visible = true; Predummy3.Visible = false; } 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"; if (arr1[0].ToString().Substring(0, 1) == "1") dvSummary.Visible = true; else dvSummary.Visible = false; if (arr1[0].ToString().Substring(1, 1) == "1") dvSpeaker.Visible = true; else dvSpeaker.Visible = false; } URLkey = arr[1].ToString(); } int WebinarID = objWebinarDA.getWebinarIDFromURLKey("REg", URLkey); hWebinarID.Value = WebinarID.ToString(); if (WebinarID != 0) { #region getting the pagelet setting List<WebinarRegistration> objWebReg = objWebinarDA.getWebinarRegistration(WebinarID); if (objWebReg.Count > 0) { if (!isPreview) { dvLogo.Visible = objWebReg[0].IncludeLogoBanner; dvSpeaker.Visible = objWebReg[0].IncludeSpeakerBio; dvSummary.Visible = objWebReg[0].IncludeSummary; } if (!dvSpeaker.Visible && !dvSummary.Visible) { phAll.Visible = false; phOpt1.Visible = true; //layoutCSS.Href = "~/Styles/layout1/layout2.css"; plPreEmail2.setSingleColumnAttributes(); dvPre.Attributes.Remove("class"); dvPre.Attributes.Add("class", "Regi-Top-Sec1N"); } // Check registration status if (objWebReg[0].isRegistrationEnabled) { plRegForm1.Visible = true; plRegForm2.Visible = true; lblRegStatus.Visible = false; } else { plRegForm1.Visible = false; plRegForm2.Visible = false; lblRegStatus.Visible = true; } } #endregion if (!isPreview) { List<WebinarTheme> objWebTheme = objWebinarDA.getWebinarTheme(WebinarID); if (objWebTheme.Count > 0) { layoutCSS.Href = "~/Styles/layout/theme" + objWebTheme[0].ThemeLayoutID.ToString() + ".css"; } } string eventTime = ""; List<WebinarBE> objWebDetail = objWebinarDA.GetWebinarDetailDA(WebinarID); if (objWebDetail.Count > 0) { List<WebinarResource> objWRes = objWebinarDA.getRegFormResoures(WebinarID); if (objWRes.Count > 0) { if (objWRes[0].ResourceType.ToUpper() == "BANNER") dvTitle.Visible = false; } else dvLogo.Visible = false; lblWebinarTitle.Text = objWebDetail[0].Title; if (dvSummary.Visible && objWebDetail[0].Description.Trim() != "") lblWebinarDesc.Text = objWebDetail[0].Description; else dvSummary.Visible = false; //Pass values to DateTime user controls MasterDA objMas = new MasterDA(); List<TimeZoneBE> tmzone = objMas.getTimeZoneName(objWebDetail[0].TimeZoneID); if (tmzone.Count > 0) eventTime = objWebDetail[0].StartDate.ToLongDateString() + "<br>" + Convert.ToDateTime(objWebDetail[0].StartTime).ToString("h:mm tt") + " - " + Convert.ToDateTime(objWebDetail[0].EndTime).ToString("h:mm tt") + "<br>" + tmzone[0].ShortTimeZoneName; else eventTime = objWebDetail[0].StartDate.ToLongDateString() + "<br>" + Convert.ToDateTime(objWebDetail[0].StartTime).ToLongTimeString(); if (phOpt1.Visible) plDateTime2.WebinarDateTime = eventTime; else plDateTime1.WebinarDateTime = eventTime; } //Pass values to Logo user control if (dvLogo.Visible) plLogos1.WebinarID = WebinarID; //Pass values to registration form user controls if (phOpt1.Visible) { plRegForm2.WebinarID = WebinarID.ToString(); plRegForm2.isPreview = (isPreview ? "1" : "0"); } else { plRegForm1.WebinarID = WebinarID.ToString(); //plRegForm1.isPreview = isPreview; plRegForm1.isPreview = (isPreview ? "1" : "0"); } //Pass values to Presenter user controls if (dvSpeaker.Visible) plRegPresenter1.WebinarID = WebinarID.ToString(); //pass values to pre-registered user controls plPreEmail1.WebinarID = WebinarID.ToString(); plPreEmail1.isPreview = (isPreview ? "1" : "0"); } else setPlaceHolder(false); } else setPlaceHolder(false); } }
public void SaveWebinarDomains(int webinarID, string webinarHost) { //if (!IsWebinarHostExistDA(webinarID, webinarHost)) //{ // try // { // using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) // { // MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlWebinarHostsInsert, sqlCon); // sqlCon.Open(); // sqlCmd.CommandType = CommandType.Text; // sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", webinarID)); // sqlCmd.Parameters.Add(new MySqlParameter("@domainURL", webinarHost)); // sqlCmd.ExecuteNonQuery(); // } // } // catch (Exception ex) // { // throw; // } //} try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { MySqlCommand sqlCmd = new MySqlCommand("Delete from tblwebinarhost where domainURL not in (" + webinarHost + ") and webinarID = " + webinarID, sqlCon); sqlCon.Open(); sqlCmd.CommandType = CommandType.Text; sqlCmd.ExecuteNonQuery(); if (webinarHost != "") { EBirdUtility objUtil = new EBirdUtility(); ArrayList arr1 = objUtil.StringToArrayList(webinarHost, new char[] { ',' }); sqlCmd = new MySqlCommand("spUpdateWebinarDomains", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; for (int idx = 0; idx < arr1.Count; idx++) { if (arr1[idx].ToString().Trim() != "") { sqlCmd.Parameters.Clear(); sqlCmd.Parameters.Add(new MySqlParameter("pWebinarID", webinarID)); sqlCmd.Parameters.Add(new MySqlParameter("pDomainURL", arr1[idx].ToString().Replace("'", ""))); sqlCmd.ExecuteNonQuery(); } } } } } catch (Exception ex) { throw; } }
// 2/19/2013 - renamed the method to get my webinar for adv search // sqlGetMyCompanyWebinar -> sqlGetMyWebinar, clientID -> userID public List<WebinarBE> GetMyWebinarAdvSearchListDA(int userID, string fromDate, string toDate, string webinarTitle, string advFilter) { EBirdUtility objUtil = new EBirdUtility(); bool isAdvFilter = false; string advTitle = string.Empty; string advFieldSearch = string.Empty; string advStDate = string.Empty; string advEnDate = string.Empty; string sql2 = string.Empty; if (advFilter.Trim() != "") { ArrayList arr1 = objUtil.StringToArrayList(advFilter, new char[] { ';' }); if (arr1.Count == 4) { isAdvFilter = true; advTitle = arr1[0].ToString(); advFieldSearch = arr1[1].ToString(); advStDate = arr1[2].ToString(); advEnDate = arr1[3].ToString(); if (advTitle != "") { switch (advFieldSearch.ToUpper()) { case "TITLE": sql2 += "webinarTitle like '%" + advTitle + "%'"; break; case "DESCRIPTION": sql2 += "description like '%" + advTitle + "%'"; break; case "ALL": sql2 += "webinarTitle like '%" + advTitle + "%' or description like '%" + advTitle + "%'"; break; } } if (advStDate != "" && fromDate != "") { advStDate = objUtil.FormDBDate(Convert.ToDateTime(advStDate)); TimeSpan span = (Convert.ToDateTime(fromDate)).Subtract(Convert.ToDateTime(advStDate)); if (span.Days < 0) { fromDate = advStDate; } } if (advEnDate != "" && toDate != "") { advEnDate = objUtil.FormDBDate(Convert.ToDateTime(advEnDate)); TimeSpan span1 = (Convert.ToDateTime(advEnDate)).Subtract(Convert.ToDateTime(toDate)); if (span1.Days < 0) { toDate = advEnDate; } } } } string sql1 = DBQuery.sqlGetMyWebinar; if (webinarTitle != "") sql1 += " and webinarTitle like '%" + webinarTitle + "%'"; if (fromDate != "" && toDate != "") sql1 += " and startDate BETWEEN '" + fromDate + "' AND '" + toDate + "'"; else if (fromDate == "" && toDate != "") sql1 += " and createdOn <= '" + toDate + "'"; else if (toDate == "" && fromDate != "") sql1 += " and startDate >= '" + fromDate + "'"; if (sql2 != string.Empty) { sql1 += " and (" + sql2 + ")"; } List<WebinarBE> objWebinarBE = new List<WebinarBE>(); try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { using (MySqlCommand sqlCmd = new MySqlCommand(sql1, sqlCon)) { sqlCon.Open(); sqlCmd.CommandType = CommandType.Text; sqlCmd.Parameters.Add(new MySqlParameter("@createdBy", userID)); MySqlDataReader reader = sqlCmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { objWebinarBE.Add(new WebinarBE { //ClientID = clientID, WebinarID = reader["WebinarID"] == DBNull.Value ? -1 : Convert.ToInt32(reader["WebinarID"]), Title = reader["webinartitle"] == DBNull.Value ? string.Empty : Convert.ToString(reader["webinartitle"]), Description = reader["description"] == DBNull.Value ? string.Empty : Convert.ToString(reader["description"]), StartDate = reader["startdate"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(reader["startdate"]), StartTime = reader["starttime"] == DBNull.Value ? string.Empty : reader["starttime"].ToString(), EndTime = reader["endTime"] == DBNull.Value ? string.Empty : reader["endTime"].ToString(), TimeZoneID = reader["TimeZoneID"] == DBNull.Value ? -1 : Convert.ToInt32(reader["TimeZoneID"]), isRecurrence = reader["recurrence"] == DBNull.Value ? false : Convert.ToBoolean(reader["recurrence"]), Registered = reader["registered"] == DBNull.Value ? 0 : Convert.ToInt32(reader["registered"]), Live = reader["live"] == DBNull.Value ? 0 : Convert.ToInt32(reader["live"]), OnDemand = reader["OnDemand"] == DBNull.Value ? 0 : Convert.ToInt32(reader["OnDemand"]), Createdby = reader["Createdby"] == DBNull.Value ? -1 : Convert.ToInt32(reader["Createdby"]), CreatedOn = reader["CreatedOn"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(reader["CreatedOn"]), ModifiedOn = reader["ModifiedOn"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(reader["ModifiedOn"]), Modifiedby = reader["Modifiedby"] == DBNull.Value ? -1 : Convert.ToInt32(reader["Modifiedby"]), WebinarStatus = reader["webinarStatus"] == DBNull.Value ? string.Empty : Convert.ToString(reader["webinarStatus"]) }); } } reader.Close(); reader = null; } sqlCon.Close(); } } catch (Exception ex) { throw; } return objWebinarBE; }
public List<EmailBE> GetRequest(int requestID) { string strToEmail = ""; List<EmailBE> objEmailBE = new List<EmailBE>(); try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { using (MySqlCommand sqlCmd = new MySqlCommand("select * from tblemailingrequest where emailRequestID=" + requestID.ToString(), sqlCon)) { sqlCon.Open(); sqlCmd.CommandType = CommandType.Text; MySqlDataReader reader = sqlCmd.ExecuteReader(); if (reader.HasRows) { List<EmailTo> objEmailTo = new List<EmailTo>(); while (reader.Read()) { strToEmail = ""; objEmailTo.Clear(); if (Convert.ToBoolean(reader["isToEmailRef"])) objEmailTo = GetToEmails(Convert.ToInt32(reader["emailRequestID"])); else { strToEmail = reader["ToEmail"] == DBNull.Value ? string.Empty : Convert.ToString(reader["ToEmail"]); if (strToEmail != string.Empty) { EBirdUtility objutil = new EBirdUtility(); System.Collections.ArrayList arr = objutil.StringToArrayList(strToEmail, new char[] { ';' }); for (int idx = 0; idx < arr.Count; idx++) { objEmailTo.Add(new EmailTo { ToEmails = arr[idx].ToString() }); } } } if (objEmailTo.Count == 0) { UpdateRequestStatus(Convert.ToInt32(reader["emailRequestID"]), "Cancelled", "Missing To email(s)"); } else { objEmailBE.Add(new EmailBE { RequestType = reader["mailType"] == DBNull.Value ? string.Empty : Convert.ToString(reader["mailType"]), RequestID = reader["emailRequestID"] == DBNull.Value ? -1 : Convert.ToInt32(reader["emailRequestID"]), FromEmail = reader["fromEmail"] == DBNull.Value ? string.Empty : Convert.ToString(reader["fromEmail"]), ToEmailList = objEmailTo, Subject = reader["subject"] == DBNull.Value ? string.Empty : Convert.ToString(reader["subject"]), EmailContent = reader["emailContent"] == DBNull.Value ? string.Empty : reader["emailContent"].ToString() }); } } } reader.Close(); reader = null; } sqlCon.Close(); } } catch (Exception ex) { throw; } return objEmailBE; }