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