public IActionResult Index()
{
var viewModel = new IndexVIewModel
{
Year = DateTime.UtcNow.Year,
Message = this.configuration["YouTube:ApiKey"],
Names = new List <string> {
"pesho", "gosho", "todor"
},
};
return(View(viewModel));
}
public async Task <IActionResult> Index()
{
var builds = this.buildService.GetAllAsync <BuildViewModel>(10);
var blogs = await this.blogService.GetAllAsync <BlogViewModel>(3);
var indexViewModel = new IndexVIewModel()
{
Blogs = blogs,
Builds = builds,
};
return(this.View(indexViewModel));
}
public async Task <IActionResult> Manage(string company, string date, int page = 1,
SortState sortOrder = SortState.CheckInAsc)
{
int pageSize = 10;
ApplicationUser user = new ApplicationUser();
var users = _userManager.Users.ToList();
if (User.Identity.IsAuthenticated)
{
user = users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
}
if (user == null)
{
return(NotFound());
}
var Restaraunt = _context.RestaurantsList.Where(t => t.ID == user.RestaurantID).FirstOrDefault();
if (Restaraunt == null)
{
return(Redirect("/Home/Contact"));
}
var halls = _context.Halls.Where(h => h.RestaurantID == Restaraunt.ID);
if (halls.Count() < 1)
{
return(Redirect("/Home/Contact"));
}
List <HallSimple> SelectedHallsList = new List <HallSimple>();
foreach (Hall h in halls)
{
HallSimple Temp = new HallSimple {
HallID = h.ID, HallName = h.Name
};
SelectedHallsList.Add(Temp);
}
var table = _context.TablesList.Join(halls, T => T.HallID,
H => H.ID,
(T, H) => new { id = T.ID, hallid = H.ID, tablename = T.Name, hallname = H.Name }
).ToList();
IQueryable <ManageBookingViewModel> bookings = _context.Bookings.Join(table, B => B.TableID,
T => T.id,
(B, T) => new ManageBookingViewModel
{
BookingID = B.ID,
CheckIn = B.CheckIn,
CheckOut = B.CheckOut,
Completed = B.Completed,
CustomerName = B.CustomerName,
CustomerPhone = B.CustomerPhone,
Guests = B.Guests,
Paid = B.Paid,
HallID = T.hallid,
HallName = T.hallname,
TableName = T.tablename,
TableID = B.TableID
}
);
if (company != null && company != "0")
{
bookings = bookings.Where(p => p.HallID == company);
}
DateTime SD = DateTime.MinValue;
DateTime dateValue;
if (DateTime.TryParse(date, out dateValue))
{
SD = Convert.ToDateTime(date);
bookings = bookings.Where(p => p.CheckIn >= SD);
}
switch (sortOrder)
{
case SortState.CheckInDesc:
bookings = bookings.OrderByDescending(s => s.CheckIn);
break;
case SortState.PhoneAsc:
bookings = bookings.OrderBy(s => s.CustomerPhone);
break;
case SortState.PhoneDesc:
bookings = bookings.OrderByDescending(s => s.CustomerPhone);
break;
case SortState.HallAsc:
bookings = bookings.OrderBy(s => s.HallName);
break;
case SortState.HallDesc:
bookings = bookings.OrderByDescending(s => s.HallName);
break;
default:
bookings = bookings.OrderBy(s => s.CheckIn);
break;
}
var count = await bookings.CountAsync();
var items = await bookings.Skip((page - 1) *pageSize).Take(pageSize).ToListAsync();
IndexVIewModel viewModel = new IndexVIewModel
{
PageViewModel = new PageViewModel(count, page, pageSize),
SortViewModel = new SortViewModel(sortOrder),
FilterViewModel = new FilterViewModel(SelectedHallsList, company, SD),
Bookings = items
};
return(View(viewModel));
}
