public static void PostMessage(string author, string authorIp, int chatRoomId, string message)
{
ChatRoomEntities database = new ChatRoomEntities();
Message newMessage = new Message();
newMessage.Author = author;
newMessage.ChatRoomID = chatRoomId;
newMessage.MessageDate = DateTime.Now;
newMessage.MessageText = message;
newMessage.AuthorIP = authorIp;
database.Messages.AddObject(newMessage);
database.SaveChanges();
}
public static List <ChatRoom> GetChatRooms(List <int> openedChatRooms)
{
ChatRoomEntities database = new ChatRoomEntities();
List <ChatRoom> chatRooms = new List <ChatRoom>();
foreach (var chatRoomId in openedChatRooms)
{
var chatRoom = (from p in database.ChatRooms.Include("Messages") where p.ChatRoomID == chatRoomId select p).FirstOrDefault();
if (chatRoom != null)
{
chatRooms.Add(chatRoom);
}
}
return(chatRooms);
}
public static List <ChatRoom> GetAllChatRooms()
{
ChatRoomEntities database = new ChatRoomEntities();
return((from p in database.ChatRooms.Include("Messages") select p).ToList());
}
