public InventoryPaging GetInventoriesPaging(int pageSize, int pageIndex, InventoryFilterEntity inventoryFilterEntity) { var storeName = "Proc_GetInventoriesPaging"; var parameters = new DynamicParameters(); parameters.Add($"@PageSize", pageSize); parameters.Add($"@PageIndex", pageIndex); parameters.Add($"@TotalRecord", dbType: System.Data.DbType.Int32, direction: System.Data.ParameterDirection.Output); //parameters.Add($"@TotalPage", dbType: System.Data.DbType.Int32, direction: System.Data.ParameterDirection.Output); parameters.Add($"@SKUCode", inventoryFilterEntity.SKUCode, DbType.String); parameters.Add($"@SKUCodeType", inventoryFilterEntity.SKUCodeType, DbType.String); parameters.Add($"@InventoryGroup", inventoryFilterEntity.InventoryGroup, DbType.String); parameters.Add($"@InventoryGroupType", inventoryFilterEntity.InventoryGroupType, DbType.String); parameters.Add($"@InventoryName", inventoryFilterEntity.InventoryName, DbType.String); parameters.Add($"@InventoryNameType", inventoryFilterEntity.InventoryNameType, DbType.String); parameters.Add($"@SalePrice", inventoryFilterEntity.SalePrice); parameters.Add($"@SalePriceType", inventoryFilterEntity.SalePriceType, DbType.String); parameters.Add($"@Status", inventoryFilterEntity.Status); parameters.Add($"@Display", inventoryFilterEntity.Display); parameters.Add($"@Unit", inventoryFilterEntity.Unit); parameters.Add($"@UnitType", inventoryFilterEntity.UnitType); var storePaging = new InventoryPaging(); var store = dbConnection.Query <Inventory>(storeName, parameters, commandType: CommandType.StoredProcedure); storePaging.Data = store.ToList(); //storePaging.TotalPage = parameters.Get<int>("@TotalPage"); storePaging.TotalRecord = parameters.Get <int>("@TotalRecord"); return(storePaging); }
public ServiceResult GetInventoriesPaging(int pageSize, int pageIndex, InventoryFilterEntity inventoryFilterEntity) { serviceResult.isValid = true; var inventories = _inventoryRepository.GetInventoriesPaging(pageSize, pageIndex, inventoryFilterEntity); serviceResult.data = inventories; if (inventories.TotalRecord < 1) { serviceResult.isValid = false; serviceResult.errorCode = MISACode.noContent; } return(serviceResult); }
public IActionResult GetInventoriesPaging(int pageIndex, int pageSize, string SKUCode, string inventoryName, string inventoryGroup, string unit, double salePrice, int status, int display, string SKUCodeType, string inventoryNameType, string inventoryGroupType, string unitType, string salePriceType ) { var inventoryFilterEntity = new InventoryFilterEntity(); inventoryFilterEntity.Display = display; inventoryFilterEntity.InventoryGroup = inventoryGroup; inventoryFilterEntity.InventoryGroupType = inventoryGroupType; inventoryFilterEntity.InventoryName = inventoryName; inventoryFilterEntity.SalePrice = salePrice; inventoryFilterEntity.InventoryNameType = inventoryNameType; inventoryFilterEntity.SalePriceType = salePriceType; inventoryFilterEntity.SKUCode = SKUCode; inventoryFilterEntity.SKUCodeType = salePriceType; inventoryFilterEntity.Status = status; inventoryFilterEntity.Unit = unit; inventoryFilterEntity.UnitType = unitType; inventoryFilterEntity.SKUCodeType = SKUCodeType; ServiceResult res = _inventoryService.GetInventoriesPaging(pageSize, pageIndex, inventoryFilterEntity); if (res.isValid) { return(Ok(res.data)); } else { return(StatusCode(204, res)); } }