private int DeleteTblPurchaseOrderDetailRequest(TblPurchaseOrderDetailRequest row)
{
using (var context = new WorkFlowManagerDBEntities())
{
var oldRow = (from e in context.TblPurchaseOrderDetailRequests
where e.Iserial == row.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
context.DeleteObject(oldRow);
}
context.SaveChanges();
}
return(row.Iserial);
}
private TblPurchaseOrderDetailRequest UpdateOrInsertTblPurchaseOrderDetailRequest(TblPurchaseOrderDetailRequest newRow, int index, out int outindex)
{
outindex = index;
using (var context = new WorkFlowManagerDBEntities())
{
var oldRow = (from e in context.TblPurchaseOrderDetailRequests
where e.Iserial == newRow.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
SharedOperation.GenericUpdate(oldRow, newRow, context);
}
else
{
newRow.RemaningQty = newRow.Qty;
context.TblPurchaseOrderDetailRequests.AddObject(newRow);
}
context.SaveChanges();
return(newRow);
}
}
