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