public void CanYouGetVenueInfoByID()
{
List <ListedVenue> venue = venueDAO.GetVenueInfoByID(6);
ListedVenue temp = new ListedVenue
{
VenueName = "Blue Nomad Outpost"
};
Assert.AreEqual("Blue Nomad Outpost", temp.VenueName);
}
public List <ListedVenue> GetVenueInfoByID(int venueId)
{
List <ListedVenue> venueInfo = new List <ListedVenue>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlGetVenueInfoById, conn);
cmd.Parameters.AddWithValue("@id", venueId);
SqlDataReader reader = cmd.ExecuteReader();
List <string> categories = new List <string>();
while (reader.Read())
{
ListedVenue lV = new ListedVenue();
lV.VenueName = Convert.ToString(reader["VenueName"]);
lV.VenueDescription = Convert.ToString(reader["VenueDescription"]);
lV.CityName = Convert.ToString(reader["CityName"]);
lV.StateName = Convert.ToString(reader["StateName"]);
categories.Add(Convert.ToString(reader["CategoryName"]));
lV.CategoryName = categories;
venueInfo.Add(lV);
}
}
}
catch (SqlException ex)
{
Console.WriteLine("ERROR");
Console.WriteLine(ex.Message);
}
return(venueInfo);
}
