public int CountActivityAppearences(Activity activity, QrtrsMrkngMode markingKind, int firstQuarter, int lastQuarter) { int result; string connectionString = "Data Source=TimeManagerDB.db"; string column = markingKind == QrtrsMrkngMode.Planning ? "Plan" : "Report"; string queryString = "SELECT COUNT(*) FROM " + _targetTableName + "\n" + "WHERE Id BETWEEN " + firstQuarter + " AND " + lastQuarter + "\n" + "AND " + column + " = '" + activity.Name + "';"; using (SQLiteConnection connection = new SQLiteConnection(connectionString)) { connection.Open(); using (SQLiteCommand command = new SQLiteCommand(queryString, connection)) { using (SQLiteDataReader dataReader = command.ExecuteReader()) { dataReader.Read(); result = dataReader.GetInt32(0); } } } return(result); }
public void ReportingRB_Checked(object sender, RoutedEventArgs e) { _mode = QrtrsMrkngMode.Reporting; }
public void PlanningRB_Checked(object sender, RoutedEventArgs e) { _mode = QrtrsMrkngMode.Planning; }