public async Task <IActionResult> GetAllSkus([FromBody] SkuMetaData skuMetaData)
{
try
{
var result = await this.skuRepository.GetAllSkus(skuMetaData);
return(Ok(result));
}
catch (Exception ex)
{
this.logger.LogInformation($"SkuController -> GetAllSkus - { ex.Message } - {ex.InnerException?.Message}");
return(BadRequest(ex));
}
}
public async Task <IEnumerable <SkuMetaDataViewModel> > GetAllSkus(SkuMetaData skuMetaData)
{
IEnumerable <SkuMetaDataViewModel> lstSkuMetadata;
using (IDbConnection con = this.Connection)
{
string sQuery = "Select SM.SkuId, SM.SkuDescription, SM.LocationName, SM.DepartmentName, SM.CategoryName, SM.SubCategoryName from SkuMetaData SM " +
"where SM.LocationName = '" + skuMetaData.LocationName + "' and SM.DepartmentName = '" + skuMetaData.DepartmentName + "' and " +
" SM.CategoryName = '" + skuMetaData.CategoryName + "' and SM.SubCategoryNames = '" + skuMetaData.SubCategoryName + "'";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
lstSkuMetadata = await con.QueryAsync <SkuMetaDataViewModel>(sQuery).ConfigureAwait(true);
}
return(lstSkuMetadata);
}
