Пример #1
0
        public void AddToDBTimeNow <T>(ChatPacket chatPack)
        {
            string sql;
            string Time = System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");

            if (typeof(T) == typeof(User))
            {
                User user = BlindChatUtil.ChatPacketToStruct <User>(chatPack);
                sql = $"insert into User (ID, Name, Time, isOnline) values ({user.ID}, {user.Name}, \'{Time}\', {user.Online});";
            }
            else if (typeof(T) == typeof(ChatRoom))
            {
                ChatRoom room = new ChatRoom();
                sql = $"insert into ChatRoom (ID, Name, Time) values ({room.ID},\'{room.Name}\',\'{Time}\');";
            }
            else if (typeof(T) == typeof(ChatRoomJoined))
            {
                ChatRoomJoined roomjoined = new ChatRoomJoined();
                sql = $"insert into ChatRoomJoined (ID, UserID, RoomID, Time) values ({roomjoined.ID},{roomjoined.UserID},{roomjoined.RoomID},\'{Time}\');";
            }
            else if (typeof(T) == typeof(ChatMessage))
            {
                ChatMessage msg = BlindChatUtil.ChatPacketToStruct <ChatMessage>(chatPack);
                sql = $"insert into ChatMessage (UserID, RoomID, Message, Time) values ({msg.UserID},{msg.RoomID},\'{msg.Message}\',\'{msg.Time}\');";
            }
            else
            {
                return;
            }

            ExecuteQuery(sql);
        }
Пример #2
0
        public void ExecuteExit(ChatPacket chatPack)
        {
            string         timeNow    = System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
            ChatRoomJoined roomJoined = BlindChatUtil.ChatPacketToStruct <ChatRoomJoined>(chatPack);

            SendChatPacketToParticipants(chatPack, roomJoined.RoomID);

            string sql = $"delete from ChatRoomJoined where UserID = {roomJoined.UserID} and RoomID = {roomJoined.RoomID};";

            ExecuteQuery(sql);

            ChatMessage message = new ChatMessage();

            message.RoomID = roomJoined.RoomID;
            message.UserID = 0;
            message.Time   = timeNow;

            sql = $"select * from User where ID = {roomJoined.UserID}";

            ChatMessage _message = new ChatMessage();

            message.RoomID = roomJoined.RoomID;
            message.UserID = 0;
            message.Time   = timeNow;

            sql = $"select * from User where ID = {roomJoined.UserID}";
            MySqlDataAdapter adpt = new MySqlDataAdapter(sql, hDB);
            DataSet          ds   = new DataSet();

            adpt.Fill(ds);
            DataRow r = ds.Tables[0].Rows[0];

            User userInfo = (User)GetStructFromDB <User>(r);

            message.Message = $"{userInfo.Name}님이 나갔습니다.";

            byte[]     _data   = BlindNetUtil.StructToByte(message);
            ChatPacket _packet = BlindChatUtil.ByteToChatPacket(_data, ChatType.Message);

            SendChatPacketToParticipants(_packet, message.RoomID);

            //시간을 수정한 메시지를 DB에 등록
            AddToDBTimeNow <ChatMessage>(_packet);
        }
Пример #3
0
        public void ClientUpdateChatRoomJoined(string Time)
        {
            string sql =
                $"select * from ChatRoomJoined " +
                $"where RoomID in " +
                $"(select roomID from ChatRoomJoined where UserID={UserID}) " +
                $"and Time > \'{Time}\' order by Time asc";
            MySqlDataReader rdr = ExecuteSelect(sql);

            while (rdr.Read())
            {
                ChatRoomJoined chatRoomJoined = (ChatRoomJoined)GetStructFromDB <ChatRoomJoined>(rdr);

                byte[] data = BlindNetUtil.StructToByte(chatRoomJoined);

                ChatPacket chatPacket = BlindChatUtil.ByteToChatPacket(data, ChatType.RoomJoined);
                ChatPacketSend(chatPacket);
            }
            rdr.Close();
        }
Пример #4
0
        public void ExecuteInvitation(ChatPacket chatPack)
        {
            ChatRoomJoined roomJoined = BlindChatUtil.ChatPacketToStruct <ChatRoomJoined>(chatPack);

            //사용자 등록
            string timeNow = System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
            string sql     = $"insert into ChatRoomJoined (UserID, RoomID, Time) values ({roomJoined.UserID},{roomJoined.RoomID},\'{timeNow}\');";

            ExecuteQuery(sql);

            //새로 추가한 사용자 검색
            sql = $"select * from ChatRoomJoined where Time = \'{timeNow}\' and UserID={ roomJoined.UserID }";
            MySqlDataReader rdr = ExecuteSelect(sql);

            byte[] data;
            if (rdr.Read())
            {
                roomJoined = (ChatRoomJoined)GetStructFromDB <ChatRoomJoined>(rdr);
                rdr.Close();

                {
                    sql = $"select * from ChatRoom where ID = {roomJoined.RoomID}";

                    rdr = ExecuteSelect(sql);
                    if (rdr.Read())
                    {
                        ChatRoom room = (ChatRoom)GetStructFromDB <ChatRoom>(rdr);

                        rdr.Close();
                        data = BlindNetUtil.StructToByte(room);

                        ChatPacket chatPacket = BlindChatUtil.ByteToChatPacket(data, ChatType.Room);
                        SendChatPacketToUser(chatPacket, roomJoined.UserID);
                    }
                }

                //방 인원 전송
                {
                    sql = $"select * from ChatRoomJoined " +
                          $"where RoomID = {roomJoined.RoomID} order by Time asc";

                    MySqlDataAdapter adptr = new MySqlDataAdapter(sql, hDB);
                    DataSet          dst   = new DataSet();
                    adptr.Fill(dst);

                    foreach (DataRow dr in dst.Tables[0].Rows)
                    {
                        ChatRoomJoined chatRoomJoined = (ChatRoomJoined)GetStructFromDB <ChatRoomJoined>(dr);

                        if (chatRoomJoined.UserID != roomJoined.UserID)
                        {
                            data = BlindNetUtil.StructToByte(chatRoomJoined);

                            ChatPacket chatPacket = BlindChatUtil.ByteToChatPacket(data, ChatType.RoomJoined);
                            SendChatPacketToUser(chatPacket, roomJoined.UserID);
                        }
                    }
                    rdr.Close();
                }



                data = BlindNetUtil.StructToByte(roomJoined);
                //방 사용자들에게 전송
                ChatPacket packet = BlindChatUtil.ByteToChatPacket(data, ChatType.RoomJoined);
                SendChatPacketToParticipants(packet, roomJoined.RoomID);

                ChatMessage message = new ChatMessage();
                message.RoomID = roomJoined.RoomID;
                message.UserID = 0;
                message.Time   = timeNow;

                sql = $"select * from User where ID = {roomJoined.UserID}";
                MySqlDataAdapter adpt = new MySqlDataAdapter(sql, hDB);
                DataSet          ds   = new DataSet();
                adpt.Fill(ds);
                DataRow r        = ds.Tables[0].Rows[0];
                User    userInfo = (User)GetStructFromDB <User>(r);

                message.Message = $"{userInfo.Name}님이 입장하셨습니다.";
                byte[]     _data   = BlindNetUtil.StructToByte(message);
                ChatPacket _packet = BlindChatUtil.ByteToChatPacket(_data, ChatType.Message);
                SendChatPacketToParticipants(_packet, message.RoomID);

                //시간을 수정한 메시지를 DB에 등록
                AddToDBTimeNow <ChatMessage>(_packet);
                Console.WriteLine("invite successed");
            }
            else
            {
                Console.WriteLine("cant find the user");
            }
        }
Пример #5
0
        public object GetStructFromDB <T>(MySqlDataReader rdr)
        {
            object st;

            try
            {
                if (typeof(T) == typeof(User))
                {
                    User user = new User();
                    user.ID         = uint.Parse(rdr["ID"].ToString());
                    user.Online     = int.Parse(rdr["isOnline"].ToString());
                    user.Name       = rdr["Name"].ToString();
                    user.Time       = rdr["Time"].ToString();
                    user.Position   = rdr["Position"].ToString();
                    user.Department = rdr["Department"].ToString();
                    user.Phone      = rdr["Phone"].ToString();
                    user.Email      = rdr["Email"].ToString();
                    user.Birth      = rdr["Birth"].ToString();
                    user.Online     = 0;

                    st = user;
                }
                else if (typeof(T) == typeof(ChatRoom))
                {
                    ChatRoom room = new ChatRoom();
                    room.ID              = int.Parse(rdr["ID"].ToString());
                    room.Name            = rdr["Name"].ToString();
                    room.Time            = rdr["Time"].ToString();
                    room.LastMessageTime = rdr["LastMessageTime"].ToString();

                    st = room;
                }
                else if (typeof(T) == typeof(ChatRoomJoined))
                {
                    ChatRoomJoined roomjoined = new ChatRoomJoined();
                    roomjoined.ID     = int.Parse(rdr["ID"].ToString());
                    roomjoined.UserID = int.Parse(rdr["UserID"].ToString());
                    roomjoined.RoomID = int.Parse(rdr["RoomID"].ToString());
                    roomjoined.Time   = rdr["Time"].ToString();

                    st = roomjoined;
                }
                else if (typeof(T) == typeof(ChatMessage))
                {
                    ChatMessage message = new ChatMessage();
                    message.UserID  = uint.Parse(rdr["UserID"].ToString());
                    message.RoomID  = int.Parse(rdr["RoomID"].ToString());
                    message.Time    = rdr["Time"].ToString();
                    message.Message = rdr["Message"].ToString();
                    message.ID      = int.Parse(rdr["ID"].ToString());

                    st = message;
                }
                else
                {
                    return(null);
                }
                return(st);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                return(null);
            }
        }