public ActionResult <PageResponse <TransactionDTO> > Transactions([FromQuery] TransactionSearch search)
{
var userId = AuthMiddleware.GetUserId(User);
var transactions = _service.GetTransactions(search, userId);
return(Ok(transactions));
}
public IActionResult Transaction([FromQuery] TransactionSearch search)
{
var id = GetTokenId.getId(User);
var transaction = _userService.GetTRansactions(search, id);
return(Ok(transaction));
}
public PageResponse <TransactionDTO> GetTransactions(TransactionSearch search, int userId)
{
var wallet = _unitOfWork.Wallet.Find(w => w.UserId == userId).FirstOrDefault();
search.WalletId = wallet.Id;
var transactions = Execute(search);
return(transactions);
}
public IActionResult GetTransactions(int id, [FromQuery] TransactionSearch search)
{
try
{
var result = transactionRepository.GetTransactions(id, search);
return(Ok(result));
}
catch (Exception ex)
{
return(HandleException(ex));
}
}
public IHttpActionResult GetTrans(TransactionSearch search)
{
if (search == null)
{
return(BadRequest());
}
if (search.Filter == null)
{
search.Filter = new TransactionFilter();
}
var lst = transactionSvc.GetTransactions(search.Filter.AccountID, search.Filter.Description);
search.Pagination.TotalItems = lst.Count;
search.Transactions = lst.Skip((search.Pagination.Page - 1) * search.Pagination.ItemsPerPage).Take(search.Pagination.ItemsPerPage).ToList();
return(Ok(search));
}
public PageResponse <TransactionDTO> Execute(TransactionSearch request)
{
var query = _unitOfWork.Transaction.Find(t => t.WalletID == request.WalletId);
if (request.MinAmount.HasValue)
{
query = query.Where(t => t.Amount >= request.MinAmount);
}
if (request.MaxAmount.HasValue)
{
query = query.Where(t => t.Amount <= request.MaxAmount);
}
if (request.Type != null)
{
var keyword = request.Type.ToLower();
query = query.Where(t => t.Type.ToLower().Contains(keyword));
}
var totalCount = query.Count();
query = query.Skip((request.PageNumber - 1) * request.PerPage).Take(request.PerPage);
var pagesCount = (int)Math.Ceiling((double)totalCount / request.PerPage);
var response = new PageResponse <TransactionDTO>
{
CurrentPage = request.PageNumber,
TotalCount = totalCount,
PageCount = pagesCount,
Data = query.Select(t => new TransactionDTO
{
Amount = t.Amount,
Type = t.Type,
CreatedAt = t.CreatedtAt
})
};
return(response);
}
public TransationSearchResult GetTransactions(int accountId, TransactionSearch search)
{
if (search.Query == null)
{
search.Query = string.Empty;
}
int pageSize = 20;
var transactions = base.Table <BankTransaction>()
.Where(q => q.AccountId == (accountId > 0 ? accountId : q.AccountId) &&
(q.Description.Contains(search.Query) || q.Tag.Contains(search.Query)))
.OrderByDescending(o => o.TransactionDate)
.ProjectTo <Transaction>().ToList();
var result = new TransationSearchResult()
{
ItemsPerPage = pageSize,
Page = search.Page,
Count = transactions.Count,
Data = transactions.Skip((search.Page - 1) * pageSize).Take(pageSize).ToList()
};
return(result);
}
public List <TransactionDataItem> SearchPastel(string buildingPath, DateTime fromDate, DateTime toDate, string reference, string description, decimal?minimumAmount, decimal?maximumAmount)
{
return(TransactionSearch.SearchPastel(buildingPath, fromDate, toDate, reference, description, minimumAmount, maximumAmount));
}
public void savedSearchMaxCredible(NetSuiteService service)
{
TransactionSearchAdvanced TSA = new TransactionSearchAdvanced();
TSA.savedSearchScriptId = TxtSavedSearch1.Text;
TransactionSearch TS = new TransactionSearch();
TransactionSearchBasic TSB = new TransactionSearchBasic();
if (Settings.Default.APP_DatesEnabled)
{
DateTime theSearchStartDate = DTPickerFrom.Value;
DateTime theSearchFinishDate = DTPickerTo.Value;
SearchDateField theDTSearch = new SearchDateField();
theDTSearch.operatorSpecified = true;
theDTSearch.@operator = SearchDateFieldOperator.within;
theDTSearch.searchValue2Specified = true;
theDTSearch.searchValueSpecified = true;
theDTSearch.searchValue = theSearchStartDate;
theDTSearch.searchValue2 = theSearchFinishDate;
TSB.tranDate = theDTSearch;
}
TS.basic = TSB;
TSA.criteria = TS;
AppendTextBoxLine(txtSearchResults, "Performing search ...", true);
SearchResult SR = service.search(TSA);
if (SR.totalRecords == 0)
{
AppendTextBoxLine(txtSearchResults, "No records / consignments were returned in the Saved Search : " + TxtSavedSearch1.Text, true);
}
else
{
AppendTextBoxLine(txtSearchResults, SR.totalRecords + " records / consignments were returned in the Saved Search : " + TxtSavedSearch1.Text, true);
SearchRow[] SSR;
SSR = SR.searchRowList;
SearchRow[] SSRM;
// Build Intermediate List to allow pagination
System.Collections.ArrayList theInvoiceList = new System.Collections.ArrayList();
for (int ssr = 0; ssr < SSR.Length; ssr++) theInvoiceList.Add(SSR[ssr]);
AppendTextBoxLine(txtSearchResults, "Records downloaded : " + theInvoiceList.Count + " of " + SR.totalRecords.ToString(), true);
if (SR.totalRecords > SR.pageSize)
{
int batchNo = 2;
// Keep getting pages until there are no more pages to get
while (SR.totalRecords > ((batchNo - 1) * SR.pageSize))
{
AppendTextBoxLine(txtSearchResults, "Fetching next batch no. " + batchNo, true);
// Invoke searchMore() operation - ensure logged in ...
setupNetSuiteObjects(service); // To ensure logged in before next batch
SearchResult SRM = service.searchMore(batchNo);
if (SRM != null)
{
// Process response
if (SRM.status.isSuccess)
{
SSRM = SRM.searchRowList;
for (int ssrm = 0; ssrm < SSRM.Length; ssrm++) theInvoiceList.Add(SSRM[ssrm]);
AppendTextBoxLine(txtSearchResults, "Records downloaded : " + theInvoiceList.Count + " of " + SR.totalRecords.ToString(), true);
batchNo++;
}
else
{
AppendTextBoxLine(txtSearchResults, getStatusDetails(SRM.status), true);
}
}
}
}
_SSRECORDS = new SearchRow[theInvoiceList.Count];
IEnumerator iienum = theInvoiceList.GetEnumerator();
for (int iicr = 0; iienum.MoveNext(); iicr++)
{
_SSRECORDS[iicr] = (SearchRow)iienum.Current;
}
//Record list assembly complete - create list for MaxCredible upload
ProgressNSSearch.Maximum = _SSRECORDS.Length;
for (int i = 0; i < _SSRECORDS.Length; i++)
{
TransactionSearchRow TSR = (TransactionSearchRow)_SSRECORDS[i];
// Declare all the variables for use when writing the file...
//DOCNUM
string theInternalid = "";
if (TSR.basic.internalId != null)
{
theInternalid = TSR.basic.internalId[0].searchValue.internalId;
}
string sDocNum = "";
if (TSR.basic.tranId != null)
{
sDocNum = TSR.basic.tranId[0].searchValue.ToString();
}
//DATE
string sDate = "";
if (TSR.basic.tranDate != null)
{
sDate = TSR.basic.tranDate[0].searchValue.ToString("dd/MM/yyyy");
}
AppendTextBoxLine(txtSearchResults, (i+1) + "\t" + theInternalid + "\t" + sDocNum + "\t" + sDate, false);
ProgressNSSearch.Value++;
}
// Set up MaxCredible Data defaults based on records returned
_MaxCredibleData.NR_RECORDS = _SSRECORDS.Length.ToString();
_MaxCredibleData.CHUNK_SIZE = TxtChunkSize.Text;
GrpMaxCredible.Text = "Step 2 - Upload " + _MaxCredibleData.NR_RECORDS + " Records to MaxCredible";
updateChunkSizes();
}
return;
}
public static void DeleteItemFullfitment()
{
string strItem = "";
try
{
TransactionSearch xactionSearch = new TransactionSearch();
//xactionSearch.basic
//SearchMultiSelectField entity = new SearchMultiSelectField();
//entity.@operator = SearchMultiSelectFieldOperator.anyOf;
//entity.operatorSpecified = true;
//RecordRef custRecordRef = new RecordRef();
//custRecordRef.internalId = strCustomerId;
//custRecordRef.type = RecordType.customer;
//custRecordRef.typeSpecified = true;
//RecordRef[] custRecordRefArray = new RecordRef[1];
//custRecordRefArray[0] = custRecordRef;
//entity.searchValue = custRecordRefArray;
SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField();
searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf;
searchSalesOrderField.operatorSpecified = true;
System.String[] soStringArray = new System.String[1];
soStringArray[0] = "_itemFulfillment";
searchSalesOrderField.searchValue = soStringArray;
TransactionSearchBasic xactionBasic = new TransactionSearchBasic();
xactionBasic.type = searchSalesOrderField;
xactionBasic.dateCreated = new SearchDateField();
xactionBasic.dateCreated.@operator = SearchDateFieldOperator.within;
xactionBasic.dateCreated.operatorSpecified = true;
xactionBasic.dateCreated.searchValue = new DateTime(2011, 12, 30);
xactionBasic.dateCreated.searchValueSpecified = true;
xactionBasic.dateCreated.searchValue2 = new DateTime(2011, 12, 31);
xactionBasic.dateCreated.searchValue2Specified = true;
xactionSearch.basic = xactionBasic;
SearchResult objSearchResult = _service.search(xactionSearch);
if (objSearchResult.status != null && objSearchResult.status.isSuccess)
{
if (objSearchResult.recordList != null)
{
Record[] recordList;
for (int i = 1; i <= objSearchResult.totalPages; i++)
{
recordList = objSearchResult.recordList;
for (int j = 0; j < recordList.Length; j++)
{
if (recordList[j] is ItemFulfillment)
{
try
{
ItemFulfillment objOrder = (ItemFulfillment)(recordList[j]);
object objCustomReseller = GetValue("custbodytbfcustomerid", objOrder.customFieldList);
if (objCustomReseller != null && (objCustomReseller.ToString().Equals("CST100WA") || objCustomReseller.ToString().Equals("1")))
{
RecordRef objRef = new RecordRef();
objRef.internalId = ((ItemFulfillment)recordList[j]).internalId;
objRef.type = RecordType.itemFulfillment;
objRef.typeSpecified = true;
WriteResponse writeRes = _service.delete(objRef);
if (writeRes.status.isSuccess)
{
Console.WriteLine("delete: " + objRef.internalId);
}
else
{
Console.WriteLine(getStatusDetails(writeRes.status));
}
}
}
catch (Exception objExc)
{
Console.WriteLine(objExc.ToString());
}
}
}
}
}
}
else
{
strItem = "error";
}
}
catch (Exception objExc)
{
Console.WriteLine(objExc.ToString());
}
}
public static string GetOrderId(string strCustomerId, double numAmount)
{
string strItem = "";
try
{
TransactionSearch xactionSearch = new TransactionSearch();
SearchMultiSelectField entity = new SearchMultiSelectField();
entity.@operator = SearchMultiSelectFieldOperator.anyOf;
entity.operatorSpecified = true;
RecordRef custRecordRef = new RecordRef();
custRecordRef.internalId = strCustomerId;
custRecordRef.type = RecordType.customer;
custRecordRef.typeSpecified = true;
RecordRef[] custRecordRefArray = new RecordRef[1];
custRecordRefArray[0] = custRecordRef;
entity.searchValue = custRecordRefArray;
SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField();
searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf;
searchSalesOrderField.operatorSpecified = true;
System.String[] soStringArray = new System.String[1];
soStringArray[0] = "_salesOrder";
searchSalesOrderField.searchValue = soStringArray;
TransactionSearchBasic xactionBasic = new TransactionSearchBasic();
xactionBasic.type = searchSalesOrderField;
xactionBasic.entity = entity;
xactionBasic.status = new SearchEnumMultiSelectField();
xactionBasic.status.@operator = SearchEnumMultiSelectFieldOperator.anyOf;
xactionBasic.status.operatorSpecified = true;
xactionBasic.status.searchValue = new string[] { "_salesOrderPendingApproval" };
xactionBasic.amount = new SearchDoubleField();
xactionBasic.amount.@operator = SearchDoubleFieldOperator.equalTo;
xactionBasic.amount.operatorSpecified = true;
xactionBasic.amount.searchValue = numAmount;
xactionBasic.amount.searchValueSpecified = true;
xactionSearch.basic = xactionBasic;
SearchResult objSearchResult = _service.search(xactionSearch);
if (objSearchResult.recordList != null)
{
Record[] recordList;
for (int i = 1; i <= objSearchResult.totalPages; i++)
{
recordList = objSearchResult.recordList;
for (int j = 0; j < recordList.Length; j++)
{
if (recordList[j] is SalesOrder)
{
SalesOrder so = (SalesOrder)(recordList[j]);
strItem = so.internalId;
return strItem;
}
}
}
}
}
catch (Exception)
{
}
return strItem;
}
public static string GetOrderId(string strCustomerId, string strPONumber, string strOrderNumber)
{
string strItem = "";
try
{
TransactionSearch xactionSearch = new TransactionSearch();
//SearchMultiSelectField entity = new SearchMultiSelectField();
//entity.@operator = SearchMultiSelectFieldOperator.anyOf;
//entity.operatorSpecified = true;
//RecordRef custRecordRef = new RecordRef();
//custRecordRef.internalId = strCustomerId;
//custRecordRef.type = RecordType.customer;
//custRecordRef.typeSpecified = true;
//RecordRef[] custRecordRefArray = new RecordRef[1];
//custRecordRefArray[0] = custRecordRef;
//entity.searchValue = custRecordRefArray;
SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField();
searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf;
searchSalesOrderField.operatorSpecified = true;
System.String[] soStringArray = new System.String[1];
soStringArray[0] = "_salesOrder";
searchSalesOrderField.searchValue = soStringArray;
TransactionSearchBasic xactionBasic = new TransactionSearchBasic();
xactionBasic.type = searchSalesOrderField;
//xactionBasic.entity = entity;
xactionBasic.otherRefNum = new SearchTextNumberField();
xactionBasic.otherRefNum.@operator = SearchTextNumberFieldOperator.equalTo;
xactionBasic.otherRefNum.operatorSpecified = true;
xactionBasic.otherRefNum.searchValue = strPONumber;
SearchStringCustomField objOrderNumber = new SearchStringCustomField();
objOrderNumber.internalId = "custbodycst_ordernumber";
objOrderNumber.@operator = SearchStringFieldOperator.contains;
objOrderNumber.operatorSpecified = true;
objOrderNumber.searchValue = strOrderNumber;
xactionBasic.customFieldList = new SearchCustomField[] { objOrderNumber };
xactionSearch.basic = xactionBasic;
SearchResult objSearchResult = _service.search(xactionSearch);
if (objSearchResult.status != null && objSearchResult.status.isSuccess)
{
if (objSearchResult.recordList != null)
{
Record[] recordList;
for (int i = 1; i <= objSearchResult.totalPages; i++)
{
recordList = objSearchResult.recordList;
for (int j = 0; j < recordList.Length; j++)
{
if (recordList[j] is SalesOrder)
{
SalesOrder so = (SalesOrder)(recordList[j]);
strItem = so.internalId;
return strItem;
}
}
}
}
}
else
{
strItem = "error";
}
}
catch (Exception)
{
}
return strItem;
}
public static string GetOrderId(string strPONumber, string strReseller)
{
string strOrderId = "";
try
{
TransactionSearch xactionSearch = new TransactionSearch();
SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField();
searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf;
searchSalesOrderField.operatorSpecified = true;
System.String[] soStringArray = new System.String[1];
soStringArray[0] = "_salesOrder";
searchSalesOrderField.searchValue = soStringArray;
TransactionSearchBasic xactionBasic = new TransactionSearchBasic();
xactionBasic.type = searchSalesOrderField;
xactionBasic.otherRefNum = new SearchTextNumberField();
xactionBasic.otherRefNum.@operator = SearchTextNumberFieldOperator.equalTo;
xactionBasic.otherRefNum.operatorSpecified = true;
xactionBasic.otherRefNum.searchValue = strPONumber;
SearchMultiSelectCustomField objReseller = new SearchMultiSelectCustomField();
objReseller.internalId = "custbodytbfcustomerid";
objReseller.@operator = SearchMultiSelectFieldOperator.anyOf;
objReseller.operatorSpecified = true;
objReseller.searchValue = new ListOrRecordRef[1];
objReseller.searchValue[0] = new ListOrRecordRef();
objReseller.searchValue[0].internalId = strReseller;
xactionBasic.customFieldList = new SearchCustomField[] { objReseller };
xactionSearch.basic = xactionBasic;
SearchResult objSearchResult = _service.search(xactionSearch);
if (objSearchResult.recordList != null)
{
Record[] recordList;
for (int i = 1; i <= objSearchResult.totalPages; i++)
{
recordList = objSearchResult.recordList;
for (int j = 0; j < recordList.Length; j++)
{
if (recordList[j] is SalesOrder)
{
SalesOrder so = (SalesOrder)(recordList[j]);
strOrderId = so.internalId;
}
}
}
}
}
catch (Exception)
{
}
return strOrderId;
}
public static void DeleteSalesOrder()
{
string strItem = "";
try
{
TransactionSearch xactionSearch = new TransactionSearch();
//xactionSearch.basic
//SearchMultiSelectField entity = new SearchMultiSelectField();
//entity.@operator = SearchMultiSelectFieldOperator.anyOf;
//entity.operatorSpecified = true;
//RecordRef custRecordRef = new RecordRef();
//custRecordRef.internalId = strCustomerId;
//custRecordRef.type = RecordType.customer;
//custRecordRef.typeSpecified = true;
//RecordRef[] custRecordRefArray = new RecordRef[1];
//custRecordRefArray[0] = custRecordRef;
//entity.searchValue = custRecordRefArray;
SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField();
searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf;
searchSalesOrderField.operatorSpecified = true;
System.String[] soStringArray = new System.String[1];
soStringArray[0] = "_salesOrder";
searchSalesOrderField.searchValue = soStringArray;
TransactionSearchBasic xactionBasic = new TransactionSearchBasic();
xactionBasic.type = searchSalesOrderField;
xactionBasic.customFieldList = new SearchCustomField[1];
SearchStringCustomField objNumber = new SearchStringCustomField();
objNumber.internalId = "custbodycst_ordernumber";
objNumber.@operator = SearchStringFieldOperator.notEmpty;
objNumber.operatorSpecified = true;
xactionBasic.customFieldList[0] = objNumber;
xactionSearch.basic = xactionBasic;
SearchResult objSearchResult = _service.search(xactionSearch);
if (objSearchResult.status != null && objSearchResult.status.isSuccess)
{
if (objSearchResult.recordList != null)
{
Record[] recordList;
for (int i = 1; i <= objSearchResult.totalPages; i++)
{
recordList = objSearchResult.recordList;
for (int j = 0; j < recordList.Length; j++)
{
if (recordList[j] is SalesOrder)
{
try
{
SalesOrder objOrder = GetSalesOrder(((SalesOrder)(recordList[j])).internalId);
object objCustomReseller = GetValue("custbodytbfcustomerid", objOrder.customFieldList);
if (objCustomReseller.ToString().Equals("CST100WA"))
{
RecordRef objRef = new RecordRef();
objRef.internalId = objOrder.internalId;
objRef.type = RecordType.salesOrder;
objRef.typeSpecified = true;
WriteResponse writeRes = _service.delete(objRef);
if (writeRes.status.isSuccess)
{
Console.WriteLine("delete: " + objOrder.tranId);
}
else
{
Console.WriteLine(getStatusDetails(writeRes.status));
}
}
}
catch (Exception objExc)
{
Console.WriteLine(objExc.ToString());
}
}
}
}
}
}
else
{
strItem = "error";
}
}
catch (Exception)
{
}
}
protected TransactionResult ListMovements(GridModel model, TransactionSearch search)
{
var response = new TransactionResult();
ExecuteReader("r_AssetTransaction_List",
delegate(SqlCommand sqlCommand)
{
if (search != null)
{
if (!string.IsNullOrEmpty(search.Id))
{
sqlCommand.Parameters.AddWithValue("@Id", search.Id);
}
if (search.Location != 0)
{
sqlCommand.Parameters.AddWithValue("@location", search.Location);
}
if (search.Status != 0)
{
sqlCommand.Parameters.AddWithValue("@status", search.Status);
}
if (!string.IsNullOrEmpty(search.Name))
{
sqlCommand.Parameters.AddWithValue("@name", search.Name);
}
if (!string.IsNullOrEmpty(search.From))
{
sqlCommand.Parameters.AddWithValue("@from", DateTime.Parse(search.From));
}
if (!string.IsNullOrEmpty(search.To))
{
sqlCommand.Parameters.AddWithValue("@to", DateTime.Parse(search.To).AddHours(23).AddMinutes(59));
}
if (!string.IsNullOrEmpty(search.Direction))
{
sqlCommand.Parameters.AddWithValue("@Direction", search.Direction);
}
if (model.iSortCol_0 != 0)
{
model.iSortCol_0--;
}
switch (model.SortingDirection)
{
case SortDirection.Undefiened:
sqlCommand.Parameters.AddWithValue("@sortColumn", 4);
sqlCommand.Parameters.AddWithValue("@SortDirection", 1);
break;
case SortDirection.Ascending:
sqlCommand.Parameters.AddWithValue("@sortColumn", model.iSortCol_0);
sqlCommand.Parameters.AddWithValue("@SortDirection", 0);
break;
case SortDirection.Descending:
sqlCommand.Parameters.AddWithValue("@sortColumn", model.iSortCol_0);
sqlCommand.Parameters.AddWithValue("@SortDirection", 1);
break;
default:
break;
}
}
var pageSize = model == null ? 10 : ((model.iDisplayLength == 0) ? 10 : model.iDisplayLength);
var PageNumber = model == null ? 1 : ((model.iDisplayStart == 0) ? 1 : model.iDisplayStart) / pageSize + 1;
sqlCommand.Parameters.AddWithValue("@pageSize", pageSize);
sqlCommand.Parameters.AddWithValue("@PageNumber", PageNumber);
},
delegate(SqlDataReader reader)
{
while (reader.Read())
{
response.AssetTransactions.Add(new AssetTransaction
{
AssetId = reader.GetString(0),
AssetName = reader.GetString(1),
AssetStatus = reader.GetInt32(2),
Location = reader.GetString(3),
Date_and_Time = reader.GetDateTime(4),
Direction = reader.GetString(5)
});
}
if (reader.NextResult() && reader.Read())
{
response.RowsCount = reader.GetInt32(0);
}
});
return(response);
}
public void itemFulfillmentSearch(string orderNumber)
{
NetSuiteService service = new NetSuiteService();
service.CookieContainer = new CookieContainer();
NetsuiteUser user = new NetsuiteUser("3451682", "*****@*****.**", "1026", "tridenT168");
Passport passport = user.prepare(user);
Status status = service.login(passport).status;
TransactionSearchAdvanced tranSearchAdvanced = new TransactionSearchAdvanced();
TransactionSearch tranSearch = new TransactionSearch();
SearchStringField orderID = new SearchStringField();
orderID.@operator = SearchStringFieldOperator.@is;
orderID.operatorSpecified = true;
orderID.searchValue = orderNumber;
TransactionSearchBasic tranSearchBasic = new TransactionSearchBasic();
tranSearchBasic.tranId = orderID;
tranSearch.basic = tranSearchBasic;
tranSearchAdvanced.criteria = tranSearch;
SearchPreferences searchPreferences = new SearchPreferences();
searchPreferences.bodyFieldsOnly = false;
service.searchPreferences = searchPreferences;
SearchResult transactionResult = service.search(tranSearchAdvanced);
if (transactionResult.status.isSuccess != true) throw new Exception("Cannot find Order " + orderNumber + " " + transactionResult.status.statusDetail[0].message);
if (transactionResult.recordList.Count() != 1) throw new Exception("More than one order found for item " + orderNumber);
this.itemFulfillment = new com.netsuite.webservices.ItemFulfillment();
this.itemFulfillment = ((com.netsuite.webservices.ItemFulfillment)transactionResult.recordList[0]);
}
