protected void btnSave_Click(object sender, EventArgs e) { int MsgCount = 0; int intValue = 0; if (txtMsgCount.Text.Trim() != "") MsgCount = Convert.ToInt32(txtMsgCount.Text); if (txtMinUpdates.Text.Trim() != "") intValue = Convert.ToInt32(txtMinUpdates.Text); FaceBookSettingBO objFB = new FaceBookSettingBO(); objFB.isStatusUpdate = chkStatusUpdate.Checked; objFB.defaultStatusMessage = txtDefaultStatus.Text; objFB.isLikeUnlike = chkLike.Checked; objFB.isComments = chkComments.Checked; objFB.isFriend = chkFriends.Checked; objFB.isSearch = chkSearch.Checked; objFB.messageReturn = MsgCount; objFB.checkInterval = intValue; objFB.WebinarID = Convert.ToInt32(hWebinarID.Value); if (Request["flg"].ToString() == "1") objSocialMediaDA.SaveFaceBookSettingDA(objFB, false); else objSocialMediaDA.SaveFaceBookSettingDA(objFB, true); //objWebinarDA.SaveWebinarAudience(Convert.ToInt32(hWebinarID.Value), "FaceBook", (Convert.ToInt32(ClientConfigMaster.Audi_Component_Facebook)).ToString()); //if (!ClientScript.IsStartupScriptRegistered("alert")) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "CloseAndReload();", true); } Session["Web_Tab"] = "3"; hModalStatusFlg.Value = "1"; }
public void SaveFaceBookSettingDA(FaceBookSettingBO objFaceBookSettingBO, bool isCancel) { //string sql1; //List<FaceBookSettingBO> objFBSettingBO = GetFaceBookSettingDA(objFaceBookSettingBO.WebinarID); //if (objFBSettingBO.Count > 0) // sql1 = SocialMediaQuery.sqlFBSettingUpdate; //else // sql1 = SocialMediaQuery.sqlFBSettingInsert; try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { MySqlCommand sqlCmd = new MySqlCommand("spUpdateFaceBookSettings", sqlCon); sqlCon.Open(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add(new MySqlParameter("pIsStatusUpdate", objFaceBookSettingBO.isStatusUpdate)); sqlCmd.Parameters.Add(new MySqlParameter("pDefaultStatusMessage", objFaceBookSettingBO.defaultStatusMessage)); sqlCmd.Parameters.Add(new MySqlParameter("pIsLikeUnlike", objFaceBookSettingBO.isLikeUnlike)); sqlCmd.Parameters.Add(new MySqlParameter("pIsComments", objFaceBookSettingBO.isComments)); sqlCmd.Parameters.Add(new MySqlParameter("pIsFriend", objFaceBookSettingBO.isFriend)); sqlCmd.Parameters.Add(new MySqlParameter("pIsSearch", objFaceBookSettingBO.isSearch)); sqlCmd.Parameters.Add(new MySqlParameter("pCheckInterval", objFaceBookSettingBO.checkInterval)); sqlCmd.Parameters.Add(new MySqlParameter("pMessageReturn", objFaceBookSettingBO.messageReturn)); sqlCmd.Parameters.Add(new MySqlParameter("pWebinarID", objFaceBookSettingBO.WebinarID)); sqlCmd.Parameters.Add(new MySqlParameter("pIsCancel", isCancel)); sqlCmd.ExecuteNonQuery(); } } catch (Exception ex) { throw; } }