using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Web.Security;
using System.Security.Principal;
using System.IO;
using System.Text;
using System.Drawing;
using System.Drawing.Imaging;
using System.Text.RegularExpressions;

public partial class EventEmbedding : System.Web.UI.Page
{
    EMUPDataContext dbEMUP = new EMUPDataContext();
    PublicMethods clsPublic = new PublicMethods();
    int tickeTotQty = 0;
    int tickePrice = 0;
    int bookedTicketsQty = 0;
    int afterBookQty = 0;
    int ticketId = 0;
    Int16 eventRecieptid = 0;

    protected void Page_Load(object sender, EventArgs e)
    {
        //if (Context.User.Identity.IsAuthenticated == false)
        //{
        //    Response.Redirect("https://jhalak.com/Sign-In.aspx?EventId=" + Convert.ToString(Request.QueryString["Id"]));

        //}
        if (!Page.IsPostBack)
        {



            // GetBuyerData();


            if (Request.QueryString["Id"] != null)
            {
                FirstGridViewRow();

                UserDetails();
                //litEventId.Text = "4876";
                litEventId.Text = Convert.ToString(Request.QueryString["Id"]);

                Int16 id0 = Convert.ToInt16(litEventId.Text);
                if (id0 != 0)
                {

                    //    BindGridView(id0);
                    var objEvent_Creates = from objev in dbEMUP.Event_Creates
                                           where objev.AdId == id0
                                           select objev;

                    Event_Create objEvent_Create = objEvent_Creates.SingleOrDefault();

                    // required fields
                    if (objEvent_Create == null)
                        return;

                    litEvent.Text = Convert.ToString(objEvent_Create.Event_Id);
                    Session["EventId"] = Convert.ToString(objEvent_Create.Event_Id);
                    lblEventName.Text = objEvent_Create.Event_Name.ToString();
                    lblstarttime.Text = objEvent_Create.StartTime.ToString();
                    //  lblEventNameHeader.Text = objEvent_Create.Event_Name.ToString();
                    lblEventDate.Text = objEvent_Create.EventDate.ToString();
                    litServiceFee.Text = objEvent_Create.ServiceTax.ToString();
                    if (litServiceFee.Text == "False")
                    {
                        litServiceTax.Visible = true;
                    }
                    if (Convert.ToString(objEvent_Create.SeatingArrangement) != "")
                    {
                        litSeat.Text = objEvent_Create.SeatingArrangement.ToString();
                    }
                    if (Convert.ToString(objEvent_Create.TermsConditions) != "")
                    {
                        litTC.Text = objEvent_Create.TermsConditions.ToString();
                    }
                    //lblVenueName.Text = objEvent_Create.VenueName.ToString();
                    lblVenue.Text = objEvent_Create.Venue.ToString();
                    litUserId.Text = objEvent_Create.UserAdsDet.UserEmailId.ToString();
                    //ddlTimeZone.Text = objEvent_Create.TimeZone.ToString();
                    lblEventCategory.Text = objEvent_Create.Event_Name;
                    lblEventCategory.NavigateUrl = "Event-Description.aspx?Id=" + Convert.ToInt16(Request.QueryString["Id"]);
                    imgEventLogo.ImageUrl = "LoadPhoto.aspx?Id=" + Convert.ToString(Request.QueryString["Id"]);

                    //lblEventCategory.NavigateUrl = objEvent_Create.Event_Name;
                    BindGridTicketEvents(Convert.ToInt16(litEventId.Text));
                  

                    BindTerms();
                    if (Convert.ToString(litTC.Text) == "")
                    {
                        gvTC.Visible = false;
                        divJTC.Visible = true;
                        litTerms.Text = "Jhalak ";
                    }
                    else
                    {
                        gvTC.Visible = true;
                        divJTC.Visible = false;
                        litTerms.Text = "Event Terms & Conditions ";
                    }
                }
            }
        }
    }


    protected void btnPayment_Click(object sender, EventArgs e)
    {


        //if (Request.QueryString["Id"] != null)
        //{
        try
        {

            CalculateAmount();
            SaveTickets();

            // Response.Redirect("Ticket_Receipt.aspx?EventId=" + Convert.ToString(Request.QueryString["Id"]));
            // Response.Redirect("https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick" + " &hosted_button_id=" + "EYHBARZVRW54N " + "&amount=" + Convert.ToString(lblTotalCost.Text) );
            //  Response.Redirect("https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick" + " &hosted_button_id=" + "EYHBARZVRW54N " + "&amount=" + Convert.ToString(lblTotalCost.Text) + "&return=https://events.jhalak.com/Ticket_Receipt.aspx?EventId=" + Convert.ToString(Request.QueryString["Id"]));
        }
        catch (Exception ex)
        {
            throw ex;
        }

        //  }

    }

    private void BindGridTicketEvents(Int16 intEventId)
    {
        grdEvent.DataSource = GetTicketedEvents(intEventId);
        grdEvent.DataBind();
    }

    public IQueryable GetTicketedEvents(int intEventId)
    {
        var objEventsList = from objEvents in dbEMUP.Event_Ticket_Mgmts
                            where objEvents.AdId == Convert.ToInt16(intEventId)

                            select new
                            {
                                AdId = objEvents.AdId,
                                TicketId = objEvents.Tiket_Mgmt_Id,
                                ClosinDate = Convert.ToString(objEvents.TicketSaleClosingDate),
                                TicketType = Convert.ToString(objEvents.TicketType),
                                UnitePrice = Convert.ToString(objEvents.UnitPrice),
                                MaxOrder = Convert.ToString(objEvents.MaxOrder),
                                MinOrder = Convert.ToString(objEvents.MinOrder),
                                TicketQty = Convert.ToString(objEvents.TotalQty),
                                Available = Convert.ToString(objEvents.AvailableQty)

                            };
        return objEventsList;
    }

    private void SaveTickets()
    {
        #region generate ticket receipt
        for (int i = 0; i < grdEvent.Rows.Count; i++)
        {

            TextBox txtQty = (TextBox)grdEvent.Rows[i].FindControl("txtTicketsReq");
            Label lblUnitPrice = (Label)grdEvent.Rows[i].FindControl("lblUnitPrice");
            Label lblAvailable = (Label)grdEvent.Rows[i].FindControl("lblAvailable");
            Label lblTicketId = (Label)grdEvent.Rows[i].FindControl("lblTicketId");
            if (Convert.ToString(txtQty.Text) != "")
            {

                int Qty = Convert.ToInt16(txtQty.Text);
                bookedTicketsQty = bookedTicketsQty + Qty;
                int unitPrice = Convert.ToInt16(lblUnitPrice.Text);
                int totPrice = Convert.ToInt16(Qty * unitPrice);
                tickeTotQty += Qty;
                tickePrice += totPrice;

            }

        }


        Event_Ticket_Receipt_Det objR = new Event_Ticket_Receipt_Det();
        objR.AdId = Convert.ToInt16(Request.QueryString["Id"]);
        objR.TotQty = tickeTotQty;
        objR.TotalCost = Convert.ToString(lblTotalCost.Text);

        dbEMUP.Event_Ticket_Receipt_Dets.InsertOnSubmit(objR);
        dbEMUP.SubmitChanges();
        tickePrice = 0;
        tickeTotQty = 0;
        eventRecieptid = Convert.ToInt16(objR.Event_ReceiptId);
        #endregion 

        for (int i = 0; i < grdEvent.Rows.Count; i++)
        {
            Dummy_Event_Ticket_Buy_Detail obj = new Dummy_Event_Ticket_Buy_Detail();
            TextBox txtQty = (TextBox)grdEvent.Rows[i].FindControl("txtTicketsReq");
            Label lblUnitPrice = (Label)grdEvent.Rows[i].FindControl("lblUnitPrice");
            Label lblAvailable = (Label)grdEvent.Rows[i].FindControl("lblAvailable");
            Label lblTicketId = (Label)grdEvent.Rows[i].FindControl("lblTicketId");
            afterBookQty = Convert.ToInt16(lblAvailable.Text);
            ticketId = Convert.ToInt16(lblTicketId.Text);
            if (Convert.ToString(txtQty.Text) != "")
            {
                try
                {
                    int Qty = Convert.ToInt16(txtQty.Text);

                    int unitPrice = Convert.ToInt16(lblUnitPrice.Text);
                    int totPrice = Convert.ToInt16(Qty * unitPrice);

                    obj.TicketReceiptId = objR.Event_ReceiptId;
                    obj.AdId = Convert.ToInt16(Request.QueryString["id"]);
                    obj.TicketMgmtId = Convert.ToInt16(lblTicketId.Text); ;
                    obj.Quantity = Qty;
                    obj.TotalCost = totPrice.ToString();
                    obj.Event_Id = Convert.ToInt16(litEvent.Text);
                    //obj.TotalCost = Convert.ToString(lblTotalCost.Text);
                    obj.CreatedDate = DateTime.Now;
                    int a = 0;
                    a = Convert.ToInt16(lblAvailable.Text) - Qty;
                    obj.AvailQuant = Convert.ToInt16(a);



                    dbEMUP.Dummy_Event_Ticket_Buy_Details.InsertOnSubmit(obj);
                    dbEMUP.SubmitChanges();
                    litbuyerid.Text = Convert.ToString(obj.TicketbuyId);
                    //int a = 0;
                    //a = Convert.ToInt16(lblAvailable.Text) - Qty;
                    //UpdateAvailableQty(Convert.ToInt16(lblTicketId.Text), a);
                    //   SaveTicketBuyerDet(Convert.ToInt16(lblTicketId.Text), Qty, Convert.ToString(obj.TotalCost), Convert.ToInt16(objR.Event_ReceiptId), Convert.ToString(txtEmail.Text));



                }

                catch (Exception ex)
                {
                }
            }

        }

        //HttpCookie hcLoc = new HttpCookie("ticketInfo");
        //hcLoc["availableQty"] = Convert.ToString(afterBookQty);
        //hcLoc["ticketid"] = Convert.ToString(ticketId);
        //Response.Cookies.Add(hcLoc);
        //Session["BookTickets"] = (GridView)grdEvent;
        //Session["TotalCost"] = Convert.ToString(lblTotalCost.Text);
        Session["AdId"] = Convert.ToString(Request.QueryString["Id"]);
        try
        {
            SaveBatchDetails(Convert.ToInt16(Request.QueryString["Id"]));
        }
        catch (Exception ex)
        {

        }
        //Session["ReceiptId"] = Convert.ToString(objR.Event_ReceiptId);

        Response.Redirect("https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick" + " &hosted_button_id=" + "EYHBARZVRW54N " + "&amount=" + Convert.ToString(lblTotalCost.Text) + "&return=https://events.jhalak.com/Ticket_Receipt.aspx?RId=" + Convert.ToString(objR.Event_ReceiptId));

    }

    private bool ValidateTicketQty(int intTicketid, int adid, int ReqQty)
    {
        var obj = from objT in dbEMUP.Event_Ticket_Mgmts
                  where objT.Tiket_Mgmt_Id == intTicketid && objT.AdId == adid
                  select objT;


        Event_Ticket_Mgmt objE = obj.SingleOrDefault();

        int qty;

        qty = Convert.ToInt16(objE.AvailableQty);
        if (ReqQty > qty)
        {

            lblQtyMsg.Text = "Only" + qty + " Tickets are available for " + objE.TicketType;
            return false;
        }
        else
        {
            return true;
        }







    }

    private bool ValidateMaxOrder(int intTicketid, int adid, int ReqQty)
    {
        var obj = from objT in dbEMUP.Event_Ticket_Mgmts
                  where objT.Tiket_Mgmt_Id == intTicketid && objT.AdId == adid
                  select objT;


        Event_Ticket_Mgmt objE = obj.SingleOrDefault();

        int qty;
        int min;

        qty = Convert.ToInt16(objE.MaxOrder);
        min = Convert.ToInt16(objE.MinOrder);
        if (ReqQty > qty)
        {

            lblQtyMsg.Text = "Maximum order is " + qty + " for " + objE.TicketType;
            return false;
        }
        else if (ReqQty < min)
        {

            lblQtyMsg.Text = "Minimum order is " + min + " for " + objE.TicketType;
            return false;
        }
        else
        {
            return true;
        }







    }

    protected void btnCalculate_Click(object sender, EventArgs e)
    {
        CalculateAmount();
        
    }

    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();
    }

    private void UserDetails()
    {
        try
        {

            var obj = from obju in dbEMUP.UserDets
                      where obju.EmailId == Context.User.Identity.Name.ToString()
                      //  where obju.EmailId == "ac@sudimna.com"
                      select obju;

            UserDet objU = obj.SingleOrDefault();

            txtFirstName.Text = Convert.ToString(objU.Name);
            txtEmail.Text = Convert.ToString(objU.EmailId);

            txtLocation.Text = Convert.ToString(objU.Location);
            txtMobilePhone.Text = Convert.ToString(objU.ContactNo);
        }
        catch
        {

        }


    }

    private void CalculateAmount()
    {
        for (int i = 0; i < grdEvent.Rows.Count; i++)
        {
            TextBox txtQty = (TextBox)grdEvent.Rows[i].FindControl("txtTicketsReq");
            Label lblTickeId = (Label)grdEvent.Rows[i].FindControl("lblTicketId");
            if (Convert.ToString(txtQty.Text) != "")
            {
                if (ValidateTicketQty(Convert.ToInt16(lblTickeId.Text), Convert.ToInt16(Request.QueryString["id"]), Convert.ToInt16(txtQty.Text)) == false)
                {
                    return;
                }
            }

        }
        for (int i = 0; i < grdEvent.Rows.Count; i++)
        {
            TextBox txtQty = (TextBox)grdEvent.Rows[i].FindControl("txtTicketsReq");
            Label lblTickeId = (Label)grdEvent.Rows[i].FindControl("lblTicketId");
            if (Convert.ToString(txtQty.Text) != "")
            {
                if (ValidateMaxOrder(Convert.ToInt16(lblTickeId.Text), Convert.ToInt16(Request.QueryString["id"]), Convert.ToInt16(txtQty.Text)) == false)
                {
                    return;
                }
            }

        }
        int totCost = 0;
        for (int i = 0; i < grdEvent.Rows.Count; i++)
        {

            TextBox txtQty = (TextBox)grdEvent.Rows[i].FindControl("txtTicketsReq");
            if (Convert.ToString(txtQty.Text) != "")
            {
                Label lblUnitPrice = (Label)grdEvent.Rows[i].FindControl("lblUnitPrice");
                totCost = totCost + (Convert.ToInt16(txtQty.Text) * Convert.ToInt16(lblUnitPrice.Text));
            }
        }
        if (litServiceFee.Text == "False")
        {
            decimal totResult = Convert.ToDecimal(totCost * 0.04);
            lblTotalCost.Text = Convert.ToString(totCost + totResult);
        }
        else
        {
            lblTotalCost.Text = Convert.ToString(totCost);
        }
    }

    private void SaveTicketBuyerDet(int ticketId, int qty, string cost, int receiptid, string email)
    {

        Dummy_Event_Ticket_Buyer_Det obj = new Dummy_Event_Ticket_Buyer_Det();
        obj.AdId = Convert.ToInt16(Request.QueryString["Id"]);
        obj.TicketMgmtId = ticketId;
        obj.TicketReceiptId = receiptid;
        obj.TicketQty = qty;
        obj.TotalCost = cost;
        obj.BuyerEmailId = Context.User.Identity.Name.ToString();

        obj.Event_Id = Convert.ToInt16(litEvent.Text);
        obj.CreatedDate = DateTime.Now;
        dbEMUP.Dummy_Event_Ticket_Buyer_Dets.InsertOnSubmit(obj);
        dbEMUP.SubmitChanges();


        litbuyerid.Text = Convert.ToString(obj.EventTicketBuyerId);


    }

    
    protected void DownloadSeating(object sender, EventArgs e)
    {
        int AdId = int.Parse((sender as LinkButton).CommandArgument);
        byte[] bytes;
        string fileName;
        string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = "select AdId, SeatingArrangement from Event_Create where AdId=@AdId";
                cmd.Parameters.AddWithValue("@AdId", AdId);
                cmd.Connection = con;
                con.Open();
                using (SqlDataReader sdr = cmd.ExecuteReader())
                {
                    sdr.Read();
                    bytes = (byte[])sdr["SeatingArrangement"];
                    fileName = sdr["AdId"].ToString();
                }
                con.Close();
            }
        }
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "";
        Response.Cache.SetCacheability(HttpCacheability.NoCache);

        Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName + ".jpg");
        Response.BinaryWrite(bytes);
        Response.Flush();
        Response.End();
    }


   




    protected void ButtonAdd_Click(object sender, EventArgs e)
    {
        if (gvBatchDetails.Rows.Count == 5)
        {
            lblBatchMsg.Visible = true;
            lblBatchMsg.Text = "Maximum 5 Batches details are allowed";
            return;
        }
        AddNewRow();
    }


    public void FirstGridViewRow()
    {
        DataTable dt = new DataTable();
        DataRow dr = null;
        dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
        dt.Columns.Add(new DataColumn("Col1", typeof(string)));
        dt.Columns.Add(new DataColumn("Col2", typeof(string)));
        dt.Columns.Add(new DataColumn("Col3", typeof(string)));
        dt.Columns.Add(new DataColumn("Col4", typeof(string)));
        //dt.Columns.Add(new DataColumn("Col5", typeof(string)));




        dr = dt.NewRow();
        dr["RowNumber"] = 1;
        dr["Col1"] = string.Empty;
        dr["Col2"] = string.Empty;
        dr["Col3"] = string.Empty;
        dr["Col4"] = string.Empty;
        // dr["Col5"] = string.Empty;

        dt.Rows.Add(dr);

        ViewState["CurrentTable"] = dt;


        gvBatchDetails.DataSource = dt;
        gvBatchDetails.DataBind();


        //TextBox txn = (TextBox)gvBatchDetails.Rows[0].Cells[1].FindControl("CourseName");
        //txn.Focus();


    }


    private void AddNewRow()
    {
        int rowIndex = 0;

        if (ViewState["CurrentTable"] != null)
        {
            DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
            DataRow drCurrentRow = null;
            if (dtCurrentTable.Rows.Count > 0)
            {
                for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
                {
                    TextBox txtName = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[1].FindControl("Name");
                    TextBox txtEmail = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[2].FindControl("Email");
                    TextBox txtPhonenumber = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[3].FindControl("Phonenumber");
                    TextBox txtAddress = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[4].FindControl("Address");
                    //TextBox txtFee = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[5].FindControl("Fee");

                    drCurrentRow = dtCurrentTable.NewRow();
                    drCurrentRow["RowNumber"] = i + 1;

                    dtCurrentTable.Rows[i - 1]["Col1"] = txtName.Text;
                    dtCurrentTable.Rows[i - 1]["Col2"] = txtEmail.Text;
                    dtCurrentTable.Rows[i - 1]["Col3"] = txtPhonenumber.Text;
                    dtCurrentTable.Rows[i - 1]["Col4"] = txtAddress.Text;
                    //   dtCurrentTable.Rows[i - 1]["Col5"] = txtFee.Text;
                    rowIndex++;
                }
                dtCurrentTable.Rows.Add(drCurrentRow);
                ViewState["CurrentTable"] = dtCurrentTable;

                gvBatchDetails.DataSource = dtCurrentTable;
                gvBatchDetails.DataBind();

                TextBox txn = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[1].FindControl("Name");
                txn.Focus();
                // txn.Focus;
            }
        }
        else
        {
            Response.Write("ViewState is null");
        }
        SetPreviousData();
    }

    private void SetPreviousData()
    {
        int rowIndex = 0;
        if (ViewState["CurrentTable"] != null)
        {
            DataTable dt = (DataTable)ViewState["CurrentTable"];
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    TextBox txtName = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[1].FindControl("Name");
                    TextBox txtEmail = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[2].FindControl("Email");
                    TextBox txtPhonenumber = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[3].FindControl("Phonenumber");
                    TextBox txtAddress = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[4].FindControl("Address");
                    //TextBox txtFee = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[5].FindControl("Fee");

                    // drCurrentRow["RowNumber"] = i + 1;

                    gvBatchDetails.Rows[i].Cells[0].Text = Convert.ToString(i + 1);
                    txtName.Text = dt.Rows[i]["Col1"].ToString();
                    txtEmail.Text = dt.Rows[i]["Col2"].ToString();
                    txtPhonenumber.Text = dt.Rows[i]["Col3"].ToString();
                    txtAddress.Text = dt.Rows[i]["Col4"].ToString();
                    //txtFee.Text = dt.Rows[i]["Col5"].ToString();

                    rowIndex++;
                }
            }
        }
    }

    private void SetRowData()
    {
        int rowIndex = 0;

        if (ViewState["CurrentTable"] != null)
        {
            DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
            DataRow drCurrentRow = null;
            if (dtCurrentTable.Rows.Count > 0)
            {
                for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
                {
                    TextBox txtName = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[1].FindControl("Name");
                    TextBox txtEmail = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[2].FindControl("Email");
                    TextBox txtPhonenumber = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[3].FindControl("Phonenumber");
                    TextBox txtAddress = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[4].FindControl("Address");
                    // TextBox txtFee = (TextBox)gvBatchDetails.Rows[rowIndex].Cells[5].FindControl("Fee");

                    drCurrentRow = dtCurrentTable.NewRow();
                    drCurrentRow["RowNumber"] = i + 1;
                    dtCurrentTable.Rows[i - 1]["Col1"] = txtName.Text;
                    dtCurrentTable.Rows[i - 1]["Col2"] = txtEmail.Text;
                    dtCurrentTable.Rows[i - 1]["Col3"] = txtPhonenumber.Text;
                    dtCurrentTable.Rows[i - 1]["Col4"] = txtAddress.Text;
                    //  dtCurrentTable.Rows[i - 1]["Col5"] = txtFee.Text;

                    rowIndex++;
                }

                ViewState["CurrentTable"] = dtCurrentTable;
                //grvStudentDetails.DataSource = dtCurrentTable;
                //grvStudentDetails.DataBind();
            }
        }
        else
        {
            Response.Write("ViewState is null");
        }
        //SetPreviousData();
    }

    protected void grvStudentDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SetRowData();
        if (ViewState["CurrentTable"] != null)
        {
            DataTable dt = (DataTable)ViewState["CurrentTable"];
            DataRow drCurrentRow = null;
            int rowIndex = Convert.ToInt32(e.RowIndex);
            if (dt.Rows.Count > 1)
            {
                dt.Rows.Remove(dt.Rows[rowIndex]);
                drCurrentRow = dt.NewRow();
                ViewState["CurrentTable"] = dt;
                gvBatchDetails.DataSource = dt;
                gvBatchDetails.DataBind();

                for (int i = 0; i < gvBatchDetails.Rows.Count - 1; i++)
                {
                    gvBatchDetails.Rows[i].Cells[0].Text = Convert.ToString(i + 1);
                }
                SetPreviousData();
            }
        }
    }




    private void SaveBatchDetails(int intAdId)
    {
        try
        {
            SetRowData();
            DataTable table = ViewState["CurrentTable"] as DataTable;

            if (table != null)
            {
                foreach (DataRow row in table.Rows)
                {
                    string txtName = row.ItemArray[1] as string;
                    string txtEmail = row.ItemArray[2] as string;
                    string txtPhonenumber = row.ItemArray[3] as string;
                    string txtAddress = row.ItemArray[4] as string;



                    // if (Convert.ToString( txtName) != ""  || Convert.ToString(txtName) != null)
                    if (txtName.Length == 0)
                        return;
                    //txtEmail != null ||
                    //txtPhonenumber != null ||
                    //txtAddress != null) 
                    {

                        Event_Ticket_Buyer_Companian_Det objS = new Event_Ticket_Buyer_Companian_Det();
                        // objS.EventId = intAdId;
                        objS.AdId = Convert.ToInt16(Request.QueryString["Id"]);
                        objS.EventTicketBuyerId = Convert.ToInt16(litbuyerid.Text);
                        //objS.AdId = 4786;

                        //objS.EventTicketBuyerId = 120;
                        objS.Name = Convert.ToString(txtName);
                        objS.Email = Convert.ToString(txtEmail);
                        objS.ContactNo = Convert.ToString(txtPhonenumber);
                        objS.Location = Convert.ToString(txtAddress);
                        objS.TicketReceiptId = eventRecieptid;

                        dbEMUP.Event_Ticket_Buyer_Companian_Dets.InsertOnSubmit(objS);
                        dbEMUP.SubmitChanges();

                    }
                }

            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }



    protected void DownloadTerms(object sender, EventArgs e)
    {
        int AdId = int.Parse((sender as LinkButton).CommandArgument);
        byte[] bytes;
        string fileName;
        string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = "select AdId, TermsConditions from Event_Create where AdId=@AdId";
                cmd.Parameters.AddWithValue("@AdId", AdId);
                cmd.Connection = con;
                con.Open();
                using (SqlDataReader sdr = cmd.ExecuteReader())
                {
                    sdr.Read();
                    bytes = (byte[])sdr["TermsConditions"];
                    fileName = sdr["AdId"].ToString();
                }
                con.Close();
            }
        }
        //Response.ClearContent();
        //Response.Clear();
        //Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName +".pdf");
        //Response.AddHeader("Content-Length", fileName.Length.ToString());
        //Response.ContentType = "application/octet-stream";
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "";
        Response.Cache.SetCacheability(HttpCacheability.NoCache);

        Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName + ".pdf");
        Response.BinaryWrite(bytes);
        Response.Flush();
        Response.End();
    }


    #region Terms & Condition
    private void BindTerms()
    {
        gvTC.DataSource = GetTerms(Convert.ToInt16(Request.QueryString["Id"]));
        gvTC.DataBind();
    }
    private IQueryable GetTerms(Int16 IntadId)
    {
        var objA = (from objG in dbEMUP.Event_Creates
                    where objG.AdId == IntadId
                    orderby objG.AdId descending
                    select new
                    {
                        Adid = objG.UserAdsDet.UserAdId,



                    }).Take(1);

        return objA;
    }
    #endregion

    private void CreateReciept(int qty, string price)
    {


    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        //Event_Ticket_Buyer_Companian_Det objTB  = new Event_Ticket_Buyer_Companian_Det();
        //objTB. = Convert.ToString(TxtCelebrityName.Text);



    }
}