public void CreatePM(ParliamentMember pm)
{
if (!CheckPMExist(pm.politicianId, pm.parliamentId))
{
db.ParliamentMember.Add(pm);
db.SaveChanges();
}
}
public void AddMembers()
{
using (var entities = new FTDatabaseEntities())
{
DBService service = new DBService();
ParliamentMemberFilter filter = new ParliamentMemberFilter();
List <ExtractedValues> values = filter.GetParliamentMembers();
List <CustomPolitcian> politcians = new List <CustomPolitcian>();
foreach (var item in values)
{
Politician politician = service.GetPolitician(item.Firstname, item.Lastname);
if (politician == null)
{
politician = new Politician();
politician.firstname = item.Firstname;
politician.lastname = item.Lastname;
politician.partyId = entities.Party.Where(p => p.name.Equals(item.Party)).SingleOrDefault().id;
service.AddPolitician(politician);
politician = service.GetPolitician(item.Firstname, item.Lastname);
UpdateContact(politician.id, item.Contact);
}
else
{
var partyId = entities.Party.Where(p => p.name.Equals(item.Party)).SingleOrDefault().id;
politician.partyId = partyId;
entities.Politician.Attach(politician);
entities.Entry(politician).Property(pol => pol.partyId).IsModified = true;
entities.SaveChanges();
}
UpdateContact(politician.id, item.Contact);
ParliamentMember member = new ParliamentMember();
member.politicianId = politician.id;
member.parliamentId = 1;
entities.ParliamentMember.Add(member);
}
entities.SaveChanges();
}
}
public static MemberOfBundestagViewModel GetMemberOfBundestagViewModel(ParliamentMember member)
{
var wahlkreis = member.Wahlkreis_Id == null
? null
: new WahlkreisViewModel
{
Id = (int)member.Wahlkreis_Id,
Name = member.Wahlkreis_Name
};
return(new MemberOfBundestagViewModel
{
ElectionId = member.Election_Id,
Member = new PersonWithPartyViewModel
{
Person = new PersonViewModel
{
Id = member.Person_Id,
Title = member.Title,
Firstname = member.Firstname,
Lastname = member.Lastname
},
Party = new PartyViewModel
{
Id = member.Party_Id,
Name = member.Party_Name
}
},
Bundesland = new BundeslandViewModel
{
Id = member.Bundesland_Id,
Name = member.Bundesland_Name
},
Wahlkreis = wahlkreis
});
}
