static public void FillFromDataBase(this List <TeenRecord> r)
{
try
{
using (var db = Code.TeenDataHelper.GetEE())
{
var TeenRecs = db.Teens.ToList(); // Read all the records from the DB
if (TeenRecs.Count <= 0)
{
return;
}
TeenRecs.ForEach(rec =>
{
TeenRecord e = new TeenRecord();
e.Bus = rec.Bus;
e.City = rec.City;
e.CheckIn = "N";
e.Dirty = "N";
e.FirstName = rec.FirstName;
e.Grade = rec.Grade;
e.GuestOf = rec.GuestOf;
e.GuestOfKey = rec.GuestOfKey;
e.LastName = rec.LastName;
e.NewRec = "N";
e.PhoneArea = rec.PhoneArea;
e.PhonePrefix = rec.PhonePrefix;
e.PhoneSuffix = rec.PhonePostfix;
e.PrivateRecId = -1;
e.PublicRecId = rec.id;
e.Sex = rec.Sex;
e.State = rec.State;
e.Street1 = rec.Street1;
e.Street2 = rec.Street2;
e.UpdateCheckin = "N";
e.UpdateRec = "N";
e.Zip = rec.zip;
var NightRec = rec.TeenNights.Where(x => x.AttendanceDate.Date == DateTime.Now.Date).FirstOrDefault();
if (NightRec != null)
{
e.CheckIn = NightRec.Attended;
}
r.Add(e);
});
}
}
catch (Exception ex)
{
Code.LogMan.Log(ex);
throw;
}
}
public static void FillFromDataBase(this List<TeenRecord> r)
{
try
{
using (var db = Code.TeenDataHelper.GetEE())
{
var TeenRecs = db.Teens.ToList(); // Read all the records from the DB
if (TeenRecs.Count <= 0) return;
TeenRecs.ForEach(rec =>
{
TeenRecord e = new TeenRecord();
e.Bus = rec.Bus;
e.City = rec.City;
e.CheckIn = "N";
e.Dirty = "N";
e.FirstName = rec.FirstName;
e.Grade = rec.Grade;
e.GuestOf = rec.GuestOf;
e.GuestOfKey = rec.GuestOfKey;
e.LastName = rec.LastName;
e.NewRec = "N";
e.PhoneArea = rec.PhoneArea;
e.PhonePrefix = rec.PhonePrefix;
e.PhoneSuffix = rec.PhonePostfix;
e.PrivateRecId = -1;
e.PublicRecId = rec.id;
e.Sex = rec.Sex;
e.State = rec.State;
e.Street1 = rec.Street1;
e.Street2 = rec.Street2;
e.UpdateCheckin = "N";
e.UpdateRec = "N";
e.Zip = rec.zip;
var NightRec = rec.TeenNights.Where(x => x.AttendanceDate.Date == DateTime.Now.Date).FirstOrDefault();
if(NightRec != null)
{
e.CheckIn = NightRec.Attended;
}
r.Add(e);
});
}
}
catch (Exception ex)
{
Code.LogMan.Log(ex);
throw;
}
}
