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 void PopulateFromEE(Entity.TeenData.Teen r)
{
id = r.id;
FirstName = r.FirstName;
LastName = r.LastName;
PhoneArea = r.PhoneArea;
PhonePrefix = r.PhonePrefix;
PhonePostfix = r.PhonePostfix;
Street1 = r.Street1;
Street2 = r.Street2;
City = r.City;
State = r.State;
zip = r.zip;
Sex = r.Sex;
Bus = r.Bus;
Grade = r.Grade;
GuestOf = r.GuestOf;
GuestOfKey = r.GuestOfKey;
}
public Entity.TeenData.Teen ToEE()
{
Entity.TeenData.Teen r = new Entity.TeenData.Teen();
r.id = id;
r.FirstName = FirstName;
r.LastName = LastName;
r.PhoneArea = PhoneArea;
r.PhonePrefix = PhonePrefix;
r.PhonePostfix = PhonePostfix;
r.Street1 = Street1;
r.Street2 = Street2;
r.City = City;
r.State = State;
r.zip = zip;
r.Sex = Sex;
r.Bus = Bus;
r.Grade = Grade;
r.GuestOf = GuestOf ?? "";
r.GuestOfKey = GuestOfKey ?? "";
return(r);
}
public void Insert(Entity.TeenData.TeenDB db)
{
var rec = new Entity.TeenData.Teen()
{
FirstName = FirstName,
LastName = LastName,
PhoneArea = PhoneArea,
PhonePrefix = PhonePrefix,
PhonePostfix = PhoneSuffix,
Street1 = Street1,
Street2 = Street2,
City = City,
State = State,
zip = Zip,
Sex = Sex,
Bus = Bus,
Grade = Grade,
GuestOf = GuestOf,
GuestOfKey = GuestOfKey
};
db.Teens.Add(rec);
}
public Entity.TeenData.Teen ToEE()
{
Entity.TeenData.Teen r = new Entity.TeenData.Teen();
r.id = id;
r.FirstName = FirstName;
r.LastName = LastName;
r.PhoneArea = PhoneArea;
r.PhonePrefix = PhonePrefix;
r.PhonePostfix = PhonePostfix;
r.Street1 = Street1;
r.Street2 = Street2;
r.City = City;
r.State = State;
r.zip = zip;
r.Sex = Sex;
r.Bus = Bus;
r.Grade = Grade;
r.GuestOf = GuestOf ?? "";
r.GuestOfKey = GuestOfKey ?? "";
return r;
}
public void Insert(Entity.TeenData.TeenDB db)
{
var rec = new Entity.TeenData.Teen()
{
FirstName = FirstName,
LastName = LastName,
PhoneArea = PhoneArea,
PhonePrefix = PhonePrefix,
PhonePostfix = PhoneSuffix,
Street1 = Street1,
Street2 = Street2,
City = City,
State = State,
zip = Zip,
Sex = Sex,
Bus = Bus,
Grade = Grade,
GuestOf = GuestOf,
GuestOfKey = GuestOfKey
};
db.Teens.Add(rec);
}
public Teen(Entity.TeenData.Teen r)
{
PopulateFromEE(r);
}
