protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
using (var context = new BookingsDbContext())
{
var totalCheckins = context.Bookings
.Count(b => b.From == DateTime.Today);
var totalCheckouts = context.Bookings
.Count(b => b.To == DateTime.Today);
var summary = new RegistrationDaySummary
{
Date = DateTime.Today,
CheckIns = totalCheckins,
CheckOuts = totalCheckouts
};
Checkins.InnerText = summary.CheckIns.ToString();
Checkouts.InnerText = summary.CheckOuts.ToString();
Clock.Text = DateTime.Now.ToShortTimeString();
}
}
public RegistrationDaySummary GetTodayRegistrationSummary()
{
using (var db = new BookingsDbContext())
{
var totalCheckins = db.Bookings
.Count(b => b.From == DateTime.Today);
var totalCheckouts = db.Bookings
.Count(b => b.To == DateTime.Today);
var summary = new RegistrationDaySummary
{
Date = DateTime.Today,
CheckIns = totalCheckins,
CheckOuts = totalCheckouts
};
return(summary);
}
}
