public int Save(CommentsEntity data)
{
try
{
return(Connection.Db.Query <int>("spCommentsSet",
new
{
Id = data.Id,
NewsId = data.NewsId,
NewsType = data.NewsType,
Name = data.Name,
Email = data.Email,
Comment = data.Comment,
DateTime = data.DateTime,
ShowMess = data.ShowMess,
Reply = data.Reply,
UserReply = data.UserReply,
DateTimeReply = data.DateTimeReply,
}, commandType: CommandType.StoredProcedure).SingleOrDefault());
}
catch (Exception ex)
{
Tools.SaveLog.Save(ex);
return(-1);
}
}
public List <CommentsEntity> Search(CommentsEntity data)
{
try
{
return(Connection.Db.Query <CommentsEntity>("spCommentsSearch",
new
{
Id = data.Id,
NewsId = data.NewsId,
NewsType = data.NewsType,
Name = "%" + data.Name + "%",
Email = "%" + data.Email + "%",
Comment = "%" + data.Comment + "%",
DateTime = "%" + data.DateTime + "%",
ShowMess = data.ShowMess,
Reply = "%" + data.Reply + "%",
UserReply = data.UserReply,
DateTimeReply = "%" + data.DateTimeReply + "%",
}, commandType: CommandType.StoredProcedure).ToList());
}
catch (Exception ex)
{
Tools.SaveLog.Save(ex);
return(new List <CommentsEntity>());
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
BL objBL = new BL();
CommentsEntity objComments = new CommentsEntity();
objComments.name = txtName.Text.Trim().Replace("'", "''");
objComments.comment = txtComments.Text.Trim().Replace("'", "''");
string result = objBL.InsertComment(objComments);
//fillComments();
if (result == "success")
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "alert", string.Format("alert('{0}');",
"Thanks for your comments"), true);
Clearfields();
fillComments();
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "alert", string.Format("alert('{0}');",
"Error Occured, Please try Again"), true);
}
}
}
protected AnnotationReplyInfo getAnnotationReplyInfo(CommentsEntity comment)
{
AnnotationReplyInfo annotationReplyInfo = base.GetAnnotationReplyInfo(comment);
if (withGuid)
{
annotationReplyInfo.ParentReplyGuid = annotationData.id.ToString();
}
return(annotationReplyInfo);
}
/// <summary>
/// Initial for reply annotation info
/// </summary>
/// <param name="comment">CommentsEntity</param>
/// <returns>AnnotationReplyInfo</returns>
protected AnnotationReplyInfo GetAnnotationReplyInfo(CommentsEntity comment)
{
AnnotationReplyInfo reply = new AnnotationReplyInfo();
reply.Message = comment.text;
DateTime date = DateTime.Parse(comment.time);
reply.RepliedOn = date;
reply.UserName = comment.userName;
return(reply);
}
protected override Reply GetAnnotationReplyInfo(CommentsEntity comment)
{
Reply annotationReplyInfo = base.GetAnnotationReplyInfo(comment);
if (withGuid)
{
annotationReplyInfo.ParentReply = new Reply {
Id = annotationData.id
};
}
return(annotationReplyInfo);
}
public string InsertComment(CommentsEntity objComment)
{
DA objDA = new DA();
string sqlQuery = "";
string returnValue = string.Empty;
//try
//{
//ID, Name, Description
sqlQuery = "INSERT INTO tb_cloud (name,comments)VALUES('" + objComment.name + "','" + objComment.comment + "')";
objDA.ExecuteNonQuery(sqlQuery);
return("success");
//}
//catch()
//{
//return "error";
//}
}
/// <summary>
/// Initial for reply annotation info
/// </summary>
/// <param name="comment">CommentsEntity</param>
/// <returns>AnnotationReplyInfo</returns>
protected virtual Reply GetAnnotationReplyInfo(CommentsEntity comment)
{
Reply reply = new Reply();
reply.Comment = comment.text;
DateTime date;
try
{
long unixDate = long.Parse(comment.time);
DateTime start = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
date = start.AddMilliseconds(unixDate).ToLocalTime();
}
catch (System.Exception)
{
date = DateTime.Parse(comment.time);
}
reply.RepliedOn = date;
reply.User = new User {
Name = comment.userName
};
return(reply);
}
/// <summary>
/// Map AnnotationInfo instances into AnnotationDataEntity
/// </summary>
/// <param name="annotationInfo">AnnotationInfo</param>
/// <returns>AnnotationDataEntity</returns>
public AnnotationDataEntity mapAnnotationDataEntity(AnnotationInfo annotationInfo)
{
AnnotationDataEntity annotation = new AnnotationDataEntity();
annotation.font = annotationInfo.FontFamily;
double fontSize = Convert.ToDouble((annotationInfo.FontSize == null) ? 0 : annotationInfo.FontSize);
annotation.fontSize = (float)fontSize;
annotation.height = annotationInfo.Box.Height;
annotation.left = annotationInfo.Box.X;
annotation.pageNumber = (int)annotationInfo.PageNumber + 1;
annotation.svgPath = (annotationInfo.SvgPath != null) ? annotationInfo.SvgPath.Replace("l", "L") : null;
string text = (annotationInfo.Text == null) ? annotationInfo.FieldText : annotationInfo.Text;
annotation.text = text;
annotation.top = annotationInfo.Box.Y;
annotation.type = Char.ToLowerInvariant(Enum.GetName(typeof(AnnotationType), annotationInfo.Type)[0]) + Enum.GetName(typeof(AnnotationType), annotationInfo.Type).Substring(1);
annotation.width = annotationInfo.Box.Width;
// each reply data
AnnotationReplyInfo[] replies = annotationInfo.Replies;
if (replies != null && replies.Length > 0)
{
CommentsEntity[] comments = new CommentsEntity[replies.Length];
for (int m = 0; m < replies.Length; m++)
{
CommentsEntity comment = new CommentsEntity();
AnnotationReplyInfo reply = replies[m];
comment.text = reply.Message;
comment.time = reply.RepliedOn.ToString("yyyy-MM-dd HH:mm:ss");
comment.userName = reply.UserName;
comments[m] = comment;
}
annotation.comments = comments;
}
return(annotation);
}
/// <summary>
/// Map AnnotationInfo instances into AnnotationDataEntity
/// </summary>
/// <param name="annotationInfo">AnnotationInfo</param>
/// <returns>AnnotationDataEntity</returns>
public static AnnotationDataEntity MapAnnotationDataEntity(AnnotationBase annotationInfo, PageInfo pageInfo, string documentType)
{
string annotationTypeName = Enum.GetName(typeof(AnnotationType), annotationInfo.Type);
float maxY = 0, minY = 0, maxX = 0, minX = 0;
float boxX = 0, boxY = 0, boxHeight = 0, boxWidth = 0;
string svgPath = "";
if (annotationInfo is IPoints)
{
List <Point> points = ((IPoints)annotationInfo).Points;
maxY = points.Max(p => p.Y);
minY = points.Min(p => p.Y);
maxX = points.Max(p => p.X);
minX = points.Min(p => p.X);
}
if (annotationInfo is IBox)
{
Rectangle box = ((IBox)annotationInfo).Box;
boxX = box.X;
boxY = box.Y;
boxHeight = box.Height;
boxWidth = box.Width;
StringBuilder builder = new StringBuilder().
Append("M").Append(box.X.ToString(CultureInfo.InvariantCulture)).
Append(",").Append(box.Y.ToString(CultureInfo.InvariantCulture)).
Append("L").Append(box.Width.ToString(CultureInfo.InvariantCulture)).
Append(",").Append(box.Height.ToString(CultureInfo.InvariantCulture));
svgPath = builder.ToString();
}
AnnotationDataEntity annotation = new AnnotationDataEntity();
annotation.font = annotationInfo is IFontFamily ? ((IFontFamily)annotationInfo).FontFamily : "";
double fontSize = annotationInfo is IFontSize?Convert.ToDouble((((IFontSize)annotationInfo).FontSize == null)? 0 : ((IFontSize)annotationInfo).FontSize) : (annotationInfo is ITextToReplace ? 10 : 0);
annotation.fontSize = (float)fontSize;
annotation.fontColor = annotationInfo is IFontColor ? ((((IFontColor)annotationInfo).FontColor == null) ? 0 : (int)((IFontColor)annotationInfo).FontColor) : 0;
annotation.height = annotationInfo is IBox ? boxHeight : (annotationInfo is IPoints ? (maxY - minY) : 0);
annotation.left = annotationInfo is IBox ? boxX : (annotationInfo is IPoints ? minX : 0);
annotation.pageNumber = (int)annotationInfo.PageNumber + 1;
annotation.svgPath = annotationInfo is ISvgPath ? (((ISvgPath)annotationInfo).SvgPath?.Replace("l", "L")) : svgPath;
string text = annotationInfo is IText ? ((IText)annotationInfo).Text : (annotationInfo is ITextToReplace ? ((ITextToReplace)annotationInfo).TextToReplace : "");
annotation.text = text;
// TODO: remove comment after check all annotations types on main formats
annotation.top = annotationInfo is IBox ? boxY : (annotationInfo is IPoints ? (!documentType.Equals("image") ? pageInfo.Height - maxY : minY) : 0);
annotation.type = char.ToLowerInvariant(annotationTypeName[0]) + annotationTypeName.Substring(1);
annotation.width = annotationInfo is IBox ? boxWidth : (annotationInfo is IPoints ? (maxX - minX) : 0);
// each reply data
Reply[] replies = annotationInfo.Replies.ToArray();
if (replies != null && replies.Length > 0)
{
CommentsEntity[] comments = new CommentsEntity[replies.Length];
for (int m = 0; m < replies.Length; m++)
{
CommentsEntity comment = new CommentsEntity();
Reply reply = replies[m];
comment.text = reply.Comment;
comment.time = reply.RepliedOn.ToString("yyyy-MM-dd HH:mm:ss");
comment.userName = reply.User.Name;
comments[m] = comment;
}
annotation.comments = comments;
}
return(annotation);
}