public async Task <IActionResult> GenerateStockLedgerWBatch(STOCKLEDGERWITHBATCHFILTER filter)
{
if (filter != null)
{
if (filter.CompanyCode != "404")
{
var model = await qneReportService.GenerateStockLedgerWBatch(filter);
if (model != null)
{
return(Ok(model));
}
else
{
return(BadRequest());
}
}
else
{
return(BadRequest());
}
}
return(BadRequest());
}
public async Task <IEnumerable <STOCKLEDGERWITHBATCHRESULT> > GenerateStockLedgerWBatch(STOCKLEDGERWITHBATCHFILTER filter)
{
using (IDbConnection con = new SqlConnection(QNEConnectionString.ChooseConnection(filter.CompanyCode)))
{
string sql = @"SELECT A.*,B.BatchNoExpiryDate,B.BatchNoManufacturingDate FROM dbo.FN_StockLedgerWithBatch(@DateFrom,@DateTo,@IncludeZero,@IncludeInactive,@IncludeStockTransfer,@StockCodes,@Location) AS A
JOIN StockBatchNumbers AS B
ON A.StockBatchNumberId = B.Id
WHERE A.StockBatchNumberId LIKE @BatchId AND A.GroupCode LIKE @GroupCode";
var p = new DynamicParameters();
p.Add("@DateFrom", filter.DateFrom);
p.Add("@DateTo", filter.DateTo);
p.Add("@IncludeZero", filter.IncludeZero);
p.Add("@IncludeInactive", filter.IncludeInactive);
p.Add("@IncludeStockTransfer", filter.IncludeStockTransfer);
p.Add("@StockCodes", filter.StockCodes);
p.Add("@BatchId", filter.BatchId);
p.Add("@Location", filter.LocationCode);
p.Add("@GroupCode", filter.StockGroup);
var model = await con.QueryAsync <STOCKLEDGERWITHBATCHRESULT>(sql, p);
return(model);
//if(filter.BatchId != "%%")
//{
// model.Where(x => x.StockBatchNumberId == Guid.Parse(filter.BatchId));
//}
//return model.ToList();
}
}
