//add parliament member to db only
public bool AddMember(CustomPolitcian politcian)
{
if (politcian == null)
{
return(false);
}
else
{
if (politcian.Firstname == null || politcian.Lastname == null || politcian.Party == null)
{
return(false);
}
else
{
entities.Politician.Add(new Politician()
{
firstname = politcian.Firstname,
lastname = politcian.Lastname,
partyId = entities.Party.Where(p => p.name.Equals(politcian.Party)).SingleOrDefault().id
});
entities.ContactInfo.Add(new ContactInfo()
{
email = politcian.Email,
phone = politcian.Phone,
politicianId = entities.Politician.Last().id
});
return(true);
}
}
}
//Edit function for parliament members
public string EditMember(CustomPolitcian politcian)
{
string msg = "";
Politician selectedPolitician = entities.Politician.Where(p => p.id == politcian.PoliticianId).SingleOrDefault();
selectedPolitician.firstname = politcian.Firstname;
selectedPolitician.lastname = politcian.Lastname;
selectedPolitician.partyId = entities.Party.Where(p => p.name.Equals(politcian.Party)).SingleOrDefault().id;
selectedPolitician.ContactInfo.SingleOrDefault().phone = politcian.Phone;
selectedPolitician.ContactInfo.SingleOrDefault().email = politcian.Email;
entities.SaveChanges();
return(msg);
}