public static void Main(string[] args)
{
Administration admin = new Administration();
admin.WaehlerErstellen("Kevin", "Peters", "123242");
admin.WaehlerErstellen("Daniel", "Nehrig", "13371337");
admin.WaehlerErstellen("Bjarne", "Christel", "44448888");
admin.ParteiErstellen("CDU", "MERKEL");
admin.ParteiErstellen("SPD", "KLOPPERT");
admin.ParteiErstellen("AFD", "MONGA");
admin.ParteiErstellen("DIE PARTEI", "TONKA");
Console.WriteLine("Login");
Console.WriteLine("Firstname : ");
string firstName = Console.ReadLine();
Console.WriteLine("Lastname : ");
string lastName = Console.ReadLine();
Console.WriteLine("Key : ");
string key = Console.ReadLine();
Waehler waehler = admin.GetWaehler(firstName, lastName);
Console.WriteLine("Vote for : CDU, SPD, AFD");
Console.WriteLine("Vote : ");
string parteiName = Console.ReadLine();
Partei partei = admin.GetPartei(parteiName);
admin.Vote(waehler, partei, key);
admin.ParteinAnzeigen();
}
public bool Vote(Waehler waehler, Partei partei, string key)
{
try {
cnn.Open();
if (waehler.key == key && !waehler.voted)
{
string sql = String.Format(@"UPDATE waehler SET voted = 1 WHERE firstName = '{0}' AND lastName = '{1}';
UPDATE partei SET votes = votes + 1 WHERE name = '{2}';", waehler.firstName, waehler.lastName, partei.name);
SqliteCommand command = new SqliteCommand(sql, cnn);
command.ExecuteNonQuery();
}
else
{
throw new OperationCanceledException("Either wrong Key or allready voted");
}
cnn.Close();
return(true);
} catch (Exception ex) {
Console.WriteLine("Error While Updating Waehler and incrementing count on Partei\n" + ex);
return(false);
}
}
public Waehler GetWaehler(string firstName, string lastName)
{
Waehler waehler = null;
try {
cnn.Open();
string sql = String.Format("select * from waehler where firstName = '{0}' AND lastName = '{1}'", firstName, lastName);
SqliteCommand command = new SqliteCommand(sql, cnn);
SqliteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (reader.GetString(reader.GetOrdinal("firstName")) == firstName &&
reader.GetString(reader.GetOrdinal("lastName")) == lastName)
{
waehler = new Waehler(reader);
}
}
cnn.Close();
return(waehler);
} catch (Exception ex) {
Console.WriteLine("Error While Creating Waehler\n" + ex);
}
return(waehler);
}
