public void CreateNewMinisterTitle(MinisterialPost title)
{
if (!CheckIfPartyExist(title))
{
db.MinisterialPost.Add(title);
db.SaveChanges();
}
}
public bool CheckIfPartyExist(MinisterialPost ministerTitle)
{
var newParty = GetMinisterTitle(ministerTitle.title);
if (newParty == null)
{
return(false);
}
else
{
return(true);
}
}
//Add Minister to db
public void AddMinisters()
{
using (var entities = new FTDatabaseEntities())
{
MinisterScraper scraper = new MinisterScraper();
List <ExtractedValues> values = scraper.GetMinisters();
List <CustomMinister> ministers = new List <CustomMinister>();
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);
ContactInfo contactInfo = item.Contact;
contactInfo.politicianId = politician.id;
Debug.WriteLine(politician.id);
service.AddContactInfo(contactInfo);
}
MinisterialPost post = service.GetMinisterialPost(item.Title);
if (post == null)
{
using (var context = new FTDatabaseEntities())
{
context.MinisterialPost.Add(new MinisterialPost()
{
governmentId = 1, title = item.Title
});
context.SaveChanges();
}
}
Minister minister = new Minister();
minister.ministerialPostId = service.GetMinisterialPost(item.Title).id;
minister.politicianId = politician.id;
minister.startDate = DateTime.Now.Date;
entities.Minister.Add(minister);
}
entities.SaveChanges();
}
}
