public async Task <IActionResult> GenerateStockIssueDetail(STOCKISSUEFILTER filter)
{
if (filter != null)
{
if (filter.CompanyCode != "404")
{
var model = await qneReportService.GenerateStockissuesDetail(filter);
if (model != null)
{
return(Ok(model));
}
else
{
return(BadRequest());
}
}
else
{
return(BadRequest());
}
}
return(BadRequest());
}
public async Task <IEnumerable <STOCKISSUEDETAILSRESULT> > GenerateStockissuesDetail(STOCKISSUEFILTER filter)
{
using (IDbConnection con = new SqlConnection(QNEConnectionString.ChooseConnection(filter.CompanyCode)))
{
string sql = @"select B.StockCode,B.StockName,D.BatchNo,A.Qty,C.UOMCode,A.Price,A.Amount from StockOutDetails AS A
LEFT JOIN Stocks AS B
ON A.StockId = B.Id
LEFT JOIN UOMs AS C
ON C.StockId = A.StockId
LEFT JOIN StockBatchNumbers AS D
ON A.StockBatchNumberId = D.Id
WHERE A.StockOutId = @StockIssueId";
var res = await con.QueryAsync <STOCKISSUEDETAILSRESULT>(sql, new { filter.StockIssueId });
return(res);
}
}
