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

public partial class All_Events : System.Web.UI.Page
{
    PublicMethods ClspUblicMethods = new PublicMethods();
    EMUPDataContext dbEmup = new EMUPDataContext();

    protected void Page_Load(object sender, EventArgs e)
    {
        if(!Page.IsPostBack)
        {
            gvEvents.DataSource = GetAllEventsFree();
            gvEvents.DataBind();

            rpPreEvents.DataSource = GetAllEventsPre();
            rpPreEvents.DataBind();
        }
    }

    public IQueryable GetAllEventsPre()
    {
        var objOrgList = (from objEvents in dbEmup.Event_Creates
                          where 
                           objEvents.UserAdsDet.Status == null && Convert.ToDateTime(objEvents.EventEndDate) >= DateTime.Now
                           && objEvents.UserAdsDet.AdType == "Premium"
                          orderby objEvents.EventEndDate descending
                          //where ((Convert.ToDateTime(objEvents.EventDate) == DateTime.Now) &&
                          //(Convert.ToDateTime(objEvents.EventEndDate)=>DateTime.Now))

                          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,
                              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,

                          }).Take(100);
        return objOrgList;
    }

    public IQueryable GetAllEventsFree()
    {
        var objOrgList = (from objEvents in dbEmup.Event_Creates
                          where
                           objEvents.UserAdsDet.Status == null && Convert.ToDateTime(objEvents.EventEndDate) >= DateTime.Now.AddDays(-1)
                           && objEvents.UserAdsDet.AdType == "Free"
                          orderby objEvents.EventEndDate descending
                          //where ((Convert.ToDateTime(objEvents.EventDate) == DateTime.Now) &&
                          //(Convert.ToDateTime(objEvents.EventEndDate)=>DateTime.Now))

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

}