using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    PublicMethods clsPublicMethods = new PublicMethods();
    EMUPDataContext dbEmup = new EMUPDataContext();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            getAllEvents();
        }
    }
    private void getAllEvents()
    {
        gvAllEvents.DataSource = GetAllEvents();
        gvAllEvents.DataBind();


    }
    public IQueryable GetAllEvents()
    {
        var objOrgList = (from objEvents in dbEmup.Event_Creates
                          where
                         objEvents.UserAdsDet.Status == null && Convert.ToDateTime(objEvents.EventEndDate) >= DateTime.Now && objEvents.UserAdsDet.UserEmailId == "gopidesitweet@gmail.com"
                          //  objEvents.UserAdsDet.Status == null && Convert.ToDateTime(objEvents.EventEndDate) >= DateTime.Now 
                          orderby objEvents.UserAdsDet.AdType



                          select new
                          {
                              AdId = objEvents.AdId,
                              Id = objEvents.AdId,
                              Title = objEvents.Event_Name,
                              AdTitle = objEvents.Event_Name,
                              City = objEvents.UserAdsDet.City,
                              Location = objEvents.UserAdsDet.City,
                              EventDate = objEvents.EventDate,
                              Date = objEvents.EventDate,

                              StartTime = objEvents.StartTime,
                              EndTime = objEvents.EndTime,
                              adtype = objEvents.UserAdsDet.AdType,
                              AdEventDetail = objEvents.UserAdsDet.City.Replace(",", "-") + "-" + objEvents.Event_Name.Replace(" ", "-").Replace(",", "").Replace(":", "").Replace("!", "").Replace("@", "").Replace("#", "").Replace("$", "").Replace("%", "").Replace("^", "").Replace("&", "").Replace("*", "").Replace("(", "").Replace(")", "").Replace("+", "").Replace("=", "").Replace("{", "").Replace("}", "").Replace(";", "").Replace("'", "").Replace("<", "").Replace(">", "").Replace("/", "").Replace("?", "").Replace("|", "").Trim() + "-" + objEvents.AdId,

                          }).OrderBy(d => Convert.ToDateTime(d.EventDate));
        return objOrgList;
    }
}