public static int SaveUserComment(DBUserComment comment)
{
int id = comment.Id;
using (ApplicationContext db = new ApplicationContext())
{
var dBUserComment = db.UserComments
.FirstOrDefault(
x => x.Id == comment.Id &&
x.UserId == comment.UserId);
if (id < 1)
{
id = db.UserComments.OrderBy(x => x.Id).LastOrDefault()?.Id ?? 0;
id = ++id;
comment.Id = id;
comment.UpdateDT = comment.CreateDT;
db.UserComments.Add(comment);
}
else
{
if (comment == null)
{
throw new Exception($"Нет записи user с таким Id = {comment.Id} и UserId = {comment.UserId}");
}
comment.UpdateDT = DateTime.Now;
db.Entry(dBUserComment).CurrentValues.SetValues(comment);
}
db.SaveChanges();
}
return(id);
}
public static DBUserComment GetUserComment(int id)
{
var userComment = new DBUserComment();
using (ApplicationContext db = new ApplicationContext())
{
userComment = db.UserComments.Where(x => x.Id == id).Include(x => x.User).Include(x => x.CreateUser).FirstOrDefault();
userComment.Invoits = db.UserCommentInvoits.Where(x => x.UserCommentId == userComment.Id).Include(x => x.User).ToList();
}
return(userComment);
}