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