public void ItShouldParseAllBundeslands()
{
var all = Bundesland.All;
foreach (var bundesland in all)
{
Bundesland.Parse(bundesland.Value).ShouldBeSome().Should().Be(bundesland);
}
}
public static async Task <List <Vacation> > LoadForYearAsync(Bundesland bundesland, string year)
{
var client = new HttpClient();
var response = await client.GetAsync(string.Format("http://api.smartnoob.de/ferien/v1/ferien/?bundesland={0}&jahr={1}", BundeslandShorts[bundesland], year));
var json = await response.Content.ReadAsStringAsync();
JObject vacations = JObject.Parse(json);
var data = vacations["daten"].Children().ToList();
var output = new List <Vacation>();
foreach (var vacation in data)
{
output.Add(JsonConvert.DeserializeObject <Vacation>(vacation.ToString()));
}
output.Sort();
return(output);
}
List <Bundesland> getBundeslaender()
{
List <Bundesland> bundeslaender = new List <Bundesland>();
con.Open();
cmd.CommandText = "Select * from Bundesland;";
reader = cmd.ExecuteReader();
while (reader.Read())
{
Bundesland bundesland = new Bundesland();
bundesland.id = reader.GetInt32(0);
bundesland.kurzbezeichnung = reader.GetString(1);
bundesland.bezeichnung = reader.GetString(2);
bundeslaender.Add(bundesland);
}
con.Close();
return(bundeslaender);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lbBundeslaender_SelectedIndexChanged(object sender, EventArgs e)
{
Bundesland bundesland = (Bundesland)lbBundeslaender.SelectedItem;
int idBundesland = bundesland.id;
chartF1.Series.Clear();
dgvOrders.Rows.Clear();
clCust objCust = new clCust();
dt_last_order = new DateTime();
db_access_connection con = new db_access_connection();
List <Landkreis> landkreise = con.Landkreis(idBundesland);
foreach (Landkreis landkreis in landkreise)
{
lbLandkreis.Items.Add(landkreis.name.ToString());
//lbBundeslaender.Items.Add(bundesland.bezeichnung);
}
/*
* //Resten der Check-Boxen
* cbWood.Enabled = false;
* cbWood.Checked = false;
* cbAzV.Checked = false;
* cbAzV.Enabled = false;
* cbRestmuell.Enabled = false;
* cbRestmuell.Checked = false;
* cbSperrmuell.Enabled = false;
* cbSperrmuell.Checked = false;
* cbPaper.Checked = false;
* cbPaper.Enabled = false;
*
* //Variablendeklaration
* //Diese Nummern bekommen die Serien des Charts
* series_count = 0;
* //series_count_azv = 0;
* //series_count_sperrmuell = 0;
* //series_count_wood = 0;
* amoAmount_sperr = 0;
* amoAmount_azv = 0;
* amoAmount_wood = 0;
* amoAmount_paper = 0;
* middle_weight = 0;
* int_last_12m_orders = 0;
*
*
* string customer_name = Convert.ToString(lbClients.SelectedItem);
*
* objCust.getCust(globalConnectionString, customer_name);
*
*
*
* lblCustID.Text = "Kundennumer: " + Convert.ToString(objCust.kundennummer);
* lblCustName.Text = "Name: " + objCust.name;
* lblCustContact.Text = "Ansprechpartner: " + objCust.strasse + " " + Convert.ToString(objCust.Hausnummer) + ", " + Convert.ToString(objCust.PLZ) + " " + objCust.ort;
*
* clAmount_get f1_clAmountGet = new clAmount_get();
*
* List < clAmount > f1_list_clAmountt = new List<clAmount>();
* f1_list_clAmountt = f1_clAmountGet.getAmount(customer_name, globalConnectionString);
*
* //Abfrage für die letzte Bestellung
* try
* {
* dt_last_order = f1_list_clAmountt[0].amoDate;
* }
*
* catch
* {
* dt_last_order = DateTime.MinValue;
* }
*
*
*
*
* //Auffüllen der DGV mit den jeweiligen Aufträgen
* for (int i = 0; i < f1_list_clAmountt.Count; i++)
* {
* dgvOrders.Rows.Add(f1_list_clAmountt[i].amoArt, f1_list_clAmountt[i].amoAmount, f1_list_clAmountt[i].amoDate.ToShortDateString());
*
* middle_weight += f1_list_clAmountt[i].amoAmount;
*
* //Abfrage nach der letzten Bestellung
* if (f1_list_clAmountt[i].amoDate > dt_last_order)
* dt_last_order = f1_list_clAmountt[i].amoDate;
*
* //Abfrage nach der Anzahl der Bestellungen in den letzten 12 Monaten
* if (f1_list_clAmountt[i].amoDate < DateTime.Now)
* int_last_12m_orders += 1;
* }
*
* draw_Chart(f1_list_clAmountt);
*
*/
}
public void ItShouldParseBW()
{
Bundesland.Parse("BW").ShouldBeSome().Should().Be(Bundesland.BadenWuerttemberg);
}
public void ItCreatesTaxNumbers(string bundesland, string input, string expected)
{
var model = Bundesland.Parse(bundesland).AssertSome();
TaxNumber.FromLocalTaxNumber(model, input).should_be_valid().Value.Should().Be(expected);
}
public void ItShouldReturnNoneInCaseOfInvalidCode()
{
Bundesland.Parse("DDT").ShouldBeNone();
}
public int CompareTo(UeberhangmandatEntryViewModel other)
{
var blandcomp = Bundesland.CompareTo(other.Bundesland);
return(blandcomp != 0 ? blandcomp : Party.CompareTo(other.Party));
}
public int CompareTo(BundeslandWithWahlkreiseViewModel <T> other)
{
return(Bundesland.CompareTo(other.Bundesland));
}
public static WahlkreisOverviewViewModel GetWahlkreisOverviewViewModel(int electionId, Bundesland bundesland,
BasicWahlkreisOverview overview, IEnumerable <ErststimmeWahlkreisOverview> firstVotes,
IEnumerable <ZweitstimmeWahlkreisOverview> secondVotes)
{
return(new WahlkreisOverviewViewModel
{
ElectionId = electionId,
Bundesland = new BundeslandViewModel
{
Id = bundesland.Id,
Name = bundesland.Name
},
Wahlkreis = new WahlkreisViewModel
{
Id = overview.Wahlkreis_Id,
Name = overview.Wahlkreis_Name
},
Participation = overview.Participation ?? -1,
Candidate = new PersonWithPartyViewModel
{
Person = new PersonViewModel
{
Id = overview.Person_Id ?? -1,
Title = overview.Title,
Firstname = overview.Firstname,
Lastname = overview.Lastname
},
Party = new PartyViewModel
{
Id = overview.Party_Id,
Name = overview.Party_Name
}
},
FirstVotes = GetWahlkreisFirstVotesViewModels(electionId, overview.Wahlkreis_Id, firstVotes).ToList().OrderBy(r => r),
SecondVotes = GetWahlkreisSecondVotesViewModels(electionId, overview.Wahlkreis_Id, secondVotes).ToList().OrderBy(r => r)
});
}
public static BundeslandWithWahlkreiseViewModel <WahlkreisViewModel> GetBundeslandListViewModel(Bundesland bundesland,
IEnumerable <Wahlkrei> wahlkreise)
{
return(new BundeslandWithWahlkreiseViewModel <WahlkreisViewModel>
{
Bundesland = new BundeslandViewModel
{
Id = bundesland.Id,
Name = bundesland.Name
},
Wahlkreise = GetWahlkreisListViewModels(wahlkreise).ToList().OrderBy(r => r)
});
}
static void Main(string[] args)
{
string resultsUrl = "http://www.bundeswahlleiter.de/de/bundestagswahlen/BTW_BUND_09/ergebnisse/wahlkreisergebnisse/";
string bundeslandPageContent = DownloadPage(resultsUrl);
if (bundeslandPageContent == null)
{
Console.WriteLine("Bundesländer konnten nicht geladen werden. Abbruch.");
return;
}
SimpleListItem[] bundeslandList = ParseSimpleList(bundeslandPageContent);
List<Bundesland> bundeslaender = new List<Bundesland>();
foreach(var curBundesland in bundeslandList)
{
Bundesland newBL = new Bundesland();
newBL.Name = curBundesland.Name;
newBL.Wahlkreise = new List<Wahlkreis>();
string blUri = resultsUrl + curBundesland.Link;
Console.WriteLine("Parse Bundesland " + curBundesland.Name + " ...");
//Parse Wahlkreise
string blWahlkreisePageContent = DownloadPage(blUri);
if (blWahlkreisePageContent == null)
{
Console.WriteLine("Wahlkreise konnten nicht geladen werden. Abbruch.");
return;
}
SimpleListItem[] blWahlkreiseList = ParseSimpleList(blWahlkreisePageContent);
foreach (var curWahlkreis in blWahlkreiseList)
{
Wahlkreis newWK = new Wahlkreis();
Match wkNameMatch = WahlkreisNameRegex.Match(curWahlkreis.Name);
if (wkNameMatch.Success)
{
newWK.Name = wkNameMatch.Groups["name"].Value;
newWK.Nr = int.Parse(wkNameMatch.Groups["nr"].Value);
}
else
newWK.Name = curWahlkreis.Name;
Console.WriteLine(" Parse Wahlkreis " + newWK.Name + " ...");
//Parse Ergebnisse
string wkErgebnisPageContent = DownloadPage(blUri + curWahlkreis.Link);
if (wkErgebnisPageContent == null)
{
Console.WriteLine("Wahlkreise-Ergebnis konnte nicht geladen werden. Abbruch.");
return;
}
var wkVotes = ParseVoteList(wkErgebnisPageContent);
newWK.Wahlberechtigte = wkVotes["Wahlberechtigte"]; wkVotes.Remove("Wahlberechtigte");
newWK.Waehler = wkVotes["Wähler"]; wkVotes.Remove("Wähler");
newWK.Ungueltige = wkVotes["Ungültige"]; wkVotes.Remove("Ungültige");
newWK.Gueltige = wkVotes["Gültige"]; wkVotes.Remove("Gültige");
newWK.Parteien = new List<Partei>();
foreach (var curPartei in wkVotes)
{
Partei newPartei = new Partei() { Id=GetParteiId(curPartei.Key), Ergebnis=curPartei.Value};
newWK.Parteien.Add(newPartei);
}
newBL.Wahlkreise.Add(newWK);
}
bundeslaender.Add(newBL);
}
//Write to CSV
StreamWriter csvWriter = new StreamWriter("Ergebnisse2009.csv", false, Encoding.UTF8);
csvWriter.WriteLine("Bundestagswahl 2009");
csvWriter.WriteLine("Endgültig");
csvWriter.Write("Nr,Gebiet,gehört,Wahlberechtigte,,,,Wähler,,,,Ungültige,,,,Gültige,,,,");
foreach (string curPartei in ParteienDict.Keys)
csvWriter.Write(curPartei + ",,,,");
csvWriter.Write(Environment.NewLine);
csvWriter.Write(",,zu,");
for (int a = 1; a < CurParteienDictKey + 4; a++)
csvWriter.Write("Erststimmen,,Zweitstimmen,,");
csvWriter.Write(Environment.NewLine);
csvWriter.Write(",,,");
for (int a = 1; a < CurParteienDictKey + 4; a++)
csvWriter.Write("Endgültig,,");
int CurBundeslandId = 1;
foreach (var curBL in bundeslaender)
{
foreach(var curWK in curBL.Wahlkreise)
{
csvWriter.Write(curWK.Nr + ",");
csvWriter.Write("\"" + curWK.Name + "\",");
csvWriter.Write(CurBundeslandId + ",");
WriteVotes(csvWriter, curWK.Wahlberechtigte);
WriteVotes(csvWriter, curWK.Waehler);
WriteVotes(csvWriter, curWK.Ungueltige);
WriteVotes(csvWriter, curWK.Gueltige);
foreach (var curPartei in ParteienDict)
{
bool foundPartei = false;
foreach (var curWkPartei in curWK.Parteien)
{
if (curPartei.Value == curWkPartei.Id)
{
WriteVotes(csvWriter, curWkPartei.Ergebnis);
foundPartei = true;
}
}
if (!foundPartei)
csvWriter.Write(",,,,");
}
csvWriter.Write(Environment.NewLine);
}
csvWriter.Write(CurBundeslandId + ",");
csvWriter.Write("\"" + curBL.Name + "\",");
csvWriter.Write("99");
csvWriter.Write(Environment.NewLine);
csvWriter.Write(Environment.NewLine);
CurBundeslandId++;
}
csvWriter.Write("99,\"Bundesgebiet\"");
csvWriter.Write(Environment.NewLine);
csvWriter.Close();
Console.ReadLine();
}
