public ActionResult Trip(ExploreClass off)
{
List <ExploreClass> images = new List <ExploreClass>();
string mainconn = ConfigurationManager.ConnectionStrings["app2000"].ConnectionString;
MySqlConnection mysql = new MySqlConnection(mainconn);
string query = "SELECT * FROM image as i " +
"LEFT JOIN trip as t ON t.trip_id = i.trip_id " +
"LEFT JOIN map_coordinates AS m ON t.trip_id = m.trip_id " +
"LEFT JOIN trip_with_type AS tw ON tw.trip_ID=t.trip_ID " +
"WHERE i.trip_id='" + off.ams + "'";
MySqlCommand comm = new MySqlCommand(query);
comm.Connection = mysql;
mysql.Open();
MySqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
images.Add(new ExploreClass
{
trip_id = dr["trip_id"].ToString(),
trip_name = dr["trip_name"].ToString(),
length = dr["length"].ToString(),
difficulty = dr["difficulty"].ToString(),
description = dr["description"].ToString(),
city = dr["city"].ToString(),
website = dr["website"].ToString(),
type_of_trip = dr["type_of_trip"].ToString(),
image = (byte[])dr["Image"],
}
);
GetIcon(dr["type_of_trip"].ToString());
GetDiff(dr["difficulty"].ToString());
}
getMapCoordinates(off.ams);
isRegistered(off.ams);
getRating(off.ams);
mysql.Close();
ViewData["List1"] = images;
return(View("Trip"));
}
public ActionResult LeaveReview(ExploreClass amv)
{
string mainconn = ConfigurationManager.ConnectionStrings["app2000"].ConnectionString;
MySqlConnection mysql = new MySqlConnection(mainconn);
string mainconni = ConfigurationManager.ConnectionStrings["app2000"].ConnectionString;
MySqlConnection mysqli = new MySqlConnection(mainconn);
string user = Request.Cookies["UserCookie"].Value;
string queryi = "INSERT INTO review VALUES(" + amv.ams + ", '" + user + "', " + amv.rating + " );";
MySqlCommand commi = new MySqlCommand(queryi);
commi.Connection = mysqli;
mysqli.Open();
int dri = commi.ExecuteNonQuery();
mysql.Close();
Trip(amv);
return(RedirectToAction("Trip", new { ams = amv.ams }));
}
public ActionResult TripSearch(ExploreClass search)
{
string city;
string tags;
string diff;
List <ExploreClass> images = new List <ExploreClass>();
string mainconn = ConfigurationManager.ConnectionStrings["app2000"].ConnectionString;
MySqlConnection mysql = new MySqlConnection(mainconn);
int i = 0;
string query = "SELECT * FROM trip left join trip_tag on trip.trip_id = trip_tag.Trip_id LEFT JOIN tag on tag.tag= trip_tag.tag where ";
string barSearch = search.bar;
if (!string.IsNullOrEmpty(barSearch))
{
city = barSearch;
tags = barSearch;
diff = barSearch;
}
else
{
city = search.city;
tags = search.tags;
diff = search.diff;
}
if (!string.IsNullOrEmpty(city))
{
if (i == 0)
{
query += " city = '" + city + "'";
i = 1;
}
else
{
query += " AND city = '" + city + "'";
i = 1;
}
}
if (!string.IsNullOrEmpty(tags))
{
if (i == 0)
{
query += " tag.tag LIKE '" + tags + "'";
i = 1;
}
else
{
query += " AND tag.tag LIKE '" + tags + "'";
i = 1;
}
}
if (!string.IsNullOrEmpty(diff))
{
if (i == 0)
{
query += " difficulty LIKE '" + diff + "'";
i = 1;
}
else
{
query += " AND difficulty LIKE '" + diff + "'";
i = 1;
}
}
MySqlCommand comm = new MySqlCommand(query);
comm.Connection = mysql;
mysql.Open();
MySqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
images.Add(new ExploreClass
{
trip_id = dr["trip_id"].ToString(),
trip_name = dr["trip_name"].ToString(),
length = dr["length"].ToString(),
difficulty = dr["difficulty"].ToString(),
description = dr["description"].ToString(),
city = dr["city"].ToString(),
website = dr["website"].ToString(),
}
);
}
mysql.Close();
getTag();
getImage();
ViewBag.ExploreClass = images;
ViewData["list1"] = images;
return(View());
}
