public async Task <RWarehouse[]> Search(string code, string email, string phone, string name, EnumDefine.WarehouseStatusEnum status, EnumDefine.WarehouseTypeEnum type, RefSqlPaging paging)
{
return(await _warehouseRepository.Search(code, email, phone, name, status, type, paging));
}
public async Task <RWarehouse[]> Search(string venderId, string keyword, EnumDefine.WarehouseStatusEnum status, EnumDefine.WarehouseTypeEnum type, RefSqlPaging paging)
{
return(await WithConnection(async (connection) =>
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@VendorId", venderId, DbType.String);
parameters.Add("@Keyword", keyword, DbType.String);
parameters.Add("@Status", status.AsEnumToInt(), DbType.Int16);
parameters.Add("@Type", type.AsEnumToInt(), DbType.Int16);
parameters.Add("@OFFSET", paging.OffSet, DbType.Int16);
parameters.Add("@FETCH", paging.PageSize, DbType.Int16);
var data = await connection.QueryAsync <RWarehouse>(ProcName.Warehouse_SearchByKeyword, parameters, commandType: CommandType.StoredProcedure);
var dataReturn = data.ToArray();
if (dataReturn.Length > 0)
{
paging.TotalRow = dataReturn[0].TotalRow;
}
return dataReturn;
}));
}
public async Task <RWarehouse[]> Search(string venderId, string keyword, EnumDefine.WarehouseStatusEnum status, EnumDefine.WarehouseTypeEnum type, RefSqlPaging paging)
{
return(await _warehouseRepository.Search(venderId, keyword, status, type, paging));
}
