public ActionResult ManageOrders()
{
var manager = new ApplicationUserManager(new UserStore <ApplicationUser>(new ApplicationDbContext()));
List <GetUserOrders_Result> ResOrders;
List <OrderToDisplay> Orders = new List <OrderToDisplay>();
List <OrderToDisplay> BookingsCancelled = new List <OrderToDisplay>();
List <OrderToDisplay> BookingsValid = new List <OrderToDisplay>();
List <OrderToDisplay> PastOrders;
List <OrderToDisplay> FutureOrders;
ResOrders = _context.GetUserOrders(User.Identity.GetUserId()).ToList();
foreach (GetUserOrders_Result r in ResOrders)
{
var CurRoom = _context.GetRoomById(r.RoomId).FirstOrDefault();
OrderToDisplay OrderVM = new OrderToDisplay
{
ID = r.ID,
Username = User.Identity.GetUserName(),
RoomNo = CurRoom.RoomNo,
FromDate = r.FromDate,
ToDate = r.ToDate,
IsCancelled = r.IsCancelled ? "Cancelled" : "Normal",
UnitPrice = CurRoom.Price,
TotalCost = r.TotalCost
};
if (r.IsCancelled)
{
BookingsCancelled.Add(OrderVM);
}
else
{
BookingsValid.Add(OrderVM);
}
}
DateTime now = DateTime.Now;
DateTime DateOfToday = new DateTime(now.Year, now.Month, now.Day);
PastOrders = BookingsValid.Where(o => ((o.ToDate <= DateOfToday) || (o.FromDate <= DateOfToday && o.ToDate >= DateOfToday))).ToList();
HashSet <int> PastCurBookingIds = new HashSet <int>(PastOrders.Select(o => o.ID).ToList());
FutureOrders = BookingsValid.Where(o => !PastCurBookingIds.Contains(o.ID)).ToList();
var tables = new ManageOrderViewModel
{
PastOrders = PastOrders,
FutureOrders = FutureOrders,
CancelledOrders = BookingsCancelled
};
return(View(tables));
}
public ActionResult ManageOrders()
{
List <GetOrders_Result> ResOrders;
List <OrderToDisplay> Orders = new List <OrderToDisplay>();
List <OrderToDisplay> CancelledOrders = new List <OrderToDisplay>();
ResOrders = _context.GetOrders().ToList();
foreach (GetOrders_Result r in ResOrders)
{
var CurRoom = _context.GetRoomById(r.RoomId).FirstOrDefault();
OrderToDisplay OrderVM = new OrderToDisplay
{
ID = r.ID,
Username = UserMgr.FindById(r.UserId).UserName,
RoomNo = CurRoom.RoomNo,
FromDate = r.FromDate,
ToDate = r.ToDate,
IsCancelled = r.IsCancelled ? "Cancelled" : "Normal",
UnitPrice = CurRoom.Price,
TotalCost = r.TotalCost
};
if (!r.IsCancelled)
{
Orders.Add(OrderVM);
}
else
{
CancelledOrders.Add(OrderVM);
}
}
var tables = new ManageOrdersViewModel
{
Orders = Orders,
CancelledOrders = CancelledOrders
};
return(View(tables));
}
