public string UD108A_Add(List <UD108A> objLots) { string epicorUserID, epiorUserPassword, company, plant, msg = ""; UriBuilder builder = null; Guid sessionId = Guid.Empty; company = objLots.First().Company; plant = objLots.First().Plant; svcSessionMod.SessionModSvcContractClient sessionModClient = null; getSession(out epicorUserID, out epiorUserPassword, company, plant, out builder, ref sessionModClient); try { EndpointBindingType bindingType = EndpointBindingType.BasicHttp; sessionId = sessionModClient.Login(); builder.Path = $"{Conn.environment}/Ice/BO/UD108.svc"; svcUD108.UD108SvcContractClient _svcUD108 = GetClient <svcUD108.UD108SvcContractClient, svcUD108.UD108SvcContract>( builder.Uri.ToString(), epicorUserID, epiorUserPassword, bindingType); _svcUD108.Endpoint.EndpointBehaviors.Add(new HookServiceBehavior(sessionId, epicorUserID)); svcUD108.UD108Tableset dsUD108 = new svcUD108.UD108Tableset(); for (var i = 0; i < objLots.Count; i++) { _svcUD108.GetaNewUD108A(ref dsUD108, objLots[i].RunningNo_Key1, objLots[i].DPNum_Key2, objLots[i].SONum_Key3, "", ""); dsUD108.UD108A[i].Key1 = objLots[i].RunningNo_Key1; dsUD108.UD108A[i].Key2 = objLots[i].DPNum_Key2; dsUD108.UD108A[i].Key3 = objLots[i].SONum_Key3; dsUD108.UD108A[i].ChildKey1 = DateTime.Now.ToString("yyyyMMddHHmmssffff"); dsUD108.UD108A[i].ChildKey2 = (i + 1).ToString(); dsUD108.UD108A[i].UserDefinedColumns["FS_Qty_c"] = objLots[i].Qty; dsUD108.UD108A[i].UserDefinedColumns["FS_LotNum_c"] = objLots[i].LotNum; dsUD108.UD108A[i].UserDefinedColumns["FS_PalletLblNum_c"] = objLots[i].PalletLblNum; dsUD108.UD108A[i].UserDefinedColumns["FS_PalletLblId_c"] = objLots[i].PalletLblId; dsUD108.UD108A[i].UserDefinedColumns["FS_LPStatus_c"] = objLots[i].Status; _svcUD108.Update(ref dsUD108); } } catch (Exception ex) { msg = $"Epicor Error : {ex.Message.ToString()}"; throw new Exception($"Epicor Error : {ex.Message.ToString()}"); } finally { if (sessionId != Guid.Empty) { sessionModClient.Logout(); } } return(msg); }
public void UD108Add(UD108Rec uD108Recs) { string epicorUserID, epiorUserPassword, company, plant; UriBuilder builder = null; Guid sessionId = Guid.Empty; company = uD108Recs.Company; plant = uD108Recs.Plant; svcSessionMod.SessionModSvcContractClient sessionModClient = null; getSession(out epicorUserID, out epiorUserPassword, company, plant, out builder, ref sessionModClient); //var it = uD108Recs.First(); try { EndpointBindingType bindingType = EndpointBindingType.BasicHttp; sessionId = sessionModClient.Login(); builder.Path = $"{Conn.environment}/Ice/BO/UD108.svc"; svcUD108.UD108SvcContractClient _svcUD108 = GetClient <svcUD108.UD108SvcContractClient, svcUD108.UD108SvcContract>( builder.Uri.ToString(), epicorUserID, epiorUserPassword, bindingType); _svcUD108.Endpoint.EndpointBehaviors.Add(new HookServiceBehavior(sessionId, epicorUserID)); svcUD108.UD108Tableset dsUD108 = new svcUD108.UD108Tableset(); _svcUD108.GetaNewUD108(ref dsUD108); dsUD108.UD108[0].Key1 = uD108Recs.RunningNo; dsUD108.UD108[0].Key3 = uD108Recs.Key3; dsUD108.UD108[0].Key2 = uD108Recs.DPNo; dsUD108.UD108[0].Key4 = ""; dsUD108.UD108[0].Key5 = ""; dsUD108.UD108[0].Date01 = uD108Recs.ShipByDate; //dsUD108.UD108[0].UserDefinedColumns["FS_PalletQty_c"] = 1; dsUD108.UD108[0].UserDefinedColumns["FS_PalletQty_c"] = (int)uD108Recs.Qty; dsUD108.UD108[0].UserDefinedColumns["FS_PartDesc_c"] = uD108Recs.PartDesc; dsUD108.UD108[0].UserDefinedColumns["FS_PartNo_c"] = uD108Recs.PartNo; dsUD108.UD108[0].UserDefinedColumns["FS_PalletType_c"] = uD108Recs.PalletType; dsUD108.UD108[0].UserDefinedColumns["FS_UOM_c"] = uD108Recs.UOM; //dsUD108.UD108[0].UserDefinedColumns["FS_Qty_c"] = uD108Recs.Qty; dsUD108.UD108[0].UserDefinedColumns["FS_Qty_c"] = uD108Recs.QtyCtn;// _svcUD108.Update(ref dsUD108); // _svcUD108.GetaNewUD108A(ref dsUD108, it.RunningNo, it.DPNo, "1","",""); // dsUD108.UD108A[0].ChildKey1 = "1"; //dsUD108.UD108A[0].ChildKey2 = ""; //dsUD108.UD108A[0].ChildKey3 = ""; //dsUD108.UD108A[0].UserDefinedColumns["FS_Qty_c"] = it.Qty; //dsUD108.UD108A[0].UserDefinedColumns["FS_LotNum_c"] = ""; //_svcUD108.Update(ref dsUD108); } catch (Exception ex) { throw new Exception($"Epicor Error : {ex.Message.ToString()}"); } finally { if (sessionId != Guid.Empty) { sessionModClient.Logout(); } } }