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