public ContactsViewModel(int?ID)
{
using (Dist23Data db = new Dist23Data())
{
contact = db.Contacts.Where(c => c.pKey == ID).FirstOrDefault();
positions = db.ContactPosition.Where(p => p.ContactID == ID).ToList();
contactPositions = new List <PositionViewModel>();
foreach (ContactPosition pos in positions)
{
PositionViewModel pvm = new PositionViewModel();
Positions p = db.Positions.Where(x => x.pKey == pos.PositionID).FirstOrDefault();
Groups g = db.Groups.Where(x => x.pKey == pos.GroupID).FirstOrDefault();
pvm.positionKey = pos.pKey;
pvm.PositionName = p.PositionName;
pvm.GroupName = g.GroupName;
contactPositions.Add(pvm);
}
}
}
public ContactsViewModel(int? ID)
{
using(Dist23Data db = new Dist23Data())
{
contact = db.Contacts.Where(c => c.pKey == ID).FirstOrDefault();
positions = db.ContactPosition.Where(p => p.ContactID == ID).ToList();
contactPositions = new List<PositionViewModel>();
foreach(ContactPosition pos in positions)
{
PositionViewModel pvm = new PositionViewModel();
Positions p = db.Positions.Where(x => x.pKey == pos.PositionID).FirstOrDefault();
Groups g = db.Groups.Where(x => x.pKey == pos.GroupID).FirstOrDefault();
pvm.positionKey = pos.pKey;
pvm.PositionName = p.PositionName;
pvm.GroupName = g.GroupName;
contactPositions.Add(pvm);
}
}
}