public async Task <int> DeleteStock(Models.Stock stock) { var cnd = new Condition("ID", Convert.ToString(stock.Id), BinaryOperators.Equal); Dictionary <LogicOperators, Condition> conditions = new Dictionary <LogicOperators, Condition> { { LogicOperators.FirstCondition, cnd } }; var query = new DeleteQuery(Tables.StockTable, conditions); var command = new SqlCommand(query.ToString(), _connection); return(await command.ExecuteNonQueryAsync()); }
public async Task <int> Delete <T>(T element, string tableName) { var model = (IBaseModel)element; var cnd = new Condition("ID", Convert.ToString(model.Id), BinaryOperators.Equal); Dictionary <LogicOperators, Condition> conditions = new Dictionary <LogicOperators, Condition> { { LogicOperators.FirstCondition, cnd } }; var query = new DeleteQuery(tableName, conditions); var command = new SqlCommand(query.ToString(), _connection); return(await command.ExecuteNonQueryAsync()); }