Chat Application integrated into existing asp.net forms sql app.

Chat Application – Separate application launched by buttons/links from existing asp.net forms sql server web app. Would be modal popup windows. All chat history stored in sql server database. Chat Rooms for the different applications by passing the chat_room_type_id CHAT_ROOM_TYPE_ID CHAT_ROOM_TYPE 1. ACTIVITY CLASS – course chat room filtered by who is enrolled in the course. a. SQL SERVER DATABASE – would supply list of who is enrolled by ACTIVITY_CLASS_ID b. Within the class on our application, we will add link to popup app passing in ACTIVITY_CLASS_ID to modal popup. 2. EVALUATION – one on one chat room with student and teacher. a. SQL SERVER DATABASE – would supply list of who is teacher/student by EVALUATION_ID. b. Within the evaluation page on our application, we will add link to popup app passing in EVALUATION_PROCESS_ID to modal popup. 3. GOAL_PLAN – one on one chat room with student and teacher a. SQL SERVER DATABASE – would supply list of who is teacher/student by GOAL_PLAN_ID b. Within the Goal page off our application, we will add link to popup app passing in GOAL_PLAN_ID to modal popup. 4. OPEN CHAT ROOMS – ability to create chat rooms and invite teachers/students. a. SQL SERVER DATABASE – create chat room, chat room name, chat room creator, members. b. Within a section of the website app you can open a link to a chat showing chat rooms with the ability to create new chat rooms. You can also invite people to your chat rooms that you create. Will need section to indicate chat rooms you were invited to and once you invited people to. 5. OPEN CHAT – one on one, click on someone to chat. a. SQL SERVER DATABASE – select person to start chat. b. Any time you can launch the chat app and filter a list (we will supply SP to list people) to start a one on one chat. You will have history and an area to display all one on one chat history. -All chats are real-time and everything is stored in a database.