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

public partial class MainForms_ServicesLocalBiz_SportsTaining_LoadLogo : System.Web.UI.Page
{
    EMUPDataContext dbEmup = new EMUPDataContext();
    protected void Page_Load(object sender, EventArgs e)
    {

        if (Convert.ToString(Request.QueryString["AdImageId"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);



            {
                var obj = (from objImg in dbEmup.UserAdsImagesDets
                           where objImg.UserAdImageId == Convert.ToInt16(Request["AdImageId"])
                           select objImg).Take(1);
                UserAdsImagesDet objI;

                objI = obj.SingleOrDefault();
                if (Convert.ToString(objI.Image).Length != 0)
                {

                    Byte[] bytImage = (Byte[])objI.Image.ToArray();
                    Response.BinaryWrite(bytImage);
                }

            }
        }

        // to get all ad images
        if (Convert.ToString(Request.QueryString["DId"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);



            {
                var obj = (from objImg in dbEmup.UserAdsImagesDets
                          where objImg.UserAdId == Convert.ToInt16(Request["DId"])
                          select objImg).Take(1);
                UserAdsImagesDet objI;
                
                objI = obj.SingleOrDefault();
                if (objI != null)
                {
                    if (Convert.ToString(objI.Image).Length != 0)
                    {

                        Byte[] bytImage = (Byte[])objI.Image.ToArray();
                        Response.BinaryWrite(bytImage);
                    }
                }
            }


        }



        // to get Organizer Image
        if (Convert.ToString(Request.QueryString["OrgAdId"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);



            {
                var obj = from objImg in dbEmup.UserAdsImagesDets
                          where objImg.UserAdImageId == Convert.ToInt16(Request["OrgAdId"])
                          select objImg;
                UserAdsImagesDet objI;

                objI = obj.SingleOrDefault();
                if (objI != null)
                {
                    if (Convert.ToString(objI.Image).Length != 0)
                    {

                        Byte[] bytImage = (Byte[])objI.Image.ToArray();
                        Response.BinaryWrite(bytImage);
                    }
                }
            }


        }


		// to get Sponsor image
		if (Convert.ToString(Request.QueryString["SponsorPhoto"]) != null)
		{

			Response.Buffer = true;
			Response.Charset = "";
			Response.Cache.SetCacheability(HttpCacheability.NoCache);
			{
				var obj = from objImg in dbEmup.Event_Sponsor_Creates
						  where objImg.Sponsor_Id == Convert.ToInt16(Request["SponsorPhoto"])
						  select objImg;
				Event_Sponsor_Create objI;
				objI = obj.SingleOrDefault();
				if (objI != null)
				{
					if (Convert.ToString(objI.Logo).Length != 0)
					{

						Byte[] bytImage = (Byte[])objI.Logo.ToArray();
						Response.BinaryWrite(bytImage);
					}
				}
			}


		}

		// to get Event Logo
		if (Convert.ToString(Request.QueryString["Id"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);



            {
                var obj = from objImg in dbEmup.Event_Creates
                          where objImg.AdId == Convert.ToInt16(Request["Id"])
                          select objImg;
                Event_Create objI;
                objI = obj.SingleOrDefault();
                if (objI != null)
                {
                    if (Convert.ToString(objI.EventLogo).Length != 0)
                    {

                        Byte[] bytImage = (Byte[])objI.EventLogo.ToArray();
                        Response.BinaryWrite(bytImage);
                    }
                }
            }


        }


		// to get Event Ticket Seating Image
		if (Convert.ToString(Request.QueryString["TicketId"]) != null)
		{

			Response.Buffer = true;
			Response.Charset = "";
			Response.Cache.SetCacheability(HttpCacheability.NoCache);



			{
				var obj = from objImg in dbEmup.Event_Ticket_Mgmts
						  where objImg.AdId == Convert.ToInt16(Request["TicketId"])
						  select objImg;
				Event_Ticket_Mgmt objI;
				objI = obj.SingleOrDefault();
				if (objI != null)
				{
					if (Convert.ToString(objI.SeatingArrangement).Length != 0)
					{

						Byte[] bytImage = (Byte[])objI.SeatingArrangement.ToArray();
						Response.BinaryWrite(bytImage);
					}
				}
			}


		}


		// to get all ad images
		if (Convert.ToString(Request.QueryString["GuestPhoto"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);



            {
                var obj = from objImg in dbEmup.Event_Guests
                          where objImg.Event_Guest_Id    == Convert.ToInt16(Request["GuestPhoto"])
                          select objImg;
                Event_Guest objI;
                objI = obj.SingleOrDefault();
                if (objI != null)
                {
                    if (Convert.ToString(objI.GuestPhoto).Length != 0)
                    {

                        Byte[] bytImage = (Byte[])objI.GuestPhoto.ToArray();
                        Response.BinaryWrite(bytImage);
                    }
                }
            }


        }
        // to get all ad images
        if (Convert.ToString(Request.QueryString["PartnerLogo"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);



            {
                var obj = from objImg in dbEmup.Event_Partners
                          where objImg.Event_PartnerId == Convert.ToInt16(Request["PartnerLogo"])
                          select objImg;
                Event_Partner    objI;
                objI = obj.SingleOrDefault();
                if (objI != null)
                {
                    if (Convert.ToString(objI.PartnerLogo).Length != 0)
                    {

                        Byte[] bytImage = (Byte[])objI.PartnerLogo.ToArray();
                        Response.BinaryWrite(bytImage);
                    }
                }
            }


        }
       
        if (Convert.ToString(Request.QueryString["UserId"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);



            {
                var obj = from objImg in dbEmup.UserDets
                          where objImg.UserSerNo == Convert.ToInt16(Request["UserId"])
                          select objImg;
                UserDet objI;
                objI = obj.SingleOrDefault();
                if (objI != null)
                {
                    if (Convert.ToString(objI.BusinessLogo).Length != 0)
                    {

                        Byte[] bytImage = (Byte[])objI.BusinessLogo.ToArray();
                        Response.BinaryWrite(bytImage);
                    }
                }
            }


        }

        if (Convert.ToString(Request.QueryString["BusinessFyler"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);



            {
                var obj = from objImg in dbEmup.UserDets
                          where objImg.UserSerNo == Convert.ToInt16(Request["BusinessFyler"])
                          select objImg;
                UserDet objI;
                objI = obj.SingleOrDefault();
                if (objI != null)
                {
                    if (Convert.ToString(objI.BusinessFlyer).Length != 0)
                    {

                        Byte[] bytImage = (Byte[])objI.BusinessFlyer.ToArray();
                        Response.BinaryWrite(bytImage);
                    }
                }
            }


        }


        if (Convert.ToString(Request.QueryString["AdImageId"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);



            {
                var obj = (from objImg in dbEmup.UserAdsImagesDets
                           where objImg.UserAdImageId == Convert.ToInt16(Request["AdImageId"])
                           select objImg).Take(1);
                UserAdsImagesDet objI;

                objI = obj.SingleOrDefault();
                if (Convert.ToString(objI.Image).Length != 0)
                {

                    Byte[] bytImage = (Byte[])objI.Image.ToArray();
                    Response.BinaryWrite(bytImage);
                }

            }
        }
        if (Convert.ToString(Request.QueryString["CelebrityOfficailPhoto"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);



            {
                var objA = from objImg in dbEmup.CelebrityDets
                           where objImg.CelebrityId == Convert.ToInt16(Request["CelebrityOfficailPhoto"])
                           select objImg;
                CelebrityDet objC = objA.FirstOrDefault();
                if (objC != null)
                {
                    if (Convert.ToString(objC.CelebrityOfficialImage).Length != 0)
                    {

                        Byte[] bytImage = (Byte[])objC.CelebrityOfficialImage.ToArray();
                        Response.BinaryWrite(bytImage);
                    }
                }
            }


        }

        if (Convert.ToString(Request.QueryString["ImagesId"]) != null)
        {

            Response.Buffer = true;
            Response.Charset = "";
            Response.Cache.SetCacheability(HttpCacheability.NoCache);
            {
                var obj = from objImg in dbEmup.UserAdsImagesDets
                           where objImg.UserAdImageId == Convert.ToInt16(Request["ImagesId"])
                           select objImg;
                UserAdsImagesDet objI;

                objI = obj.SingleOrDefault();
                if (Convert.ToString(objI.Image).Length != 0)
                {

                    Byte[] bytImage = (Byte[])objI.Image.ToArray();
                    Response.BinaryWrite(bytImage);
                }

            }
        }

        Response.Flush();
        Response.End();
    }


}