public async Task <IEnumerable <NEAREXPIRYRESULT> > GenerateNearExpiry(NEAREXPIRYFILTER filter)
{
using (IDbConnection con = new SqlConnection(QNEConnectionString.ChooseConnection(filter.CompanyCode)))
{
string sql = "SELECT * FROM dbo.FN_NearExpiryItems(@AsofDate,@StockCodes,@Location)";
var p = new DynamicParameters();
p.Add("@AsofDate", filter.AsOfDate);
p.Add("@StockCodes", filter.StockCodes);
p.Add("@Location", filter.LocationCode);
var res = await con.QueryAsync <NEAREXPIRYRESULT>(sql, p);
return(res);
}
}
public async Task <IActionResult> GenerateNearExp(NEAREXPIRYFILTER filter)
{
if (filter != null)
{
if (filter.CompanyCode != "404")
{
var model = await qneReportService.GenerateNearExpiry(filter);
if (model != null)
{
return(Ok(model));
}
else
{
return(BadRequest());
}
}
else
{
return(BadRequest());
}
}
return(BadRequest());
}
