public static void DeleteComment(Comment comment)
{
try
{
DB.DB.Comments_Delete(comment.Id);
}
catch (Exception e)
{
Utils.Log.LogInfo(e.Message, e, "error");
}
}
public static void UpdateComment(Comment comment)
{
try
{
var old = GetComment(comment.Id);
var old_mentions = GetMentions(old.Text);
var new_mentions = GetMentions(comment.Text);
new_mentions.ExceptWith(old_mentions);
foreach (var m in new_mentions)
{
var user = DB.DB.GetUser(m);
if (user.Any())
{
DB.DB.Notification_Insert(Convert.ToInt32(user[0]["id"]), "You've been mentioned in a comment", comment.Code_Id, comment.User_Id);
}
}
DB.DB.Comments_Update(comment.Id, comment.Text);
}
catch (Exception e)
{
Utils.Log.LogInfo(e.Message, e, "error");
}
}
public static void SaveComment(Comment comment)
{
try
{
if (string.IsNullOrEmpty(comment.Text))
{
return;
}
DB.DB.Comments_Insert(comment.Code_Id, comment.User_Id, comment.Text);
int? user_id = Model.GetUserIdByCodeId(comment.Code_Id);
if (user_id != null)
{
DB.DB.Notification_Insert((int)user_id, "New comment on your code", comment.Code_Id, comment.User_Id);
}
var mentions = GetMentions(comment.Text);
foreach (var m in mentions)
{
var user = DB.DB.GetUser(m);
if (user.Any())
{
DB.DB.Notification_Insert(Convert.ToInt32(user[0]["id"]), "You've been mentioned in a comment", comment.Code_Id, comment.User_Id);
}
}
}
catch (Exception e)
{
Utils.Log.LogInfo(e.Message, e, "error");
}
}