private TblAssetsTransaction UpdateOrInsertTblAssetsTransaction(TblAssetsTransaction newRow, bool save, int index, out int outindex) { outindex = index; using (var context = new WorkFlowManagerDBEntities()) { if (save) { var temp = (context.TblAssetsTransactions.Count( e => e.TblAssets == newRow.TblAssets && e.ReturnDate == null)); if (temp > 0) { return(null); } context.TblAssetsTransactions.AddObject(newRow); } else { var oldRow = (from e in context.TblAssetsTransactions where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); return(newRow); } }
private int DeleteTblAssetsTransaction(TblAssetsTransaction row) { using (var context = new WorkFlowManagerDBEntities()) { var oldRow = (from e in context.TblAssetsTransactions where e.Iserial == row.Iserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); } context.SaveChanges(); } return(row.Iserial); }