protected void btnPublish_Click(object sender, EventArgs e)
{
HiddenField hFld;
CheckBox chk1;
string pubList = string.Empty;
string unpubList = string.Empty;
SnapSiteBO objSS = new SnapSiteBO();
objSS.HeaderType = rcmbHeader.SelectedValue;
objSS.Title = txtSSTitle.Text;
objSS.Description = redtDesc.Content;
objSS.SkinID = Convert.ToInt32(hSelThemeID.Value);
objSS.IsEnabled = !chkDisableSS.Checked;
objSS.IsFacebook = chkFB.Checked;
objSS.IsTwitter = chkTwit.Checked;
objSS.IsLinkedIn = chkLIn.Checked;
objSS.UserID = Convert.ToInt32(Session["UserID"]);
objSnapSiteDA.SaveSnapSiteSetting(objSS);
foreach (GridDataItem item in tgrdWebinarList.Items)
{
hFld = (HiddenField)item.FindControl("hWebinarID");
chk1 = (CheckBox)item.FindControl("chkPublish");
if (chk1.Checked)
pubList = pubList + hFld.Value + ",";
else
unpubList = unpubList + hFld.Value + ",";
}
objSnapSiteDA.PublishWebinarToSnapSite(pubList + "0", unpubList + "0");
popPublishWebinars();
getThemeLayouts();
lblError.Text = "Saved successfully";
}
public void SaveSnapSiteSetting(SnapSiteBO objSS)
{
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand("spUpdateSnapSiteSettings", sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pUserID", objSS.UserID));
sqlCmd.Parameters.Add(new MySqlParameter("pTitle", objSS.Title));
sqlCmd.Parameters.Add(new MySqlParameter("pDescription", objSS.Description));
sqlCmd.Parameters.Add(new MySqlParameter("pHeaderType", objSS.HeaderType));
sqlCmd.Parameters.Add(new MySqlParameter("pSkinID", objSS.SkinID));
sqlCmd.Parameters.Add(new MySqlParameter("pIsFaceBook", objSS.IsFacebook));
sqlCmd.Parameters.Add(new MySqlParameter("pIsTwitter", objSS.IsTwitter));
sqlCmd.Parameters.Add(new MySqlParameter("pIsLinkedIn", objSS.IsLinkedIn));
sqlCmd.Parameters.Add(new MySqlParameter("pIsEnabled", objSS.IsEnabled));
sqlCmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw;
}
}
