public async Task <IActionResult> GenerateStockLedgerInq(STOCKLEDGERINQUIRYFILTER filter)
{
if (filter != null)
{
if (filter.CompanyCode != "404")
{
var model = await qneReportService.GenerateStockLedgerInq(filter);
if (model != null)
{
return(Ok(model));
}
else
{
return(BadRequest());
}
}
else
{
return(BadRequest());
}
}
return(BadRequest());
}
public async Task <IEnumerable <STOCKLEDGERINQUIRYRESULT> > GenerateStockLedgerInq(STOCKLEDGERINQUIRYFILTER filter)
{
using (IDbConnection con = new SqlConnection(QNEConnectionString.ChooseConnection(filter.CompanyCode)))
{
string sql = "SELECT * FROM dbo.FN_StockLedgerInquiry(@DateFrom,@DateTo,@IncludeGST,@IncludeZero,@IncludeInactive,@StockCodeFrom,@StockCodeTo,@Location,@IncludeStockTransfer)";
var p = new DynamicParameters();
p.Add("@DateFrom", filter.DateFrom);
p.Add("@DateTo", filter.DateTo);
p.Add("@IncludeGST", filter.IncludeGST);
p.Add("@IncludeZero", filter.IncludeZero);
p.Add("@IncludeInactive", filter.IncludeInactive);
p.Add("@StockCodeFrom", filter.StockCodeFrom);
p.Add("@StockCodeTo", filter.StockCodeTo);
p.Add("@Location", filter.LocationCode);
p.Add("@IncludeStockTransfer", filter.IncludeStockTransfer);
var res = await con.QueryAsync <STOCKLEDGERINQUIRYRESULT>(sql, p);
return(res);
}
}
