public List <Attractions> getAllAttractions() { List <Attractions> listOfAttractions = new List <Attractions>(); SqlConnection con = new SqlConnection { ConnectionString = @"Data Source=DESKTOP-RBTV5AJ\SQLEXPRESS;Initial Catalog=Test;Integrated Security=TrueData Source=DESKTOP-RBTV5AJ\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True" }; con.Open(); SqlCommand cmd8 = new SqlCommand { CommandText = "select * from Attraction", Connection = con }; SqlDataReader rd8 = cmd8.ExecuteReader(); while (rd8.Read()) { Attractions attractions = new Attractions(); var id = rd8[0].ToString(); attractions.AttractionID = Int32.Parse(id); attractions.Attractions_TicketPrice = rd8[1].ToString(); attractions.Attractions_Schedule = rd8[2].ToString(); attractions.Attractions_Name = rd8[4].ToString(); attractions.Attraction_Descriptions = rd8[5].ToString(); var id2 = rd8[3].ToString(); attractions.Attraction_CityID = Int32.Parse(id2); listOfAttractions.Add(attractions); } con.Close(); rd8.Close(); return(listOfAttractions); }
public List <Attractions> random3Attractions(string searchID) { Details det = new Details(); det.Cities.City_Name = searchID; List <Attractions> listOfRandomAtt = new List <Attractions>(); SqlConnection con = new SqlConnection { ConnectionString = @"Data Source=DESKTOP-RBTV5AJ\SQLEXPRESS;Initial Catalog=Test;Integrated Security=TrueData Source=DESKTOP-RBTV5AJ\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True" }; con.Open(); SqlCommand cmd9 = new SqlCommand { CommandText = "SELECT top 3 * from Attraction inner join Cities on CityID=Attraction.Attraction_City where @city_Name=Cities.City_Name ORDER BY NEWID()", Connection = con }; cmd9.Parameters.Add(new SqlParameter("@city_Name", det.Cities.City_Name)); SqlDataReader rd9 = cmd9.ExecuteReader(); while (rd9.Read()) { Attractions attractions = new Attractions(); var id = rd9[0].ToString(); attractions.AttractionID = Int32.Parse(id); attractions.Attractions_TicketPrice = rd9[1].ToString(); attractions.Attractions_Schedule = rd9[2].ToString(); attractions.Attractions_Name = rd9[4].ToString(); attractions.Attraction_Descriptions = rd9[5].ToString(); var id2 = rd9[3].ToString(); attractions.Attraction_CityID = Int32.Parse(id2); listOfRandomAtt.Add(attractions); } con.Close(); rd9.Close(); return(listOfRandomAtt); }