protected bool InsertBookedTicketDetails(string TicketrefNo, string tinNo)
    {
        try
        {
            string message = ""; bool resinsert = false;

            ClsBAL ObjManbusBAL = new ClsBAL();
            ObjManbusBAL.PNRNumber = tinNo;
            ObjManbusBAL.PNRTicketIDs = tinNo;
            ObjManbusBAL.message = message;
            ObjManbusBAL.manabusRefNo = TicketrefNo;
            ObjManbusBAL.api = "SeatSeller";

            if (ObjManbusBAL.AddBooking_TicketDetails())
            {
                resinsert = true;
            }

            return resinsert;
        }
        catch (System.Exception ex)
        {
            throw ex;
        }
    }
    protected bool InsertBookedTicketDetails(DataSet dsbookres, string manabusrefno, string api)
    {
        try
        {
            string pnrNumber = ""; string pnrticketId = ""; string message = ""; bool resinsert = false;
            if (api == "Kesineni")
            {
                pnrNumber = dsbookres.Tables[0].Rows[0]["PNRNumber"].ToString();
                pnrticketId = dsbookres.Tables[0].Rows[0]["PNRTicketIDs"].ToString();
                message = dsbookres.Tables[0].Rows[0]["Message"].ToString();
            }
            else if (api == "Bitla")
            {
                pnrNumber = dsbookres.Tables[0].Rows[0]["ticket_number"].ToString();
                pnrticketId = dsbookres.Tables[0].Rows[0]["travel_operator_pnr"].ToString();
                message = dsbookres.Tables[0].Rows[0]["ticket_status"].ToString();
            }
            else if (api == "Abhibus")
            {
                pnrNumber = dsbookres.Tables[0].Rows[0]["TicketNumber"].ToString();
                pnrticketId = dsbookres.Tables[0].Rows[0]["serviceNumber"].ToString();
                message = dsbookres.Tables[0].Rows[0]["Message"].ToString();
            }
            else if (api == "Kallada")
            {
                pnrNumber = dsbookres.Tables[0].Rows[0]["TicketNumber"].ToString();
                pnrticketId = dsbookres.Tables[0].Rows[0]["serviceNumber"].ToString();
                message = dsbookres.Tables[0].Rows[0]["Message"].ToString();
            }
            else if (api == "TicketGoose")
            {
                pnrNumber = dsbookres.Tables[0].Rows[0]["bookingId"].ToString();
                pnrticketId = dsbookres.Tables[0].Rows[0]["extraSeatInfo"].ToString();
                message = dsbookres.Tables[0].Rows[0]["Status"].ToString();
            }
            ObjBAL = new ClsBAL();
            ObjBAL.PNRNumber = pnrNumber;
            ObjBAL.PNRTicketIDs = pnrticketId;
            ObjBAL.message = message;
            ObjBAL.manabusRefNo = manabusrefno;//Session["manabusrefno"].ToString();
            ObjBAL.api = api;
            if (ObjBAL.AddBooking_TicketDetails())
            {
                resinsert = true;
            }

            return resinsert;
        }
        catch (System.Exception ex)
        {
            throw ex;
        }
    }