static public void UpdateCheckIn(this List <TeenRecord> r) { try { using (var db = Code.TeenDataHelper.GetEE()) { r.ForEach(rec => { Entity.TeenData.Teen dbRec = null; if (rec.PublicRecId == -1) { dbRec = db.Teens.Where(x => x.GuestOfKey == rec.GuestOfKey).FirstOrDefault(); } else { dbRec = db.Teens.Where(x => x.id == rec.PublicRecId).FirstOrDefault(); } if (dbRec == null) { return; } Entity.TeenData.TeenNight NightRec = dbRec.TeenNights.Where(x => x.AttendanceDate.Date == DateTime.Now.Date).FirstOrDefault(); if (NightRec != null) { NightRec.Attended = rec.CheckIn; } else { NightRec = new Entity.TeenData.TeenNight(); NightRec.AttendanceDate = DateTime.Today; NightRec.Attended = rec.CheckIn; NightRec.TeenId = dbRec.id; dbRec.TeenNights.Add(NightRec); } }); db.SaveChanges(); } } catch (Exception ex) { Code.LogMan.Log(ex); throw; } }
public static void UpdateCheckIn(this List<TeenRecord> r) { try { using (var db = Code.TeenDataHelper.GetEE()) { r.ForEach(rec => { Entity.TeenData.Teen dbRec = null; if(rec.PublicRecId == -1) { dbRec = db.Teens.Where(x => x.GuestOfKey == rec.GuestOfKey).FirstOrDefault(); } else { dbRec = db.Teens.Where(x => x.id == rec.PublicRecId).FirstOrDefault(); } if (dbRec == null) return; Entity.TeenData.TeenNight NightRec = dbRec.TeenNights.Where(x => x.AttendanceDate.Date == DateTime.Now.Date).FirstOrDefault(); if (NightRec != null) { NightRec.Attended = rec.CheckIn; } else { NightRec = new Entity.TeenData.TeenNight(); NightRec.AttendanceDate = DateTime.Today; NightRec.Attended = rec.CheckIn; NightRec.TeenId = dbRec.id; dbRec.TeenNights.Add(NightRec); } }); db.SaveChanges(); } } catch (Exception ex) { Code.LogMan.Log(ex); throw; } }
public Entity.TeenData.TeenNight ToEE() { Entity.TeenData.TeenNight r = new Entity.TeenData.TeenNight(); r.id = id; r.TeenId = TeenId; r.AttendanceDate = AttendanceDate; r.Decision = Decision; r.Attended = Attended; return r; }