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(); } }