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