public async Task <IActionResult> Create(BookingModel booking)
{
try
{
List <CategoryModel> categoryList = await ApiConnection.GetCategoryList();
List <RoomModel> roomList = await ApiConnection.GetRoomList();
List <BookingModel> bookingList = await ApiConnection.GetBookingList();
List <RoomModel> qualifiedrooms = new List <RoomModel>();
List <RoomModel> corcatroom = new List <RoomModel>();
int bookingstart = int.Parse(DateTime.Parse(booking.StartDate.ToString()).ToString().Remove(10, 9).Remove(4, 1).Remove(6, 1)); //parsar datetime till int
int bookingend = int.Parse(DateTime.Parse(booking.EndDate.ToString()).ToString().Remove(10, 9).Remove(4, 1).Remove(6, 1)); //parsar datetime till int
int dateToday = int.Parse(DateTime.Parse(DateTime.Today.ToString()).ToString().Remove(10, 9).Remove(4, 1).Remove(6, 1));
if (bookingstart < bookingend && bookingstart >= dateToday) //kollar så bokningens startdatum inte är före dagens datum.
{
corcatroom.AddRange(from item in roomList
where item.CategoryId == booking.CategoryId
select item);
List <BookingModel> corcatbooking = new List <BookingModel>();
BookingHandler.RoomAvailableCheckV2(bookingList, corcatroom, bookingstart, bookingend);
if (corcatroom.Count > 0) //kollar ifall det finns tillgängliga rum
{
var room = corcatroom.First();
BookingModel finalBooking = BookingHandler.SetFinalBooking(booking, room);
var postTask = ApiConnection.ApiClient.PostAsJsonAsync <BookingModel>("BookingModels", finalBooking);
postTask.Wait();
var result = postTask.Result;
return(RedirectToAction("Confirmation", "Booking"));
}
else
{
ViewData["norooms"] = "Det finns inga lediga rum av din preferenser";
await ViewbagCategory();
return(View(new BookingModel()));
}
}
else
{
ViewData["wrongtime"] = "Vänligen fyll i en korrekt tid. Slutdatumet måste vara senare än startdatumet.";
await ViewbagCategory();
return(View(new BookingModel()));
}
}
catch (Exception ex)
{
_logger.LogWarning("Could not create booking: HttpPost", ex);
return(View());
}
}
private string PrepareBookingDetails(int BookingId)
{
#region GetBookingDetails
BookingHandler bookingHandler = new BookingHandler();
BookingDTO bookingDTO = bookingHandler.GetBookingDetails(BookingId);
StringBuilder emailText = new StringBuilder();
emailText.Append(string.Empty);
string BookingText = string.Empty;
if (bookingDTO != null)
{
BookingText = PrepareBookingText(bookingDTO);
}
emailText.Append(BookingText);
#endregion
emailText.Append("</br>");
#region GetBookingRoomDetails
BookingRoomReportsDTO[] oBRRD = null;
BookingRoomReportsHandler oBRM = new BookingRoomReportsHandler();
string BookingDetailsText = string.Empty;
oBRRD = oBRM.GetDetailedBookingDetails(BookingId);
if (oBRRD != null)
{
if (oBRRD.Length > 0)
{
BookingDetailsText = PrepareBookingRoomDetailsText(oBRRD);
}
}
emailText.Append(BookingDetailsText);
#endregion
return(emailText.ToString());
}
public async Task <IActionResult> Index(string sortOrder, int?pageNumber, int pageSize = 5)
{
try
{
List <BookingModel> bookingList = await ApiConnection.GetBookingList();
List <CategoryModel> categoryList = await ApiConnection.GetCategoryList();
List <RoomdescModel> roomdescList = await ApiConnection.GetRoomdescList();
BookingHandler.PlaceCategoryInBooking(bookingList, categoryList, roomdescList); //placerar kategoribeskrivning i bokningslistan
ViewData["CurrentSort"] = sortOrder;
ViewDataImport(sortOrder);
bookingList = BookingListViewHelper.ColumnSwitch(sortOrder, bookingList);
return(View(await PaginatedList <BookingModel> .CreatePaging(bookingList, pageNumber ?? 1, pageSize)));
}
catch (Exception ex)
{
_logger.LogWarning("Could not fetch bookings", ex);
return(RedirectToAction("Privacy", "Home"));
}
}
public async Task <IActionResult> SuperDelete(int?id)
{
try
{
List <BookingModel> bookingList = await ApiConnection.GetBookingList();
List <CategoryModel> categoryList = await ApiConnection.GetCategoryList();
List <RoomdescModel> roomdescList = await ApiConnection.GetRoomdescList();
BookingHandler.PlaceCategoryInBooking(bookingList, categoryList, roomdescList); //placerar kategoribeskrivning i bokningslistan
foreach (var item in bookingList)
{
if (id == item.Id)
{
return(View(item));
}
}
return(RedirectToAction("Index", "Booking"));
}
catch (Exception ex)
{
_logger.LogWarning("Could not show delete confirmation screen", ex);
throw;
}
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (XtraMessageBox.Show("La prenotazione corrente sarà eliminata. Continuare?", "Domanda", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
//elimino dal calendario tutte le assegnazioni
foreach (Assignment item in _currentBooking.Assignments)
{
Appointment app = GetAppointment(item);
if (app != null)
{
_control.Storage.Appointments.Remove(app);
}
}
BookingHandler h = new BookingHandler();
h.Delete(_currentBooking.BaseObject);
this.Close();
}
}
catch (Exception ex)
{
ErrorHandler.Show(ex);
}
}
public UserBookingView()
{
this.InitializeComponent();
log = new LoginVm();
col = new Collector();
_bookingHandler = new BookingHandler();
savm = new SelectedActivityViewVM();
selectedColor = new SolidColorBrush(Colors.Yellow);
red = new SolidColorBrush(Windows.UI.Colors.Red);
cds = CurrentDateSingleton.GetInstance();
CalendarView.SelectedDates.Add(new DateTime(2017, 10, 29)); // Set selected date is "x date");
CalendarView.MinDate = new DateTime(2017, 11, 1); //Min date is "x date "
CalendarView.MaxDate = DateTime.Now.AddMonths(12); //Max date is "x" months from current date
CalendarView.NumberOfWeeksInView = 5; //Month view show "x" weeks at a time
CalendarView.SelectedForeground = selectedColor;
_eventListSingleton = EventListSingleton.GetInstance();
_eventListSingleton.SetEvents(col.Events);
cds = CurrentDateSingleton.GetInstance();
ChooseEventList();
dates = new List <DateTimeOffset>();
}
public bool AddSeriesBooking(SeriesDTO SeriesDTO, List <SeriesDetailDTO> oSeriesDetailList, List <BookingOfSeriesDTO> BookingsOfSeries, out int SeriesId)
{
int iSeriesId = 0;
int iBookingId = 0;
BookingHandler bookingHandler = new BookingHandler();
SeriesDetailHandler oSeriesDetailHandler = new SeriesDetailHandler();
//BookingDTO oBookingData;
//BookedRooms oBookedRooms;
//BookingWaitListDTO oBookingWaitListData;
//BookingOfSeriesDTO FinalizedBookingDTO;
List <BookingOfSeriesDTO> FinalizedBookingList = new List <BookingOfSeriesDTO>();
#region Saving Series in Master and Detail
AddSeries(SeriesDTO, out iSeriesId);
foreach (SeriesDetailDTO var in oSeriesDetailList)
{
var.SeriesID = iSeriesId;
}
oSeriesDetailHandler.AddSeriesDetail(oSeriesDetailList);
#endregion
#region Pulling EveryBooking and Saving It
foreach (BookingOfSeriesDTO FinalBooking in BookingsOfSeries)
{
FinalBooking.Booking.SeriesId = iSeriesId;
bookingHandler.AddBooking(FinalBooking.Booking, FinalBooking.BookedRooms.ToArray(), FinalBooking.WaitListedRooms.ToArray(), out iBookingId);
}
#endregion Pulling EveryBooking and Saving It
SeriesId = iSeriesId;
return(true);
}
private static void Subscribe()
{
SubscribeResource sr = new SubscribeResource(1, 1, 100, "test", 1000, DateTime.Now,
new Bookings.Contract.TimeSlot(DateTime.Now, DateTime.Now.AddHours(4).AddSeconds(32)));
SqlOption option = new SqlOption { ConnectionString = "Server=localhost;Port=3306;Database=yue;Uid=root;Pwd=123456;" };
BookingWriteRepository bookingWriteRepository = new BookingWriteRepository(option);
BookingHandler bookingHandler = new BookingHandler(bookingWriteRepository);
bookingHandler.Execute(sr);
}
public CustomerBooking(int bookingId)
{
InitializeComponent();
BookingHandler h = new BookingHandler();
_currentBooking = h.GetElementById(bookingId.ToString()) as Booking;
PaymentSectionInitializzation();
LoadComboTipoPrenotazione();
LoadComboOperatori();
LoadCurrentBookingData();
}
private void UpdateBooking()
{
_currentBooking.Date = dtpDate.DateTime;
_currentBooking.BookingType = cboTipo.EditValue as BookingType;
_currentBooking.Notes = memoEdit1.Text;
_currentBooking.Operator = cboOp.EditValue as Operator;
_currentBooking.Color = colorEdit1.Color.ToArgb();
_currentBooking.ColorBookings = chkColorBookings.Checked;
_currentBooking.Notes1 = memoEdit2.Text;
if (chkConfirm.Checked)
{
_currentBooking.ConfirmBooking();
//aggiungo tutti gli altri dati di conferma
_currentBooking.SetTotal((float)spTotale.Value);
_currentBooking.SetStayTax((float)spTassa.Value);
if (spAcconto.Value != 0)
{
_currentBooking.SetAccount(dtpAcconto.DateTime, (float)spAcconto.Value, cboModAcconto.EditValue as PaymentType);
}
else
{
_currentBooking.SetAccount(DateTime.MinValue, 0, null);
}
if (spSaldo.Value != 0)
{
_currentBooking.SetRestOfTypePayment(dtpSaldo.DateTime, (float)spSaldo.Value, cboModSaldo.EditValue as PaymentType);
}
else
{
_currentBooking.SetRestOfTypePayment(DateTime.MinValue, 0, null);
}
}
else
{
_currentBooking.UnConfirmBooking();
}
BookingHandler h = new BookingHandler();
h.SaveOrUpdate(_currentBooking.BaseObject);
//rinfresco
SetImageAndDescriptionState();
UpdateRiepiloghi();
}
public BookingDTO[] GetConfirmMailDetails(int BookingId)
{
try
{
if (bookingHandler == null)
{
bookingHandler = new BookingHandler();
}
return(bookingHandler.GetConfirmMail(BookingId));
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet GetBookingsCruiseFH(cdtGetBookingsInput getBookingsInput)
{
try
{
if (bookingHandler == null)
{
bookingHandler = new BookingHandler();
}
return(bookingHandler.GetBookingsCruiseFH(getBookingsInput));
}
catch (Exception exp)
{
throw exp;
}
}
public List <ViewBookingDTO> GetBookingsFH(cdtGetBookingsInput getBookingsInput)
{
try
{
if (bookingHandler == null)
{
bookingHandler = new BookingHandler();
}
return(bookingHandler.GetBookingsFH(getBookingsInput));
}
catch (Exception exp)
{
throw exp;
}
}
public BookingDTO[] GetBookingDetails(DateTime FromDate, DateTime ToDate)
{
try
{
if (bookingHandler == null)
{
bookingHandler = new BookingHandler();
}
return(bookingHandler.GetBookingDetails(FromDate, ToDate));
}
catch (Exception exp)
{
throw exp;
}
}
public int GetBookingReferenceCount(BookingDTO BookingData)
{
try
{
if (bookingHandler == null)
{
bookingHandler = new BookingHandler();
}
return(bookingHandler.GetBookingReferenceCount(BookingData));
}
catch (Exception exp)
{
throw exp;
}
}
public bool CancelBooking(int BookingId)
{
try
{
if (bookingHandler == null)
{
bookingHandler = new BookingHandler();
}
return(bookingHandler.CancelBooking(BookingId));
}
catch (Exception exp)
{
throw exp;
}
}
public bool UpdateBooking(BookingDTO oBookingData, BookedRooms[] oBookedRooms, BookingWaitListDTO[] oBookingWaitListData, BookedRooms[] TotallyRemovedRoomCategoryAndType)
{
try
{
if (bookingHandler == null)
{
bookingHandler = new BookingHandler();
}
return(bookingHandler.UpdateBooking(oBookingData, oBookedRooms, oBookingWaitListData, TotallyRemovedRoomCategoryAndType));
}
catch (Exception exp)
{
throw exp;
}
}
public bool AddBooking(BookingDTO oBookingData, BookedRooms[] oBookedRooms, BookingWaitListDTO[] oBookingWaitListData, out int BookingId)
{
try
{
if (bookingHandler == null)
{
bookingHandler = new BookingHandler();
}
return(bookingHandler.AddBooking(oBookingData, oBookedRooms, oBookingWaitListData, out BookingId));
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet CheckifCharteredBookingExists(DateTime frm, DateTime to)
{
try
{
if (bookingHandler == null)
{
bookingHandler = new BookingHandler();
}
return(bookingHandler.CheckifCharteredBookingExists(frm, to));
}
catch (Exception exp)
{
throw exp;
}
}
private void schedulerStorage1_AppointmentDeleting(object sender, PersistentObjectCancelEventArgs e)
{
try
{
Nested_CheckSecurityForDeletion();
}
catch (AccessDeniedException)
{
ErrorHandler.Show("Impossibile accedere alla funzionalità richiesta. Accesso negato");
e.Cancel = true;
return;
}
//if (XtraMessageBox.Show("Sicuro di procedere alla cancellazione dell'assegnazione?", "Domanda", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
//{
DevExpress.XtraScheduler.Appointment app = e.Object as DevExpress.XtraScheduler.Appointment;
Assignment a = app.GetSourceObject(schedulerStorage1) as Assignment;
IBooking b = a.Booking;
//aggiorno lo stato della prenotaizone
a.Booking.RemoveAssignment(a);
if (b.Assignments.Count == 0)
{
//elimino l'intera prenotazione
BookingHandler h = new BookingHandler();
h.Delete(b.BaseObject);
}
else
{
//elimino solo la assegnazione corrente
////i save on my db
AssignmentHandler h = new AssignmentHandler();
h.Delete(a);
}
// return;
//}
//e.Cancel = true;
}
public ActionResult DeleteConfirmed(int id)
{
User u = (User)Session[WebUtil.CURRENT_USER];
if (!(u != null && u.IsInRole(WebUtil.ADMIN_ROLE)))
{
return(RedirectToAction("Login", "User", new { ctl = "Admin", act = "AdminPanel" }));
}
Booking booking = new BookingHandler().GetBookingById(id);
db.Entry(booking.Tour).State = EntityState.Unchanged;
db.Entry(booking.User).State = EntityState.Unchanged;
db.Entry(booking).State = EntityState.Deleted;
db.Bookings.Remove(booking);
db.SaveChanges();
return(RedirectToAction("BookingList"));
}
public void BookRoom_WithEmptyStore_ShouldBeSuccessful()
{
var store = new InMemoryStore();
Assert.Empty(store.AllBookings());
var bus = new FakeBus();
var handler = new BookingHandler(new BookingService(store, bus));
bus.Subscribe <BookRoom>(handler.Handle);
bus.Send(new BookRoom("Room1", DateTime.Now, DateTime.Now.AddDays(2)));
var bookings = store.AllBookings();
Assert.NotEmpty(bookings);
Assert.Single(bookings);
Assert.Equal("Room1", bookings.Single().RoomName);
}
private IBooking CreateNewBooking()
{
BookingHandler h = new BookingHandler();
IBooking b = new Booking();
b.Date = DateTime.Now;
b.BookingType = new BookingTypeHandler().GetAll()[0] as BookingType;
b.Notes = "";
b.Operator = null;
b.Color = Color.WhiteSmoke.ToArgb();
b.ColorBookings = false;
b.Notes1 = "";
b.UnConfirmBooking();
h.SaveOrUpdate(b as Booking);
return(b);
}
private CFormReportDTO GetCFormData(int bookingId, bool foreignNationals, bool indianNationals)
{
CFormReportDTO cFormReportDto;
BookingDTO bookingDetailsDto;
BookingTouristDTO[] bookingTouristDetailsDto;
BookingHandler bookingHandler;
BookingTouristHandler touristHandler;
try
{
bookingHandler = new BookingHandler();
touristHandler = new BookingTouristHandler();
cFormReportDto = new CFormReportDTO();
GenerateCFormNumbers(bookingId);
bookingDetailsDto = bookingHandler.GetBookingDetails(bookingId);
cFormReportDto.CFormNo = GetBookingCFormNo(bookingDetailsDto, foreignNationals, indianNationals);
cFormReportDto.BookingDetails = bookingDetailsDto;
bookingTouristDetailsDto = touristHandler.GetAllTouristDetails(bookingId);
if (foreignNationals && indianNationals)
{
cFormReportDto.BookingTouristDetails = bookingTouristDetailsDto;
}
else if (foreignNationals)
{
cFormReportDto.BookingTouristDetails = GetForeignNationalsData(bookingTouristDetailsDto);
}
else if (indianNationals)
{
cFormReportDto.BookingTouristDetails = GetIndianNationalsData(bookingTouristDetailsDto);
}
}
catch (Exception exp)
{
throw exp;
}
return(cFormReportDto);
}
public BookingDTO[] GetRoomBookings(string RoomNo)
{
try
{
if (bookingHandler == null)
{
bookingHandler = new BookingHandler();
}
return(bookingHandler.GetRoomBookings(RoomNo));
}
catch (Exception exp)
{
throw exp;
}
finally
{
bookingHandler = null;
}
}
public ActionResult Delete(int?id)
{
User u = (User)Session[WebUtil.CURRENT_USER];
if (!(u != null && u.IsInRole(WebUtil.ADMIN_ROLE)))
{
return(RedirectToAction("Login", "User", new { ctl = "Admin", act = "AdminPanel" }));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Booking booking = new BookingHandler().GetBookingById(id);
if (booking == null)
{
return(HttpNotFound());
}
return(View(booking));
}
private void SetGridDataSource()
{
try
{
BookingHandler hh = new BookingHandler();
DataRange r = null;
if (dateEdit1.DateTime > dateEdit2.DateTime)
{
r = new DataRange(dateEdit2.DateTime, dateEdit1.DateTime);
}
else
{
r = new DataRange(dateEdit1.DateTime, dateEdit2.DateTime);
}
IList h = hh.GetBookings(r);
if (h.Count == 0)
{
XtraMessageBox.Show("Nessuna prenotazione trovata", "Messaggio", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try
{
gridControl1.MainView.SaveLayoutToXml(fileLayout);
}
catch (Exception)
{
//non fa nulla
}
}
gridControl1.DataSource = h;
}
catch (Exception ex)
{
WIN.SCHEDULING_APP.GUI.Utility.ErrorHandler.Show(ex);
}
}
public async Task <IActionResult> Edit(int id, int GuestId, [Bind("Id,CategoryId,StartDate,EndDate,GuestId")] BookingModel booking)
{
try
{
//först måste vi ta bort aktuell bokning från den lokala bokningslistan
//anropa metod för att kolla om bokningen är möjlig
List <RoomModel> roomList = await ApiConnection.GetRoomList();
List <BookingModel> bookingList = await ApiConnection.GetBookingList();
foreach (var item in bookingList)
{
if (booking.Id == item.Id)
{
bookingList.Remove(item);
break;
}
}
int bookingstart = int.Parse(DateTime.Parse(booking.StartDate.ToString()).ToString().Remove(10, 9).Remove(4, 1).Remove(6, 1)); //parsar datetime till int
int bookingend = int.Parse(DateTime.Parse(booking.EndDate.ToString()).ToString().Remove(10, 9).Remove(4, 1).Remove(6, 1)); //parsar datetime till int
int dateToday = int.Parse(DateTime.Parse(DateTime.Today.ToString()).ToString().Remove(10, 9).Remove(4, 1).Remove(6, 1));
List <RoomModel> corcatroom = new List <RoomModel>();
if (bookingstart < bookingend && bookingstart >= dateToday) //kollar så bokningens start datum inte är efter slutdatum
{
corcatroom.AddRange(from item in roomList
where item.CategoryId == booking.CategoryId
select item);
//---------------------------------------------------------------------------------------------------------------------------------------------
BookingHandler.RoomAvailableCheckV2(bookingList, corcatroom, bookingstart, bookingend);
RoomModel Besterummet = new RoomModel();
if (corcatroom.Count() > 0)
{
Besterummet = corcatroom.First();
BookingModel finalBooking = new BookingModel();
finalBooking.Id = booking.Id;
finalBooking.StartDate = booking.StartDate;
finalBooking.EndDate = booking.EndDate;
finalBooking.RoomId = Besterummet.Id;
finalBooking.GuestId = GuestId;
HttpResponseMessage response = ApiConnection.ApiClient.PutAsJsonAsync("BookingModels/" + finalBooking.Id, finalBooking).Result;
return(RedirectToAction(nameof(Index)));
}
else
{
ViewData["norooms"] = "Det finns inga lediga rum av din preferenser";
await ViewbagCategory();
return(View());
}
}
else
{
ViewData["wrongtime"] = "Denna ändring är inte möjlig";
await ViewbagCategory();
return(RedirectToAction("Privacy", "Home"));
}
}
catch (Exception ex)
{
_logger.LogWarning("Could not edit booking: HttpPost", ex);
throw;
}
}
public GetCoincidingBookingsCommand(DateTime requestedStartDate, DateTime requestedEndDate, ApplicationDbContext dbContext)
{
BookingHandler = new BookingHandler(dbContext);
RequestedStartDate = requestedStartDate;
RequestedEndDate = requestedEndDate;
}
public UpdateBookingCommand(Booking booking, List <Equipment> chosenEquipmentList, ApplicationDbContext dbContext)
{
Booking = booking;
ChosenEquipmentList = chosenEquipmentList;
BookingHandler = new BookingHandler(dbContext);
}
public AddBookingCommand(Booking newBooking, List <Equipment> chosenEquipmentList, ApplicationDbContext dbContext)
{
BookingHandler = new BookingHandler(dbContext);
NewBooking = newBooking;
ChosenEquipmentList = chosenEquipmentList;
}
