/// <summary> /// Write chatmessage to database /// </summary> /// <param name="messageid"> ID of the message itself</param> /// <param name="userid"> ID of the user that sends the message </param> /// <param name="chatid"> ID of the chatroom </param> /// <param name="messagecontent"> The actual content of the message </param> /// <param name="chat"> Object of current chatroom </param> /// <returns></returns> public bool SendMessage(int messageid, int userid, int chatid, string messagecontent) //, Chat chat) { using (ChatModelContainer context = new ChatModelContainer()) { IQueryable <Chat> chatroom = context.ChatSet; var chatroomDestination = (from room in context.ChatSet where room.Id == chatid select room).First(); IQueryable <Message> messageq = context.MessageSet; var record = new Message(); record.Id = messageid; record.Content = messagecontent; record.TimeStamp = DateTime.Now; record.IsReceived = false; record.Chat = chatroomDestination; IQueryable <User> userq = context.UserSet; var account_test = (from act in context.UserSet where act.Id == 2 // Currently the id has been hardcoded, needs to change when account component is finished select act).First(); record.User = account_test; context.MessageSet.Add(record); context.SaveChanges(); return(true); } }
public void CreateChat(int chatroomid, string chatroomname) { using (ChatModelContainer context = new ChatModelContainer()) { IQueryable <Chat> chatq = context.ChatSet; var record = new Chat(); record.Id = chatroomid; record.ChatRoomName = chatroomname; context.ChatSet.Add(record); context.SaveChanges(); //return record; } }
/// <summary> /// Receive a chatmessage /// </summary> /// <param name="chatid"> ID of the chatroom </param> /// <returns> New messages in database </returns> public Message[] RecieveMessage(int chatid) { using (ChatModelContainer context = new ChatModelContainer()) { IQueryable <Message> messages = context.MessageSet; Message[] messageArray = ( from m in messages where m.Chat.Id == chatid select m).ToArray(); return(messageArray); } }
/// <summary> /// Delete a message from chat /// </summary> /// <param name="messageid"> ID of message </param> /// <returns> Bool to determine success of operation </returns> public bool DeleteMessage(int messageid) { using (ChatModelContainer context = new ChatModelContainer()) { var messagecheck = context.MessageSet.Where(b => b.Id == messageid).Count(); if (messagecheck > 0) { // bericht verwijderen var verwijder = context.MessageSet.RemoveRange(context.MessageSet.Where(x => x.Id == messageid)); context.SaveChanges(); return(true); } else { // Kan niet verwijderd worden? return(false); } } }
public bool RemoveChat(int chatid) { // Verwijder alle berichten ChatModelContainer context = new ChatModelContainer(); context.MessageSet.RemoveRange(context.MessageSet.Where(x => x.Chat.Id == chatid)); var VerwijderChat = context.ChatSet.FirstOrDefault(f => f.Id == chatid); if (VerwijderChat != null) { context.ChatSet.Attach(VerwijderChat); context.ChatSet.Remove(VerwijderChat); context.SaveChanges(); return(true); } else { return(false); } }