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); }
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); }