コード例 #1
0
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            lblError.Text = "";
            if (txtAdvSearch.Text.Trim() == "" && dtpFromDate.SelectedDate.ToString() == "" && dtpToDate.SelectedDate.ToString() == "")
            {
                lblError.Text = "Atleast one criteria need to entered for search";
            }
            else
            {
                EBirdUtility objUtil = new EBirdUtility();
                EBErrorMessages objError = new EBErrorMessages();
                string dt1 = "", dt2 = "";
                string errMsg = "";

                if (dtpFromDate.SelectedDate.ToString() != "")
                    dt1 = objUtil.FormDBDate(Convert.ToDateTime(dtpFromDate.SelectedDate));
                if (dtpToDate.SelectedDate.ToString() != "")
                    dt2 = objUtil.FormDBDate(Convert.ToDateTime(dtpToDate.SelectedDate));

                if (dt1 != "" && dt2 != "")
                {
                    TimeSpan span = (Convert.ToDateTime(dtpToDate.SelectedDate)).Subtract(Convert.ToDateTime(dtpFromDate.SelectedDate));
                    if (span.Days < 0)
                        errMsg = objError.getMessage("SS0002");
                }
                if (errMsg != "")
                    lblError.Text = errMsg;
                else
                {
                    Session["ADV_SEARCH"] = txtAdvSearch.Text.Trim() + ";" + optSearchOption.SelectedValue + ";" + dtpFromDate.SelectedDate.ToString() + ";" + dtpToDate.SelectedDate.ToString();
                    hModalStatusFlg.Value = "1";
                }
            }
        }
コード例 #2
0
        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);
            }
        }
コード例 #3
0
ファイル: WebinarDA.cs プロジェクト: selva-osai/scheduler
        public List<WebinarBE> GetMyWebinarListDA(int userID, string fromDate, string toDate, string searchString, string searchField, int Registered, int LiveViewed, int OnDemandViewed)
        {
            EBirdUtility objUtil = new EBirdUtility();

            string sql1 = DBQuery.sqlGetMyWebinar;

            if (searchString != "")
            {
                if (searchField == "Title")
                    sql1 += " and webinarTitle like '%" + searchString + "%'";
                else if (searchField == "Description")
                    sql1 += " and Description like '%" + searchString + "%'";
                else
                    sql1 += " and (webinarTitle like '%" + searchString + "%' or Description like '%" + searchString + "%')";
            }

            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 + "'";

            sql1 += " and registered >= " + Registered.ToString() + " and live >= " + LiveViewed.ToString() + " and onDemand >= " + OnDemandViewed;

            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
                                {
                                    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 ? -1 : Convert.ToInt32(reader["registered"]),
                                    Live = reader["live"] == DBNull.Value ? -1 : Convert.ToInt32(reader["live"]),
                                    OnDemand = reader["OnDemand"] == DBNull.Value ? -1 : 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;
        }
コード例 #4
0
ファイル: WebinarDA.cs プロジェクト: selva-osai/scheduler
        // 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;
        }
コード例 #5
0
ファイル: WebinarDA.cs プロジェクト: selva-osai/scheduler
        public void UpdateRegFormLogoOrder(int webinarID, ArrayList arrLogos)
        {
            try
            {
                string sql1 = DBQuery.sqlWebinarResourceLogoOrderUpdate;

                using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
                {
                    MySqlCommand sqlCmd = new MySqlCommand(sql1, sqlCon);
                    sqlCon.Open();
                    sqlCmd.CommandType = CommandType.Text;

                    EBirdUtility objUtil = new EBirdUtility();

                    for (int idx = 0; idx < arrLogos.Count; idx++)
                    {
                        if (objUtil.IsNumeric(arrLogos[idx]))
                        {
                            sqlCmd.Parameters.Clear();
                            sqlCmd.Parameters.Add(new MySqlParameter("@resourceOrder", idx + 1));
                            sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", webinarID));
                            sqlCmd.Parameters.Add(new MySqlParameter("@docID", arrLogos[idx].ToString()));
                            sqlCmd.ExecuteNonQuery();
                        }
                    }
                    sqlCon.Close();
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }
コード例 #6
0
ファイル: WebinarDA.cs プロジェクト: selva-osai/scheduler
        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;
            }
        }
コード例 #7
0
ファイル: EmailDA.cs プロジェクト: selva-osai/scheduler
        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;
        }
コード例 #8
0
ファイル: webEmail.ascx.cs プロジェクト: selva-osai/scheduler
 public string SaveWebEmail()
 {
     RegistrantEmailSettingBO objEmailSetting = new RegistrantEmailSettingBO();
     // Reminder Email
     if (chkRem1.Checked)
     {
         objEmailSetting.intervalType = "M"; //ddRem1Type.SelectedValue;
         objEmailSetting.intervalValue = Convert.ToInt16(ddRem1Value.SelectedValue);
         objEmailSetting.EmailScheduleStatus = "Draft";
         objEmailSetting.SettingType = "Reminder Email";
         objEmailSetting.setID = Convert.ToInt32(hRem1.Value);
         objEmailSetting.webinarID = Convert.ToInt32(hWebinarID.Value);
         objEmailDA.SaveRegistrantEmailSetting(objEmailSetting);
     }
     if (chkRem2.Checked)
     {
         objEmailSetting.intervalType = ddRem2Type.SelectedValue;
         objEmailSetting.intervalValue = Convert.ToInt16(ddRem2Value.SelectedValue);
         objEmailSetting.EmailScheduleStatus = "Draft";
         objEmailSetting.SettingType = "Reminder Email";
         objEmailSetting.setID = Convert.ToInt32(hRem2.Value);
         objEmailSetting.webinarID = Convert.ToInt32(hWebinarID.Value);
         objEmailDA.SaveRegistrantEmailSetting(objEmailSetting);
     }
     if (chkRem3.Checked)
     {
         objEmailSetting.intervalType = ddRem3Type.SelectedValue;
         objEmailSetting.intervalValue = Convert.ToInt16(ddRem3Value.SelectedValue);
         objEmailSetting.EmailScheduleStatus = "Draft";
         objEmailSetting.SettingType = "Reminder Email";
         objEmailSetting.setID = Convert.ToInt32(hRem3.Value);
         objEmailSetting.webinarID = Convert.ToInt32(hWebinarID.Value);
         objEmailDA.SaveRegistrantEmailSetting(objEmailSetting);
     }
     if (chkRem4.Checked)
     {
         objEmailSetting.intervalType = ddRem4Type.SelectedValue;
         objEmailSetting.intervalValue = Convert.ToInt16(ddRem4Value.SelectedValue);
         objEmailSetting.EmailScheduleStatus = "Draft";
         objEmailSetting.SettingType = "Reminder Email";
         objEmailSetting.setID = Convert.ToInt32(hRem4.Value);
         objEmailSetting.webinarID = Convert.ToInt32(hWebinarID.Value);
         objEmailDA.SaveRegistrantEmailSetting(objEmailSetting);
     }
     if (chkRem5.Checked)
     {
         objEmailSetting.intervalType = ddRem5Type.SelectedValue;
         objEmailSetting.intervalValue = Convert.ToInt16(ddRem5Value.SelectedValue);
         objEmailSetting.EmailScheduleStatus = "Draft";
         objEmailSetting.SettingType = "Reminder Email";
         objEmailSetting.setID = Convert.ToInt32(hRem5.Value);
         objEmailSetting.webinarID = Convert.ToInt32(hWebinarID.Value);
         objEmailDA.SaveRegistrantEmailSetting(objEmailSetting);
     }
     // Follow-up Email - attend
     if (chkFollowAttendee.Checked)
     {
         objEmailSetting.intervalType = ddFollowAttendType.SelectedValue;
         objEmailSetting.intervalValue = Convert.ToInt16(ddFollowAttendValue.SelectedValue);
         objEmailSetting.EmailScheduleStatus = "Draft";
         objEmailSetting.SettingType = "Follow-up Email - Attended";
         objEmailSetting.setID = Convert.ToInt32(hFollowAttendee.Value);
         objEmailSetting.webinarID = Convert.ToInt32(hWebinarID.Value);
         objEmailDA.SaveRegistrantEmailSetting(objEmailSetting);
     }
     // Follow-up Email - unattended
     if (chkFollowNonAttendee.Checked)
     {
         objEmailSetting.intervalType = ddFollowNonAttendType.SelectedValue;
         objEmailSetting.intervalValue = Convert.ToInt16(ddFollowNonAttendValue.SelectedValue);
         objEmailSetting.EmailScheduleStatus = "Draft";
         objEmailSetting.SettingType = "Follow-up Email - Unattended";
         objEmailSetting.setID = Convert.ToInt32(hFollowNonAttendee.Value);
         objEmailSetting.webinarID = Convert.ToInt32(hWebinarID.Value);
         objEmailDA.SaveRegistrantEmailSetting(objEmailSetting);
     }
     // Registrant Updates
     string rtnVal = string.Empty;
     if (chkEmailRegularUpdate.Checked || chkEmailWhenRegistered.Checked)
     {
         if (txtEmailRegularToRedirect.Text.Trim() == "")
             rtnVal = "Email addressing to notify the registration";
         else
         {
             EBirdUtility objUtil = new EBirdUtility();
             rtnVal = objUtil.getInvalidEmails(txtEmailRegularToRedirect.Text.Trim(), new char[] { ';' });
         }
     }
     if (rtnVal != string.Empty)
     {
         RegistrantUpdateBO objRegistrantUpdateBO = new RegistrantUpdateBO();
         objRegistrantUpdateBO.WebinarID = Convert.ToInt32(hWebinarID.Value);
         objRegistrantUpdateBO.IsRegularUpdate = chkEmailRegularUpdate.Checked;
         objRegistrantUpdateBO.IsUpdateWhenRegister = chkEmailWhenRegistered.Checked;
         objRegistrantUpdateBO.UpdateTime = Convert.ToDateTime(rtEmailRegularTime.SelectedDate).ToString("HH:mm", CultureInfo.CurrentCulture);
         objRegistrantUpdateBO.updateToEmails = txtEmailRegularToRedirect.Text;
         objRegistrantUpdateBO.UpdateWeekday = Convert.ToInt32(ddEmailRegularDay.SelectedValue);
         objEmailDA.SaveRegistrantUpdate(objRegistrantUpdateBO);
     }
     return rtnVal;
 }