private void CheckComment(string commentMsg)
{
var comment = new AlbumComment(album, commentMsg, new AgentLoginData(agentName));
repository.HandleTransaction(ctx => {
new UserCommentNotifier().CheckComment(comment, entryLinkFactory, ctx);
});
}
public AlbumComment AddComment(AlbumComment comment, Album album, User user)
{
comment.User = user;
album.Comments.Add(comment);
dbContext.SaveChanges();
return(comment);
}
public AlbumComment AddComment(CommentModel comment, Album album, User user)
{
var albumComment = new AlbumComment()
{
Text = comment.Text,
CreatedAt = DateTime.Now
};
return(this.albumManager.AddComment(albumComment, album, user));
}
public CommentAlbumModel Converter(AlbumComment c)
{
return(new CommentAlbumModel()
{
Id = c.Id,
Comment = c.Comment,
UserId = c.UserId,
Date = c.Date,
DataId = c.AlbumId,
UserInfo = userInfoDto.ConvertToUserInfoModel(c.User.UserInfoes).FirstOrDefault()
});
}
public virtual void SaveOrUpdate(AlbumComment comment)
{
ISession session = _sessionManager.OpenSession();
// can't seem to get this to work automagically
if (comment.Id == -1)
{
session.Save(comment);
}
else
{
session.Update(comment);
}
session.Flush();
}
public HttpResponseMessage DeleteComment([FromUri] int albumId, [FromUri] long commentId)
{
using (var db = new OnlineMusicEntities())
{
AlbumComment comment = (from c in db.AlbumComments
where c.Id == commentId
select c).FirstOrDefault();
if (comment == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.OK, "Không tìm thấy comment id=" + commentId));
}
db.AlbumComments.Remove(comment);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
protected void buttonSubmit_Click(object sender, EventArgs e)
{
// Nếu đã đánh dấu I agree, có nội dung comment, có tên author, email hoặc đã đăng nhập
if (chkAgree.Checked && !string.IsNullOrEmpty(textBoxComment.Text) && ((!string.IsNullOrEmpty(textBoxAuthor.Text) && !string.IsNullOrEmpty(textBoxEmail.Text)) || PageEngine.User.Identity is User))
{
if (textBoxVerifierCode.Text == imageVerifier.Text)
{
AlbumComment comment = new AlbumComment();
comment.Deleted = false;
if (Page.User.Identity is User)
{
comment.Author = ((User)Page.User.Identity).FullName;
comment.AuthorId = ((User)Page.User.Identity);
comment.Email = ((User)Page.User.Identity).Email;
}
else
{
comment.Author = textBoxAuthor.Text;
comment.AuthorId = null;
comment.Email = textBoxEmail.Text;
}
comment.DateCreated = DateTime.Now;
comment.DateModified = DateTime.Now;
comment.Comment = textBoxComment.Text;
comment.Status = 0;
comment.Album = _album;
comment.IP = Request.UserHostAddress;
chkAgree.Checked = false;
textBoxComment.Text = string.Empty;
_galleryModule.GetAlbumService().SaveOrUpdate(comment);
rptReviews.DataSource = _album.Comments;
rptReviews.DataBind();
imageVerifier.Refresh();
}
else
{
labelFailedVerified.Visible = true;
}
}
}
public HttpResponseMessage AddCommentToAlbum([FromUri] int id, [FromBody] CommentAlbumModel commentModel)
{
if (commentModel.DataId != id)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Dữ liệu không phù hợp"));
}
using (var db = new OnlineMusicEntities())
{
AlbumComment comment = new AlbumComment();
commentModel.UpdateEntity(comment);
comment.Date = DateTime.Now;
db.AlbumComments.Add(comment);
db.SaveChanges();
comment.User = (from u in db.Users where u.Id == comment.UserId select u).FirstOrDefault();
commentModel = commentDto.GetCommentQuery(db, awhereClause: null).Where(c => c.Id == comment.Id).FirstOrDefault();
return(Request.CreateResponse(HttpStatusCode.Created, commentModel));
}
}
public async Task <bool> CreateCommentAsync(string albumId, string content, User user)
{
ArgumentValidator.ThrowIfNullOrEmpty(albumId, nameof(albumId));
ArgumentValidator.ThrowIfNullOrEmpty(content, nameof(content));
ArgumentValidator.ThrowIfNull(user, nameof(user));
var comment = new AlbumComment
{
AuthorId = user.Id,
AlbumId = albumId,
Comment = content,
CreatedOn = DateTime.UtcNow
};
await this.albumCommentRepository.AddAsync(comment);
var result = await this.albumCommentRepository.SaveChangesAsync();
return(result != 0);
}
public HttpResponseMessage EditComment([FromUri] int id, [FromBody] CommentAlbumModel commentModel)
{
if (commentModel.DataId != id)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Dữ liệu không phù hợp"));
}
using (var db = new OnlineMusicEntities())
{
AlbumComment comment = (from c in db.AlbumComments
where c.Id == commentModel.Id
select c).FirstOrDefault();
if (comment == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.OK, "Không tìm thấy comment id=" + commentModel.Id));
}
commentModel.UpdateEntity(comment);
db.SaveChanges();
commentModel = commentDto.GetCommentQuery(db, awhereClause: null).Where(c => c.Id == comment.Id).FirstOrDefault();
return(Request.CreateResponse(HttpStatusCode.OK, commentModel));
}
}
protected void rptReviews_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.DataItem is AlbumComment)
{
AlbumComment comment = (AlbumComment)e.Item.DataItem;
Label labelAuthor = e.Item.FindControl("labelAuthor") as Label;
if (labelAuthor != null)
{
if (comment.AuthorId != null)
{
comment.Author = comment.AuthorId.FullName;
}
labelAuthor.Text = string.Format("{0:F} by {1}", comment.DateCreated, comment.Author);
}
Label labelContent = e.Item.FindControl("labelContent") as Label;
if (labelContent != null)
{
labelContent.Text = string.Format("{0}", comment.Comment);
}
}
}
public static bool setComment2Album(AlbumComment albumComment, string connString)
{
#region code
bool rs;
using (var conn = new SqlConnection(connString))
{
try
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sony_sp_add_album_comment";
cmd.Parameters.AddWithValue("@username",
String.IsNullOrEmpty(albumComment.UserName) ? "admin" : albumComment.UserName);
cmd.Parameters.AddWithValue("@albumId", albumComment.AlbumId);
cmd.Parameters.AddWithValue("@photoId", albumComment.PhotoId);
cmd.Parameters.AddWithValue("@status", albumComment.Status ? 1 : 0);
cmd.Parameters.AddWithValue("@comment", albumComment.Comment);
var returnVal = new SqlParameter("@returnVal", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(returnVal);
cmd.ExecuteNonQuery();
rs = ((int) cmd.Parameters["@returnVal"].Value != 0);
}
}
catch (Exception ex)
{
writeLog("", "Add Album Comment Error: " + ex.Message, connString);
return false;
}
}
return rs;
#endregion
}
public static List<AlbumComment> getListCommentOfAlbum(int photoId, string connString)
{
#region code
var lists = new List<AlbumComment>();
using (var conn = new SqlConnection(connString))
{
try
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sony_sp_get_all_album_photo_comment_by_photo_id";
cmd.Parameters.AddWithValue("@photoId", photoId);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var albumComment = new AlbumComment
{
Id = (int) reader["id"],
UserName = reader["username"].ToString(),
AlbumId = (int) reader["albumId"],
PhotoId = (int) reader["photoId"],
Status =
reader["status"].ToString().Equals("1") ||
reader["status"].ToString().Equals("True"),
Created = (DateTime) reader["created"],
Comment = reader["comment"].ToString()
};
lists.Add(albumComment);
}
}
}
}
catch (Exception ex)
{
writeLog("", String.Format("Get Album Comment Error: photoId={0}, CauseBy:{1}", photoId, ex.Message),
connString);
return new List<AlbumComment>();
}
}
return lists;
#endregion
}
/// <summary>
/// Get list all album comment
/// </summary>
/// <param name="connString"></param>
/// <returns></returns>
public static List<AlbumComment> getListComment(string connString)
{
#region code
var lists = new List<AlbumComment>();
using (var conn = new SqlConnection(connString))
{
try
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sony_sp_get_all_album_comment";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var albumComment = new AlbumComment
{
Id = (int) reader["id"],
AlbumId =
String.IsNullOrEmpty(reader["albumId"].ToString()) ? 0 : (int) reader["albumId"],
PhotoId =
String.IsNullOrEmpty(reader["photoId"].ToString()) ? 0 : (int) reader["photoId"],
Comment = reader["comment"].ToString(),
Status =
reader["status"].ToString().Equals("1") ||
reader["status"].ToString().Equals("True"),
UserName = reader["username"].ToString(),
Created = (DateTime) reader["created"]
};
lists.Add(albumComment);
}
}
}
}
catch (Exception ex)
{
writeLog("", "Get All AlbumComment Error: " + ex.Message, connString);
return new List<AlbumComment>();
}
}
return lists;
#endregion
}
public static AlbumComment getCommentById(int commentId, string connString)
{
#region code
var rs = new AlbumComment();
using (var conn = new SqlConnection(connString))
{
try
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sony_sp_get_album_comment_by_id";
cmd.Parameters.AddWithValue("@id", commentId);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
rs.AlbumId = String.IsNullOrEmpty(reader["albumId"].ToString())
? 0
: (int) reader["albumId"];
rs.PhotoId = String.IsNullOrEmpty(reader["photoId"].ToString())
? 0
: (int) reader["photoId"];
rs.Comment = reader["comment"].ToString();
rs.Status = reader["status"].ToString().Equals("1") ||
reader["status"].ToString().Equals("True");
rs.UserName = reader["username"].ToString();
}
}
}
}
catch (Exception ex)
{
writeLog("", "Get Album Comment Error: " + ex.Message, connString);
return new AlbumComment();
}
}
return rs;
#endregion
}
