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