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);
}
}
