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