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); } }