public string TripGetAllByNoOfDays(string nod) { var noOfDays = -1; try { noOfDays = Convert.ToInt32(nod); } catch { } var listTrip = AddSeriesBookingsBLL.TripGetAllByNoOfDays(noOfDays); var listTripDTO = new List <TripDTO>(); foreach (var trip in listTrip) { var tripDTO = new TripDTO() { Id = trip.Id, Name = trip.Name }; listTripDTO.Add(tripDTO); } Dispose(); return(JsonConvert.SerializeObject(listTripDTO)); }
public string AgencyContactGetAllByAgency(string ai) { var agencyId = -1; try { agencyId = Convert.ToInt32(ai); } catch { } var listAgencyContactDTO = new List <AgencyContactDTO>(); var listAgencyContact = AddSeriesBookingsBLL.AgencyContactGetAllByAgency(agencyId); foreach (var agencyContact in listAgencyContact) { var agencyContactDTO = new AgencyContactDTO() { Id = agencyContact.Id, Name = agencyContact.Name, }; listAgencyContactDTO.Add(agencyContactDTO); } Dispose(); return(JsonConvert.SerializeObject(listAgencyContactDTO)); }
public string BookingGetBySeries(string si) { int seriesId = -1; try { seriesId = Int32.Parse(si); } catch { } var series = AddSeriesBookingsBLL.SeriesGetById(seriesId); var listBookingDTO = new List <BookingDTO>(); foreach (var booking in series.ListBooking.OrderBy(x => x.Status).ThenByDescending(x => x.StartDate)) { var modifiedName = ""; try { modifiedName = booking.ModifiedBy.FullName; } catch { } var modifiedDate = ""; try { modifiedDate = booking.ModifiedDate.ToString("dd/MM/yyyy HH:mm"); } catch { } var bookingDTO = new BookingDTO { Id = booking.Id, BookingId = "OS" + booking.Id.ToString(), StartDate = booking.StartDate.ToString("dd/MM/yyyy"), TripName = booking.Trip.Name, CruiseName = booking.Cruise.Name, NoOfRoom = booking.BookingRooms.Count, NoOfPax = booking.Pax, Pax = string.Format("Adults : {0}</br> Childs : {1}<br/> Baby : {2}", booking.Adult, booking.Child, booking.Baby), Room = booking.RoomName, TACode = booking.AgencyCode, SpecialRequest = booking.SpecialRequest, Status = booking.Status.ToString(), CutoffDate = booking.Series.CutoffDate + " day(s)", TripCode = booking.Trip.TripCode, ModifiedBy = modifiedName, ModifiedDate = modifiedDate, }; listBookingDTO.Add(bookingDTO); } Dispose(); return(JsonConvert.SerializeObject(listBookingDTO)); }
public void Dispose() { if (addSeriesBookingsBLL != null) { addSeriesBookingsBLL.Dispose(); addSeriesBookingsBLL = null; } if (userUtil != null) { userUtil.Dispose(); userUtil = null; } }
public void BookingHistorySave(Booking booking) { var bookingHistory = new BookingHistory() { Booking = booking, Date = DateTime.Now, User = UserBLL.UserGetCurrent(), CabinNumber = booking.BookingRooms.Count, CustomerNumber = booking.Pax, StartDate = booking.StartDate, Status = booking.Status, Trip = booking.Trip, Agency = booking.Agency, Total = booking.Total, TotalCurrency = booking.IsTotalUsd ? "USD" : "VND", }; AddSeriesBookingsBLL.BookingHistorySaveOrUpdate(bookingHistory); }
public void BookingCancel(string bi) { var bookingId = -1; try { bookingId = Int32.Parse(bi); } catch { } var booking = AddSeriesBookingsBLL.BookingGetById(bookingId); booking.Status = StatusType.Cancelled; booking.ModifiedBy = UserBLL.UserGetCurrent(); booking.ModifiedDate = DateTime.Now; AddSeriesBookingsBLL.BookingSaveOrUpdate(booking); BookingHistorySave(booking); Dispose(); }
public new void Dispose() { if (addSeriesBookingsBLL != null) { addSeriesBookingsBLL.Dispose(); addSeriesBookingsBLL = null; } if (userBLL != null) { userBLL.Dispose(); userBLL = null; } if (permissionBLL != null) { permissionBLL.Dispose(); permissionBLL = null; } }
public string CheckDuplicateSeriesCode(string txtSeriesCode, string si) { var seriesId = -1; try { seriesId = Int32.Parse(si); } catch { } var duplicate = AddSeriesBookingsBLL.CheckDuplicateSeriesCode(txtSeriesCode, seriesId); if (duplicate) { Dispose(); return("Series code đã tồn tại. Yêu cầu nhập series code khác"); } else { Dispose(); return(JsonConvert.SerializeObject(true)); } }
public string SeriesGetByid(string si) { int seriesId = -1; try { seriesId = Int32.Parse(si); } catch { } var series = AddSeriesBookingsBLL.SeriesGetById(seriesId); var createdBy = ""; try { createdBy = series.CreatedBy.FullName; } catch { } var createdDate = ""; try { createdDate = series.CreatedDate.Value.ToString("dd/MM/yyyy HH:mm"); } catch { } var seriesDTO = new SeriesDTO() { Id = series.Id, SeriesCode = series.SeriesCode, CutoffDate = series.CutoffDate, NoOfDays = series.NoOfDays.ToString(), NoOfDaysTrip = series.NoOfDays == 2 ? "2 days 1 night" : "3 days 2 nights", CreatedBy = createdBy, CreatedDate = createdDate, SpecialRequest = series.SpecialRequest, }; if (series.Booker != null) { seriesDTO.Booker = new SeriesDTO.BookerDTO() { Id = series.Booker.Id, Name = series.Booker.Name, }; } if (series.Agency != null) { seriesDTO.Agency = new SeriesDTO.AgencyDTO() { Id = series.Agency.Id, Name = series.Agency.Name }; } Dispose(); return(JsonConvert.SerializeObject(seriesDTO)); }
public string SaveBooking(IList <AvaiableRoomDTO> listAvaiableRoomDTO, string si, string sd, string ci, string ti, string tac, string bsr) { var seriesId = -1; try { seriesId = Convert.ToInt32(si); } catch { } var series = AddSeriesBookingsBLL.SeriesGetById(seriesId); DateTime?startDate = null; try { startDate = DateTime.ParseExact(sd, "dd/MM/yyyy", CultureInfo.InvariantCulture); } catch { } var tripId = -1; try { tripId = Convert.ToInt32(ti); } catch { } var trip = AddSeriesBookingsBLL.TripGetById(tripId); var cruiseId = -1; try { cruiseId = Convert.ToInt32(ci); } catch { } var cruise = AddSeriesBookingsBLL.CruiseGetById(cruiseId); var bookingSpecialRequest = bsr; var taCode = tac; var booking = new Booking() { Agency = series.Agency, Booker = series.Booker, StartDate = startDate.Value, Trip = trip, Cruise = cruise, CreatedBy = UserBLL.UserGetCurrent(), CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, ModifiedBy = UserBLL.UserGetCurrent(), Sale = UserBLL.UserGetCurrent(), Status = Util.StatusType.Pending, Total = 0, Series = series, AgencyCode = taCode, PickupAddress = "N/A", SpecialRequest = bookingSpecialRequest, Deadline = startDate.Value.Subtract(new TimeSpan(series.CutoffDate, 0, 0, 0)), }; booking.EndDate = booking.StartDate.AddDays(booking.Trip.NumberOfDay - 1); AddSeriesBookingsBLL.BookingSaveOrUpdate(booking); foreach (var avaiableRoomDTO in listAvaiableRoomDTO) { var selectedRoom = 0; try { selectedRoom = Convert.ToInt32(avaiableRoomDTO.selectedRoom); } catch { } var selectedChild = 0; try { selectedChild = Convert.ToInt32(avaiableRoomDTO.selectedChild); } catch { } var selectedBaby = 0; try { selectedBaby = Convert.ToInt32(avaiableRoomDTO.selectedBaby); } catch { } var noOfBaby = selectedBaby; var noOfChild = selectedChild; for (int i = 0; i < selectedRoom; i++) { var bookingRoom = new BookingRoom() { Book = booking, Booked = 2, HasChild = noOfBaby > 0 ? true : false, HasBaby = noOfChild > 0 ? true : false, RoomClass = AddSeriesBookingsBLL.RoomClassGetById(avaiableRoomDTO.RoomClass.Id), RoomType = AddSeriesBookingsBLL.RoomTypeGetById(avaiableRoomDTO.RoomType.Id), }; AddSeriesBookingsBLL.BookingRoomSaveOrUpdate(bookingRoom); noOfChild--; noOfBaby--; for (int j = 0; j < bookingRoom.Booked; j++) { var customer = new Customer() { Type = Util.CustomerType.Adult, }; customer.BookingRooms.Clear(); customer.BookingRooms.Add(bookingRoom); AddSeriesBookingsBLL.CustomerSaveOrUpdate(customer); } if (bookingRoom.HasChild) { var customer = new Customer() { Type = Util.CustomerType.Children, }; customer.BookingRooms.Add(bookingRoom); AddSeriesBookingsBLL.CustomerSaveOrUpdate(customer); } if (bookingRoom.HasBaby) { var customer = new Customer() { Type = Util.CustomerType.Baby, }; customer.BookingRooms.Add(bookingRoom); AddSeriesBookingsBLL.CustomerSaveOrUpdate(customer); } } } Dispose(); booking = AddSeriesBookingsBLL.BookingGetById(booking.Id); var modifiedName = ""; try { modifiedName = booking.ModifiedBy.FullName; } catch (Exception) { } var modifiedDate = ""; try { modifiedDate = booking.ModifiedDate.ToString("dd/MM/yyyy HH:mm"); } catch (Exception) { } var bookingDTO = new BookingDTO() { Id = booking.Id, BookingId = "OS" + booking.Id.ToString(), StartDate = booking.StartDate.ToString("dd/MM/yyyy"), TripName = booking.Trip.Name, CruiseName = booking.Cruise.Name, NoOfRoom = booking.BookingRooms.Count, NoOfPax = booking.Pax, Pax = string.Format("Adults : {0}</br> Childs : {1}<br/> Baby : {2}", booking.Adult, booking.Child, booking.Baby), Room = booking.RoomName, TACode = booking.AgencyCode, SpecialRequest = booking.SpecialRequest, Status = booking.Status.ToString(), CutoffDate = booking.Series.CutoffDate + " day(s)", TripCode = booking.Trip.TripCode, ModifiedBy = modifiedName, ModifiedDate = modifiedDate, }; Dispose(); return(JsonConvert.SerializeObject(bookingDTO)); }
public string GetAvaiableRoom(string ci, string sd, string ti, string SectionId, string NodeId) { CoreRepository CoreRepository = HttpContext.Current.Items["CoreRepository"] as CoreRepository; int nodeId = Int32.Parse(NodeId); Node node = (Node)CoreRepository.GetObjectById(typeof(Node), nodeId); int sectionId = Int32.Parse(SectionId); Section section = (Section)CoreRepository.GetObjectById(typeof(Section), sectionId); SailsModule module = (SailsModule)ContainerAccessorUtil.GetContainer().Resolve <ModuleLoader>().GetModuleFromSection(section); DateTime?startDate = null; try { startDate = DateTime.ParseExact(sd, "dd/MM/yyyy", CultureInfo.InvariantCulture); } catch { } var tripId = -1; try { tripId = Convert.ToInt32(ti); } catch { } var trip = AddSeriesBookingsBLL.TripGetById(tripId); var cruiseId = -1; try { cruiseId = Convert.ToInt32(ci); } catch { } var cruise = AddSeriesBookingsBLL.CruiseGetById(cruiseId); var listRoomClass = AddSeriesBookingsBLL.RoomClassGetAll(); var listRoomType = AddSeriesBookingsBLL.RoomTypeGetAll(); var listAvaiableRoomDTO = new List <AvaiableRoomDTO>(); foreach (var roomClass in listRoomClass) { foreach (var roomType in listRoomType) { if (trip == null) { break; } if (!startDate.HasValue) { break; } var roomCount = module.RoomCount(roomClass, roomType, cruise, startDate.Value, trip.NumberOfDay, true, trip.HalfDay); var avaiableRoomDTO = new AvaiableRoomDTO(); if (roomCount > -1) { avaiableRoomDTO.KindOfRoom = roomClass.Name + " " + roomType.Name; avaiableRoomDTO.RoomClass = new AvaiableRoomDTO.RoomClassDTO() { Id = roomClass.Id, Name = roomClass.Name }; avaiableRoomDTO.RoomType = new AvaiableRoomDTO.RoomTypeDTO() { Id = roomType.Id, Name = roomType.Name, }; var NoOfAdult = roomCount; avaiableRoomDTO.NoOfAdult = NoOfAdult; var NoOfChild = roomCount; avaiableRoomDTO.NoOfChild = NoOfChild; var NoOfBaby = roomCount; avaiableRoomDTO.NoOfBaby = NoOfBaby; listAvaiableRoomDTO.Add(avaiableRoomDTO); } } } Dispose(); return(JsonConvert.SerializeObject(listAvaiableRoomDTO)); }
public string CheckRoom(string sd, string ti, string SectionId, string NodeId) { CoreRepository CoreRepository = HttpContext.Current.Items["CoreRepository"] as CoreRepository; int nodeId = Int32.Parse(NodeId); Node node = (Node)CoreRepository.GetObjectById(typeof(Node), nodeId); int sectionId = Int32.Parse(SectionId); Section section = (Section)CoreRepository.GetObjectById(typeof(Section), sectionId); SailsModule module = (SailsModule)ContainerAccessorUtil.GetContainer().Resolve <ModuleLoader>().GetModuleFromSection(section); DateTime?startDate = null; try { startDate = DateTime.ParseExact(sd, "dd/MM/yyyy", CultureInfo.InvariantCulture); } catch { } var tripId = -1; try { tripId = Convert.ToInt32(ti); } catch { } var trip = AddSeriesBookingsBLL.TripGetById(tripId); var listRoomClass = AddSeriesBookingsBLL.RoomClassGetAll(); var listRoomType = AddSeriesBookingsBLL.RoomTypeGetAll(); var listCruise = AddSeriesBookingsBLL.CruiseGetAllByTrip(trip); var listCheckRoomResultDTO = new List <CheckRoomResultDTO>(); foreach (var cruise in listCruise) { var checkRoomResultDTO = new CheckRoomResultDTO(); checkRoomResultDTO.Cruise = new CheckRoomResultDTO.CruiseDTO() { Id = cruise.Id, Name = cruise.Name }; int total = 0; string detail = ""; foreach (var roomClass in listRoomClass) { foreach (var roomType in listRoomType) { if (trip == null) { break; } if (!startDate.HasValue) { break; } int avail = module.RoomCount(roomClass, roomType, cruise, startDate.Value, trip.NumberOfDay, trip.HalfDay); if (avail > 0) { total += avail; detail += string.Format("{0} {2} {1} ", avail, roomType.Name, roomClass.Name); } } } checkRoomResultDTO.NoOfRoomAvaiable = total; checkRoomResultDTO.DetailRooms = detail; listCheckRoomResultDTO.Add(checkRoomResultDTO); } Dispose(); return(JsonConvert.SerializeObject(listCheckRoomResultDTO)); }
public string UpdateSeries(string si, string ai, string bi, string sc, string cd, string nod, string sr) { var seriesId = -1; try { seriesId = Convert.ToInt32(si); } catch { } var series = AddSeriesBookingsBLL.SeriesGetById(seriesId); var agencyId = -1; try { agencyId = Convert.ToInt32(ai); } catch { } var agency = AddSeriesBookingsBLL.AgencyGetById(agencyId); var bookerId = -1; try { bookerId = Convert.ToInt32(bi); } catch { } var booker = AddSeriesBookingsBLL.AgencyContactGetById(bookerId); var seriesCode = sc; int cutoffDate = -1; try { cutoffDate = Convert.ToInt32(cd); } catch { } var noOfDays = -1; try { noOfDays = Convert.ToInt32(nod); } catch { } var specialRequest = sr; series.CutoffDate = cutoffDate; series.NoOfDays = noOfDays; series.Booker = booker; series.Agency = agency; series.SpecialRequest = specialRequest; AddSeriesBookingsBLL.SeriesSaveOrUpdate(series); series.SeriesCode = String.IsNullOrEmpty(seriesCode) ? "OSS" + series.Id : seriesCode; AddSeriesBookingsBLL.SeriesSaveOrUpdate(series); var createdBy = ""; try { createdBy = series.CreatedBy.FullName; } catch { } var createdDate = ""; try { createdDate = series.CreatedDate.Value.ToString("dd/MM/yyyy HH:mm"); } catch { } var seriesDTO = new SeriesDTO() { Id = series.Id, SeriesCode = series.SeriesCode, CutoffDate = series.CutoffDate, NoOfDays = series.NoOfDays.ToString(), NoOfDaysTrip = series.NoOfDays == 2 ? "2 days 1 night" : "3 days 2 nights", CreatedBy = createdBy, CreatedDate = createdDate, SpecialRequest = specialRequest, }; if (series.Booker != null) { seriesDTO.Booker = new SeriesDTO.BookerDTO() { Id = series.Booker.Id, Name = series.Booker.Name, }; } if (series.Agency != null) { seriesDTO.Agency = new SeriesDTO.AgencyDTO() { Id = series.Agency.Id, Name = series.Agency.Name }; } Dispose(); return(JsonConvert.SerializeObject(seriesDTO)); }