public IEnumerable <HotelBookingCancelModel> List() { int SNo = 1; TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel(); var result = _ent.Htl_BookingCancelDetail.Where(x => x.IsProcessed == true).OrderByDescending(x => x.CreatedDate); List <HotelBookingCancelModel> model = new List <HotelBookingCancelModel>(); foreach (var item in result) { HotelBookingCancelModel _booking = new HotelBookingCancelModel(); HotelBookingDetailModel _bookingDtl = new HotelBookingDetailModel(); _booking.BookingCancelId = item.BookingCancelId; _booking.BookingRecordId = item.BookingRecordId.Value; _booking.CancelStatus = item.CancellationStatus; _bookingDtl.HotelName = item.Htl_BookingRecord.HotelName; var obj = item.Htl_BookingRecord.Htl_BookingGuestDetail.Where(x => x.IsLeadGuest = true).FirstOrDefault(); List <GuestDetailModel> _guests = new List <GuestDetailModel>(); GuestDetailModel _guest = new GuestDetailModel(); _guest.Title = obj.Title; _guest.FirstName = obj.FirstName; _guest.MiddleName = obj.FirstName; _guest.LastName = obj.LastName; _guests.Add(_guest); _bookingDtl.Guests = _guests.ToArray(); _booking.BookingDetail = _bookingDtl; _booking.CreatedOn = item.CreatedDate; _booking.SNo = SNo++; //BookingReferenceNo = item.BookingReferenceNo, //CheckInDate = item.CheckInDate, //CheckOutDate = item.CheckOutDate, //CreatedBy = item.CreatedBy, //CreatedDate = item.CreatedOn, //CurrencyCode = item.CurrencyCode, //FlightInfo = item.FlightInfo, //GDSBookingId = item.GDSBookingId, //GDSID = item.GDSID, //BookingRecordId = item.BookingRecordId, //HotelBookingStatus = item.HotelBookingStatus, //HotelCode = item.HotelCode, //HotelName = item.HotelName, //HotelRating = item.HotelRating, //NoOfNights = item.NoOfNights, //NoOfRoom = item.NoOfRoom, //SearchIndex = item.SearchIndex, //SearchSessionId = item.SearchSessionId, //SpecialRequest = item.SpecialRequest, //TotalAmount = item.TotalAmount model.Add(_booking); } return(model.AsEnumerable()); }
public IEnumerable <HotelBookingCancelModel> DistributorPendingList() { int SNo = 1; TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel(); var ts = SessionStore.GetTravelSession(); var result = from a in _ent.Htl_BookingCancelDetail join c in _ent.Htl_BookingRecord on a.BookingRecordId equals c.BookingRecordId join b in _ent.Agents on c.AgentId equals b.AgentId where b.DistributorId == ts.LoginTypeId select a; // var result = _ent.Htl_BookingCancelDetail.Where(x => x.IsProcessed == false && x.IsCancilRequest == true).OrderByDescending(x => x.CreatedDate); List <HotelBookingCancelModel> model = new List <HotelBookingCancelModel>(); foreach (var item in result.Where(x => x.IsProcessed == false && x.IsCancilRequest == true).OrderByDescending(x => x.CreatedDate)) { HotelBookingCancelModel _booking = new HotelBookingCancelModel(); HotelBookingDetailModel _bookingDtl = new HotelBookingDetailModel(); _booking.BookingCancelId = item.BookingCancelId; _booking.BookingRecordId = item.BookingRecordId.Value; _booking.CancelStatus = item.CancellationStatus; _bookingDtl.HotelName = item.Htl_BookingRecord.HotelName; var obj = item.Htl_BookingRecord.Htl_BookingGuestDetail.Where(x => x.IsLeadGuest = true).FirstOrDefault(); List <GuestDetailModel> _guests = new List <GuestDetailModel>(); GuestDetailModel _guest = new GuestDetailModel(); _guest.Title = obj.Title; _guest.FirstName = obj.FirstName; _guest.MiddleName = obj.MiddleName; _guest.LastName = obj.LastName; _guests.Add(_guest); _bookingDtl.Guests = _guests.ToArray(); _booking.BookingDetail = _bookingDtl; _booking.CreatedOn = item.CreatedDate; _booking.SNo = SNo++; model.Add(_booking); } return(model.AsEnumerable()); }
public IEnumerable <HotelBookingRecordModel> ListDistributorHotelBookingProcess() { int SNO = 0; TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel(); int GDSID = HotelCore.Utility.AppSetting.TBOHotelAPI; var ts = SessionStore.GetTravelSession(); var result = from a in _ent.Htl_BookingRecord join b in _ent.Agents on a.AgentId equals b.AgentId where b.DistributorId == ts.LoginTypeId select a; //var result = _ent.Htl_BookingRecord.Where(x => x.IsProcessed == false && x.IsBookingSuccess == true).OrderByDescending(x => x.CreatedOn); //&& x.GDSID == GDSID && x.AgentId == LoggedAgentId List <HotelBookingRecordModel> model = new List <HotelBookingRecordModel>(); foreach (var item in result.Where(x => x.IsProcessed == false && x.IsBookingSuccess == true).OrderByDescending(x => x.CreatedOn)) { SNO = SNO + 1; HotelBookingRecordModel _booking = new HotelBookingRecordModel { SNo = SNO, AddBookingRefId = item.AddBookingRefId, AgentId = item.AgentId, BookingReferenceNo = item.BookingReferenceNo, CheckInDate = item.CheckInDate, CheckOutDate = item.CheckOutDate, CreatedBy = item.CreatedBy, CreatedDate = item.CreatedOn, CurrencyCode = item.CurrencyCode, FlightInfo = item.FlightInfo, GDSBookingId = item.GDSBookingId, GDSID = item.GDSID, BookingRecordId = item.BookingRecordId, HotelBookingStatus = item.HotelBookingStatus, HotelCode = item.HotelCode, HotelName = item.HotelName, HotelRating = item.HotelRating, NoOfNights = item.NoOfNights, NoOfRoom = item.NoOfRoom, SearchIndex = item.SearchIndex, SearchSessionId = item.SearchSessionId, SpecialRequest = item.SpecialRequest, TotalAmount = item.TotalChargeableAmount }; List <GuestDetailModel> _liguest = new List <GuestDetailModel>(); var _guestList = _ent.Htl_BookingGuestDetail.Where(x => x.BookingRecordId == item.BookingRecordId); foreach (var items in _guestList) { GuestDetailModel _guest = new GuestDetailModel { Address1 = items.Address1, Address2 = items.Address1, Age = items.Age, City = items.City, Country = items.Country, Email = items.Email, FirstName = items.FirstName, GuestState = items.GuestState, //GuestType = item.GuestType., LastName = items.LastName, MiddleName = items.MiddleName, PhoneNo = items.PhoneNo, RoomIndex = items.RoomIndex, Title = items.Title, ZipCoade = items.ZipCoade }; _booking.CountryName = items.Country; _booking.CityName = items.City; _booking.GuestName = items.Title + " " + items.FirstName + " " + items.MiddleName + " " + items.LastName; _liguest.Add(_guest); } _booking.GuestDetails = _liguest.AsEnumerable(); model.Add(_booking); } return(model.AsEnumerable()); }
public IEnumerable <HotelBookingRecordModel> DistributorList() { int Sno = 1; int no = 1; TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel(); var ts = SessionStore.GetTravelSession(); var result = from a in _ent.Htl_BookingRecord join b in _ent.Agents on a.AgentId equals b.AgentId where b.DistributorId == ts.LoginTypeId && (a.TicketStatusId == 4 || a.IsProcessed == true) orderby a.CreatedOn descending select a; // var result = _ent.Htl_BookingRecord.Where(x => x.IsProcessed == true ).OrderByDescending(x => x.CreatedOn); List <HotelBookingRecordModel> model = new List <HotelBookingRecordModel>(); foreach (var item in result) { HotelBookingRecordModel _booking = new HotelBookingRecordModel { AddBookingRefId = item.AddBookingRefId, AgentId = item.AgentId, BookingReferenceNo = item.BookingReferenceNo, CheckInDate = item.CheckInDate, CheckOutDate = item.CheckOutDate, CreatedBy = item.CreatedBy, CreatedDate = item.CreatedOn, CurrencyCode = item.CurrencyCode, FlightInfo = item.FlightInfo, GDSBookingId = item.GDSBookingId, GDSID = item.GDSID, BookingRecordId = item.BookingRecordId, HotelBookingStatus = item.HotelBookingStatus, HotelCode = item.HotelCode, HotelName = item.HotelName, HotelRating = item.HotelRating, NoOfNights = item.NoOfNights, NoOfRoom = item.NoOfRoom, SearchIndex = item.SearchIndex, SearchSessionId = item.SearchSessionId, SpecialRequest = item.SpecialRequest, TotalAmount = item.TotalChargeableAmount, TicketStatusId = item.TicketStatusId, TicketStatus = item.TicketStatusId == null ? "NA" : item.TicketStatus.ticketStatusName }; List <GuestDetailModel> _liguest = new List <GuestDetailModel>(); var _guestList = _ent.Htl_BookingGuestDetail.Where(x => x.BookingRecordId == item.BookingRecordId && x.IsLeadGuest == true); foreach (var items in _guestList) { GuestDetailModel _guest = new GuestDetailModel { No = no++, Address1 = items.Address1, Address2 = items.Address1, Age = items.Age, City = items.City, Country = items.Country, Email = items.Email, FirstName = items.FirstName, GuestState = items.GuestState, //GuestType = item.GuestType., LastName = items.LastName, MiddleName = items.MiddleName, PhoneNo = items.PhoneNo, RoomIndex = items.RoomIndex, Title = items.Title, ZipCoade = items.ZipCoade }; _booking.SNo = Sno++; _booking.CountryName = items.Country; _booking.CityName = items.City; _booking.GuestName = items.Title + " " + items.FirstName + " " + items.MiddleName + " " + items.LastName; _liguest.Add(_guest); } _booking.GuestDetails = _liguest.AsEnumerable(); model.Add(_booking); } return(model.AsEnumerable()); }
public HotelBookingDetailModel GetHotelBooking(long?BookingRecordId) { HotelCore.GetHotelBooking.Response _res = new HotelCore.GetHotelBooking.Response(); HotelCore.GetHotelBooking.Request _req = new HotelCore.GetHotelBooking.Request(); HotelBookingDetailModel model = new HotelBookingDetailModel(); TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel(); HotelMessageModel _msg = new HotelMessageModel(); if (BookingRecordId != null) { var obj = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == BookingRecordId).FirstOrDefault(); if (obj != null) { _req.BookingId = obj.GDSBookingId; HotelCore.API _api = new HotelCore.API(); //_res = _api.GetHotelBooking(_req); var _bookingDtl = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == BookingRecordId).FirstOrDefault(); Administrator.Models.AgentModel _agent = new Administrator.Models.AgentModel { AgentName = _bookingDtl.Agents.AgentName, Address = _bookingDtl.Agents.Address, PhoneNo = _bookingDtl.Agents.Phone, AgentId = _bookingDtl.AgentId }; model.CheckInDate = _bookingDtl.CheckInDate; model.CheckOutDate = _bookingDtl.CheckOutDate; model.CityName = _bookingDtl.CityName; model.CountryName = _bookingDtl.CountryName; model.CurrencyCode = _bookingDtl.CurrencyCode; model.Flightinfo = _bookingDtl.FlightInfo; model.HotelRating = _bookingDtl.HotelRating; model.HotelImageUrl = _bookingDtl.HotelImageUrl; model.TotalChargableAmount = _bookingDtl.TotalChargeableAmount; model.BookingId = _bookingDtl.GDSBookingId; model.ConfirmationNo = _bookingDtl.BookingConformationNo; model.ReferenceNo = _bookingDtl.BookingReferenceNo; model.AgentDetail = _agent; var _guests = _ent.Htl_BookingGuestDetail.Where(x => x.BookingRecordId == BookingRecordId); List <GuestDetailModel> _guestList = new List <GuestDetailModel>(); foreach (var item in _guests) { GuestDetailModel _guest = new GuestDetailModel(); _guest.Address1 = item.Address1; _guest.Address2 = item.Address2; _guest.Age = item.Age; _guest.City = item.City; _guest.Country = item.Country; _guest.Email = item.Email; _guest.Title = item.Title; _guest.FirstName = item.FirstName; _guest.GuestState = item.GuestState; _guest.GuestType = item.GuestType; _guest.IsLeadGuest = item.IsLeadGuest; _guest.LastName = item.LastName; _guest.MiddleName = item.MiddleName; _guest.PhoneNo = item.PhoneNo; _guest.RoomIndex = item.RoomIndex; _guest.Title = item.Title; _guest.ZipCoade = item.ZipCoade; _guestList.Add(_guest); } List <HotelCore.Utility.RoomGuestData> _roomGuestList = new List <HotelCore.Utility.RoomGuestData>(); List <int> _childAge = new List <int>(); var _roomDtl = _ent.Htl_BookingRoomDetail.Where(x => x.BookingRecordId == BookingRecordId); foreach (var item in _roomDtl) { HotelCore.Utility.RoomGuestData _roomGuest = new HotelCore.Utility.RoomGuestData(); _roomGuest.NoOfAdults = item.NoOfAdult; _roomGuest.NoOfChild = item.NoOfChild; _roomGuest.RoomTypeName = item.RoomTypeName; _roomGuestList.Add(_roomGuest); } var _roomType = _ent.Htl_BookingRoomDetail.Where(x => x.BookingRecordId == BookingRecordId); List <HotelCore.Utility.HotelRoomsDetails> RoomList = new List <HotelCore.Utility.HotelRoomsDetails>(); var bookingRoomCode = ""; foreach (var item in _roomType) { HotelCore.Utility.HotelRoomsDetails room = new HotelCore.Utility.HotelRoomsDetails(); room.RoomTypeName = item.RoomTypeName; room.NoOfUnits = 1; bookingRoomCode = item.BookingRoomCode; var _nightRate = _ent.Htl_BookingNightRate.Where(x => x.BookingRoomCodeId == item.BookingRoomCodeId); List <HotelCore.Utility.DayRates> _dayRates = new List <HotelCore.Utility.DayRates>(); foreach (var item1 in _nightRate) { HotelCore.Utility.DayRates _dayRate = new HotelCore.Utility.DayRates(); _dayRate.Days = item1.BookingDate; _dayRate.LowRate = item1.BookingRate; _dayRates.Add(_dayRate); } room.DayRates = _dayRates.ToArray(); var _roomRate = _ent.Htl_BookingRoomRate.Where(x => x.BookingRoomCodeId == item.BookingRoomCodeId); List <HotelCore.Utility.RoomRate> _roomRateList = new List <HotelCore.Utility.RoomRate>(); HotelCore.Utility.RoomRate RoomRate = new HotelCore.Utility.RoomRate(); RoomRate.TotalRoomRate = _roomRate.Where(x => x.Particular == "Total-Rate").FirstOrDefault().Amount; RoomRate.ExtraGuestCharges = _roomRate.Where(x => x.Particular == "Extra-Guest-Charge").FirstOrDefault().Amount; RoomRate.TotalRoomTax = _roomRate.Where(x => x.Particular == "Tax").FirstOrDefault().Amount; RoomRate.ServiceTax = _roomRate.Where(x => x.Particular == "Service-Tax").FirstOrDefault().Amount; RoomRate.DisCount = _roomRate.Where(x => x.Particular == "Discount").FirstOrDefault().Amount; RoomRate.TotalTaxesAndFees = RoomRate.TotalRoomTax + RoomRate.ServiceTax; //RoomRate.AgentServiceCharge = _roomRate.Where(x => x.Particular == "Agent-Service-Charge").FirstOrDefault().Amount; RoomRate.CommissionExtraGuestCharge = _roomRate.Where(x => x.Particular == "Commission-Extra-Guest-Charge").FirstOrDefault().Amount; RoomRate.CommissionRatePerRoom = _roomRate.Where(x => x.Particular == "Commission-Rate-Per-Room").FirstOrDefault().Amount; RoomRate.DiscountExtraGuestCharge = _roomRate.Where(x => x.Particular == "Discount-Extra-Guest-Charge").FirstOrDefault().Amount; RoomRate.DiscountRatePerRoom = _roomRate.Where(x => x.Particular == "Discount-Rate-Per-Room").FirstOrDefault().Amount; RoomRate.MarkupExtraGuestCharge = _roomRate.Where(x => x.Particular == "Markup-Extra-Guest-Charge").FirstOrDefault().Amount; RoomRate.MarkupRatePerRoom = _roomRate.Where(x => x.Particular == "Markup-Rate-Per-Room").FirstOrDefault().Amount; room.RoomRate = RoomRate; RoomList.Add(room); } model.RoomDetail = RoomList.ToArray(); model.RoomGuest = _roomGuestList.ToArray(); model.Guests = _guestList.ToArray(); model.HotelAddress = _bookingDtl.HotelAddress; model.HotelEmail = _bookingDtl.HotelEmail; model.HotelName = _bookingDtl.HotelName; model.HotelPhoneNo = _bookingDtl.HotelPhone; model.NoOfRooms = _bookingDtl.NoOfRoom; model.SpecialRequest = _bookingDtl.SpecialRequest; model.BookingDetail = _res.BookingDetail; _msg.ActionMessage = "Success."; _msg.MsgNumber = 1; _msg.MsgStatus = false; _msg.MsgType = 0; model.Message = _msg; } else { _msg.ActionMessage = "Invalid Operation."; _msg.MsgNumber = 1000; _msg.MsgStatus = true; _msg.MsgType = 2; model.Message = _msg; } } else { _msg.ActionMessage = "Invalid Operation."; _msg.MsgNumber = 1000; _msg.MsgStatus = true; _msg.MsgType = 2; model.Message = _msg; } return(model); }
public List <HotelBookingRecordModel> GetOfflineHotelBookList() { var result = _ent.Htl_BookingRecord.Where(x => x.TicketStatusId == 28 || x.TicketStatusId == 14).OrderByDescending(x => x.CreatedOn); List <HotelBookingRecordModel> model = new List <HotelBookingRecordModel>(); foreach (var item in result) { HotelBookingRecordModel _booking = new HotelBookingRecordModel { AddBookingRefId = item.AddBookingRefId, AgentId = item.AgentId, AgentName = item.Agents.AgentName, BookingReferenceNo = item.BookingReferenceNo, CheckInDate = item.CheckInDate, CheckOutDate = item.CheckOutDate, CreatedBy = item.CreatedBy, CreatedDate = item.CreatedOn, CurrencyCode = item.CurrencyCode, FlightInfo = item.FlightInfo, GDSBookingId = item.GDSBookingId, GDSID = item.GDSID, BookingRecordId = item.BookingRecordId, HotelBookingStatus = item.HotelBookingStatus, HotelCode = item.HotelCode, HotelName = item.HotelName, HotelRating = item.HotelRating, NoOfNights = item.NoOfNights, NoOfRoom = item.NoOfRoom, SearchIndex = item.SearchIndex, SearchSessionId = item.SearchSessionId, SpecialRequest = item.SpecialRequest, TotalAmount = item.TotalChargeableAmount, HotelAddress = item.HotelAddress, TicketStatusId = (int)item.TicketStatusId }; List <GuestDetailModel> _liguest = new List <GuestDetailModel>(); var _guestList = _ent.Htl_BookingGuestDetail.Where(x => x.BookingRecordId == item.BookingRecordId); foreach (var items in _guestList) { GuestDetailModel _guest = new GuestDetailModel { Address1 = items.Address1, Address2 = items.Address1, Age = items.Age, City = items.City, Country = items.Country, Email = items.Email, FirstName = items.FirstName, GuestState = items.GuestState, LastName = items.LastName, MiddleName = items.MiddleName, PhoneNo = items.PhoneNo, RoomIndex = items.RoomIndex, Title = items.Title, ZipCoade = items.ZipCoade }; _booking.CountryName = items.Country; _booking.CityName = items.City; _booking.GuestName = items.Title + " " + items.FirstName + " " + items.MiddleName + " " + items.LastName; _liguest.Add(_guest); } _booking.GuestDetails = _liguest.AsEnumerable(); model.Add(_booking); } return(model); }