public BookingHistory CreateHistoryForUpdateBooking(Booking booking,
Member approveManager)
{
var entity = new BookingHistory
{
Booking = booking,
HappenedTime = DateTime.UtcNow,
DisplayContent = $"{approveManager.Email} updated this booking",
FromStatus = booking.Status,
Id = Guid.NewGuid().ToString(),
MemberId = approveManager.UserId,
ToStatus = booking.Status,
Type = BookingHistoryTypes.UPDATE,
};
return(context.BookingHistory.Add(entity).Entity);
}
protected void Page_Load(object sender, EventArgs e)
{
var booking = Module.BookingGetById(Convert.ToInt32(Request.QueryString["bookingid"]));
var histories = Module.BookingGetHistory(booking);
_prev = null;
rptAgencies.DataSource = histories;
rptAgencies.DataBind();
_prev = null;
rptDates.DataSource = histories;
rptDates.DataBind();
_prev = null;
rptTotals.DataSource = histories;
rptTotals.DataBind();
_prev = null;
rptStatus.DataSource = histories;
rptStatus.DataBind();
_prev = null;
rptTrips.DataSource = histories;
rptTrips.DataBind();
_prev = null;
rptCabins.DataSource = histories;
rptCabins.DataBind();
_prev = null;
rptCustomers.DataSource = histories;
rptCustomers.DataBind();
_prev = null;
rptSpecialRequest.DataSource = histories;
rptSpecialRequest.DataBind();
_prev = null;
rptRooms.DataSource = histories;
rptRooms.DataBind();
_prev = null;
rptPickupAddress.DataSource = histories;
rptPickupAddress.DataBind();
}
public void BookingHistorySave()
{
var bookingHistory = new BookingHistory()
{
Booking = Booking,
Date = DateTime.Now,
User = CurrentUser,
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",
};
Module.SaveOrUpdate(bookingHistory);
}
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",
};
SeriesViewBLL.BookingHistorySaveOrUpdate(bookingHistory);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var booking = Module.BookingGetById(Convert.ToInt32(Request.QueryString["bookingid"]));
var histories = Module.BookingGetHistory(booking);
_prev = null;
rptAgencies.DataSource = histories;
rptAgencies.DataBind();
_prev = null;
rptDates.DataSource = histories;
rptDates.DataBind();
_prev = null;
rptTotals.DataSource = histories;
rptTotals.DataBind();
_prev = null;
rptStatus.DataSource = histories;
rptStatus.DataBind();
_prev = null;
rptTrips.DataSource = histories;
rptTrips.DataBind();
_prev = null;
rptCabins.DataSource = histories;
rptCabins.DataBind();
_prev = null;
rptCustomers.DataSource = histories;
rptCustomers.DataBind();
}
catch (Exception ex)
{
_logger.Error("Error when Page_Load in BookingView", ex);
ShowError(ex.Message);
}
}
public void Read_CsvFilesAnd_CreateListWith_BookingView()
{
var bookingInfo = _csvFileManager.ReadBookingsFile(bookingInfoFilePath).ToList();
var serviceInfo = _csvFileManager.ReadServicesFile(serviceInfoFilePath).ToList();
var passangersInfo = _csvFileManager.ReadPassangersFile(passangerInfoFilePath).ToList();
var bookings = new List <BookingView>();
foreach (var booking in bookingInfo.GroupBy(x => x.Pnr))
{
var bookingView = new BookingView(booking.Key, serviceInfo);
foreach (var booking1 in booking)
{
var bookingHistory = new BookingHistory(booking1, passangersInfo);
bookingView.Histories.Add(bookingHistory);
}
bookings.Add(bookingView);
}
Assert.IsTrue(bookings.Any());
}
private IActionResult BookingHistoryInner(BookingHistory obj)
{
if (obj == null)
{
obj = new BookingHistory();
}
var user_info = Session.Get <UserInfo>("UserInfo");
obj.page = (obj.page ?? 1);
var data = _dbAccess.SpBookingHistoryWithPaging(user_info.User_Id, 10, obj.page.Value);
ViewBag.RecordsCount = data.LastOrDefault().RecordCount;
ViewBag.PageNo = (obj.page ?? 1);
if (obj.forAjax == null)
{
return(View(data.Take(data.Count - 1).ToList()));
}
else
{
return(PartialView("_MovieHistory", data.Take(data.Count - 1).ToList()));
}
}
public async Task <IActionResult> ReserveRoom(int roomId, DateTime checkIn, DateTime checkOut, decimal price)
{
var room = await db.Rooms.FindAsync(roomId);
if (room is not null && checkIn >= DateTime.Today)
{
var newBooking = new BookingHistory()
{
CheckIn = checkIn,
CheckOut = checkOut,
Price = price,
Room = room,
Visitor = (await userManager.GetUserAsync(User)).Visitor
};
await db.BookingHistories.AddAsync(newBooking);
await db.SaveChangesAsync();
return(RedirectToAction("GetHistories", "Visitor"));
}
return(NotFound());
}
protected void btnAddRoom_Click(object sender, EventArgs e)
{
Customer customer1 = new Customer();
customer1.Booking = Booking;
customer1.Type = CustomerType.Adult;
Module.SaveOrUpdate(customer1);
var history = new BookingHistory();
history.Booking = Booking;
history.Date = DateTime.Now;
history.Agency = Booking.Agency;
history.StartDate = Booking.StartDate;
history.Status = Booking.Status;
history.Trip = Booking.Trip;
history.User = UserIdentity;
history.SpecialRequest = Booking.SpecialRequest;
history.NumberOfPax = (Booking.Adult + Booking.Child + Booking.Baby);
history.CustomerInfo = Booking.Note;
Module.SaveOrUpdate(history);
PageRedirect(Request.RawUrl);
}
public string CreateBooking(BookingViewModel model)
{
if (model != null)
{
int noOfBooking = _dbContext.Bookings.Where(a => a.VehicleId == model.VehicleId).Where(a => a.ServiceId == model.ServiceId && a.Status != 3 && a.Status != 4).Count();
if (noOfBooking != 0)
{
return("Exist");
}
model.BookingDate = DateTime.Now;
model.Status = 1;
if (model.ServiceId == 4)
{
model.DepartmentId = 2;
}
else if (model.ServiceId == 5)
{
model.DepartmentId = 3;
}
else
{
model.DepartmentId = model.ServiceId;
}
Booking entity = Mapper.Map <BookingViewModel, Booking>(model);
_dbContext.Bookings.Add(entity);
_dbContext.SaveChanges();
BookingHistory bookingHistory = new BookingHistory();
bookingHistory.ServiceId = model.ServiceId;
bookingHistory.BookingId = entity.BookingId;
bookingHistory.VehicleId = model.VehicleId;
bookingHistory.DepartmentId = model.DepartmentId;
_dbContext.BookingHistories.Add(bookingHistory);
_dbContext.SaveChanges();
return("Booking added");
}
return("Model is null");
}
protected void rptAgencies_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.DataItem is BookingHistory)
{
var history = (BookingHistory)e.Item.DataItem;
if (_prev != null)
{
try
{
if (_prev.Agency.Id == history.Agency.Id)
{
e.Item.Visible = false;
return;
}
}
catch (Exception) { }
}
try
{
ValueBinder.BindLiteral(e.Item, "litTime", history.Date.ToString("dd-MMM-yyyy HH:mm"));
ValueBinder.BindLiteral(e.Item, "litUser", history.User.FullName);
ValueBinder.BindLiteral(e.Item, "litTo", history.Agency.Name);
}
catch (Exception) { }
if (_prev != null)
{
try
{
ValueBinder.BindLiteral(e.Item, "litFrom", _prev.Agency.Name);
}
catch (Exception) { }
}
_prev = history;
}
}
private async void LogBookingStats(object sender, RoutedEventArgs e)
{
MenuItem miBuy = (sender as MenuItem);
miBuy.Click -= this.LogBookingStats;
try
{
MenuItem mi = sender as MenuItem;
if (mi != null)
{
ContextMenu cm = mi.Parent as ContextMenu;
PerformanceInfo pi = (PerformanceInfo)cm.Tag;
BookingHistory bh = new BookingHistory(pi);
bh.UserId = ExtendedPropertyHelper.GetUserIdentifier();
await App.MobileService.GetTable <BookingHistory>().InsertAsync(bh);
}
}
catch { }
}
public IActionResult BookingHistoryAjax([FromQuery] BookingHistory obj)
{
return(BookingHistoryInner(obj));
}
public IActionResult BookingHistory([FromForm] BookingHistory obj)
{
return(BookingHistoryInner(obj));
}
public BookingHistory Create(BookingHistory BookingHistory)
{
//this.database.GetCollection<BookingHistory>(mongosettings.BookingHistoryCollectionName).InsertOne(BookingHistory);
GetBookingHistorys.InsertOne(BookingHistory);
return(BookingHistory);
}
public async Task LogBooking(BookingHistory booking)
{
await MobileService.GetTable <BookingHistory>().InsertAsync(booking);
}
protected void btnSaveRoom_OnClick(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(hidChangeRoomIds.Value))
{
var ids = hidChangeRoomIds.Value.Split('$');
var listChange = new Dictionary <int, int>();
if (!string.IsNullOrWhiteSpace(hidChangeRoomOption.Value))
{
var cids = hidChangeRoomOption.Value.Split('$');
foreach (string cid in cids)
{
if (!string.IsNullOrWhiteSpace(cid))
{
var bkc = cid.Split('|');
listChange.Add(Convert.ToInt32(bkc[0]), Convert.ToInt32(bkc[1]));
}
}
}
foreach (string crids in ids)
{
var rid = crids.Split('|');
var bookingRoom = Module.BookingRoomGetById(Convert.ToInt32(rid[0]));
var newRoom = Module.RoomGetById(Convert.ToInt32(rid[1]));
if (bookingRoom.Room.Id != newRoom.Id)
{
var oldRoom = bookingRoom.Room;
bookingRoom.Room = newRoom;
bookingRoom.RoomClass = newRoom.RoomClass;
if (listChange.ContainsKey(bookingRoom.Id))
{
if (listChange[bookingRoom.Id] == 2) // 2 ghep giuong twin
{
bookingRoom.RoomType = oldRoom.RoomType;
}
else
{
bookingRoom.RoomType = newRoom.RoomType;
}
}
else
{
bookingRoom.RoomType = newRoom.RoomType;
}
Module.Update(bookingRoom);
// change room export service
var exports = Module.GetAllExportService(bookingRoom);
if (exports.Count > 0)
{
// update new room status
newRoom.Status = oldRoom.Status;
Module.SaveOrUpdate(newRoom);
// update current room
oldRoom.Status = RoomType.NotCleaned;
Module.SaveOrUpdate(oldRoom);
foreach (IvExport export in exports)
{
export.Room = newRoom;
Module.SaveOrUpdate(export);
}
}
//save history
var bookingHistory = new BookingHistory()
{
Booking = bookingRoom.Book,
Date = DateTime.Now,
User = UserIdentity,
CabinNumber = bookingRoom.Book.BookingRooms.Count,
CustomerNumber = bookingRoom.Book.Pax,
StartDate = bookingRoom.Book.StartDate,
Status = bookingRoom.Book.Status,
Trip = bookingRoom.Book.Trip,
Agency = bookingRoom.Book.Agency,
Total = bookingRoom.Book.Total,
TotalCurrency = bookingRoom.Book.IsTotalUsd ? "USD" : "VND",
SpecialRequest = bookingRoom.Book.SpecialRequest,
OldRoom = oldRoom,
NewRoom = newRoom
};
Module.SaveOrUpdate(bookingHistory);
}
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "RefreshParentPage", "RefreshParentPage();", true);
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "RefreshParentPage", "RefreshParentPage();", true);
}
protected void btnAddBooking_OnClick(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(hidRoomId.Value))
{
if (_room != null && _room.Id > 0)
{
var newRoom = Module.RoomGetById(Convert.ToInt32(hidRoomId.Value));
var bookingRoom = _booking.BookingRooms.FirstOrDefault(r => r.Room.Id == _room.Id);
if (bookingRoom != null)
{
var oldRoom = bookingRoom.Room;
bookingRoom.Room = newRoom;
bookingRoom.RoomClass = newRoom.RoomClass;
bookingRoom.RoomType = newRoom.RoomType;
Module.Update(bookingRoom);
// change room export service
var exports = Module.GetAllExportService(_room, bookingRoom);
if (exports.Count > 0)
{
// update new room status
newRoom.Status = _room.Status;
Module.SaveOrUpdate(newRoom);
// update current room
_room.Status = RoomType.NotCleaned;
Module.SaveOrUpdate(_room);
foreach (IvExport export in exports)
{
export.Room = newRoom;
Module.SaveOrUpdate(export);
}
}
//save history
var bookingHistory = new BookingHistory()
{
Booking = bookingRoom.Book,
Date = DateTime.Now,
User = UserIdentity,
CabinNumber = bookingRoom.Book.BookingRooms.Count,
CustomerNumber = bookingRoom.Book.Pax,
StartDate = bookingRoom.Book.StartDate,
Status = bookingRoom.Book.Status,
Trip = bookingRoom.Book.Trip,
Agency = bookingRoom.Book.Agency,
Total = bookingRoom.Book.Total,
TotalCurrency = bookingRoom.Book.IsTotalUsd ? "USD" : "VND",
SpecialRequest = bookingRoom.Book.SpecialRequest,
OldRoom = oldRoom,
NewRoom = newRoom
};
Module.SaveOrUpdate(bookingHistory);
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "RefreshParentPage", "RefreshParentPage();", true);
}
if (_bookingRoom != null && _bookingRoom.Id > 0)
{
var newRoom = Module.RoomGetById(Convert.ToInt32(hidRoomId.Value));
var bkr = _booking.BookingRooms.FirstOrDefault(b => b.Id == _bookingRoom.Id);
if (bkr != null)
{
var oldRoom = bkr.Room;
bkr.Room = newRoom;
bkr.RoomClass = newRoom.RoomClass;
bkr.RoomType = newRoom.RoomType;
Module.Update(bkr);
//save history
var bookingHistory = new BookingHistory()
{
Booking = bkr.Book,
Date = DateTime.Now,
User = UserIdentity,
CabinNumber = bkr.Book.BookingRooms.Count,
CustomerNumber = bkr.Book.Pax,
StartDate = bkr.Book.StartDate,
Status = bkr.Book.Status,
Trip = bkr.Book.Trip,
Agency = bkr.Book.Agency,
Total = bkr.Book.Total,
TotalCurrency = bkr.Book.IsTotalUsd ? "USD" : "VND",
SpecialRequest = bkr.Book.SpecialRequest,
OldRoom = oldRoom,
NewRoom = newRoom
};
Module.SaveOrUpdate(bookingHistory);
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "RefreshParentPage", "RefreshParentPage();", true);
}
}
}
public void BookingHistorySaveOrUpdate(BookingHistory bookingHistory)
{
BookingHistoryRepository.SaveOrUpdate(bookingHistory);
}
protected void btnAddBooking_OnClick(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(Request["startdate"]))
{
var startDate = DateTime.ParseExact(Request["startdate"], "dd/MM/yyyy",
CultureInfo.InvariantCulture);
_booking.StartDate = startDate;
}
_booking.Trip = Module.TripGetById(Convert.ToInt32(ddlTrips.SelectedValue));
_booking.EndDate = _booking.StartDate.AddDays(_booking.Trip.NumberOfDay - 1);
_booking.Transfer_DateTo = _booking.StartDate;
_booking.Transfer_DateBack = _booking.EndDate;
Module.SaveOrUpdate(_booking);
if (!string.IsNullOrWhiteSpace(hidChangeRoomIds.Value))
{
_booking.Cruise = Module.CruiseGetById(Convert.ToInt32(ddlCruises.SelectedValue));
Module.SaveOrUpdate(_booking);
var ids = hidChangeRoomIds.Value.Split('$');
foreach (string crids in ids)
{
var rid = crids.Split('|');
var oldRoom = Module.RoomGetById(Convert.ToInt32(rid[0]));
var newRoom = Module.RoomGetById(Convert.ToInt32(rid[1]));
foreach (var bookingRoom in _booking.BookingRooms)
{
if (bookingRoom.Room.Id == oldRoom.Id)
{
bookingRoom.Room = newRoom;
bookingRoom.RoomClass = newRoom.RoomClass;
bookingRoom.RoomType = newRoom.RoomType;
Module.Update(bookingRoom);
// change room export service
var exports = Module.GetAllExportService(oldRoom, bookingRoom);
if (exports.Count > 0)
{
// update new room status
newRoom.Status = oldRoom.Status;
Module.SaveOrUpdate(newRoom);
// update current room
oldRoom.Status = RoomType.NotCleaned;
Module.SaveOrUpdate(oldRoom);
foreach (IvExport export in exports)
{
export.Room = newRoom;
Module.SaveOrUpdate(export);
}
}
//save history
var bookingHistory = new BookingHistory()
{
Booking = bookingRoom.Book,
Date = DateTime.Now,
User = UserIdentity,
CabinNumber = bookingRoom.Book.BookingRooms.Count,
CustomerNumber = bookingRoom.Book.Pax,
StartDate = bookingRoom.Book.StartDate,
Status = bookingRoom.Book.Status,
Trip = bookingRoom.Book.Trip,
Agency = bookingRoom.Book.Agency,
Total = bookingRoom.Book.Total,
TotalCurrency = bookingRoom.Book.IsTotalUsd ? "USD" : "VND",
SpecialRequest = bookingRoom.Book.SpecialRequest,
OldRoom = oldRoom,
NewRoom = newRoom
};
Module.SaveOrUpdate(bookingHistory);
}
}
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "RefreshParentPage", "RefreshParentPage();", true);
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "RefreshParentPage", "RefreshParentPage();", true);
}
public async Task DeleteAsync(BookingHistory history)
{
_dbContext.BookingHistories.Remove(history);
await _dbContext.SaveChangesAsync();
}
