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

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

    PublicMethods ClsPublicMethods = new PublicMethods();

    protected void Page_Load(object sender, EventArgs e)
    {
        BindGridView();
        Page.MetaDescription = "Jhalak.com,Jhalak Events Listing,Free Classifeds and Business Listing in " + Convert.ToString(Session["loc"]);
    }
    private void BindGridView()
    {

        gvEvents.DataSource = ClsPublicMethods.GetAllEvents();
        gvEvents.DataBind();
    }
    private IQueryable GetEventList()
    {

        var objEvent = (from objEventsList in dbEmup.Event_Creates
                       orderby objEventsList.EventDate ascending
                        select new
                        {
                            EventId = objEventsList.Event_Id,
                            EventName = objEventsList.Event_Name,
                            StartTime = objEventsList.StartTime,
                            EndTime = objEventsList.EndTime,
                            Location = objEventsList.Venue,
                            JhalakEvent = objEventsList.Event_Name.Replace(" ","-").Trim() + "-" + objEventsList.Event_Id,
                            //EventLogo = objEventsList.EventLogo
                            //JhalakPlayer = (objEventsList.FirstName + " " + objEventsList.LastName).Trim().Replace(" ", "-") + "-" + objEventsList.PlayerId

                            AdEventDetail = objEventsList.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() + "-" + objEventsList.AdId,
                            AdOrganizerDetail = objEventsList.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() + "-" + objEventsList.AdId,
                            AdSupplierDetail = objEventsList.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() + "-" + objEventsList.AdId,
                            AdVenueDetail = objEventsList.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() + "-" + objEventsList.AdId,


                        }).Take(10);

        return objEvent;

    }
}