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); } }