public async Task <IActionResult> DeleteProductsByIdsAsync([FromBody] List <int> idsList)
{
if (idsList == null)
{
return(Error("Invalid Payload"));
}
if (!idsList.Any())
{
return(Error("Empty Products Ids List"));
}
var userId = GetUserIdFromClaim();
_logger.LogInformation($"Deleting Productss: {string.Join(",", idsList)}, Requested By:{userId}");
ProductsContract products = new ProductsContract();
products.StatementType = "Delete";
var command = new AddOrUpdateProductsCommand
{
Products = products,
UserId = GetUserIdFromClaim()
};
var result = await _messages.Dispatch(command).ConfigureAwait(false);
return(Ok(result));
}
public async Task <IActionResult> UpdateProductsAsync([FromBody] ProductsContract products)
{
if (products == null)
{
return(Error("Invalid Payload"));
}
else if (products.Id < 1)
{
return(Error("Invalid products id"));
}
_logger.LogInformation($"Updating products: ${products.Id}");
products.StatementType = "Update";
var command = new AddOrUpdateProductsCommand
{
Products = products,
UserId = GetUserIdFromClaim()
};
var result = await _messages.Dispatch(command).ConfigureAwait(false);
return(Ok(result));
}
public async Task <IActionResult> DeleteProductsAsync(int productsId)
{
if (productsId < 1)
{
return(Error("Invalid Products Id"));
}
var userId = GetUserIdFromClaim();
_logger.LogInformation($"Deleting Products: ${productsId}, Requested By:${userId}");
ProductsContract products = new ProductsContract();
products.StatementType = "Delete";
products.Id = productsId;
var command = new AddOrUpdateProductsCommand
{
Products = products,
UserId = GetUserIdFromClaim()
};
var result = await _messages.Dispatch(command).ConfigureAwait(false);
return(Ok(result));
}
public async Task <int> AddOrUpdateProductsAsync(ProductsContract products, int userId)
{
using var connection = _connectionFactory.GetDbConnection();
var procName = StoredProcedureConstants.spProductsInsertUpdateDelete;
var result = await connection.QueryAsync <int>(procName, new
{
Product_id = products.Id,
Company_id = products.Companyid,
Product_name = products.ProductName,
Techname = products.Techname,
Searchname = products.Searchname,
Description = products.Description,
PrimeImage = products.PrimeImage,
Price = products.Price,
Sold_By = products.SoldBy,
Specifications = products.Specifications,
ProductURL = products.ProductURL,
AvgCustReview = products.AvgCustReview,
YrofLaunch = products.YrofLaunch,
StatementType = products.StatementType
}, null, null, CommandType.StoredProcedure).ConfigureAwait(false);
return(result.FirstOrDefault());
}
