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

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

    int tickeTotQty = 0;
    int tickePrice = 0;

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

        if (!Page.IsPostBack)
        {
            if (Convert.ToString(Request.QueryString["p"]) == "cancel")
            {
                //if (Request.Cookies["ticketInfo"] != null)
                //{
                //    //lblMsg.Text = "Ticket id:" + Convert.ToString(Server.HtmlEncode(Request.Cookies["ticketInfo"]["ticketid"])) + "Qty:" + Convert.ToString(Server.HtmlEncode(Request.Cookies["ticketInfo"]["availableQty"]));
                //    UpdateAvailableQty(Convert.ToInt16(Server.HtmlEncode(Request.Cookies["ticketInfo"]["ticketid"])), Convert.ToInt32(Server.HtmlEncode(Request.Cookies["ticketInfo"]["availableQty"])));
                //}

                Response.Redirect("Default.aspx");

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

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



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


                
                Response.Redirect("Event-Receipt.aspx?RId=" + Convert.ToString(Request.QueryString["RId"]));
            }
        }
    }

    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);
        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);
        lblEventDate.Text = Convert.ToString(objR.Event_Create.EventDate);
        lblEventLocation.Text = Convert.ToString(objR.UserAdsDet.City);
        //  Test(Convert.ToInt16(objR.AdId));


    }


    //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 void BindGrid(int recieptid)
    {
        grdEvent.DataSource = GetTickets(recieptid);
        grdEvent.DataBind();
    }

    private void BindTicketData(int recieptid)
    {
        gvTicketDet.DataSource = GetTicketsData(recieptid);
        gvTicketDet.DataBind();
    }

    private void UpdateAvailableQty(int ticketId, int availableQty)
    {
        Event_Ticket_Mgmt obj;
        obj = dbEmup.Event_Ticket_Mgmts.SingleOrDefault(x => x.Tiket_Mgmt_Id == ticketId);

        obj.AvailableQty = availableQty;

        dbEmup.SubmitChanges();
        //lblMsg.Text = "Updated Available Quantity";
    }

    private void SaveTicketBuyerDet(int AdId, int EventId, int ticketId, int qty, string cost, int receiptid, string email)
    {
        try
        {
            Event_Ticket_Buyer_Det obj = new Event_Ticket_Buyer_Det();
            obj.AdId = Convert.ToInt16(AdId);
            obj.Event_Id = Convert.ToInt16(EventId);
           
            obj.TicketMgmtId = ticketId;
            obj.TicketReceiptId = receiptid;
            obj.TicketQty = qty;
            obj.TotalCost = cost;
            obj.BuyerEmailId = email;
            //obj.BuyerEmailId = "ac@sudimna.com";
            obj.CreatedDate = DateTime.Now;
            dbEmup.Event_Ticket_Buyer_Dets.InsertOnSubmit(obj);
            dbEmup.SubmitChanges();
            //lblMsg.Text = "Updated Event Ticket buyer details";
        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.ToString();
            // Label1.Text = "ticket buyer details successfully inserted";
        }

    }


    #region update details new
    private void BindGridDummyTicketEvents(Int16 receiptid)
    {
        gvPayDetails.DataSource = GetTicketedEvents(receiptid);
        gvPayDetails.DataBind();
    }

    public IQueryable GetTicketedEvents(int ticketRecieptId)
    {
        var objEventsList = from objEvents in dbEmup.Dummy_Event_Ticket_Buy_Details
                            where objEvents.TicketReceiptId == Convert.ToInt16(ticketRecieptId)

                            select new
                            {
                                AdId = objEvents.AdId,
                                TicketId = objEvents.TicketMgmtId,
                                Cost = objEvents.TotalCost,
                                TicketReceiptId = objEvents.TicketReceiptId,
                                ServiceTax = objEvents.Event_Create.ServiceTax,
                                EventDate = objEvents.Event_Create.EventDate,
                                Quantity = Convert.ToString(objEvents.Quantity),
                                Available = Convert.ToString(objEvents.AvailQuant),
                                EventId = Convert.ToString(objEvents.Event_Id),
                            };
        return objEventsList;
    }

    private void UpdateTicketDet()
    {
        for (int i = 0; i < gvPayDetails.Rows.Count; i++)
        {
            Event_Ticket_Buy_Detail obj = new Event_Ticket_Buy_Detail();
            Label lblQty = (Label)gvPayDetails.Rows[i].FindControl("lblTicketQty");

            Label lblAvailable = (Label)gvPayDetails.Rows[i].FindControl("lblAvailable");
            Label lblTicketId = (Label)gvPayDetails.Rows[i].FindControl("lblTicketId");
            Label lblCost = (Label)gvPayDetails.Rows[i].FindControl("lblCost");
            Label lblAdId = (Label)gvPayDetails.Rows[i].FindControl("lblAdId");
            Label lblEventId = (Label)gvPayDetails.Rows[i].FindControl("lblEventId");
            ticketId = Convert.ToInt16(lblTicketId.Text);

            try
            {


                //dbEmup.Connection.BeginTransaction();

                obj.TicketReceiptId = Convert.ToInt16(Request.QueryString["RId"]);
                obj.AdId = Convert.ToInt16(lblAdId.Text);
                
                obj.TicketMgmtId = Convert.ToInt16(lblTicketId.Text); ;
                obj.Quantity = Convert.ToInt16(lblQty.Text);
                obj.TotalCost = Convert.ToString(lblCost.Text);

                obj.CreatedDate = DateTime.Now;





                dbEmup.Event_Ticket_Buy_Details.InsertOnSubmit(obj);
                dbEmup.SubmitChanges();
                //int a = 0;
                //a = Convert.ToInt16(lblAvailable.Text) - Qty;
                UpdateAvailableQty(Convert.ToInt16(lblTicketId.Text), Convert.ToInt16(lblAvailable.Text));
                SaveTicketBuyerDet(Convert.ToInt16(lblAdId.Text), Convert.ToInt16(lblEventId.Text), Convert.ToInt16(lblTicketId.Text), Convert.ToInt16(lblQty.Text), Convert.ToString(obj.TotalCost), Convert.ToInt16(obj.TicketReceiptId), Convert.ToString(Context.User.Identity.Name.ToString()));
                //   dbEmup.Transaction.Commit();


            }

            catch (Exception ex)
            {
                //   dbEmup.Transaction.Rollback();
            }
        }


    }
    #endregion end update new
}