{"id":7896,"date":"2023-07-05T13:32:43","date_gmt":"2023-07-05T12:32:43","guid":{"rendered":"https:\/\/solidt.eu\/site\/?p=7896"},"modified":"2023-07-05T13:32:45","modified_gmt":"2023-07-05T12:32:45","slug":"uniconta-save-batchnumbers","status":"publish","type":"post","link":"https:\/\/solidt.eu\/site\/uniconta-save-batchnumbers\/","title":{"rendered":"Uniconta Save BatchNumbers"},"content":{"rendered":"\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"csharp\" data-theme=\"monokai\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"false\">public bool SaveGrid()\n{\n\t(dgBatchNrGrid.View as TableView).PostEditor();\n\tif (!dgBatchNrGrid.HasUnsavedData) return true;\n\n\tvar data = (dgBatchNrGrid.ItemsSource as IEnumerable&lt;InvSerieBatchClientUserCustom>).ToList();\n\n\tvar deletedRowItems = dgBatchNrGrid.DeletedRows.Select(x => x.DataItem).Cast&lt;InvSerieBatchClientUserCustom>().ToList();\n\tvar modifiedItems = data.Where(x => !deletedRowItems.Contains(x)).ToList();\n\n\tvar addedItems = modifiedItems.Where(x => x.RowId == 0 &amp;&amp; x.InvItem != null).ToList();\n\tvar updatedItems = modifiedItems.Where(x => x.RowId != 0).ToList();\n\tvar deletedItems = deletedRowItems.Where(x => x.RowId != 0).ToList();\n\tvar result = TaskHelper.RunSync(() => SaveData(ApiHelpers.GetNewApi(api), OrderLine, addedItems, updatedItems, deletedItems));\n\n\tif (!result.Success)\n\t{\n\t\tbusyIndicator.IsBusy = false;\n\t\tUniconta.ClientTools.Util.UtilDisplay.ShowErrorCode(result.ErrorCode);\n\t}\n\treturn result.Success;\n}\n\n\npublic static async Task&lt;ApiResult> SaveData(CrudAPI crudApi, CreditorOrderLineClientUserCustom orderLine, List&lt;InvSerieBatchClientUserCustom> addedItems, List&lt;InvSerieBatchClientUserCustom> updatedItems, List&lt;InvSerieBatchClientUserCustom> deletedItems)\n{\n\tvar allBatchNummerLinks = await ApiHelpers.QueryWrapper(crudApi, api => api.Query&lt;DCOrderLineSerieBatch>(orderLine));\n\n\t\/\/ Remove all changed batchnumber links, new links are created below\n\tvar allChangedRowIds = LinqHelper.SelectMany(updatedItems.Select(y => y.RowId), deletedItems.Select(y => y.RowId)).ToHashSet();\n\tvar allLinksToRemove = allBatchNummerLinks.Where(x => allChangedRowIds.Contains(x.InvSerieBatchRowId));\n\tApiResult result;\n\t\n\tresult = await ApiHelpers.MultiCrudNoRowId(crudApi, null, null, allLinksToRemove);\n\tif (!result.Success) return result;\n\n\tforeach (var item in addedItems)\n\t\titem.QtyMarked = item.Qty;\n\n\tresult = await ApiHelpers.MultiCrudNoRowId(crudApi, addedItems, updatedItems, deletedItems);\n\tif (!result.Success) return result;\n\n\tvar newLinks = LinqHelper.SelectMany(addedItems, updatedItems).Select(x => CreateBatchNumberLink&lt;CreditorOrderLineClient>(x, orderLine, GetQuantity(x)));\n\n\tresult = await ApiHelpers.MultiCrudNoRowId(crudApi, newLinks, null, null);\n\tif (!result.Success) return result;\n\n\t\/\/ We need to save updatedItems again to update the correct amount on the batchnummers.\n\tresult = await ApiHelpers.MultiCrudNoRowId(crudApi, null, updatedItems, null);\n\tif (!result.Success) return result;\n\n\torderLine.CachedBatchNumbers = null;\n\treturn ApiResult.Ok();\n}<\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7896","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/7896","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/comments?post=7896"}],"version-history":[{"count":1,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/7896\/revisions"}],"predecessor-version":[{"id":7897,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/7896\/revisions\/7897"}],"wp:attachment":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/media?parent=7896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/categories?post=7896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/tags?post=7896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}