public EventPageDataModal GetEventListBySearch(int MainCategoryId, string Keyword, int PageNumber, int PageSize, string Sort, string Latitude, string Longitude) { using (var db = new MusicEventEntities()) { db.Database.Connection.Open(); EventPageDataModal EventPage = new EventPageDataModal(); EventPage.Events = new List <EventDataModal>(); EventPage.TotalRecords = new List <TotalRecordsDataModal>(); var command = db.Database.Connection.CreateCommand(); command.CommandText = "[dbo].[GetEventListBySearch]"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@MainCategoryId", MainCategoryId)); command.Parameters.Add(new SqlParameter("@Keyword", Keyword)); command.Parameters.Add(new SqlParameter("@PageNumber", PageNumber)); command.Parameters.Add(new SqlParameter("@PageSize", PageSize)); command.Parameters.Add(new SqlParameter("@Sort", Sort)); command.Parameters.Add(new SqlParameter("@Latitude", Latitude)); command.Parameters.Add(new SqlParameter("@Longitude", Longitude)); var reader = command.ExecuteReader(); List <EventDataModal> _events = ((IObjectContextAdapter)db).ObjectContext.Translate <EventDataModal>(reader).ToList(); reader.NextResult(); List <TotalRecordsDataModal> _totalrecords = ((IObjectContextAdapter)db).ObjectContext.Translate <TotalRecordsDataModal>(reader).ToList(); EventPage.Events.AddRange(_events); EventPage.TotalRecords.AddRange(_totalrecords); db.Database.Connection.Close(); return(EventPage); } }
public ActionResult EventList(int MainCategoryId, string Keyword, int PageNumber, int PageSize, string Sort) { string Latitude = Session["ULatitude"] != null ? Session["ULatitude"].ToString() : "0"; string Longitude = Session["ULongitude"] != null ? Session["ULongitude"].ToString() : "0"; EventPageDataModal EventPage = _EventService.GetEventListBySearch(MainCategoryId, Keyword, PageNumber, PageSize, Sort, Latitude, Longitude); List <EventViewModal> Events = Mapper.Map <List <EventDataModal>, List <EventViewModal> >(EventPage.Events); ViewBag.TotalRecords = EventPage.TotalRecords.FirstOrDefault().TotalRecords; return(PartialView("_EventListPartial", Events)); }