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