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