public MethodResult Create(int userId, int offendingUserId, int messageId, string description, int commentTypeId)
{
try
{
TbComment comment = new TbComment();
String SetDecription = "این کاربر تخلف کرده است. لطفا بررسی شود";
comment.UserId = userId;
comment.Description = description;
comment.CommentTypeId = commentTypeId;
if (commentTypeId.Equals(2))
{
comment.OffendingUserId = offendingUserId;
comment.Description = SetDecription;
}
else
{
comment.MessageId = messageId;
}
Business.Comment.Create(comment);
return new MethodResult(false, " نظر ارسالی با موفقیت ثبت شد ", null);
}
catch (HabbeException e)
{
return new MethodResult(true, e.Message, null);
}
}
public static void Create(TbComment comment)
{
using (DataAccess.Comment db = new DataAccess.Comment())
{
comment.RegisterDate = DateTime.Now;
db.Create(comment);
}
}
public void Create(TbComment comment)
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "Insert Into TbComment (CommentTypeId,UserId,OffendingUserId,MessageId,Description,RegisterDate) values (@CommentTypeId,@UserId,@OffendingUserId,@MessageId,@Description,@RegisterDate)";
cmd.Parameters.AddWithValue("@MessageId", comment.MessageId.Equals(0) ? (object)DBNull.Value : comment.MessageId);
cmd.Parameters.AddWithValue("@UserId", comment.UserId);
cmd.Parameters.AddWithValue("@OffendingUserId", comment.OffendingUserId.Equals(0) ? (object)DBNull.Value : comment.OffendingUserId);
cmd.Parameters.AddWithValue("@CommentTypeId", comment.CommentTypeId);
cmd.Parameters.AddWithValue("@Description", comment.Description);
cmd.Parameters.AddWithValue("@RegisterDate", comment.RegisterDate);
cmd.ExecuteNonQuery();
}
public static TbComment ToEntity(System.Data.IDataReader reader)
{
TbComment comment = null;
comment = new TbComment();
comment.Id = Convert.ToInt32(reader["Id"]);
if (reader["MessageId"] != DBNull.Value)
comment.MessageId = Convert.ToInt32(reader["MessageId"]);
comment.CommentTypeId = Convert.ToInt32(reader["CommentTypeId"]);
comment.UserId = Convert.ToInt32(reader["UserId"]);
if (reader["OffendingUserId"] != DBNull.Value)
comment.OffendingUserId = Convert.ToInt32(reader["OffendingUserId"]);
comment.Description = Convert.ToString(reader["Description"]);
comment.RegisterDate = Convert.ToDateTime(reader["RegisterDate"]);
return comment;
}
