protected void btnSave_Click(object sender, EventArgs e)
{
TwitterSettingBO objTW = new TwitterSettingBO();
objTW.dispFromAcct = rcmbAcct.SelectedValue;
objTW.headerTitle = txtHeaderTitle.Text;
objTW.tweetHashtags = txtHashTag.Text;
objTW.dispFromAcct = txtDisplayAcct.Text;
objTW.filterKeywords = txtDisplayKeywords.Text;
objTW.isUserTweet = chkUserTweet.Checked;
objTW.userHashtags = txtEndUseHashtag.Text;
objTW.userTextURL = txtEndUseURL.Text;
objTW.WebinarID = Convert.ToInt32(hWebinarID.Value);
if (Request["flg"].ToString() == "1")
objSocialMediaDA.SaveTwitterSettingDA(objTW, false);
else
objSocialMediaDA.SaveTwitterSettingDA(objTW, true);
//objWebinarDA.SaveWebinarAudience(Convert.ToInt32(hWebinarID.Value), "Twitter", (Convert.ToInt32(ClientConfigMaster.Audi_Component_Twitter)).ToString());
// if (!ClientScript.IsStartupScriptRegistered("alert")) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "CloseAndReload();", true); }
//}
//else
//{
// objWebinarDA.SaveWebinarAudience(Convert.ToInt32(hWebinarID.Value), "Twitter", "0");
// // if (!ClientScript.IsStartupScriptRegistered("alert")) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "CloseAndReload();", true); }
//}
Session["Web_Tab"] = "3";
hModalStatusFlg.Value = "1";
}
public void SaveTwitterSettingDA(TwitterSettingBO objTwitterSettingBO, bool isCancel)
{
//string sql1;
//List<TwitterSettingBO> objTWSettingBO = GetTwitterSettingDA(objTwitterSettingBO.WebinarID);
//if (objTWSettingBO.Count > 0)
// sql1 = SocialMediaQuery.sqlTWSettingUpdate;
//else
// sql1 = SocialMediaQuery.sqlTWSettingInsert;
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand("spUpdateTwitterSettings", sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pTwitterAcct", objTwitterSettingBO.twitterAcct));
sqlCmd.Parameters.Add(new MySqlParameter("pHeaderTitle", objTwitterSettingBO.headerTitle));
sqlCmd.Parameters.Add(new MySqlParameter("pTweetHashtags", objTwitterSettingBO.tweetHashtags));
sqlCmd.Parameters.Add(new MySqlParameter("pDispFromAcct", objTwitterSettingBO.dispFromAcct));
sqlCmd.Parameters.Add(new MySqlParameter("pFilterKeywords", objTwitterSettingBO.filterKeywords));
sqlCmd.Parameters.Add(new MySqlParameter("pIsUserTweet", objTwitterSettingBO.isUserTweet));
sqlCmd.Parameters.Add(new MySqlParameter("pUserHashtags", objTwitterSettingBO.userHashtags));
sqlCmd.Parameters.Add(new MySqlParameter("pUserTextURL", objTwitterSettingBO.userTextURL));
sqlCmd.Parameters.Add(new MySqlParameter("pWebinarID", objTwitterSettingBO.WebinarID));
sqlCmd.Parameters.Add(new MySqlParameter("pIsCancel", isCancel));
sqlCmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw;
}
}