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