protected void lnkbtnPromoteToPhase3_Click(object sender, EventArgs e)
{
if (Request.QueryString["threadId"] != null)
{
int threadId = Convert.ToInt32(Request.QueryString["threadId"].ToString());
using (var sqlConn = new SqlConnection(CONNECTION_STRING))
{
sqlConn.Open();
string sql = "UPDATE Ourspace_Forum_Thread_Info SET phaseId = 3 WHERE ThreadId = @ThreadId";
using (SqlCommand cmd = new SqlCommand(sql, sqlConn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@ThreadId", threadId));
int rows = cmd.ExecuteNonQuery();
}
sqlConn.Close();
}
// Sending email notification
Ourspace_Utilities.View util = new Ourspace_Utilities.View();
util.SendEmailToThreadTrackersAboutMovingToPhase3(threadId, threadId, CultureInfo.CurrentCulture.ToString());
// the IMC message data gets stored inside
// a ModuleCommunicationEventArgs object
ModuleCommunicationEventArgs mcArgs =
new ModuleCommunicationEventArgs();
mcArgs.Sender = "Ourspace_ProposedSolutions";
mcArgs.Target = "Ourspace_ThreadDetails";
mcArgs.Text = "updatePhaseDisplay";
mcArgs.Type = "Your custom type";
//XmlDocument xmlDoc = new XmlDocument();
//xmlDoc.Load("path/to/xml/doc.xml");
mcArgs.Value = "notUsed";
// if ModuleCommunication is null,
// the cache settings for your module
// might need to be set to 0 (turned off)
if (ModuleCommunication != null)
{
// calling your ModuleCommunication delegate event
// will cause the event to be raised
ModuleCommunication(this, mcArgs);
}
lnkbtnPromoteToPhase3.Visible = false;
string[] parameters1 = new string[3];
parameters1 = new string[3] { "threadid=" + threadId,"mode=featured", "language=" + CultureInfo.CurrentCulture.ToString()};
string url = DotNetNuke.Common.Globals.NavigateURL(200, "", parameters1);
//string language = CultureInfo.CurrentCulture.ToString();
//string url = "http://www.joinourspace.eu/tabid/196/result/" + threadId + "/language/" + language + "/Default.aspx";
Response.Redirect(url);
}
}