static void LoadSalesOrder(SalesOrderSvcContractClient salesOrderClient, SalesOrder so, out string result)
{
var ts = new SalesOrderTableset();
result = "p_";
salesOrderClient.GetNewOrderHed(ref ts);
var newRow = ts.OrderHed.Where(n => n.RowMod.Equals("A", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
// Guid rowID = newRow.SysRowID;
// FastLoad.SalesOrder so = new FastLoad.SalesOrder();
E10Lookup look = new E10Lookup();
int custNum = look.GetCustomerNum(so.CustomerID);
if (newRow != null)
{
newRow.Company = so.Company;
Epicor.SalesOrderSvc.UserDefinedColumns columns = newRow.UserDefinedColumns;
/*
foreach (KeyValuePair<string, object> kvp in columns)
{
Console.WriteLine("Key = {0}, Value = {1}", kvp.Key, kvp.Value);
}
*/
columns["OrderType_c"] = "EDI";
columns["EDIHeadChar11_c"] = "";
// columns["EDIHeadChar11_c"] = "hello";
// newRow.BTCustID = so.CustomerID;
newRow.CustNum = custNum;
newRow.BTCustNum = custNum;
if (so.ShipVia.Equals("UGND"))
{
newRow.ShipViaCode = "UPGD";
}
else
{
newRow.ShipViaCode = so.ShipVia;
}
newRow.PONum = so.PoNo;
newRow.TermsCode = so.TermsCode;
newRow.ShipToNum = so.ShipToNum;
newRow.ShipToCustNum = custNum;
newRow.NeedByDate = so.NeedByDate;
newRow.OrderDate = so.OrderDate;
newRow.RequestDate = so.RequestDate;
newRow.ReadyToCalc = true;
#if STEINMART
newRow.PickListComment = so.ediMarkingNotes;
newRow.RefNotes = so.ediMarkingNotes;
newRow.ShipComment = so.ediMarkingNotes;
#endif
newRow.RowMod = "A";
try
{
salesOrderClient.Update(ref ts);
}
catch (Exception e)
{
string message = e.Message;
result = message.Substring(0, 3);
bool AllOk = false;
}
}
int orderNum = ts.OrderHed[0].OrderNum;
ts = salesOrderClient.GetByID(orderNum);
if (ts != null)
{
result = orderNum.ToString();
foreach (OrderLine line in so.lines)
{
bool Inactive = look.IsPartInActive(line.Upc);
if (Inactive)
{
continue;
}
salesOrderClient.GetNewOrderDtl(ref ts, orderNum);
string PartDescription = look.GetPartDescr(line.Upc);
// ts = salesOrderClient.GetByID(orderNum);
string dtlrow = ts.OrderDtl[0].RowMod;
var newDtlRow = ts.OrderDtl.Where(n => n.RowMod.Equals("A", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
newDtlRow.PartNum = line.Upc;
newDtlRow.PartNumPartDescription = PartDescription;
newDtlRow.LineDesc = PartDescription;
newDtlRow.XPartNum = line.CustomerPart;
newDtlRow.OrderLine = line.LineNum;
newDtlRow.OrderQty = line.OrderQty;
newDtlRow.PricingQty = line.OrderQty;
newDtlRow.SellingQuantity = line.OrderQty;
newDtlRow.SalesUM = so.Get_UOM_FromSellingFactor(line.SellingFactor);
// newDtlRow.DocInUnitPrice = line.UnitPrice;
newDtlRow.DocUnitPrice = line.UnitPrice;
// newDtlRow.Reference = "123456";
newDtlRow.UnitPrice = line.UnitPrice;
newDtlRow.SellingFactor = line.SellingFactor;
// newDtlRow.RevisionNum = "PCK";
newDtlRow.RowMod = "A";
// newRow.RowMod = "U";
try
{
salesOrderClient.Update(ref ts);
ts = salesOrderClient.GetByID(orderNum);
}
catch (Exception ex2)
{
string mess2 = ex2.Message;
// result = ex2.Message;
}
}
try
{
ts = salesOrderClient.GetByID(orderNum);
TaxConnectStatusRow taxrow = ts.TaxConnectStatus.First();
taxrow.ETCOffline = true;
salesOrderClient.Update(ref ts);
}
catch (Exception ex2)
{
string messtaxOffline = ex2.Message;
// result = ex2.Message;
}
}
}