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 bool IsSubscribedEmail(string Email)
{
using (var db = new MusicEventEntities())
{
return(db.EmailSubscribers.Any(e => e.Email == Email));
}
}
public List <EmailSubscriberDataModal> GetAllEmailSubscriber()
{
using (var db = new MusicEventEntities())
{
var subscribers = db.EmailSubscribers.ToList();
return(Mapper.Map <List <EmailSubscriber>, List <EmailSubscriberDataModal> >(subscribers));
}
}
public void SetEmailSentFlag(List <int> Events)
{
using (var db = new MusicEventEntities())
{
db.NewEvents.Where(e => Events.Contains(e.EventID)).ToList().ForEach(e => e.IsNew = 0);
db.SaveChanges();
}
}
public List <EventDataModal> GetTenLatestEvents(int MainCategoryId, string Keyword, DateTime?startdate, string Latitude, string Longitude)
{
using (var db = new MusicEventEntities())
{
var events = db.GetTenLatestEventList(MainCategoryId, Keyword, startdate, Latitude, Longitude).ToList();
return(Mapper.Map <List <GetTenLatestEventList_Result>, List <EventDataModal> >(events));
}
}
public EventDataModal GetHeaderEvent(string Latitude, string Longitude)
{
using (var db = new MusicEventEntities())
{
var evt = db.GetHeaderEvent(Latitude, Longitude).ToList().FirstOrDefault();
return(Mapper.Map <GetHeaderEvent_Result, EventDataModal>(evt));
}
}
public EventDataModal GetEventDetailsById(int EventID, string Latitude, string Longitude)
{
using (var db = new MusicEventEntities())
{
var evt = db.GetEventDetailsById(EventID, Latitude, Longitude).ToList().FirstOrDefault();
return(Mapper.Map <GetEventDetailsById_Result, EventDataModal>(evt));
}
}
public List <EventDataModal> GetAllNewEvents()
{
using (var db = new MusicEventEntities())
{
var events = db.GetAllNewEvents().ToList();
return(Mapper.Map <List <GetAllNewEvents_Result>, List <EventDataModal> >(events));
}
}
public bool SubscribeEmail(string Email)
{
using (var db = new MusicEventEntities())
{
db.EmailSubscribers.Add(new EmailSubscriber {
Email = Email, CreatedOn = DateTime.Now
});
db.SaveChanges();
return(true);
}
}
private GlobalData()
{
db = new MusicEventEntities();
MainCategories = db.MainCategories.ToList();
SubCategories = db.Categories.ToList();
}