public Member GetMemberInfoById(int id)
{
using (var context = new ScottishParliamentEntities())
{
Member member = context.Members.First(x => x.PersonID == id);
return(member);
}
}
public void UpdateMember(Member member)
{
using (var context = new ScottishParliamentEntities())
{
Member memberFromDB = context.Members.First(x => x.PersonID == member.PersonID);
memberFromDB.ParliamentaryName = member.ParliamentaryName;
memberFromDB.PreferredName = member.PreferredName;
memberFromDB.BirthDate = member.BirthDate;
memberFromDB.BirthDateIsProtected = member.BirthDateIsProtected;
memberFromDB.GenderTypeID = member.GenderTypeID;
memberFromDB.Notes = member.Notes;
memberFromDB.PhotoURL = member.PhotoURL;
memberFromDB.IsActive = member.IsActive;
context.SaveChanges();
}
}
public void AddMember(Member member)
{
using (var context = new ScottishParliamentEntities())
{
member.IsActive = true;
context.Members.Add(member);
try
{
context.SaveChanges();
}catch (Exception ex)
{
Console.WriteLine(ex);
Console.ReadLine();
}
}
}
public List <Member> GetAllMembersNames()
{
using (ScottishParliamentEntities db = new ScottishParliamentEntities())
{
List <Member> query = new List <Member>();
try
{
query = db.Members.Where(m => m.IsActive == true).ToList();
}
catch (InvalidOperationException ex)
{
Console.WriteLine(ex);
Console.ReadLine();
}
return(query);
}
}
