private async Task RemoveRow(ILiteDbSet table, string rowId, Type setType)
{
var data = _dbInstance.Select <object>(table, RowSelector, new { RowId = rowId });
var objTable = SetValues(Activator.CreateInstance(setType), data.First());
await _dbInstance.DeleteAsync(objTable).ConfigureAwait(false);
}
/// <summary>
/// Selects the asynchronous.
/// </summary>
/// <typeparam name="TEntity">The type of the entity.</typeparam>
/// <param name="set">The set.</param>
/// <param name="whereText">The where text.</param>
/// <param name="whereParams">The where parameters.</param>
/// <returns>A Task with a enumerable of type of the entity.</returns>
public Task <IEnumerable <TEntity> > SelectAsync <TEntity>(
ILiteDbSet set,
string whereText,
object whereParams = null)
{
return(QueryAsync <TEntity>($"{set.SelectDefinition} WHERE {whereText}", whereParams));
}
private async Task UpdateRow(Type setType, ILiteDbSet table, string rowId, IHttpContext context)
{
var objTable = Activator.CreateInstance(setType);
var data = _dbInstance.Select <object>(table, RowSelector, new { RowId = rowId });
((IDictionary <string, object>)data.First()).CopyKeyValuePairTo(objTable);
var body = (IDictionary <string, object>)Json.Deserialize(await context.GetRequestBodyAsStringAsync().ConfigureAwait(false));
body.CopyKeyValuePairTo(objTable, "RowId");
await _dbInstance.UpdateAsync(objTable).ConfigureAwait(false);
}
private async Task <bool> UpdateRow(Type setType, ILiteDbSet table, string rowId, IHttpContext context)
{
var objTable = Activator.CreateInstance(setType);
var data = _dbInstance.Select <object>(table, RowSelector, new { RowId = rowId });
((IDictionary <string, object>)data.First()).CopyKeyValuePairTo(objTable);
var body = (IDictionary <string, object>)Json.Deserialize(context.RequestBody());
body.CopyKeyValuePairTo(objTable, new[] { "RowId" });
await _dbInstance.UpdateAsync(objTable);
return(true);
}
/// <summary>
/// Initializes a new instance of the <see cref="EntityEventArgs{T}"/> class.
/// </summary>
/// <param name="entity">The entity.</param>
/// <param name="liteDbSet">The database set.</param>
public EntityEventArgs(T entity, ILiteDbSet <T> liteDbSet)
{
DbSet = liteDbSet;
Entity = entity;
Cancel = false;
}
/// <summary>
/// Deletes the asynchronous.
/// </summary>
/// <param name="set">The set.</param>
/// <param name="whereText">The where text.</param>
/// <param name="whereParams">The where parameters.</param>
/// <returns>A count for affected rows.</returns>
public Task <int> DeleteAsync(ILiteDbSet set, string whereText, object whereParams = null)
{
LogSqlCommand($"{set.DeleteDefinitionWhere} WHERE {whereText}", whereParams);
return(Connection.ExecuteAsync($"{set.DeleteDefinitionWhere} WHERE {whereText}", whereParams));
}
/// <summary> /// Deletes the specified set. /// </summary> /// <param name="set">The set.</param> /// <param name="whereText">The where text.</param> /// <param name="whereParams">The where parameters.</param> /// <returns>A count for affected rows.</returns> public int Delete(ILiteDbSet set, string whereText, object whereParams = null) => DeleteAsync(set, whereText, whereParams).GetAwaiter().GetResult();
/// <summary>
/// Selects the specified set.
/// </summary>
/// <typeparam name="TEntity">The type of the entity.</typeparam>
/// <param name="set">The set.</param>
/// <param name="whereText">The where text.</param>
/// <param name="whereParams">The where parameters.</param>
/// <returns>An enumerable of type of the Entity.</returns>
public IEnumerable <TEntity> Select <TEntity>(ILiteDbSet set, string whereText, object whereParams = null)
=> Query <TEntity>($"{set.SelectDefinition} WHERE {whereText}", whereParams);
