public IEnumerable <string> Get(string location) { BsfEntities db = new BsfEntities(); string today = DateTime.Now.ToShortDateString(); var students = (from att in db.Attedences where att.Location == location && att.CheckInDate == today select att).Select(att => att.Student).ToList(); return(students); }
public IEnumerable <string> Get(string student, int year) { BsfEntities db = new BsfEntities(); DateTime yearStart = DateTime.Parse(string.Format("{0}/9/1", year)); DateTime yearEnd = DateTime.Parse(string.Format("{0}/9/1", year + 1)); var students = (from att in db.Attedences where att.Student == student && att.CheckInTimeStamp > yearStart && att.CheckInTimeStamp < yearEnd select att).Select(att => att.CheckInDate).ToList(); return(students); }
public IEnumerable <string> Get(int year, string location) { BsfEntities db = new BsfEntities(); DateTime yearStart = DateTime.Parse(string.Format("{0}/9/1", year)); DateTime yearEnd = DateTime.Parse(string.Format("{0}/9/1", year + 1)); var roster = (from att in db.Attedences where att.Location == location && att.CheckInTimeStamp > yearStart && att.CheckInTimeStamp < yearEnd select att).Select(att => att.Student).Distinct().ToList(); return(roster); }
public void Put(string student, string location) { BsfEntities db = new BsfEntities(); var today = DateTime.Today.ToShortDateString(); var checkin = (from a in db.Attedences where a.Student == student && a.CheckInDate == today select a).ToList(); if (checkin.Count == 0) { Attedence att = new Attedence { Student = student, Location = location, CheckInDate = DateTime.Now.ToShortDateString(), CheckInTimeStamp = DateTime.Now }; db.Attedences.Add(att); db.SaveChanges(); } }