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