Exemplo n.º 1
0
        public void CreateRoomTest()
        {
            UserController user = new UserController();
            HostJoin       join = new HostJoin();

            join.Name     = "TESTINGUSER";
            join.RoomName = "TESTINGROOM";
            string result = user.CreateRoom(join);

            string[] parts = result.Split('|');
            rooms.Add(int.Parse(parts[3]));
            Assert.AreEqual(parts[0], join.Name);
        }
Exemplo n.º 2
0
        public string CreateRoom([FromBody] HostJoin info)
        {
            SqlConnection connection = new SqlConnection(connectionString);
            SqlCommand    command    = new SqlCommand("usp_addHost", connection);

            command.CommandType = System.Data.CommandType.StoredProcedure;
            command.Parameters.Add(new SqlParameter("@Username", info.Name));
            command.Parameters.Add(new SqlParameter("@RoomName", info.RoomName));
            connection.Open();
            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataTable      table   = new DataTable();

            adapter.Fill(table);
            connection.Close();

            string username2 = table.Rows[0][0].ToString();
            string userID    = table.Rows[0][1].ToString();
            string roomname2 = table.Rows[0][2].ToString();
            string roomID    = table.Rows[0][3].ToString();
            string hostID    = table.Rows[0][4].ToString();

            return(username2 + "|" + userID + "|" + roomname2 + "|" + roomID + "|" + hostID);
        }