public int CountBusinessObjects <T>(int result, Expression <Func <T, bool> > filter)
where T : class, IBaseObject
{
var table = GetTableName <T>();
var sqlClause = expressionToSql.Translate(filter);
var query = SqlQueryProvider.AnyCountBusinessObjects(table, sqlClause);
object count = null;
using (SqlConnection conn = new SqlConnection(Configuration.DefaultConnectionString))
using (SqlCommand cmd = new SqlCommand(query, conn))
{
conn.Open();
count = cmd.ExecuteScalar();
conn.Close();
}
if (count != null)
{
if ((int)count > 0)
{
result = (int)count;
return(result);
}
else
{
return(result);
}
}
return(result);
}
public bool AnyBusinessObjects <T>(bool result)
where T : class, IBaseObject
{
var table = GetTableName <T>();
var query = SqlQueryProvider.AnyCountBusinessObjects(table);
object count = null;
using (SqlConnection conn = new SqlConnection(Configuration.DefaultConnectionString))
using (SqlCommand cmd = new SqlCommand(query, conn))
{
conn.Open();
count = cmd.ExecuteScalar();
conn.Close();
}
if (count != null)
{
if ((int)count > 0)
{
result = true;
return(result);
}
else
{
return(result);
}
}
return(result);
}
