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();
            }
        }
Ejemplo n.º 3
0
 public IEnumerable <GuestDetailstbl> GetHotelByStatus(GuestDetailstbl gd)
 {
     return(objGuestDA.GuestDetails(8, gd));
 }
Ejemplo n.º 4
0
 public IEnumerable <GuestDetailstbl> UpdateGuestStatus(GuestDetailstbl gd)
 {
     return(objGuestDA.GuestDetails(7, gd));
 }
Ejemplo n.º 5
0
 public IEnumerable <GuestDetailstbl> UpdateGuestIsActive(GuestDetailstbl gd)
 {
     return(objGuestDA.GuestDetails(6, gd));
 }
Ejemplo n.º 6
0
 public IEnumerable <GuestDetailstbl> DeleteGuest(GuestDetailstbl gd)
 {
     return(objGuestDA.GuestDetails(5, gd));
 }
Ejemplo n.º 7
0
 public IEnumerable <GuestDetailstbl> InsertGuest(GuestDetailstbl hd)
 {
     return(objGuestDA.GuestDetails(3, hd));
 }
Ejemplo n.º 8
0
 public IEnumerable <GuestDetailstbl> GetGuestbyId(GuestDetailstbl gd)
 {
     return(objGuestDA.GuestDetails(2, gd));
 }
Ejemplo n.º 9
0
 public IEnumerable <GuestDetailstbl> GetAllGuest(GuestDetailstbl gd)
 {
     return(objGuestDA.GuestDetails(1, gd));
 }
        protected void GuestInsert(int RoomDetailsId)
        {
            GuestDetailstbl gd1 = new GuestDetailstbl()
            {
                GuestId          = 0,
                BookingDetailsId = 0,
                RoomDetailsId    = 0,
                FirstName        = txtAdultFN1.Text,
                LastName         = txtAdultLN1.Text,
                Salutation       = ddlAdultSalutation1.SelectedValue,
                Type             = "Adult",
                Status           = 1,
                CreatedBy        = 2,
                CreatedDate      = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
            };
            GuestDetailstbl gd2 = new GuestDetailstbl()
            {
                GuestId          = 0,
                BookingDetailsId = 0,
                RoomDetailsId    = 1,
                FirstName        = txtAdultFN2.Text,
                LastName         = txtAdultLN2.Text,
                Salutation       = ddlAdultSalutation2.SelectedValue,
                Type             = "Adult",
                Status           = 1,
                CreatedBy        = 36,
                CreatedDate      = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
            };
            GuestDetailstbl gd3 = new GuestDetailstbl()
            {
                GuestId          = 0,
                BookingDetailsId = 0,
                RoomDetailsId    = 2,
                FirstName        = txtChildFN1.Text,
                LastName         = txtChildLN1.Text,
                Age         = Convert.ToInt32(ddlChildAge1.SelectedValue),
                Type        = "Child",
                Status      = 1,
                CreatedBy   = 26,
                CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
            };
            GuestDetailstbl gd4 = new GuestDetailstbl()
            {
                GuestId          = 0,
                BookingDetailsId = 0,
                RoomDetailsId    = 2,
                FirstName        = txtChildFN2.Text,
                LastName         = txtChildLN2.Text,
                Age         = Convert.ToInt32(ddlChildAge2.SelectedValue),
                Type        = "Child",
                Status      = 1,
                CreatedBy   = 26,
                CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
            };
            GuestDetailstbl        gd    = new GuestDetailstbl();
            List <GuestDetailstbl> objgd = new List <GuestDetailstbl>();

            gd1.RoomDetailsId = RoomDetailsId;
            gd2.RoomDetailsId = RoomDetailsId;
            gd3.RoomDetailsId = RoomDetailsId;
            gd4.RoomDetailsId = RoomDetailsId;
            objgd.Add(gd1);
            objgd.Add(gd2);
            objgd.Add(gd3);
            objgd.Add(gd4);
            for (int i = 0; i < objgd.Count(); i++)
            {
                GuestDetailstbl gdt = new GuestDetailstbl();

                gdt.GuestId          = objgd[i].GuestId;
                gdt.BookingDetailsId = objgd[i].BookingDetailsId;
                gdt.RoomDetailsId    = objgd[i].RoomDetailsId;
                gdt.FirstName        = objgd[i].FirstName;
                gdt.LastName         = objgd[i].LastName;
                gdt.Salutation       = objgd[i].Salutation;
                gdt.Type             = objgd[i].Type;
                gdt.Status           = objgd[i].Status;
                gdt.CreatedBy        = objgd[i].CreatedBy;
                gdt.CreatedDate      = objgd[i].CreatedDate;

                gdt.Age = objgd[i].Age;
                GDtbl   = objGBL.InsertGuest(gdt).ToList();
            }
        }