public void SaveWebinarRegistration(WebinarRegistration objWebReg) { try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlWebinarRegUpdate, sqlCon); sqlCon.Open(); sqlCmd.CommandType = CommandType.Text; sqlCmd.Parameters.Add(new MySqlParameter("@isVideoFile", objWebReg.isVideoFile)); sqlCmd.Parameters.Add(new MySqlParameter("@isAddWebinar", objWebReg.isAdditionalWebinar)); sqlCmd.Parameters.Add(new MySqlParameter("@ConnectedAPIEmails", objWebReg.APIEmails)); sqlCmd.Parameters.Add(new MySqlParameter("@inclLogoBanner", objWebReg.IncludeLogoBanner)); sqlCmd.Parameters.Add(new MySqlParameter("@inclSummary", objWebReg.IncludeSummary)); sqlCmd.Parameters.Add(new MySqlParameter("@inclSpeakerBio", objWebReg.IncludeSpeakerBio)); sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", objWebReg.WebinarID)); sqlCmd.Parameters.Add(new MySqlParameter("@campTrackerEmail", objWebReg.CampaignTrackerEmails)); sqlCmd.ExecuteNonQuery(); sqlCon.Close(); } } catch (Exception ex) { throw; } }
public void SaveWebinarRegistrationDefault(WebinarRegistration objWebReg) { try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlWebinarRegDefaultInsert, sqlCon); sqlCon.Open(); sqlCmd.CommandType = CommandType.Text; sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", objWebReg.WebinarID)); sqlCmd.Parameters.Add(new MySqlParameter("@isRegEnabled", objWebReg.isRegistrationEnabled)); sqlCmd.Parameters.Add(new MySqlParameter("@isVideoFile", objWebReg.isVideoFile)); sqlCmd.Parameters.Add(new MySqlParameter("@isAddPresenter", objWebReg.isAdditionalPresenter)); sqlCmd.Parameters.Add(new MySqlParameter("@isAddWebinar", objWebReg.isAdditionalWebinar)); sqlCmd.Parameters.Add(new MySqlParameter("@ConnectedAPIEmails", objWebReg.APIEmails)); sqlCmd.Parameters.Add(new MySqlParameter("@includeLogoBanner", objWebReg.IncludeLogoBanner)); sqlCmd.Parameters.Add(new MySqlParameter("@includeSummary", objWebReg.IncludeSummary)); sqlCmd.Parameters.Add(new MySqlParameter("@includeSpeakerBio", objWebReg.IncludeSpeakerBio)); sqlCmd.ExecuteNonQuery(); ////Insert Registration form defaults sqlCmd = new MySqlCommand(DBQuery.sqlWebinarRegDefaultFormFieldsInsert, sqlCon); sqlCmd.CommandType = CommandType.Text; sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", objWebReg.WebinarID)); sqlCmd.ExecuteNonQuery(); sqlCon.Close(); } } catch (Exception ex) { throw; } }
public string saveRegistrationInfo() { string strError = string.Empty; if (chkAPI.Checked && !objUtil.isEmail(txtAPIReg.Text.Trim())) strError = "Registration API instructions email is missing or invalid<br>"; if (chkCamp.Checked && !objUtil.isEmail(txtEmailCampaign.Text.Trim())) strError = strError + "Webinar Campaign Tracking email is missing or invalid"; if (strError == string.Empty) { foreach (RepeaterItem iter in rpLogo.Items) { if (iter.ItemType == ListItemType.Item || iter.ItemType == ListItemType.AlternatingItem) { Image sImg = ((Image)iter.FindControl("imgLogo")); string sVal = sImg.Attributes["Name"]; //((Image)iter.FindControl("imgLogo")).ImageUrl; string hDocID = ((HiddenField)iter.FindControl("hDocID")).Value.ToString(); } } #region registration info - tblwebinarregistration WebinarRegistration objWebReg = new WebinarRegistration(); objWebReg.WebinarID = Convert.ToInt32(hWebinarID.Value); //objWebReg.isRegistrationEnabled = chkEnableReg.Checked; //objWebReg.isAdditionalPresenter = chkAddPresenter.Checked; objWebReg.isVideoFile = false; objWebReg.isAdditionalWebinar = false; objWebReg.APIEmails = txtAPIReg.Text.Trim(); objWebReg.IncludeLogoBanner = true; //chkIncLogo.Checked; objWebReg.IncludeSummary = chkIncSummary.Checked; objWebReg.IncludeSpeakerBio = chkIncSpeakerBio.Checked; objWebReg.CampaignTrackerEmails = txtEmailCampaign.Text.Trim(); objWebinarDA.SaveWebinarRegistration(objWebReg); if (chkCamp.Checked && txtEmailCampaign.Text.Trim() != "") { boolCampTrackerEmail = true; } if (chkAPI.Checked && txtAPIReg.Text.Trim() != "") boolConnectRegistration = true; #endregion #region registration form List<WebinarRegFormFields> objWebinarRegFormFields = new List<WebinarRegFormFields>(); CheckBox chk; CheckBox chk1; TextBox txt1; int webID = Convert.ToInt32(hWebinarID.Value); for (int idx = 1; idx < 19; idx++) { if (this.FindControl("chkInc" + idx.ToString()) != null && this.FindControl("txtFld" + idx.ToString()) != null) { chk = (CheckBox)this.FindControl("chkInc" + idx.ToString()); chk1 = (CheckBox)this.FindControl("chkReq" + idx.ToString()); txt1 = (TextBox)this.FindControl("txtFld" + idx.ToString()); if (chk.Checked && txt1.Text.Trim() != "") { objWebinarRegFormFields.Add(new WebinarRegFormFields { webinarID = webID, FieldID = idx, FieldLabel = txt1.Text, isRequired = chk1.Checked }); } } } objWebinarDA.UpdateRegFormFields(objWebinarRegFormFields); #endregion #region theme, header type saveWebTheme(); popLogo(); #endregion #region domain blocking saveWebinarDomain(); #endregion regTabLoad(); } return strError; }