private DtDelta FindNextRelatedGroupDelta(DtDelta rootDtDelta, IEnumerable <DtDelta> allInserts, IEnumerable <DtDelta> allDeletes)
        {
            DtDelta result = null;

            if (rootDtDelta.Action == DtDelta.DeleteAction)
            {
                //get username for this deletion id
                var groupnameToDelete = string.Empty;
                var earlierInsert     = allInserts.
                                        FirstOrDefault(i => i.Seq < rootDtDelta.Seq &&
                                                       i.DataAsGroup.Id == rootDtDelta.DataForDelete);

                if (earlierInsert != null)
                {
                    groupnameToDelete = earlierInsert.DataAsGroup.Name;
                }

                //if there's no value in the array, there may be one in the db
                if (string.IsNullOrWhiteSpace(groupnameToDelete))
                {
                    groupnameToDelete = sqlService.GetGroupnameForId(rootDtDelta.DataForDelete);
                }

                //if you can't find a record for this Id, you can't proceed. Something is wrong with data.
                if (string.IsNullOrWhiteSpace(groupnameToDelete))
                {
                    throw new Exception(string.Format("No role insert record found for this id: {0}", rootDtDelta.DataForDelete));
                }

                //search for next insert for same username as delete
                var insertsForGroupname = allInserts.
                                          Where(i => i.Seq > rootDtDelta.Seq &&
                                                i.DataAsGroup.Name == groupnameToDelete)
                                          .OrderBy(a => a.Seq);
                if (insertsForGroupname.Any())
                {
                    result = insertsForGroupname.First();
                }
            }
            else if (rootDtDelta.Action == DtDelta.InsertAction)
            {
                //search for delete action for same id
                var deletesForId = allDeletes.
                                   Where(i => i.Seq > rootDtDelta.Seq &&
                                         i.DataForDelete == rootDtDelta.DataAsGroup.Id);
                if (deletesForId.Any())
                {
                    result = deletesForId.First();
                }
            }

            return(result);
        }