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

public partial class Default2 : System.Web.UI.Page
{
    EMUPDataContext dbEmup = new EMUPDataContext();
    MailServicesCls clsMail = new MailServicesCls();
    string organizerName { set; get; }
    string ticketType { set; get; }
    StringBuilder ticketTypes = new StringBuilder();

    StringBuilder ticketQuantities = new StringBuilder();
    int tickeTotQty = 0;
    int tickePrice = 0;
    string tempFee { set; get; }

    int ticketId = 0;
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {
          // clsMail.BookTicketMail("Shailesh", Convert.ToString("Jhalak Organizer"), Convert.ToString("123456"), Convert.ToString("2"), "Kids", Convert.ToString("shailesh.gajula@sudimna.com"), "susheelg@sudimna.com", Convert.ToString("jhalak test event"), Convert.ToString("3"), Convert.ToString("100"), Convert.ToString("10-10-2010"), Convert.ToString("Hyderabad"));
            if (Convert.ToString(Request.QueryString["p"]) == "cancel")
            {
               
                Response.Redirect("Default.aspx");

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


                GetTicketReceipt();
                GetTicketDetails(Convert.ToInt16(Request.QueryString["RId"]));
                BindGrid(Convert.ToInt16(Request.QueryString["RId"]));
               

                if (litServiceFee.Text == "False")
                {
                    divServiceFee.Visible = true;
                }
                else
                {
                    divServiceFee.Visible = false;
                }

                try
                {

                    gvComp.DataSource = GetCompanionDet(Convert.ToInt16(Request.QueryString["RId"]));
                    gvComp.DataBind();

                }
                catch
                {

                }
                try
                {
                   //tempFee=Convert.ToString( (4 / Convert.ToInt16(lblTotalCost.Text) * 100));
                    clsMail.BookTicketMail(Convert.ToString(litBuyerName.Text),Convert.ToString(organizerName),Convert.ToString(lbltransactionId.Text),Convert.ToString(tempFee),ticketTypes.ToString(),Convert.ToString(litEmailId.Text),litOrgMailId.Text, Convert.ToString(lblEventName.Text), Convert.ToString(lblTotalTickets.Text), Convert.ToString(lblTotalCost.Text), Convert.ToString(litEventDate.Text), Convert.ToString(lblEventLocation.Text));
                }
                catch
                {

                }
                //try
                //{

                //    clsMail.BookTicketOrganizerMail(Convert.ToString(litOrgMailId.Text), Convert.ToString(litBuyerName.Text), Convert.ToString(lblEventName.Text), Convert.ToString(lblTotalTickets.Text), Convert.ToString(lblTotalCost.Text), Convert.ToString(litEventDate.Text), Convert.ToString(lblEventLocation.Text));
                //}
                //catch
                //{

                //}
               // clsMail.BookTicketMail(Convert.ToString("shailesh.gajula@sudimna.com"), Convert.ToString(lblEventName.Text), Convert.ToString(lblTotalTickets.Text), Convert.ToString(lblTotalCost.Text), Convert.ToString(litEventDate.Text), Convert.ToString(lblEventLocation.Text));
            }
        }
    }

    private IQueryable GetTicketDetails(int id)
    {

        var obj = from objT in dbEmup.Event_Ticket_Buy_Details
                  where objT.TicketReceiptId == id
                  select new
                  {
                      EventName = objT.UserAdsDet.AdTitle,
                      TicketType = objT.Event_Ticket_Mgmt.TicketType,
                      Qty = objT.Quantity,
                      Cost = objT.TotalCost,

                  };
        return obj;


    }

    private void GetTicketReceipt()
    {


        var obj = (from objT in dbEmup.Event_Ticket_Buyer_Dets
                   where objT.TicketReceiptId == Convert.ToInt16(Request.QueryString["RId"])
                   select objT).Take(1);

        Event_Ticket_Buyer_Det objR = obj.SingleOrDefault();

        lblTotalCost.Text = "$" + "" + Convert.ToString(objR.Event_Ticket_Receipt_Det.TotalCost);
        if (lblTotalCost.Text.Contains(".") == true)
        {
            lblTotalCost.Text = "$" + "" + Convert.ToString(objR.Event_Ticket_Receipt_Det.TotalCost);
        }
        else
        {
            lblTotalCost.Text = "$" + "" + Convert.ToString(objR.Event_Ticket_Receipt_Det.TotalCost) + "" + ".00";
        }

        lblTotalTickets.Text = Convert.ToString(objR.Event_Ticket_Receipt_Det.TotQty);
        lblBookingDate.Text = Convert.ToDateTime(objR.CreatedDate).ToShortDateString();
        lbltransactionId.Text = Convert.ToString(objR.Event_Ticket_Receipt_Det.Event_ReceiptId);
        if (Convert.ToString(objR.Event_Create.ServiceTax) != "")
        {
            litServiceFee.Text = Convert.ToString(objR.Event_Create.ServiceTax);
        }

        litEmailId.Text = Convert.ToString(objR.BuyerEmailId);
        lblEventName.Text = Convert.ToString(objR.UserAdsDet.AdTitle);
        litOrgMailId.Text = Convert.ToString(objR.UserAdsDet.UserEmailId);
        organizerName = Convert.ToString(objR.UserAdsDet.UserDet.Name);
        lblEventDate.Text = Convert.ToString(objR.Event_Create.EventDate);
        lblEventLocation.Text = Convert.ToString(objR.UserAdsDet.City);
        litBuyerName.Text = Convert.ToString(objR.UserDet.Name);
        lblBuyerName.Text = Convert.ToString(objR.UserDet.Name);
        litEventDate.Text = Convert.ToString(objR.Event_Create.EventDate);
        litAdid.Text = Convert.ToString(objR.AdId);
        ticketType = Convert.ToString(objR.Event_Ticket_Mgmt.TicketType);





        //private void GetTicketReceipt()
        //{
        //    var obj = from objT in dbEmup.Event_Ticket_Receipt_Dets
        //              where objT.Event_ReceiptId == Convert.ToInt16(Request.QueryString["RId"])
        //              select objT;

        //    Event_Ticket_Receipt_Det objR = obj.SingleOrDefault();

        //    lblTotalCost.Text ="$" + Convert.ToString(objR.TotalCost)+".00" ;
        //    lblTotalTickets.Text = Convert.ToString(objR.TotQty);

        //    lbltransactionId.Text = Convert.ToString(objR.Event_ReceiptId);
        //    litEmailId.Text = Convert.ToString(objR.UserAdsDet.UserEmailId);
        //    //litEmailId.Text = Convert.ToString(objR.Event_Ticket_Buyer_Dets.);
        //    Test(Convert.ToInt16(objR.AdId));


        //}



    }

        private IQueryable GetTickets(int receiptid)
    {
        var obj = from objB in dbEmup.Event_Ticket_Buy_Details
                  where objB.TicketReceiptId == receiptid
                  select new

                  {
                      TicketType = objB.Event_Ticket_Mgmt.TicketType,
                      Quanity = objB.Quantity,
                      UnitPrice = "$" + "" + objB.Event_Ticket_Mgmt.UnitPrice + "" + ".00",
                      Cost = "$" + "" + objB.TotalCost + "" + ".00",
                      ServiceTax = "",
                      //BookingDate = objB.Event_Ticket_Receipt_Det.Event_Ticket_Buyer_Dets.CreatedDate,
                      //TransactionID = objB.Event_Ticket_Receipt_Det.Event_ReceiptId,

                  };

        return obj;


    }

    private IQueryable GetTicketsData(int receiptid)
    {
        var obj = from objB in dbEmup.Event_Ticket_Buyer_Dets
                  where objB.TicketReceiptId == receiptid
                  select new

                  {
                      BookingDate = objB.CreatedDate,
                      TransactionID = objB.Event_Ticket_Receipt_Det.Event_ReceiptId,
                      TotalTickets = objB.Event_Ticket_Receipt_Det.TotQty,
                      TotalCost = "$" + "" + objB.TotalCost + "" + ".00",
                  };

        return obj;


    }



    private IQueryable GetCompanionDet(int receiptid)
    {
        var obj = from objB in dbEmup.Event_Ticket_Buyer_Companian_Dets
               where objB.TicketReceiptId == receiptid
                  select new

                  {
                      Name = objB.Name,
                      Email = objB.Email,
                      Contact = objB.ContactNo,
                      Location = objB.Location,
                  };

        return obj;


    }


    private void BindGrid(int recieptid)
    {
        grdEvent.DataSource = GetTickets(recieptid);
        grdEvent.DataBind();


        foreach (GridViewRow gr in grdEvent.Rows)
        {
            ticketTypes.AppendLine("<div style='font-size:14px; font-weight:normal;padding:5px'>Ticket Type: " + gr.Cells[0].Text + "</div>");
            ticketTypes.AppendLine("<div style='font-size:14px; font-weight:normal;padding:5px'>No.Of Tickets : " + gr.Cells[1].Text + "</div>");
            // ticketTypes = ticketTypes +  gr.Cells[0].Text;
            //ticketQuantities = ticketQuantities + gr.Cells[1].Text;

        }
    }






}