protected override void AddRosterRowFrom4x4Sheet(ExpandedRowsContext model, SarUnit unit, IRosterEntry row)
{
TrainingRoster mrow = (TrainingRoster)row;
Guid personId = mrow.Person.Id;
TrainingRoster newRow = new TrainingRoster
{
Training = (Training)model.SarEvent,
Person = this.db.Members.Include("TrainingRosters").Single(f => f.Id == personId),
TimeIn = mrow.TimeIn,
TimeOut = mrow.TimeOut,
Miles = mrow.Miles,
};
mrow.Id = newRow.Id;
this.db.TrainingRosters.Add(newRow);
}
private Member NewEsarTrainee_Internal(FormCollection fields)
{
Member m = new Member();
TryUpdateModel(m, new[] { "FirstName", "LastName", "MiddleName", "BirthDate", "SheriffApp", "Gender" });
this.db.Members.Add(m);
SarUnit esar = (from u in this.db.Units where u.DisplayName == "ESAR" select u).First();
UnitStatus status = (from s in this.db.UnitStatusTypes where s.Unit.Id == esar.Id && s.StatusName == "trainee" select s).First();
if (!string.IsNullOrEmpty(fields["Street"]))
{
PersonAddress address = new PersonAddress { Person = m, Type = PersonAddressType.Mailing };
TryUpdateModel(address, new[] { "Street", "City", "State" });
GeographyServices.RefineAddressWithGeography(address);
if (address.Quality < 8)
{
try
{
ModelState.SetModelValue("Zip", new ValueProviderResult(fields["Zip"], fields["Zip"], CultureInfo.CurrentUICulture));
// This is supposed to be UpdateModel, not TryUpdate
UpdateModel(address, new[] { "Zip" });
}
catch (Exception)
{
ModelState.AddModelError("Zip", "Can't locate address. ZIP is required");
}
}
this.db.PersonAddress.Add(address);
}
foreach (string contact in new[] { "Home", "Work", "Cell" })
{
if (string.IsNullOrEmpty(fields[contact + "Phone"]))
{
continue;
}
ModelState.SetModelValue(contact + "Phone", new ValueProviderResult(fields[contact + "Phone"], fields[contact + "Phone"], CultureInfo.CurrentUICulture));
PersonContact pc = new PersonContact { Person = m, Type = "phone", Subtype = contact.ToLower(), Value = fields[contact + "Phone"] };
this.db.PersonContact.Add(pc);
}
if (!string.IsNullOrEmpty(fields["HamCall"]))
{
ModelState.SetModelValue("HamCall", new ValueProviderResult(fields["HamCall"], fields["HamCall"], CultureInfo.CurrentUICulture));
PersonContact pc = new PersonContact { Person = m, Type = "hamcall", Value = fields["HamCall"] };
this.db.PersonContact.Add(pc);
}
if (!string.IsNullOrEmpty(fields["Email"]))
{
ModelState.SetModelValue("Email", new ValueProviderResult(fields["Email"], fields["Email"], CultureInfo.CurrentUICulture));
PersonContact pc = new PersonContact { Person = m, Type = "email", Value = fields["Email"] };
this.db.PersonContact.Add(pc);
}
if (!string.IsNullOrEmpty(fields["Email2"]))
{
ModelState.SetModelValue("Email2", new ValueProviderResult(fields["Email2"], fields["Email2"], CultureInfo.CurrentUICulture));
PersonContact pc = new PersonContact { Person = m, Type = "email", Value = fields["Email2"] };
this.db.PersonContact.Add(pc);
}
DateTime courseDate = new DateTime(1900, 1, 1);
ModelState.SetModelValue("CourseDate", new ValueProviderResult(fields["CourseDate"], fields["CourseDate"], CultureInfo.CurrentUICulture));
if (string.IsNullOrEmpty(fields["CourseDate"]))
{
ModelState.AddModelError("CourseDate", "Required");
return null;
}
else if (!DateTime.TryParse(fields["CourseDate"], out courseDate))
{
ModelState.AddModelError("CourseDate", "Unknown format. Try yyyy-mm-dd");
return null;
}
courseDate = courseDate.Date;
UnitMembership um = new UnitMembership { Person = m, Status = status, Unit = esar, Activated = courseDate };
this.db.UnitMemberships.Add(um);
TrainingCourse courseA = (from tc in this.db.TrainingCourses where tc.DisplayName == "Course A" select tc).First();
DateTime nextDate = courseDate.AddDays(1);
Training t = (from trn in this.db.Trainings where trn.StartTime >= courseDate && trn.StartTime < nextDate && trn.Title == "Course A" select trn).FirstOrDefault();
if (t == null)
{
t = new Training();
t.OfferedCourses.Add(courseA);
t.StartTime = courseDate.AddHours(19);
t.StopTime = courseDate.AddHours(21);
t.County = "King";
t.Title = "Course A";
t.Location = "Eastside Fire Headquarters";
this.db.Trainings.Add(t);
}
TrainingRoster tr = new TrainingRoster { Person = m, TimeIn = courseDate.AddHours(18), TimeOut = courseDate.AddHours(22) };
this.db.TrainingRosters.Add(tr);
t.Roster.Add(tr);
TrainingAward ta = new TrainingAward();
ta.Completed = courseDate.AddHours(21);
if ((courseA.ValidMonths ?? 0) > 0)
{
ta.Expiry = ta.Completed.AddMonths(courseA.ValidMonths.Value);
}
ta.Course = courseA;
ta.Member = m;
this.db.TrainingAward.Add(ta);
tr.TrainingAwards.Add(ta);
return m;
}
public static void AssignUserToTraining(this ApplicationContext db, TrainingRoster roster)
{
db.Add(roster);
db.SaveChanges();
}
protected override void AddRosterRowFrom4x4Sheet(ExpandedRowsContext model, SarUnit unit, IRosterEntry row)
{
TrainingRoster mrow = (TrainingRoster)row;
Guid personId = mrow.Person.Id;
TrainingRoster newRow = new TrainingRoster
{
Training = (Training)model.SarEvent,
Person = this.db.Members.Include("TrainingRosters").Single(f => f.Id == personId),
TimeIn = mrow.TimeIn,
TimeOut = mrow.TimeOut,
Miles = mrow.Miles,
};
mrow.Id = newRow.Id;
this.db.TrainingRosters.Add(newRow);
}
