public async Task <int> AddAsync(User user) { using (IDbConnection connection = _dataProviders.CDE_DbConnection()) { return(await connection.ExecuteAsync ( $@" insert into tb_user([user_name], user_email, user_password) Values (@UserName, @UserEmail, @UserPassword); ", user )); } }
public async Task <int> AddAsync(StorageLocation storageLocation) { using (IDbConnection connection = _dataProviders.CDE_DbConnection()) { return(await connection.ExecuteAsync ( @" insert into tb_storage_location(storage_location_Floor, storage_location_hall, storage_location_shelf, storage_location_bay, fk_product_id) values (@Floor, @Hall, @Shelf, @Bay, @IdProduct); ", storageLocation )); } }
public async Task <int> AddAsync(Product product) { using (IDbConnection connection = _dataProviders.CDE_DbConnection()) { return(await connection.ExecuteAsync ( @" insert into tb_product(product_name, product_quantity, product_active, product_group, product_unit_of_measuremen) values(@ProdutctName, @ProductQuantity, @ProductActive, @ProductGroup, @ProductUnitOfMeasurement); ", product )); } }