private GetOfflineTransactionCountDataResponse GetOfflineTransactionCount(SqliteDatabaseContext databaseContext) { string queryString = string.Format("SELECT COUNT(TRANSACTIONID) FROM {0};", MainRetailTransactionTableName); int offlineTransactionsCount = (int)databaseContext.ExecuteScalar <int>(new SqlQuery(queryString)); return(new GetOfflineTransactionCountDataResponse(offlineTransactionsCount)); }