protected void lnkbtnSubmitProposal_Click(object sender, EventArgs e)
{
try
{
if (UserId > -1)
{
int postId = -1;
string title = "";
GetThreadTitle(out title, out postId);
title = txtProposalTitle.Text;
string body = txtProposalDescription.Text;
Ourspace_Utilities.View util = new Ourspace_Utilities.View();
int newPostId = (int)SqlHelper.ExecuteScalar(CONNECTION_STRING, "Ourspace_Forum_Post_Add", postId, -1, UserId, "::1", title, body, false, DateTime.Now, false, PortalId, -1, false, 0, true);
int threadId = util.GetThreadId(newPostId);
int forumId = (int)SqlHelper.ExecuteScalar(CONNECTION_STRING, "Ourspace_Forum_Id_From_Thread_Id", threadId);
var added = SqlHelper.ExecuteScalar(CONNECTION_STRING, "Forum_Forum_PostAdded", forumId, threadId, newPostId, UserId, "approve");
//RegisterSolutionProposal(thre;
// Sending emails to Thread Trackers (Subscribers)
util.SendEmailToThreadTrackers(threadId, newPostId, CultureInfo.CurrentCulture.ToString());
//SendEmailToThreadTrackers(threadId, newPostId);
//lblShowProposalSubmitted.Text = "yes";
Session["showProposeSuccess"] = true;
if (Request.QueryString["threadId"] != null)
{
threadId = int.Parse(Request.QueryString["threadId"]);
RegisterSolutionProposal(threadId, newPostId);
Response.Redirect(Request.Url.ToString().Replace("threadid=" + threadId, "postId=" + newPostId) + "#" + newPostId);
}
else if (Request.QueryString["postId"] != null)
{
RegisterSolutionProposal(threadId, newPostId);
Response.Redirect(Request.Url.ToString().Replace("postid=" + postId, "postId=" + newPostId) + "#" + newPostId);
}
}
if (CultureInfo.CurrentCulture.Name == "en-GB")
{
hprlnkTermsAndCons.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(216, "");
}
else if (CultureInfo.CurrentCulture.Name == "el-GR")
{
hprlnkTermsAndCons.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(217, "");
}
else if (CultureInfo.CurrentCulture.Name == "cs-CZ")
{
hprlnkTermsAndCons.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(218, "");
}
else if (CultureInfo.CurrentCulture.Name == "de-AT")
{
hprlnkTermsAndCons.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(219, "");
}
}
catch (Exception ex)
{
string error = ex.Message;
}
}
protected void lnkbtnSubmitReply_Click(object sender, EventArgs e)
{
try
{
if (UserId > -1)
{
string test = ctlAttachment.lstAttachmentIDs;
string text = txtEditor.Text;
string title = "";
Random random = new Random();
//Session["ATTACHMENTS_SESSION"] =
int postId = -1;
GetThreadTitle(out title, out postId);
int newPostId = (int)SqlHelper.ExecuteScalar(CONNECTION_STRING, "Ourspace_Forum_Post_Add", postId, -1, UserId, "::1", title, txtEditor.Text, false, DateTime.Now, false, PortalId, -1, false, 0, false);
// http://localhost/ourspace/OpenDebates/tabid/62/forumid/1/postid/25/scope/posts/language/en-GB/Default.aspx#25
Ourspace_Utilities.View util = new Ourspace_Utilities.View();
int threadId = util.GetThreadId(newPostId);
int forumId = (int)SqlHelper.ExecuteScalar(CONNECTION_STRING, "Ourspace_Forum_Id_From_Thread_Id", threadId);
var added = SqlHelper.ExecuteScalar(CONNECTION_STRING, "Forum_Forum_PostAdded", forumId, threadId, newPostId, UserId, "approve");
int attachmentsSession = (int)Session["ATTACHMENTS_SESSION"];
AssignAttachmentsToPost(attachmentsSession, newPostId);
util.SubscribeUserToThread(threadId, forumId, UserId);
//Forum.PostConnector postConnector = new Forum.PostConnector();
//List<Entities.Content.Taxonomy.Term> terms = new List<Entities.Content.Taxonomy.Term>();
//postConnector.SubmitExternalPost(TabId, 381, 0, UserId, title, txtEditor.Text, forumId, threadId, ctlAttachment.lstAttachmentIDs, "Ourspace_Texteditor:reply",threadId,terms);
// ctlAttachment.
//Ourspace_Utilities.View util = new Ourspace_Utilities.View();
util.SendEmailToThreadTrackers(threadId, newPostId, CultureInfo.CurrentCulture.ToString());
Session["showPostSuccess"] = true;
if (Request.QueryString["threadId"] != null)
{
threadId = int.Parse(Request.QueryString["threadId"]);
string[] parameters = new string[3] { "postId=" + newPostId, "forumId=" + forumId, "scope=posts" };
string url = DotNetNuke.Common.Globals.NavigateURL(TabId, "", parameters);
//Response.Redirect(Request.Url.ToString().Replace("threadid=" + threadId, "postId=" + newPostId) + "#" + newPostId,true);
Response.Redirect(url);
}
else if (Request.QueryString["postId"] != null)
{
//Response.Redirect(Request.Url.ToString().Replace("postid=" + postId, "postId=" + newPostId) + "#" + newPostId,true);
string[] parameters = new string[3] { "postId=" + newPostId, "forumId=" + forumId, "scope=posts" };
string url = DotNetNuke.Common.Globals.NavigateURL(TabId, "", parameters);
//Response.Redirect(Request.Url.ToString().Replace("threadid=" + threadId, "postId=" + newPostId) + "#" + newPostId,true);
Response.Redirect(url);
}
}
}
catch (Exception ex)
{
string error = ex.Message;
}
}