private int DeleteTblPurchaseReceiveDetail(TblPurchaseReceiveDetail row) { using (var context = new WorkFlowManagerDBEntities()) { var oldRow = (from e in context.TblPurchaseReceiveDetails where e.Iserial == row.Iserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); } context.SaveChanges(); } return(row.Iserial); }
private TblPurchaseReceiveDetail UpdateOrInsertTblPurchaseReceiveDetail(TblPurchaseReceiveDetail newRow, int index, out int outindex) { outindex = index; using (var context = new WorkFlowManagerDBEntities()) { var oldRow = (from e in context.TblPurchaseReceiveDetails where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { var purchaseorderdetailIserial = newRow.TblPurchaseOrderDetailRequest; newRow.TblPurchaseOrderDetailRequest1 = null; newRow.TblPurchaseOrderDetailRequest = purchaseorderdetailIserial; SharedOperation.GenericUpdate(oldRow, newRow, context); } else { context.TblPurchaseReceiveDetails.AddObject(newRow); } context.SaveChanges(); return(newRow); } }
public decimal PurchaseFabricLinesToAx(TblPurchaseOrderHeaderRequest headerObjToPost, TblPurchaseReceiveDetail item, string purchaseOrder, int userIserial, Axapta axapta) { try { var importNew = axapta.CreateAxaptaObject("CreateProductionJournals"); var lineNum = importNew.Call("CreatePurchaseLinesSize", purchaseOrder, item.TblPurchaseOrderDetailRequest1.ItemId, item.Qty, item.BatchNo ?? "", item.TblPurchaseOrderDetailRequest1.TblColor.Code, headerObjToPost.TblWarehouse1.Code, item.TblPurchaseOrderDetailRequest1.Price, headerObjToPost.TblWarehouse1.Code, headerObjToPost.TblWarehouse1.TblSite1.Code, item.TblPurchaseOrderDetailRequest1.Size ?? ""); return(Convert.ToDecimal(lineNum)); } catch (Exception ex) { throw new Exception(ex.Message); } }