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