public InvoiceItemList addItemList( SalesOrderItemList salesOrderLines)
{
InvoiceItemList invItemList = new InvoiceItemList();
int i = 0;
InvoiceItem[] Items = new InvoiceItem[salesOrderLines.item.Count()];
foreach (var itemLine in salesOrderLines.item)
{
Items[i] = new InvoiceItem();
RecordRef item = new RecordRef();
item.type = RecordType.inventoryItem;
item.typeSpecified = true;
// item.internalId = "1229";
item.internalId = salesOrderLines.item[i].item.internalId;
Items[i].item = item;
RecordRef prLevel = new RecordRef();
prLevel.type = RecordType.priceLevel;
prLevel.internalId = "-1";
prLevel.typeSpecified = true;
Items[i].price = prLevel;
Items[i].rate = Convert.ToString(salesOrderLines.item[i].rate);
Items[i].quantity = salesOrderLines.item[i].quantity;
Items[i].quantitySpecified = true;
i++;
}
invItemList.item = Items;
return invItemList;
}
public SalesOrderItemList addToExistingItemList(SalesOrderItemList oldList, SalesOrderLine salesOrderLine)
{
int oldCount = oldList.item.Length;
int newCount = oldCount + 1;
SalesOrderItemList newOrderList = new SalesOrderItemList();
SalesOrderItem[] newItem = new SalesOrderItem[1];
SalesOrderItem[] newList = new SalesOrderItem[newCount];
oldList.item.CopyTo(newList, 0);
newItem[0] = new SalesOrderItem();
RecordRef item = new RecordRef();
item.type = RecordType.inventoryItem;
item.typeSpecified = true;
// item.internalId = "1229";
item.name = salesOrderLine.item.ItemName;
item.internalId = salesOrderLine.item.itemRecord.internalId;
newItem[0].item = item;
RecordRef prLevel = new RecordRef();
prLevel.type = RecordType.priceLevel;
prLevel.internalId = "-1";
prLevel.typeSpecified = true;
newItem[0].price = prLevel;
newItem[0].rate = Convert.ToString(salesOrderLine.UnitPrice);
newItem[0].quantity = salesOrderLine.QuantityRequested;
newItem[0].quantitySpecified = true;
newItem.CopyTo(newList, oldCount);
newOrderList.item = newList;
return newOrderList;
}
public void addItemList(List<SalesOrderLine> salesOrderLines)
{
SalesOrderItemList salesOrderItemList = new SalesOrderItemList();
int i = 0;
SalesOrderItem[] Items = new SalesOrderItem[salesOrderLines.Count];
foreach (var SOLine in salesOrderLines)
{
Items[i] = new SalesOrderItem();
RecordRef item = new RecordRef();
item.type = RecordType.inventoryItem;
item.typeSpecified = true;
item.internalId = salesOrderLines[i].item.itemRecord.internalId;
Items[i].item = item;
RecordRef prLevel = new RecordRef();
prLevel.type = RecordType.priceLevel;
prLevel.internalId = "-1";
prLevel.typeSpecified = true;
Items[i].price = prLevel;
Items[i].rate = Convert.ToString(salesOrderLines[i].UnitPrice);
Items[i].quantity = salesOrderLines[i].QuantityRequested;
Items[i].quantitySpecified = true;
i++;
}
salesOrderItemList.item = Items;
this.salesOrder.itemList = salesOrderItemList;
}
public static string AddSalesOrderMassive(RecordRef objCustomer, string strCategory, string strPoNumber, string strOrderNumber, DateTime datOrderDate,
DateTime datInsertDate, DateTime datEventDate, bool booConfirmed, bool booCases, string strBride, string strGroom, ArrayList arrItems, string strUserId)
{
string strId = "";
SalesOrder objSalesOrder = new SalesOrder();
objSalesOrder.entity = objCustomer;
objSalesOrder.tranDate = new System.DateTime();
objSalesOrder.orderStatus = SalesOrderOrderStatus._pendingFulfillment;
//objSalesOrder.salesRep = new RecordRef();
//objSalesOrder.salesRep.internalId = strUserId;
//objSalesOrder.salesRep.type = RecordType.employee;
//objSalesOrder.salesRep.typeSpecified = true;
SelectCustomFieldRef objReseller = new SelectCustomFieldRef();
objReseller.internalId = "custbodytbfcustomerid";
objReseller.value = new ListOrRecordRef();
objReseller.value.internalId = "1";
BooleanCustomFieldRef objCategory = new BooleanCustomFieldRef();
objCategory.internalId = "custbodycst_ordercategory";
objCategory.value = bool.Parse(strCategory);
BooleanCustomFieldRef objConfirmed = new BooleanCustomFieldRef();
objConfirmed.internalId = "custbodycst_orderconfirmed";
objConfirmed.value = booConfirmed;
BooleanCustomFieldRef objCases = new BooleanCustomFieldRef();
objCases.internalId = "custbodycst_cases";
objCases.value = booCases;
StringCustomFieldRef objOrderNumber = new StringCustomFieldRef();
objOrderNumber.internalId = "custbodycst_ordernumber";
objOrderNumber.value = strOrderNumber;
StringCustomFieldRef objPONumber = new StringCustomFieldRef();
objPONumber.internalId = "custbodycostcoponumber";
objPONumber.value = strPoNumber;
StringCustomFieldRef objGroom = new StringCustomFieldRef();
objGroom.internalId = "custbody_groom";
objGroom.value = strGroom;
StringCustomFieldRef objBride = new StringCustomFieldRef();
objBride.internalId = "custbody_bride";
objBride.value = strBride;
DateCustomFieldRef objOrderDate = new DateCustomFieldRef();
objOrderDate.internalId = "custbodycst_orderdate";
objOrderDate.value = datOrderDate;
DateCustomFieldRef objInsertDate = new DateCustomFieldRef();
objInsertDate.internalId = "custbodycst_insertdate";
objInsertDate.value = datInsertDate;
DateCustomFieldRef objEventDate = new DateCustomFieldRef();
objEventDate.internalId = "custbody_wedding_date";
objEventDate.value = datEventDate;
object[] arrFirstItem = (object[])arrItems[0];
DateCustomFieldRef objDeliveryDate = new DateCustomFieldRef();
objDeliveryDate.internalId = "custbody_delivery_date";
objDeliveryDate.value = (DateTime)arrFirstItem[2];
DateCustomFieldRef objShippingDate = new DateCustomFieldRef();
objShippingDate.internalId = "custbody_shipping_date";
objShippingDate.value = (DateTime)arrFirstItem[3];
if (datEventDate != DateTime.MaxValue)
{
objSalesOrder.customFieldList = new CustomFieldRef[] { objReseller, objConfirmed, objCases, objCategory, objGroom, objBride, objOrderNumber, objPONumber, objOrderDate, objInsertDate, objEventDate, objDeliveryDate, objShippingDate };
}
else
{
objSalesOrder.customFieldList = new CustomFieldRef[] { objReseller, objConfirmed, objCases, objCategory, objGroom, objBride, objOrderNumber, objPONumber, objOrderDate, objInsertDate, objDeliveryDate, objShippingDate };
}
objSalesOrder.otherRefNum = strPoNumber;
SalesOrderItem[] salesOrderItemArray = new SalesOrderItem[arrItems.Count];
for (int i = 0; i < salesOrderItemArray.Length; i++)
{
object[] arrColumns = (object[])arrItems[i];
RecordRef item = new RecordRef();
item.type = RecordType.nonInventoryResaleItem;
item.typeSpecified = true;
item.internalId = arrColumns[0].ToString();
salesOrderItemArray[i] = new SalesOrderItem();
salesOrderItemArray[i].item = item;
StringCustomFieldRef objCustomInfo = new StringCustomFieldRef();
objCustomInfo.internalId = "custcol_additional_info";
objCustomInfo.value = arrColumns[8].ToString();
StringCustomFieldRef objOriginal = new StringCustomFieldRef();
objOriginal.internalId = "custcolcst_originalid";
objOriginal.value = arrColumns[9].ToString();
LongCustomFieldRef objOrderLine = new LongCustomFieldRef();
objOrderLine.internalId = "custcolcst_orderline";
objOrderLine.value = (int)arrColumns[6];
SelectCustomFieldRef objShippingType = new SelectCustomFieldRef();
objShippingType.internalId = "custcolcst_shippingtype";
objShippingType.value = new ListOrRecordRef();
switch (arrColumns[7].ToString())
{
case "IPD":
objShippingType.value.internalId = "1";
break;
case "IP":
objShippingType.value.internalId = "2";
break;
case "Domestic":
objShippingType.value.internalId = "3";
break;
case "Fedex Next Day":
objShippingType.value.internalId = "4";
break;
}
if ((DateTime)arrColumns[4] == DateTime.MaxValue)
{
DateCustomFieldRef objDelivDate = new DateCustomFieldRef();
objDelivDate.internalId = "custcolcst_deliverydate";
objDelivDate.value = (DateTime)arrColumns[2];
DateCustomFieldRef objShipDate = new DateCustomFieldRef();
objShipDate.internalId = "custcolcst_shippingdate";
objShipDate.value = (DateTime)arrColumns[3];
salesOrderItemArray[i].customFieldList = new CustomFieldRef[] { objDelivDate, objShipDate, objOrderLine, objShippingType, objCustomInfo, objOriginal };
}
else
{
DateCustomFieldRef objDelivDate = new DateCustomFieldRef();
objDelivDate.internalId = "custcolcst_deliverydate";
objDelivDate.value = (DateTime)arrColumns[2];
DateCustomFieldRef objShipDate = new DateCustomFieldRef();
objShipDate.internalId = "custcolcst_shippingdate";
objShipDate.value = (DateTime)arrColumns[3];
DateCustomFieldRef objPrefDate = new DateCustomFieldRef();
objPrefDate.internalId = "custcolcst_preferredarrivaldate";
objPrefDate.value = (DateTime)arrColumns[4];
salesOrderItemArray[i].customFieldList = new CustomFieldRef[] { objDelivDate, objShipDate, objPrefDate, objOrderLine, objShippingType, objCustomInfo, objOriginal };
}
System.Double quantity = System.Double.Parse(arrColumns[1].ToString());
salesOrderItemArray[i].quantity = quantity;
salesOrderItemArray[i].quantitySpecified = true;
}
SalesOrderItemList salesOrderItemList = new SalesOrderItemList();
salesOrderItemList.item = salesOrderItemArray;
objSalesOrder.itemList = salesOrderItemList;
WriteResponse writeRes = _service.add(objSalesOrder);
if (writeRes.status.isSuccess)
{
strId = ((RecordRef)writeRes.baseRef).internalId;
//_out.writeLn("\nSales order created successfully\nSales Order Internal ID=" + ((RecordRef)writeRes.baseRef).internalId);
}
else
{
throw new Exception("Orden no ingresada: " + getStatusDetails(writeRes.status));
//_out.error(getStatusDetails(writeRes.status));
}
return strId;
}
public static string AddSalesOrder1800(int numReseller, Customer objCustomer, string strVendorCode, string strPoNumber, string strOrderNumber, DateTime datOrderDate,
DateTime datInsertDate, DateTime datEventDate, ArrayList arrItems, string strUserId, out string strError)
{
strError = "";
string strId = "";
SalesOrder objSalesOrder = new SalesOrder();
objSalesOrder.entity = new RecordRef();
objSalesOrder.entity.type = RecordType.customer;
objSalesOrder.entity.typeSpecified = true;
objSalesOrder.entity.externalId = objCustomer.externalId;
objSalesOrder.tranDate = new System.DateTime();
objSalesOrder.orderStatus = SalesOrderOrderStatus._pendingFulfillment;
objSalesOrder.externalId = "so1800_"+strOrderNumber;
objSalesOrder.customForm = new RecordRef();
objSalesOrder.customForm.internalId = GlobalSettings.Default.nsOrderForm;
objSalesOrder.customForm.type = RecordType.account;
objSalesOrder.customForm.typeSpecified = true;
//objSalesOrder.salesRep = new RecordRef();
//objSalesOrder.salesRep.internalId = strUserId;
//objSalesOrder.salesRep.type = RecordType.employee;
//objSalesOrder.salesRep.typeSpecified = true;
SelectCustomFieldRef objReseller = new SelectCustomFieldRef();
objReseller.internalId = "custbodytbfcustomerid";
objReseller.value = new ListOrRecordRef();
objReseller.value.internalId = numReseller.ToString();
StringCustomFieldRef objVendorCode = new StringCustomFieldRef();
objVendorCode.internalId = "custbody_vfvendorcode";
objVendorCode.value = strVendorCode;
StringCustomFieldRef objOrderNumber = new StringCustomFieldRef();
objOrderNumber.internalId = "custbodycst_ordernumber";
objOrderNumber.value = strOrderNumber;
StringCustomFieldRef objPONumber = new StringCustomFieldRef();
objPONumber.internalId = "custbodycostcoponumber";
objPONumber.value = strPoNumber;
DateCustomFieldRef objOrderDate = new DateCustomFieldRef();
objOrderDate.internalId = "custbodycst_orderdate";
objOrderDate.value = datOrderDate;
DateCustomFieldRef objInsertDate = new DateCustomFieldRef();
objInsertDate.internalId = "custbodycst_insertdate";
objInsertDate.value = datInsertDate;
//DateCustomFieldRef objEventDate = new DateCustomFieldRef();
//objEventDate.internalId = "custbody_wedding_date";
//objEventDate.value = datEventDate;
object[] arrFirstItem = (object[])arrItems[0];
DateCustomFieldRef objDeliveryDate = new DateCustomFieldRef();
objDeliveryDate.internalId = "custbody_delivery_date";
objDeliveryDate.value = (DateTime)arrFirstItem[3];
DateCustomFieldRef objShippingDate = new DateCustomFieldRef();
objShippingDate.internalId = "custbody_shipping_date";
objShippingDate.value = (DateTime)arrFirstItem[2];
StringCustomFieldRef objMessage = new StringCustomFieldRef();
objMessage.internalId = "custbodycst_giftmessage";
objMessage.value = "";
if (objDeliveryDate.value != DateTime.MaxValue)
{
objSalesOrder.customFieldList = new CustomFieldRef[] { objReseller, objOrderNumber, objPONumber, objOrderDate, objInsertDate, objMessage, objVendorCode };
}
else
{
objSalesOrder.customFieldList = new CustomFieldRef[] { objReseller, objOrderNumber, objPONumber, objOrderDate, objInsertDate, objMessage, objVendorCode };
}
objSalesOrder.otherRefNum = strPoNumber;
//arrItems.Add(new object[] { strProductId, numQty, strShipDate, strDeliDate, arrItems.IndexOf(strShipType) });
SalesOrderItem[] salesOrderItemArray = new SalesOrderItem[arrItems.Count];
for (int i = 0; i < salesOrderItemArray.Length; i++)
{
object[] arrColumns = (object[])arrItems[i];
RecordRef item = new RecordRef();
item.type = RecordType.nonInventoryResaleItem;
item.typeSpecified = true;
item.internalId = arrColumns[0].ToString();
salesOrderItemArray[i] = new SalesOrderItem();
salesOrderItemArray[i].item = item;
SelectCustomFieldRef objShippingType = new SelectCustomFieldRef();
objShippingType.internalId = "custcolcst_shippingtype";
objShippingType.value = new ListOrRecordRef();
objShippingType.value.internalId = arrColumns[4].ToString();
if (objShippingType.value.internalId.Equals("-1"))
{
objShippingType.value.internalId = "7";
}
SelectCustomFieldRef objShippingCourier = new SelectCustomFieldRef();
objShippingCourier.internalId = "custcolcst_courier";
objShippingCourier.value = new ListOrRecordRef();
objShippingCourier.value.internalId = "1";
if (objShippingType.value.internalId.Equals("8") || objShippingType.value.internalId.Equals("9"))
{
objShippingCourier.value.internalId = "2";
}
if (objShippingType.value.internalId.Equals("5") || objShippingType.value.internalId.Equals("6") || objShippingType.value.internalId.Equals("7"))
{
objShippingCourier.value.internalId = "3";
}
DateCustomFieldRef objShipDate = new DateCustomFieldRef();
objShipDate.internalId = "custcolcst_shippingdate";
objShipDate.value = (DateTime)arrColumns[2];
DateCustomFieldRef objDelivDate = new DateCustomFieldRef();
objDelivDate.internalId = "custcolcst_deliverydate";
objDelivDate.value = (DateTime)arrColumns[3];
StringCustomFieldRef objPo = new StringCustomFieldRef();
objPo.internalId = "custcolos_ponumber";
objPo.value = arrColumns[5].ToString();
StringCustomFieldRef objColMessage = new StringCustomFieldRef();
objColMessage.internalId = "custcolcst_message";
objColMessage.value = "";
if (arrColumns.Length == 7)
{
objColMessage.value = arrColumns[6].ToString();
objMessage.value = arrColumns[6].ToString();
}
if (objDelivDate.value != DateTime.MaxValue)
{
salesOrderItemArray[i].customFieldList = new CustomFieldRef[] { objDelivDate, objShipDate, objShippingType, objPo, objShippingCourier, objColMessage };
}
else
{
salesOrderItemArray[i].customFieldList = new CustomFieldRef[] { objShipDate, objShippingType, objPo, objShippingCourier, objColMessage };
}
System.Double quantity = System.Double.Parse(arrColumns[1].ToString());
salesOrderItemArray[i].quantity = quantity;
salesOrderItemArray[i].quantitySpecified = true;
}
SalesOrderItemList salesOrderItemList = new SalesOrderItemList();
salesOrderItemList.item = salesOrderItemArray;
objSalesOrder.itemList = salesOrderItemList;
//WriteResponse writeRes = _service.add(objSalesOrder);
WriteResponse[] writeRes = _service.addList(new Record[] { objCustomer, objSalesOrder });
if (writeRes[0].status.isSuccess)
{
strId = ((RecordRef)writeRes[0].baseRef).internalId;
//_out.writeLn("\nSales order created successfully\nSales Order Internal ID=" + ((RecordRef)writeRes.baseRef).internalId);
}
else
{
strError = getStatusDetails(writeRes[0].status);
}
if (writeRes[1].status.isSuccess)
{
strId = ((RecordRef)writeRes[1].baseRef).internalId;
//_out.writeLn("\nSales order created successfully\nSales Order Internal ID=" + ((RecordRef)writeRes.baseRef).internalId);
}
else
{
strError = getStatusDetails(writeRes[1].status);
}
return strId;
}
public static string UpdateSalesOrder(SalesOrder objOrder, ArrayList arrItems, out string strError)
{
strError = "";
string strId = "";
SalesOrder objSalesOrder = new SalesOrder();
objSalesOrder.internalId = objOrder.internalId;
objSalesOrder.customForm = new RecordRef();
objSalesOrder.customForm.internalId = GlobalSettings.Default.nsOrderForm;
objSalesOrder.customForm.type = RecordType.account;
objSalesOrder.customForm.typeSpecified = true;
SalesOrderItem[] salesOrderItemArray = new SalesOrderItem[arrItems.Count + objOrder.itemList.item.Length];
for (int i = 0; i < salesOrderItemArray.Length; i++)
{
if (i < objOrder.itemList.item.Length)
{
salesOrderItemArray[i] = new SalesOrderItem();
salesOrderItemArray[i].item = objOrder.itemList.item[i].item;
salesOrderItemArray[i].line = objOrder.itemList.item[i].line;
salesOrderItemArray[i].lineSpecified = true;
SelectCustomFieldRef objShippingType = new SelectCustomFieldRef();
objShippingType.internalId = "custcolcst_shippingtype";
objShippingType.value = new ListOrRecordRef();
objShippingType.value.internalId = "7";
//salesOrderItemArray[i].customFieldList = new CustomFieldRef[] { objShippingType };
}
else
{
object[] arrColumns = (object[])arrItems[i - objOrder.itemList.item.Length];
RecordRef item = new RecordRef();
item.type = RecordType.nonInventoryResaleItem;
item.typeSpecified = true;
item.internalId = arrColumns[0].ToString();
salesOrderItemArray[i] = new SalesOrderItem();
salesOrderItemArray[i].item = item;
SelectCustomFieldRef objShippingType = new SelectCustomFieldRef();
objShippingType.internalId = "custcolcst_shippingtype";
objShippingType.value = new ListOrRecordRef();
objShippingType.value.internalId = arrColumns[4].ToString();
if (objShippingType.value.internalId.Equals("-1"))
{
objShippingType.value.internalId = "7";
}
DateCustomFieldRef objShipDate = new DateCustomFieldRef();
objShipDate.internalId = "custcolcst_shippingdate";
objShipDate.value = (DateTime)arrColumns[2];
DateCustomFieldRef objDelivDate = new DateCustomFieldRef();
objDelivDate.internalId = "custcolcst_deliverydate";
objDelivDate.value = (DateTime)arrColumns[3];
StringCustomFieldRef objPo = new StringCustomFieldRef();
objPo.internalId = "custcolos_ponumber";
objPo.value = arrColumns[5].ToString();
if (objDelivDate.value != DateTime.MaxValue)
{
salesOrderItemArray[i].customFieldList = new CustomFieldRef[] { objDelivDate, objShipDate, objShippingType, objPo };
}
else
{
salesOrderItemArray[i].customFieldList = new CustomFieldRef[] { objShipDate, objShippingType, objPo };
}
System.Double quantity = System.Double.Parse(arrColumns[1].ToString());
salesOrderItemArray[i].quantity = quantity;
salesOrderItemArray[i].quantitySpecified = true;
}
}
SalesOrderItemList salesOrderItemList = new SalesOrderItemList();
salesOrderItemList.item = salesOrderItemArray;
objSalesOrder.itemList = salesOrderItemList;
WriteResponse writeRes = _service.update(objSalesOrder);
if (writeRes.status.isSuccess)
{
strId = ((RecordRef)writeRes.baseRef).internalId;
//_out.writeLn("\nSales order created successfully\nSales Order Internal ID=" + ((RecordRef)writeRes.baseRef).internalId);
}
else
{
strError = getStatusDetails(writeRes.status);
}
return strId;
}
public List<SalesOrderLine> createNewSalesOrderLines(SalesOrderItemList oldItemList)
{
List<SalesOrderLine> newItemList = new List<SalesOrderLine>();
bool flag = false;
foreach (var line in oldItemList.item)
{
SalesOrderLine newLine = new SalesOrderLine(line.item.name, line.quantity, Convert.ToDecimal(line.rate), flag);
newItemList.Add(newLine);
}
return newItemList;
}
