public bool AddNewRoom(GroopsRoom newRoom)
        {
            DataClassesContextDataContext db = new DataClassesContextDataContext();

            var thisRoom = new GroopsRoom();

            thisRoom.Name          = newRoom.Name;
            thisRoom.CreatorUserId = newRoom.CreatorUserId;
            thisRoom.ID            = newRoom.ID;


            db.GroopsRooms.InsertOnSubmit(thisRoom);

            //submit the changes to the database
            try
            {
                db.SubmitChanges();
                return(true);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.ToString());
                return(false);
            }
        }
        public bool AddNewUser(GroopsUser oneGroopMember)
        {
            //var ctx = HttpContext.Current;
            //if (ctx != null)
            //{
            //    try
            //    {
            //        var currentData = ((GroopsAPI[])ctx.Cache[CacheKey]).ToList();
            //        currentData.Add(oneGroopMember);
            //        ctx.Cache[CacheKey] = currentData.ToArray();

            //        return true;
            //    }


            //    catch (Exception ex)
            //    {
            //        Console.WriteLine(ex.ToString());
            //        return false;
            //    }
            //}



            DataClassesContextDataContext db = new DataClassesContextDataContext();

            var thisUser = new GroopsUser();

            thisUser.Name  = oneGroopMember.Name;
            thisUser.Email = oneGroopMember.Email;
            thisUser.ID    = oneGroopMember.ID;

            db.GroopsUsers.InsertOnSubmit(thisUser);

            //submit the changes to the database
            try
            {
                db.SubmitChanges();
                return(true);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.ToString());
                return(false);
            }
        }
        public string addNewComment(Guid userId, string message, Guid roomId)
        {
            DataClassesContextDataContext db = new DataClassesContextDataContext();

            GroopsMessages thisMessage = new GroopsMessages();

            thisMessage.Content = message;
            thisMessage.ID      = Guid.NewGuid();
            thisMessage.RoomId  = roomId;
            thisMessage.UserId  = userId;
            thisMessage.Created = DateTime.Now;

            db.GroopsMessages.InsertOnSubmit(thisMessage);

            try
            {
                db.SubmitChanges();
                return(userIdToUserName(userId));
            }
            catch (Exception e)
            {
                return(null);
            }
        }
        public string addNewComment(Guid userId, string message, Guid roomId)
        {
            DataClassesContextDataContext db = new DataClassesContextDataContext();

            GroopsMessages thisMessage = new GroopsMessages();

            thisMessage.Content = message;
            thisMessage.ID = Guid.NewGuid();
            thisMessage.RoomId = roomId;
            thisMessage.UserId = userId;
            thisMessage.Created = DateTime.Now;

            db.GroopsMessages.InsertOnSubmit(thisMessage);

            try
            {

                db.SubmitChanges();
                return userIdToUserName(userId);
            }
            catch (Exception e)
            {

                return null;
            }

        }
        public bool AddNewUser(GroopsUser oneGroopMember)
        {
            //var ctx = HttpContext.Current;
            //if (ctx != null)
            //{
            //    try
            //    {
            //        var currentData = ((GroopsAPI[])ctx.Cache[CacheKey]).ToList();
            //        currentData.Add(oneGroopMember);
            //        ctx.Cache[CacheKey] = currentData.ToArray();

            //        return true;
            //    }


            //    catch (Exception ex)
            //    {
            //        Console.WriteLine(ex.ToString());
            //        return false;
            //    }
            //}



            DataClassesContextDataContext db = new DataClassesContextDataContext();

            var thisUser = new GroopsUser();

            thisUser.Name = oneGroopMember.Name;
            thisUser.Email = oneGroopMember.Email;
            thisUser.ID = oneGroopMember.ID;

            db.GroopsUsers.InsertOnSubmit(thisUser);

            //submit the changes to the database
            try
            {
                db.SubmitChanges();
                return true;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.ToString());
                return false;
            }


        }
        public bool AddNewRoom(GroopsRoom newRoom)
        {

            DataClassesContextDataContext db = new DataClassesContextDataContext();

            var thisRoom = new GroopsRoom();

            thisRoom.Name = newRoom.Name;
            thisRoom.CreatorUserId = newRoom.CreatorUserId;
            thisRoom.ID = newRoom.ID;


            db.GroopsRooms.InsertOnSubmit(thisRoom);

            //submit the changes to the database
            try
            {
                db.SubmitChanges();
                return true;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.ToString());
                return false;
            }


        }