Example #1
0
 /// <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);
     }
 }
Example #2
0
 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;
     }
 }
Example #3
0
        /// <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);
            }
        }
Example #4
0
 /// <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);
         }
     }
 }
Example #5
0
        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);
            }
        }