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

/// <summary>
/// Summary description for EventOrganizersClass
/// </summary>
public class EventOrganizersClass
{
    EMUPDataContext dbEmup = new EMUPDataContext();

    public EventOrganizersClass()
    {
        //
        // TODO: Add constructor logic here
        //
    }



    //public IQueryable GetEventConcepts()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                      where objEvents.ConceptDesignPlanning == true
    //                      orderby objEvents.OrganizerId descending
    //                      select new
    //                      {
    //                          Id = objEvents.OrganizerId,
    //                          OrganizerName = objEvents.OrganizationName,
    //                          Website = objEvents.Website,
    //                          Email = objEvents.Email,
    //                          Address = objEvents.Address


    //                      };
    //    return objOrgList;
    //}

    //public IQueryable GetBudgetting()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                     where objEvents.Budgeting == true
    //                     orderby objEvents.OrganizerId descending
    //                     select new
    //                     {
    //                         Id = objEvents.OrganizerId,
    //                         OrganizerName = objEvents.OrganizationName,
    //                         Website = objEvents.Website,
    //                         Email = objEvents.Email,
    //                         Address = objEvents.Address


    //                     };
    //    return objOrgList;
    //}

    //public IQueryable GetSiteSelection()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                     where objEvents.SiteSelection == true
    //                     orderby objEvents.OrganizerId descending
    //                     select new
    //                     {
    //                         Id = objEvents.OrganizerId,
    //                         OrganizerName = objEvents.OrganizationName,
    //                         Website = objEvents.Website,
    //                         Email = objEvents.Email,
    //                         Address = objEvents.Address


    //                     };
    //    return objOrgList;
    //}


    //public IQueryable GetLogisticVendor()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                     where objEvents.LogisticVendor == true
    //                     orderby objEvents.OrganizerId descending
    //                     select new
    //                     {
    //                         Id = objEvents.OrganizerId,
    //                         OrganizerName = objEvents.OrganizationName,
    //                         Website = objEvents.Website,
    //                         Email = objEvents.Email,
    //                         Address = objEvents.Address


    //                     };
    //    return objOrgList;
    //}

    //public IQueryable GetTicketing()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                     where objEvents.TicketingRegistration == true
    //                     orderby objEvents.OrganizerId descending
    //                     select new
    //                     {
    //                         Id = objEvents.OrganizerId,
    //                         OrganizerName = objEvents.OrganizationName,
    //                         Website = objEvents.Website,
    //                         Email = objEvents.Email,
    //                         Address = objEvents.Address


    //                     };
    //    return objOrgList;
    //}


    //public IQueryable GetPermitLicence()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                     where objEvents.PermitLicence == true
    //                     orderby objEvents.OrganizerId descending
    //                     select new
    //                     {
    //                         Id = objEvents.OrganizerId,
    //                         OrganizerName = objEvents.OrganizationName,
    //                         Website = objEvents.Website,
    //                         Email = objEvents.Email,
    //                         Address = objEvents.Address


    //                     };
    //    return objOrgList;
    //}



    ////public IQueryable GetExhibitSponser()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.ExhibitSponsor == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}


    ////public IQueryable GetMarketing()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.MarketingCommunication == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}


    ////public IQueryable GetArtist()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.ArtistSpeaker == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}


    //public IQueryable GetAudio_Video()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                     where objEvents.Audio_Video == true
    //                     orderby objEvents.OrganizerId descending
    //                     select new
    //                     {
    //                         Id = objEvents.OrganizerId,
    //                         OrganizerName = objEvents.OrganizationName,
    //                         Website = objEvents.Website,
    //                         Email = objEvents.Email,
    //                         Address = objEvents.Address


    //                     };
    //    return objOrgList;
    //}


    //public IQueryable GetSMSServices()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                     where objEvents.MobileApp_Msg_Services == true
    //                     orderby objEvents.OrganizerId descending
    //                     select new
    //                     {
    //                         Id = objEvents.OrganizerId,
    //                         OrganizerName = objEvents.OrganizationName,
    //                         Website = objEvents.Website,
    //                         Email = objEvents.Email,
    //                         Address = objEvents.Address


    //                     };
    //    return objOrgList;
    //}


    //public IQueryable GetAccounting()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                     where objEvents.AccountingRevenue == true
    //                     orderby objEvents.OrganizerId descending
    //                     select new
    //                     {
    //                         Id = objEvents.OrganizerId,
    //                         OrganizerName = objEvents.OrganizationName,
    //                         Website = objEvents.Website,
    //                         Email = objEvents.Email,
    //                         Address = objEvents.Address


    //                     };
    //    return objOrgList;
    //}
    //public IQueryable GetFood_Bevarage()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                     where objEvents.FoodBevarage == true
    //                     orderby objEvents.OrganizerId descending
    //                     select new
    //                     {
    //                         Id = objEvents.OrganizerId,
    //                         OrganizerName = objEvents.OrganizationName,
    //                         Website = objEvents.Website,
    //                         Email = objEvents.Email,
    //                         Address = objEvents.Address


    //                     };
    //    return objOrgList;
    //}



    //public IQueryable GetDecorPlanning()
    //{
    //    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    //                     where objEvents.DecorPlanning == true
    //                     orderby objEvents.OrganizerId descending
    //                     select new
    //                     {
    //                         Id = objEvents.OrganizerId,
    //                         OrganizerName = objEvents.OrganizationName,
    //                         Website = objEvents.Website,
    //                         Email = objEvents.Email,
    //                         Address = objEvents.Address


    //                     };
    //    return objOrgList;
    //}


    ////public IQueryable GetEntertainmnet()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.EntertairnemntAttractions == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}


    ////public IQueryable GetSoundLighting()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.SoundLighting == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}


    ////public IQueryable GetTransportation()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.Transportation == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}


    ////public IQueryable GetSecurity()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.SecurityEmergency == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}


    ////public IQueryable GetSiteCleanUp()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.SiteCleanUp == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}


    ////public IQueryable GetParty()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.PartyGifts == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}


    ////public IQueryable GetInnovative()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.InnovativeConcepts == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}


    ////public IQueryable GetExcursions()
    ////{
    ////    var objOrgList = from objEvents in dbEmup.Event_Oraganization_Creates
    ////                     where objEvents.Excursions == true
    ////                     orderby objEvents.OrganizerId descending
    ////                     select new
    ////                     {
    ////                         Id = objEvents.OrganizerId,
    ////                         OrganizerName = objEvents.OrganizationName,
    ////                         Website = objEvents.Website,
    ////                         Email = objEvents.Email,
    ////                         Address = objEvents.Address


    ////                     };
    ////    return objOrgList;
    ////}

}