public ActionResult ItinPartial() { List <ItineraryPlacesModel> model = new List <ItineraryPlacesModel>(); UserModel user = Session["user"] as UserModel; ItineraryDAL itdal = new ItineraryDAL(); List <ItineraryModel> itinerary = itdal.GetAllItinerary(user.UserId); List <int> listOfPlaceIds = itdal.GetItinerary(user.UserId); foreach (var i in itinerary) { ItineraryPlacesModel singleIntinForUser = new ItineraryPlacesModel(); singleIntinForUser.Itinerary = i; List <PlacesModel> listOfPlacesInItin = new List <PlacesModel>(); foreach (var singlePlaceId in listOfPlaceIds) { PlacesModel newPlaceFromItin = new PlacesModel(); newPlaceFromItin = dal.GetSinglePlace(singlePlaceId); listOfPlacesInItin.Add(newPlaceFromItin); } singleIntinForUser.Places = listOfPlacesInItin; model.Add(singleIntinForUser); } return(View("ItinPartial", model)); }
public List <ItineraryPlacesModel> GetAllItineraryPlacesForUser(int userId) { try { List <ItineraryPlacesModel> output = new List <ItineraryPlacesModel>(); PlacesDAL pdal = new PlacesDAL(); using (SqlConnection conn = new SqlConnection(connectionString)) { ItineraryDAL idal = new ItineraryDAL(); List <ItineraryModel> listOfItineraries = idal.GetAllItinerary(userId); for (int i = 0; i < listOfItineraries.Count; i++) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_GetAllItineraryPlaces, conn); cmd.Parameters.AddWithValue("@itineraryId", listOfItineraries[i].Id); SqlDataReader reader = cmd.ExecuteReader(); ItineraryPlacesModel it = new ItineraryPlacesModel(); it.Itinerary = listOfItineraries[i]; List <PlacesModel> placesList = new List <PlacesModel>(); while (reader.Read()) { PlacesModel place = new PlacesModel(); int placeId = Convert.ToInt32(reader["placeId"]); place = pdal.GetSinglePlace(placeId); placesList.Add(place); } it.Places = placesList; output.Add(it); conn.Close(); } } return(output); } //ItineraryDAL idal = new ItineraryDAL(); //List<ItineraryModel> itineraryModels = idal.GetAllItinerary(userId); //try //{ // List<int> output = new List<int>(); // using (SqlConnection conn = new SqlConnection(connectionString)) // { // conn.Open(); // SqlCommand cmd2 = new SqlCommand(SQL_GetAllItineraryPlaces, conn); // SqlDataReader reader2 = cmd2.ExecuteReader(); // foreach (var i in itineraryModels) // { // cmd2.Parameters.AddWithValue("@itineraryId", i.Id); // while(reader2.Read()) // { // int placeId; // placeId = Convert.ToInt32(reader2["id"]); // output.Add(placeId); // } // } // } // return output; //} catch (SqlException ex) { throw; } }