Exemplo n.º 1
0
        protected void GetAllBookingsById(int BookingDetailsId)
        {
            AllBookingstbl ls = new AllBookingstbl
            {
                BookingDetailsId = BookingDetailsId
            };
            Hotelstbl    hs = new Hotelstbl();
            Gueststbl    gs = new Gueststbl();
            Roomstbl     rs = new Roomstbl();
            Supplierstbl sp = new Supplierstbl();
            Agentstbl    ag = new Agentstbl();

            lstAllBookings = objAllBookingsBL.GetAllBookingsById(ls, gs, hs, rs, sp, ag).ToList();

            foreach (var el in lstAllBookings)
            {
                lblBID.Text          = el.AllBookingstc.SupBookingId;
                lblDate.Text         = Convert.ToDateTime(el.AllBookingstc.BookingDate).ToShortDateString();
                lblSName.Text        = el.Supplierstc.Supplier;
                lblRec.Text          = el.Supplierstc.ToString();
                lblAgencyName.Text   = el.Agentstc.AgencyName;
                lblAgencyCNo.Text    = el.Agentstc.MobileNo;
                lblCancel.Text       = el.Agentstc.ToString();
                lblDeadlineDate.Text = el.Agentstc.ToString();
                lblABID.Text         = el.AllBookingstc.AgentBookingId;

                lblHName.Text        = el.Hotelstc.HotelName;
                lblCNo.Text          = el.Hotelstc.ContactNumber;
                lblAdrs.Text         = el.Hotelstc.HotelAddress;
                lblLctn.Text         = el.Hotelstc.ToString();
                lblCheckInDate.Text  = Convert.ToDateTime(el.AllBookingstc.CheckinDate).ToShortDateString();
                lblCheckOutDate.Text = Convert.ToDateTime(el.AllBookingstc.ChekoutDate).ToShortDateString();
            }
            //GetAllBookingsById(30);
        }
Exemplo n.º 2
0
        protected void GetAllBookings()
        {
            AllBookingstbl ls = new AllBookingstbl();
            Hotelstbl      hs = new Hotelstbl();
            Gueststbl      gs = new Gueststbl();
            Roomstbl       rs = new Roomstbl();
            Supplierstbl   sp = new Supplierstbl();
            Agentstbl      ag = new Agentstbl();
            //Booking Bok = new Booking();

            List <Booking> lstBok = new List <Booking>();

            lstBok = objAllBookingsBL.GetAllBookings(ls, gs, hs, rs, sp, ag).ToList();
            gdvAllBookings.DataSource = lstBok;
            gdvAllBookings.DataBind();
            GridView1.DataSource = lstBok;
            GridView1.DataBind();
            decimal Total = 0;

            foreach (var vl in lstBok)
            {
                Total += Convert.ToDecimal(vl.AllBookingstc.NoofRooms) * Convert.ToDecimal(vl.AllBookingstc.AgentPrice);
            }
            lblTotalAmount.Text = Total.ToString();
        }
 protected void GetAllBookings()
 {
     AllBookingstbl ls = new AllBookingstbl();
     Hotelstbl hs = new Hotelstbl();
     Gueststbl gs = new Gueststbl();
     Roomstbl rs = new Roomstbl();
     Supplierstbl sp = new Supplierstbl();
     Agentstbl ag = new Agentstbl();
     //Booking Bok = new Booking();
     
     lstBok = objAllBookingsBL.GetAllBookingsWithSearch(ls, gs, hs, rs, sp, ag).ToList();           
     gdvAllBookings.DataSource = lstBok;
     gdvAllBookings.DataBind();
 }
        protected void GetAllBookingsById(int id)
        {
            AllBookingstbl ls = new AllBookingstbl();
            Hotelstbl hs = new Hotelstbl();
            Gueststbl gs = new Gueststbl();
            Roomstbl rs = new Roomstbl();
            Supplierstbl sp = new Supplierstbl();
            Agentstbl ag = new Agentstbl();
            
            List<Booking> lstAllBookings = new List<Booking>();
            lstAllBookings = objAllBookingsBL.GetAllBookingsById(ls, gs, hs, rs, sp, ag).ToList();

            foreach (var el in lstAllBookings)
            {
                              
            }
        }
        protected void GetGuestName()
        {
            AllBookingsBL          objGuestDetailsBL = new AllBookingsBL();
            List <Booking>         lstBook           = new List <Booking>();
            List <GuestDetailstbl> lstGuestDetails   = new List <GuestDetailstbl>();
            AllBookingstbl         abt = new AllBookingstbl();
            Gueststbl       gt         = new Gueststbl();
            Hotelstbl       ht         = new Hotelstbl();
            Roomstbl        rt         = new Roomstbl();
            Supplierstbl    st         = new Supplierstbl();
            Agentstbl       at         = new Agentstbl();
            GuestDetailstbl Cust       = new GuestDetailstbl();

            Cust.Status = 1;
            lstBook     = objGuestDetailsBL.GetAllBookings(abt, gt, ht, rt, st, at).ToList();
            foreach (var cnt in lstBook)
            {
                ListItem li = new ListItem();
                li.Text  = cnt.Gueststc.FirstName + ' ' + cnt.Gueststc.LastName;
                li.Value = cnt.Gueststc.GuestId.ToString();
            }
        }
        protected void GetHotelName()
        {
            AllBookingsBL          objHotelBL = new AllBookingsBL();
            List <Booking>         lstBook    = new List <Booking>();
            List <HotelDetailstbl> lstHotel   = new List <HotelDetailstbl>();
            HotelDetailstbl        Htl        = new HotelDetailstbl();
            AllBookingstbl         abt        = new AllBookingstbl();
            Gueststbl       gt   = new Gueststbl();
            Hotelstbl       ht   = new Hotelstbl();
            Roomstbl        rt   = new Roomstbl();
            Supplierstbl    st   = new Supplierstbl();
            Agentstbl       at   = new Agentstbl();
            GuestDetailstbl Cust = new GuestDetailstbl();

            Htl.IsActive = 1;
            lstBook      = objHotelBL.GetAllBookings(abt, gt, ht, rt, st, at).ToList();
            foreach (var cnt in lstHotel)
            {
                ListItem li = new ListItem();
                li.Text  = cnt.HotelName;
                li.Value = cnt.HotelDetailsId.ToString();
            }
        }
Exemplo n.º 7
0
 public IEnumerable <Booking> GetAllBookingsWithSearch(AllBookingstbl ls, Gueststbl gs, Hotelstbl hs, Roomstbl rs, Supplierstbl sp, Agentstbl ag)
 {
     return(objAllBookingsDA.AllBookingsWithSearch(1, ls, gs, hs, rs, sp, ag));
 }
Exemplo n.º 8
0
 public IEnumerable <Booking> UpdateAllBookingsStatus(AllBookingstbl ls, Gueststbl gs, Hotelstbl hs, Roomstbl rs, Supplierstbl sp, Agentstbl ag)
 {
     return(objAllBookingsDA.AllBookings(7, ls, gs, hs, rs, sp, ag));
 }