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