public List <MessageModel> GetComments(int messageId)
{
using (var db = new DBModelDataContext())
{
var replies = db.Messages.Where(r => r.MessageId.HasValue && r.MessageId.Value == messageId)
.Select(r => new MessageModel
{
UserName = r.UserName,
DatePosted = r.DatePosted,
Id = r.Id,
MessageId = r.MessageId,
TextMessage = r.TextMessage
}).ToList();
return(replies);
}
}
public int AddMessage(MessageModel model)
{
using (var db = new DBModelDataContext())
{
var dbmsg = new Message
{
MessageId = model.MessageId,
UserName = model.UserName,
TextMessage = model.TextMessage,
DatePosted = DateTime.Now
};
db.Messages.InsertOnSubmit(dbmsg);
db.SubmitChanges();
return(dbmsg.Id);
}
}
public List <MessageModel> GetMessages(int take, int skip)
{
using (var db = new DBModelDataContext())
{
var msgs = db.Messages.Where(r => r.MessageId == null)
.OrderByDescending(r => r.DatePosted)
.Skip(skip)
.Take(take)
.Select(r => new MessageModel
{
UserName = r.UserName,
DatePosted = r.DatePosted,
Id = r.Id,
MessageId = r.MessageId,
TextMessage = r.TextMessage,
Comments = db.Messages.Count(c => c.MessageId == r.Id)
}).ToList();
return(msgs);
}
}
