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