/// <summary>
/// Gets the rows total.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="whereClause">The where clause.</param>
/// <returns></returns>
public int GetRowsTotal <T>(string whereClause = "") where T : new()
{
int returnValue = 0;
SQLiteDataReader reader = null;
try
{
var objectType = typeof(T);
var properties = objectType.GetProperties(BindingFlags.Public | BindingFlags.Instance);
string sqlQuery = SQLiteQuery.CountTotal(objectType.Name, whereClause);
reader = SQLiteQuery.ExecuteReader(sqlQuery, this.Connection);
while (reader.Read())
{
returnValue = Convert.ToInt32(reader[Constant.TotalCount]);
}
}
catch (Exception exception)
{
APILog.Error(this, "GetRowsTotal", exception);
}
finally
{
reader.Close();
reader = null;
}
return(returnValue);
}