public override void DataBind()
{
dataSrc = this.Parent as CommentsDataSource;
if (!_bound)
{
_bound = true;
CommentsManager cMgr = new CommentsManager();
Comments.Comments_Tables_View table = cMgr.GetTableDetails(TableName);
if (table == null)
{
CommentsSetup cs = new CommentsSetup();
if (MembersOnly)
{
cs.CreateCommentsTableWithMembers(TableName, RelateTo, 1);
}
else
{
cs.CreateCommentsTableNoMembers(TableName, RelateTo, 1);
}
table = cMgr.GetTableDetails(TableName);
}
//HtmlInputHidden RelationId = new HtmlInputHidden();
//RelationId.ID = "RelationId";
//RelationId.Value = "-2";
//this.Controls.Add(RelationId);
HtmlInputHidden ParentId = new HtmlInputHidden();
ParentId.ID = "ParentId";
if (this.dataSrc == null)
{
ParentId.Value = "-1";
}
else
{
ParentId.Value = dataSrc.ParentId.ToString();
}
this.Controls.Add(ParentId);
if (!NoRelations)
{
object relationValue = ControlUtils.GetBoundedDataField(this.NamingContainer, table.RelationField);
RelationId = (int)relationValue;
}
if (AjaxSubmit)
{
AjaxResponse resp = new AjaxResponse();
if (this.IsPostBack)
{
resp.callBack = this.AjaxCallback;
this.Validate();
resp.valid = this.IsValid.Value;
if (resp.valid)
{
if (this.MembersOnly)
{
string text = WebContext.Request["CommentText"];
if (!String.IsNullOrWhiteSpace(text))
{
int comment = cMgr.AddMemberComment(TableName,
Int32.Parse(ParentId.Value), RelationId,
WebContext.Request["CommentTitle"],
text, WebContext.Profile.UserId, CommentType.Text);
var dr = cMgr.GetTopComment(TableName, RelationId, Int32.Parse(ParentId.Value), "Order By CommentId Desc");
MembersManager mMgr = new MembersManager();
resp r = new resp();
string mId = dr["MemberId"].ToString();
if (!String.IsNullOrWhiteSpace(mId))
{
var member = mMgr.GetMember(Int32.Parse(mId));
r.FirstName = member.FirstName;
r.LastName = member.LastName;
r.Username = member.UserName;
r.Picture = member.Picture;
}
r.CommentId = dr["CommentId"].ToString();
r.ParentId = dr["ParentId"].ToString();
r.RelationId = dr["RelationId"].ToString();
r.DateCreated = string.Format("{0:MMM dd, yyyy} at {0:h:mm:tt}", dr["DateCreated"]);
r.Title = dr["Title"].ToString();
r.CommentText = dr["CommentText"].ToString();
r.MemberId = dr["MemberId"].ToString();
r.TableName = TableName;
resp.data = r;
resp.message = "Text successfully added";
resp.error = null;
}
else
{
resp.message = "Please write your text before submitting and try again.";
resp.error = "true";
}
}
else
{
NameValueCollection post = GetValues();
ContentManager pMgr = new ContentManager();
CustomPage thisPage = this.Page as CustomPage;
if (thisPage == null)
{
thisPage = new CustomPage();
}
if (String.IsNullOrEmpty(post["Name"]))
{
Validated = false;
ErrorContext.Add("validation-name", ContentManager.ErrorMsg("Name-Validation", thisPage.Language));
}
if (String.IsNullOrEmpty(post["Email"]) || !Validation.IsEmail(post["Email"]))
{
Validated = false;
ErrorContext.Add("validation-email", ContentManager.ErrorMsg("Email-Validation", thisPage.Language));
}
if (String.IsNullOrEmpty(post["Title"]))
{
Validated = false;
ErrorContext.Add("validation-comment", ContentManager.ErrorMsg("Comment-Validation", thisPage.Language));
}
if (String.IsNullOrEmpty(post["Comment"]))
{
Validated = false;
ErrorContext.Add("validation-comment", ContentManager.ErrorMsg("Comment-Validation", thisPage.Language));
}
if (Validated != null && Validated.Value)
{
int commentId = -1;
try
{
commentId = cMgr.AddNoMemberComment(TableName, -1,
RelationId,
post["Title"],
post["Comment"], WebContext.Profile.UserGuid,
post["Name"], post["Website"],
post["Country"], WebContext.Request.ServerVariables["REMOTE_ADDR"],
post["avatar"], CommentType.Text);
}
catch (Exception ex)
{
ErrorContext.Add(ex);
}
if (commentId > 0)
{
if (!String.IsNullOrEmpty(table.Email))
{
Config cfg = new Config();
Mail mail = new Mail("Comments");
mail.Subject = post["Name"] + " submitted a comment to " + table.TableName;
NameValueCollection dic = new NameValueCollection();
dic["Name"] = post["Name"];
dic["Email"] = post["Email"];
dic["Comment"] = StringUtils.PutBR(post["Comment"].ToString());
if (!String.IsNullOrWhiteSpace(post["Website"]))
{
dic["Website"] = post["Website"];
}
ArrayList files = cMgr.AddFiles(TableName, commentId);
StringBuilder sb = new StringBuilder();
if (files.Count > 0)
{
sb.Append("<dl><dt>Files:</dt><dd>");
foreach (string s in files)
{
string temp = s;
if (temp.IndexOf("~") == 0)
{
temp = temp.Substring(1);
}
sb.Append(String.Format("<a href=\"http://{0}/{1}\">{2}</a>",
WebTools.WebContext.ServerName,
s.Replace("\\", "/").Substring(1),
Path.GetFileName(temp)));
sb.Append("<br />");
}
sb.Append("</dd></dl>");
}
dic["Files"] = sb.ToString();
sb.Clear();
sb.Append(string.Format(@"<p>
<a href=""http://{0}/Prv/proxies/comments/status.ashx?commentId={1}&table={2}&action=approve"">Approve</a>
- <a href=""http://{0}/Prv/proxies/comments/status.ashx?commentId={1}&table={2}&action=edit"">Edit</a>
- <a href=""http://{0}/Prv/proxies/comments/status.ashx?CommentId={1}&table={2}&action=delete"">Delete</a>
</p>", WebTools.WebContext.ServerName, commentId, table.TableName));
dic["Permission"] = sb.ToString();
mail.Data = dic;
mail.To = table.Email;
/*
* mail.From = cfg.GetKey("EmailsFrom");
*
* StringBuilder sb = new StringBuilder();
*
* sb.Append("<dl>");
* sb.Append(String.Format("<dt>Name: </dt><dd>{0}</dd>", post["Name"]));
* sb.Append(String.Format("<dt>Email: </dt><dd>{0}</dd>", post["Email"]));
*
* if(!String.IsNullOrWhiteSpace(post["Website"]))
* sb.Append(String.Format("<dt>Website: </dt><dd>{0}</dd>", post["Website"]));
*
*
* ArrayList files = cMgr.AddFiles(TableName, commentId);
*
* if (files.Count > 0)
* {
* sb.Append("<dt>Files:</dt><dd>");
* foreach (string s in files)
* {
* String.Format("<a href=\"{0}/{1}\">{2}</a>",
* WebTools.WebContext.ServerName,
* s.Replace("\\", "/"),
* Path.GetFileName(s));
* }
* sb.Append("</dd>");
* }
*
* sb.Append(String.Format("<dt>Comment: </dt><dd>{0}</dd>", StringUtils.PutBR(post["Comment"])));
* sb.Append("</dl>");
*
* sb.Append(string.Format(@"<p>
* <a href=""http://{0}/Prv/proxies/comments/status.ashx?commentId={1}&table={2}&action=approve"">Approve</a>
* - <a href=""http://{0}/Prv/proxies/comments/status.ashx?commentId={1}&table={2}&action=edit"">Edit</a>
* - <a href=""http://{0}/Prv/proxies/comments/status.ashx?CommentId={1}&table={2}&action=delete"">Delete</a>
* </p>", WebTools.WebContext.ServerName, commentId, table.TableName));
*
* mail.Body = sb.ToString();
* mail.Subject = post["Name"] + " submitted a comment to " + table.TableName;
*/
mail.Send();
}
SuccessContext.Add("comment-submitted", ContentManager.Message("comment-submitted"));
this.Visible = false;
}
}
}
}
resp.WriteJson(true);
}
}
else
{
if (this.MembersOnly)
{
string text = WebContext.Request["CommentText"];
if (!String.IsNullOrWhiteSpace(text))
{
cMgr.AddMemberComment(TableName,
Int32.Parse(ParentId.Value), RelationId,
WebContext.Request["CommentTitle"],
text, WebContext.Profile.UserId, CommentType.Text);
WebContext.Response.Redirect(WebContext.Request.RawUrl);
}
}
else
{
NameValueCollection post = GetValues();
ContentManager pMgr = new ContentManager();
CustomPage thisPage = this.Page as CustomPage;
if (thisPage == null)
{
thisPage = new CustomPage();
}
if (String.IsNullOrEmpty(post["Name"]))
{
Validated = false;
ErrorContext.Add("validation-name", ContentManager.ErrorMsg("Name-Validation", thisPage.Language));
}
if (String.IsNullOrEmpty(post["Email"]) || !Validation.IsEmail(post["Email"]))
{
Validated = false;
ErrorContext.Add("validation-email", ContentManager.ErrorMsg("Email-Validation", thisPage.Language));
}
if (String.IsNullOrEmpty(post["Title"]))
{
Validated = false;
ErrorContext.Add("validation-comment", ContentManager.ErrorMsg("Comment-Validation", thisPage.Language));
}
if (String.IsNullOrEmpty(post["Comment"]))
{
Validated = false;
ErrorContext.Add("validation-comment", ContentManager.ErrorMsg("Comment-Validation", thisPage.Language));
}
if (Validated != null && Validated.Value)
{
int commentId = -1;
try
{
commentId = cMgr.AddNoMemberComment(TableName, -1,
RelationId,
post["Title"],
post["Comment"], WebContext.Profile.UserGuid,
post["Name"], post["Website"],
post["Country"], WebContext.Request.ServerVariables["REMOTE_ADDR"],
post["avatar"], CommentType.Text);
}
catch (Exception ex)
{
ErrorContext.Add(ex);
}
if (commentId > 0)
{
if (!String.IsNullOrEmpty(table.Email))
{
Config cfg = new Config();
Mail mail = new Mail("Comments");
mail.Subject = post["Name"] + " submitted a comment to " + table.TableName;
NameValueCollection dic = new NameValueCollection();
dic["Name"] = post["Name"];
dic["Email"] = post["Email"];
dic["Comment"] = StringUtils.PutBR(post["Comment"].ToString());
if (!String.IsNullOrWhiteSpace(post["Website"]))
{
dic["Website"] = post["Website"];
}
ArrayList files = cMgr.AddFiles(TableName, commentId);
StringBuilder sb = new StringBuilder();
if (files.Count > 0)
{
sb.Append("<dl><dt>Files:</dt><dd>");
foreach (string s in files)
{
string temp = s;
if (temp.IndexOf("~") == 0)
{
temp = temp.Substring(1);
}
sb.Append(String.Format("<a href=\"http://{0}/{1}\">{2}</a>",
WebTools.WebContext.ServerName,
s.Replace("\\", "/").Substring(1),
Path.GetFileName(temp)));
sb.Append("<br />");
}
sb.Append("</dd></dl>");
}
dic["Files"] = sb.ToString();
sb.Clear();
sb.Append(string.Format(@"<p>
<a href=""http://{0}/Prv/proxies/comments/status.ashx?commentId={1}&table={2}&action=approve"">Approve</a>
- <a href=""http://{0}/Prv/proxies/comments/status.ashx?commentId={1}&table={2}&action=edit"">Edit</a>
- <a href=""http://{0}/Prv/proxies/comments/status.ashx?CommentId={1}&table={2}&action=delete"">Delete</a>
</p>" , WebTools.WebContext.ServerName, commentId, table.TableName));
dic["Permission"] = sb.ToString();
mail.Data = dic;
mail.To = table.Email;
/*
* mail.From = cfg.GetKey("EmailsFrom");
*
* StringBuilder sb = new StringBuilder();
*
* sb.Append("<dl>");
* sb.Append(String.Format("<dt>Name: </dt><dd>{0}</dd>", post["Name"]));
* sb.Append(String.Format("<dt>Email: </dt><dd>{0}</dd>", post["Email"]));
*
* if(!String.IsNullOrWhiteSpace(post["Website"]))
* sb.Append(String.Format("<dt>Website: </dt><dd>{0}</dd>", post["Website"]));
*
*
* ArrayList files = cMgr.AddFiles(TableName, commentId);
*
* if (files.Count > 0)
* {
* sb.Append("<dt>Files:</dt><dd>");
* foreach (string s in files)
* {
* String.Format("<a href=\"{0}/{1}\">{2}</a>",
* WebTools.WebContext.ServerName,
* s.Replace("\\", "/"),
* Path.GetFileName(s));
* }
* sb.Append("</dd>");
* }
*
* sb.Append(String.Format("<dt>Comment: </dt><dd>{0}</dd>", StringUtils.PutBR(post["Comment"])));
* sb.Append("</dl>");
*
* sb.Append(string.Format(@"<p>
* <a href=""http://{0}/Prv/proxies/comments/status.ashx?commentId={1}&table={2}&action=approve"">Approve</a>
* - <a href=""http://{0}/Prv/proxies/comments/status.ashx?commentId={1}&table={2}&action=edit"">Edit</a>
* - <a href=""http://{0}/Prv/proxies/comments/status.ashx?CommentId={1}&table={2}&action=delete"">Delete</a>
* </p>", WebTools.WebContext.ServerName, commentId, table.TableName));
*
* mail.Body = sb.ToString();
* mail.Subject = post["Name"] + " submitted a comment to " + table.TableName;
*/
mail.Send();
}
SuccessContext.Add("comment-submitted", ContentManager.Message("comment-submitted"));
this.Visible = false;
}
}
}
}
}
base.DataBind();
}
public override void DataBind()
{
if (!_bound)
{
_bound = true;
lw.Base.CustomPage page = this.Page as lw.Base.CustomPage;
string GroupName = page.GetQueryValue("CommentTitle");
if (!StringUtils.IsNullOrWhiteSpace(GroupName))
{
String[] Split = GroupName.Split('-');
CommentId = Int32.Parse(Split[Split.Length - 1]);
}
if (!NoRelations)
{
Comments.Comments_Tables_View table = cMgr.GetTableDetails(TableName);
if (table == null)
{
return;
}
object relationValue = ControlUtils.GetBoundedDataField(this.NamingContainer, table.RelationField);
if (MembersOnly)
{
this.SelectCommand = cMgr.GetMemberCommentsQueryWithRelations(TableName, (int)relationValue, -1, Top);
}
else
{
this.SelectCommand = cMgr.GetCommentsQueryWithRelations(TableName, (int)relationValue, -1, Top);
}
}
else
{
if (MembersOnly)
{
if (ChildComments)
{
object obj = DataBinder.Eval(this.NamingContainer, "DataItem.CommentId");
if (obj != null)
{
ParentId = (int)obj;
}
}
this.SelectCommand = cMgr.GetMemberCommentsQueryWithNoRelations(TableName, ParentId, Top);
this.SelectCommand += string.Format(" And C.Status&{0}={0}", (int)Status.Enabled);
if (ChildComments)
{
this.SelectCommand += string.Format(" And C.CommentId>{0} Order by C.CommentId ASC", 0);
}
else
{
if (CommentId != -2)
{
this.SelectCommand += string.Format("And (CommentId={0} or ParentId={0})", CommentId);
}
}
}
else
{
this.SelectCommand = cMgr.GetCommentsQueryNoRelations(TableName, -1, Top);
}
}
//TODO: Display Disabled Comments in case an administrator is logged in
if (!MembersOnly)
{
//this.SelectCommand += String.Format(" And Status&{0}={0}", (int)Status.Enabled);
if (!EnablePaging)
{
this.SelectCommand += " Order By DateCreated DESC";
}
}
}
base.DataBind();
}
