public List <LikeViewModel> GetFilteredListLikes(LikeBindingModel model)
{
using (var context = new ForumDatabase())
{
return(context.Like.Where(rec => rec.Messageid == model.IdMessage).Select(rec => new LikeViewModel
{
LoginUser = rec.Visitorlogin,
IdMessage = rec.Messageid
}).ToList());
}
}
public List <TopicViewModel> GetFullListTopic()
{
using (var context = new ForumDatabase())
{
return(context.Topic.Include(rec => rec.Message)
.Select(rec => new TopicViewModel
{
Name = rec.Name,
NumberOfVisitors = rec.Numberofvisitors,
NumberOfMessages = rec.Numberofmessages,
}).ToList());
}
}
public List <ModeratorViewModel> GetFullListModerators()
{
using (var context = new ForumDatabase())
{
return(context.Moderator
.Select(rec => new ModeratorViewModel
{
LoginUser = rec.Login,
Password = rec.Password,
Email = rec.Email,
TotalTime = rec.TotalTime,
AmountOfHelp = rec.Amountofhelp
}).ToList());
}
}
public List <MessageViewModel> GetFilteredListMessages(MessageBindingModel model)
{
using (var context = new ForumDatabase())
{
return(context.Message.Include(rec => rec.Like).Where(rec => rec.Topicname.Contains(model.NameTopic))
.Select(rec => new MessageViewModel
{
Id = rec.Id,
Text = rec.Text,
Time = rec.Time,
LoginUser = rec.Visitorlogin,
NameTopic = rec.Topicname,
}).ToList());
}
}
public List <VisitorViewModel> GetFullListVisitors()
{
using (var context = new ForumDatabase())
{
return(context.Visitor
.Select(rec => new VisitorViewModel
{
LoginUser = rec.Login,
Password = rec.Password,
Email = rec.Email,
TotalTime = rec.TotalTime,
Status = rec.Status,
Decency = rec.Decency,
CountOfMessages = rec.Countmessages,
}).ToList());
}
}
