public void ReservationList(Form _MdiForm)
{
ReservationList Help = new ReservationList();
Help.MdiParent = _MdiForm;
Help.Show();
}
private void UserReservationButton_Click(object sender, EventArgs e)
{
Program app = Program.GetInstance();
ReservationList reservationList = app.GetScreen <ReservationList>("reservationList");
app.ShowScreen(reservationList);
}
public ActionResult MarkOrderAsReturned(int id)
{
var order = uow.OrderRepository.Get(m => m.OrderId == id);
order.OrderStatus = 4;
order.Payment = uow.PaymentRepository.Get(m => m.PaymentID == order.PaymentRefID);
uow.OrderRepository.Update(order);
foreach (var b in order.OrderLine)
{
if (b.BookCopy.BookCopyStatus == 3)
{
ReservationList reservationList = uow.ReservationListRepository.Get(m => m.bookId == b.BookId);
List<ReservationListUser> usersOnList =
uow.ReservationListUserRepository.GetAll()
.Where(m => m.ReservationListId == reservationList.ReservationListId)
.OrderByDescending(m => m.DateAddedToList).ToList();
ReservationListUser firstOnList = usersOnList.FirstOrDefault();
}
b.BookCopy.BookCopyStatus = 0;
b.BookCopy.Book.StockLevel++;
uow.BookRepository.Update(b.BookCopy.Book);
uow.BookCopyRepository.Update(b.BookCopy);
uow.OrderLineRepository.Update(b);
}
ApplicationUser user = uow.UserRepository.Get(m => m.Id.Equals(order.UserOrderId));
user.CanPlaceOrder = true;
user.AccountRestricted = false;
uow.UserRepository.Update(user);
uow.SaveChanges();
TempData["ReturnedMessage"] = "Order number: " + order.OrderId + " has now been marked as returned";
return RedirectToAction("ViewAllActiveOrders");
}
/// <summary>Snippet for List</summary>
public void List()
{
// Snippet: List(string, string, CallSettings)
// Create client
ReservationsClient reservationsClient = ReservationsClient.Create();
// Initialize request argument(s)
string project = "";
string zone = "";
// Make the request
ReservationList response = reservationsClient.List(project, zone);
// End snippet
}
public string GetReservationFromDateTime(DateTime date, DateTime time)
{
DateTime reservationDate = date.Add(time.TimeOfDay);
ReservationViewModel reservation = ReservationList.Find(x => x.StartDate.CompareTo(reservationDate) <= 0 && x.EndDate.CompareTo(reservationDate) > 0);
string result = string.Empty;
if (reservation != null)
{
UrlHelper url = new UrlHelper(HttpContext.Current.Request.RequestContext);
result = String.Format("<a href=\"{0}\">{1} {2}</a>", url.Action("Details", new { id = reservation.Id }), reservation.Member.FirstName, reservation.Member.LastName);
}
return(result);
}
/// <summary>Snippet for ListAsync</summary>
public async Task ListAsync()
{
// Snippet: ListAsync(string, string, CallSettings)
// Additional: ListAsync(string, string, CancellationToken)
// Create client
ReservationsClient reservationsClient = await ReservationsClient.CreateAsync();
// Initialize request argument(s)
string project = "";
string zone = "";
// Make the request
ReservationList response = await reservationsClient.ListAsync(project, zone);
// End snippet
}
public ReservationList GetReservation(int page = 0, int sort = 0)
{
var totalElement = Query <int>("sp_CountReservation").FirstOrDefault();
var totalPage = totalElement / rows;
var decimalNumber = Math.IEEERemainder(totalElement, rows);
if (decimalNumber != 0)
{
totalPage++;
}
var pageNumber = page + 1;
int take = 10;
if ((totalPage == pageNumber) && (pageNumber * rows > totalElement))
{
take = (totalElement - (rows * page)) - 1;
}
ReservationList reservationList = new ReservationList();
var parameters = new DynamicParameters();
parameters.Add("Sort", sort, DbType.Int32);
parameters.Add("Skip", page * rows, DbType.Int32);
parameters.Add("Take", take, DbType.Int32);
parameters.Add("ErrorCode", null, DbType.Int32, ParameterDirection.Output);
var query = Query <Reservation, Place, Contact, Reservation>("sp_GetReservation",
(r, pa, c) =>
{
r.Place = pa;
r.Contact = c;
return(r);
}, parameters, split: "PlaceId, ContactId")
.AsQueryable();
IEnumerable <Reservation> result = query.ToList();
reservationList.TotalPage = totalPage;
reservationList.SortByCode = sort;
reservationList.List = result;
return(reservationList);
}
/// <summary>Snippet for List</summary>
public void ListRequestObject()
{
// Snippet: List(ListReservationsRequest, CallSettings)
// Create client
ReservationsClient reservationsClient = ReservationsClient.Create();
// Initialize request argument(s)
ListReservationsRequest request = new ListReservationsRequest
{
Zone = "",
PageToken = "",
MaxResults = 0U,
Filter = "",
OrderBy = "",
Project = "",
ReturnPartialSuccess = false,
};
// Make the request
ReservationList response = reservationsClient.List(request);
// End snippet
}
public bool makeReservation(DateTime startDate, DateTime endDate, Hotel hotel, Room room)
{
bool temp = true;
foreach (Reservation i in ReservationList)
{
if (i.StartDate < endDate && startDate < i.EndDate && hotel == i.Hotel && room.No == i.Room.No)
{
temp = false;
break;
}
}
if (temp)
{
Reservation reservation = new Reservation(startDate, endDate, hotel, room);
ReservationList.Add(reservation);
}
return(temp);
}
/// <summary>
/// WriteToXML
/// </summary>
/// <param name="reservationList"></param>
public static void WriteToXML(ReservationList reservationList)
{
XmlSerializer serializer = null;
TextWriter writer = null;
try
{
serializer = new XmlSerializer(typeof(ReservationList));
writer = new StreamWriter(Common.XML_FILE_NAME);
serializer.Serialize(writer, reservationList);
}
catch (Exception ex)
{
throw ex;
}
finally
{
writer.Flush();
writer.Close();
}
}
public async Task <IActionResult> OnPostGetAvailableRoomsAsync(DateTime startDate, DateTime endDate)
{
//ItemList = await _itemApi.GetItems();
ReservationList = await _reservationApi.GetReservations();
ReservationList = ReservationList.Where(b => (b.StartDate > startDate && b.StartDate < endDate) || (b.EndDate > startDate) && b.EndDate < endDate).ToList();
RoomList = await _roomApi.GetRooms();
RoomList = RoomList.Where(x => ReservationList.Where(y => y.RoomId == x.Id).ToList().Count == 0).ToList();
Rooms = RoomList.Select(x => new SelectListItem()
{
Text = x.Name,
Value = x.Id
}).ToList();
TempData["startDate"] = startDate;
TempData["endDate"] = endDate;
return(Page());
}
private void ShowTimeTable(DateTime selectedDate)
{
IEnumerable <ReservationVo> necessaryList;
for (int k = 0; k < StylistList.Count; k++) //미용사 리스트를 가져와서 한명씩 실행
{
_row = _dataTable.NewRow(); //DataRow를 생성해서 그 사람의 예약 테이블을 채워야지
_row["StylistName"] = StylistList[k].StylistName;
//_dataTable.Rows.Add(_row["StylistName"].ToString());
//예약 목록 중 StylistId와 StylistList[k].StylistId가 일치하는 사람 찾아서 예약목록 불러오기
necessaryList = ReservationList.Where(x => x.StylistId == StylistList[k].StylistId);
//이 목록 중에서 선택한 날짜만 다시 불러오기
necessaryList = necessaryList.Where(x => x.StartAt.ToString("d").Equals(selectedDate.ToString("d")));
//SaveResInColumn(necessaryList);
SaveResInColumn.SaveReservationInColumn(necessaryList, _dataTable, _row);
}
}
/// <summary>Snippet for ListAsync</summary>
public async Task ListRequestObjectAsync()
{
// Snippet: ListAsync(ListReservationsRequest, CallSettings)
// Additional: ListAsync(ListReservationsRequest, CancellationToken)
// Create client
ReservationsClient reservationsClient = await ReservationsClient.CreateAsync();
// Initialize request argument(s)
ListReservationsRequest request = new ListReservationsRequest
{
Zone = "",
PageToken = "",
MaxResults = 0U,
Filter = "",
OrderBy = "",
Project = "",
ReturnPartialSuccess = false,
};
// Make the request
ReservationList response = await reservationsClient.ListAsync(request);
// End snippet
}
/// <summary>
/// コマンドを実行
/// </summary>
public void Execute()
{
// 検索クラス作成
var finder = new ProcessFormat()
{
HotelID = new Hotel()
{
HotelID = SelectedHotel.HotelID,
HotelName = SelectedHotel.HotelName,
PrefCode = SelectedHotel.PrefCode
},
CheckinDate = CheckinDate,
Type = SelectedRoomType,
CheckinValue = SelectedCheckinTime,
EnableNoSmoking = ChkNoSmoking,
EnableSmoking = ChkSmoking,
SmokingFirst = IsSmokingFirst,
EnableAutoRetry = ChkAutoRetry,
EnableOverwrite = ChkOverwrite
};
var item = new ReservationControlViewModel(finder);
ReservationList.Add(item);
}
/// <summary>
/// ReadXML
/// </summary>
/// <param name="reservationList"></param>
public static void ReadXML(ref ReservationList reservationList)
{
try
{
if (File.Exists(Common.XML_FILE_NAME))
{
XmlSerializer serializer = new XmlSerializer(typeof(ReservationList));
StreamReader reader = new StreamReader(Common.XML_FILE_NAME);
reservationList = (ReservationList)serializer.Deserialize(reader);
reader.Close();
}
else
{
// Create xml file
TextWriter writer = new StreamWriter(Common.XML_FILE_NAME);
writer.Flush();
writer.Close();
}
}
catch (Exception)
{
throw;
}
}
private void DeleteButton_Click(object sender, EventArgs e)
{
Program app = Program.GetInstance();
UserService userService = app.GetService <UserService>("users");
ReservationService reservationService = app.GetService <ReservationService>("reservations");
// Ask for confirmation
if (!GuiHelper.ShowConfirm("Weet je zeker dat je deze reservering wilt verwijderen?"))
{
return;
}
if (!reservationService.DeleteReservation(reservation))
{
GuiHelper.ShowError("Kon reservering niet verwijderen");
return;
}
// Redirect to screen
ReservationList reservationListScreen = app.GetScreen <ReservationList>("reservationList");
app.ShowScreen(reservationListScreen);
GuiHelper.ShowInfo("Reservering succesvol verwijderd");
}
public ReservationList GetReservation(int page = 0, int sort = 0)
{
ReservationList reservationList = new ReservationList();
IEnumerable <Reservation> result = null;
Func <IQueryable <Reservation>, IOrderedQueryable <Reservation> > orderBy = null;
var totalElement = Context.Reservations.Count();
var totalPage = totalElement / rows;
var decimalNumber = Math.IEEERemainder(totalElement, rows);
if (decimalNumber != 0)
{
totalPage++;
}
reservationList.TotalPage = totalPage;
reservationList.SortByCode = sort;
if (sort > 0)
{
switch (sort)
{
case 1:
orderBy = s => s.OrderBy(t => t.Date);
break;
case 2:
orderBy = s => s.OrderByDescending(t => t.Date);
break;
case 3:
orderBy = s => s.OrderBy(t => t.Place.Name);
break;
case 4:
orderBy = s => s.OrderByDescending(t => t.Place.Name);
break;
default:
orderBy = s => s.OrderByDescending(t => t.Ranking);
break;
}
reservationList.SortByCode = sort;
result = orderBy(Context.Reservations).ToList().Skip(page * rows).Take(rows).Select(r => new Reservation()
{
Id = r.Id,
Date = r.Date,
IsFavorite = r.IsFavorite,
Ranking = r.Ranking,
Place = r.Place
}
);
}
else
{
result = Context.Reservations.AsNoTracking().Distinct().ToList().Skip(page * rows).Take(rows).Select(r => new Reservation()
{
Id = r.Id,
Date = r.Date,
IsFavorite = r.IsFavorite,
Ranking = r.Ranking,
Place = r.Place
}
);
}
reservationList.List = result;
return(reservationList);
}
public void cancelReservation(Reservation reservation)
{
ReservationList.Remove(reservation);
}
public ucHotel()
{
InitializeComponent();
DB = new ReservationList();
}
/***************************CLASS METHODS*************************/
/*************************** WAITING LIST (UNFINISHED FUNCTIONALITY) *************************/
/// <summary>
/// Method which adds a user to a waiting list for a particular book
/// </summary>
/// <param name="user">user to be added to list</param>
/// <param name="book">book which the waiting list applies to</param>
/// <returns>a message stating if they have been added or not</returns>
public string AddToWaitingList(ApplicationUser user, Book book)
{
var waitingList = uow.ReservationListRepository.Get(m => m.bookId == book.BookId);
string message;
//entity to be added to waiting list
//includes a date added, the list they are being added to and the user being added
ReservationListUser reservationListUser = new ReservationListUser
{
ReservationList = waitingList,
User = user,
UserId = user.Id,
DateAddedToList = DateTime.Now
//POSSIBLY NEED TO ADD BOOK COPY?
};
//if no waiting list exists create one
if (waitingList == null)
{
ReservationList newReservationList = new ReservationList
{
ReservationListUser = new List<ReservationListUser>(),
Book = book,
bookId = book.BookId
};
newReservationList.ReservationListUser.Add(reservationListUser);
uow.ReservationListRepository.Add(newReservationList);
uow.ReservationListUserRepository.Add(reservationListUser);
var bookCopyToBeReserved = uow.BookCopyRepository.Get(m => m.Book.BookId == book.BookId && m.BookCopyStatus == 2);
bookCopyToBeReserved.BookCopyStatus = 3;
bookCopyToBeReserved.Book = book;
uow.BookCopyRepository.Update(bookCopyToBeReserved);
message = "added to list";
uow.SaveChanges();
return message;
}
//if waiting list exists add user to it
else if (waitingList.ReservationListUser.Contains(reservationListUser) == false)
{
uow.ReservationListUserRepository.Add(reservationListUser);
waitingList.ReservationListUser.Add(reservationListUser);
waitingList.Book = book;
uow.ReservationListRepository.Update(waitingList);
uow.SaveChanges();
message = "added to list";
return message;
}
else
{
message = "Already on this waiting list";
return message;
}
}
