public void SumAsync(string columnName, SqlCondition condition, BasicAction <decimal> onSum)
{
SqlManager.PoolAsyncOperation(() => {
var sum = _database.Sum <TableKey>(columnName, condition);
onSum?.Invoke(sum);
});
}
public void MaxAsync(string columnName, SqlCondition condition, BasicAction <TableKey> onMax)
{
SqlManager.PoolAsyncOperation(() => {
var max = _database.Max <TableKey>(columnName, condition);
onMax?.Invoke(max);
});
}
public void MinAsync(string columnName, SqlCondition condition, BasicAction <TableKey> onMin)
{
SqlManager.PoolAsyncOperation(() => {
var min = _database.Min <TableKey>(columnName, condition);
onMin?.Invoke(min);
});
}
public void ExistAsync(SqlCondition condition, BasicAction <bool> onExist, bool distinct)
{
SqlManager.PoolAsyncOperation(() => {
var count = _database.Count <TableKey>(condition, distinct);
onExist?.Invoke(count > 0);
});
}
public void AverageAsync(string columnName, SqlCondition condition, BasicAction <long> onAverage)
{
SqlManager.PoolAsyncOperation(() => {
var average = _database.Average <TableKey>(columnName, condition);
onAverage?.Invoke(average);
});
}
public void SelectAllAsync(SqlCondition condition, BasicAction <TableKey[]> onSelected, bool distinct, params string[] columnsToSelect)
{
SqlManager.PoolAsyncOperation(() => {
var tables = _database.SelectAll <TableKey>(condition, distinct, columnsToSelect);
onSelected?.Invoke(tables);
});
}
public void CountAsync(string columnName, SqlCondition condition, BasicAction <long> onCounted, bool distinct)
{
SqlManager.PoolAsyncOperation(() => {
var count = _database.Count <TableKey>(columnName, condition, distinct);
onCounted?.Invoke(count);
});
}
public void UpdateAllAsync(TableKey reference, BasicAction onUpdated, params string[] columnsToUpdate)
{
SqlManager.PoolAsyncOperation(() => {
var updated = _database.UpdateAll(reference, columnsToUpdate);
if (updated)
{
onUpdated?.Invoke();
}
});
}
public void DeleteAllAsync(BasicAction onDeleted)
{
SqlManager.PoolAsyncOperation(() => {
var deleted = _database.DeleteAll <TableKey>();
if (deleted)
{
onDeleted?.Invoke();
}
});
}
public void DeleteAsync(SqlCondition condition, BasicAction onDeleted)
{
SqlManager.PoolAsyncOperation(() => {
var deleted = _database.Delete <TableKey>(condition);
if (deleted)
{
onDeleted?.Invoke();
}
});
}
/// <summary>
/// Insert the current instance values in <see cref="Database"/>
/// </summary>
/// <returns></returns>
public void InsertAsync(BasicAction <long> onResult)
{
SqlManager.PoolAsyncOperation(() => {
onResult(Insert());
});
}
/// <summary>
/// Update all elements in the <see cref="Database"/> with current instance's values using the specified <see cref="SqlCondition"/>
/// </summary>
/// <param name="condition"></param>
/// <param name="onUpdated"></param>
/// <param name="columnsToUpdate"></param>
public void UpdateAsync(SqlCondition condition, BasicAction <bool> onUpdated, params string[] columnsToUpdate)
{
SqlManager.PoolAsyncOperation(() => {
onUpdated(Update(condition, columnsToUpdate));
});
}
