public bool IsUserGroupInReaderGroup(UserGroup userGroup, ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{F8EB1766-410A-4C38-9435-1C316956CAF3}"), userGroup.ItemId, readerGroup.ItemId);
var content = ExecScalar<int>(query);
var result = content == 1;
return result;
}
public bool IsReaderInReaderGroup(Reader reader, ReaderGroup group)
{
var query = GenerateQuery(new Guid("{097E4D46-49DA-4BEC-B9ED-DE4684F3AC67}"), reader.ItemId, group.ItemId);
var content = ExecScalar<int>(query);
var result = content == 1;
return result;
}
public bool CreateReaderGroup(ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{DE83B778-9AB7-4282-BC69-7D507B818B86}"),
readerGroup.ItemId,
readerGroup.FriendlyName);
var result = ExecChangeLineQuery(query);
return result;
}
public bool Create(ReaderGroup group)
{
if (group.ItemId.Equals(Guid.Empty))
{
group.ItemId = Guid.NewGuid();
}
return dataAccess.CreateReaderGroup(group);
}
public bool UpdateReaderGroup(ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{4CF89B86-0398-44D2-A057-B559D8B83D87}"),
readerGroup.ItemId,
readerGroup.FriendlyName
);
var result = ExecChangeLineQuery(query);
return result;
}
public void EditGroup(int id, ReaderGroup newGroup)
{
var group = GetGroup(id);
newGroup.CopyProperties <ReaderGroup>(group,
g => g.Name,
g => g.Description,
g => g.Public,
g => g.Closed);
SaveChanges();
}
public bool LinkGroupToReader(ReaderGroup group, Guid readerId)
{
var reader = dataAccess.GetReaderById(readerId);
if (reader == null)
{
return false;
}
var alreadyLinked = dataAccess.IsReaderInReaderGroup(reader, group);
if (alreadyLinked)
{
return false;
}
return dataAccess.LinkReaderToReaderGroup(reader, group);
}
public void AddGroupForUser(ReaderGroup group, string userName)
{
var user = GetCurrentUser(userName);
var newGroup = new ReaderGroup();
group.CopyProperties <ReaderGroup>(newGroup,
g => g.Public,
g => g.Name,
g => g.Themes,
g => g.Description,
g => g.Closed);
newGroup.Admins = new List <User>(new User[] { user });
newGroup.Members = new List <User>(new User[] { user });
newGroup.Owner = user;
Ctx.ReaderGroups.Add(newGroup);
SaveChanges();
}
public ActionResult Create(ReaderGroupDetailModel model)
{
if (ModelState.IsValid)
{
var domain = new ReaderGroup() { FriendlyName = model.DisplayName };
var result = readerGroupRepo.Create(domain);
if (result)
{
TempData[TempDataInfMsg] = string.Format("Die Lesergruppe {0} wurde erfolgreich angelegt", domain.FriendlyName);
}
else
{
TempData[TempDataInfMsg] = string.Format("Die Lesergruppe {0} konnte nicht angelegt werden. Bitte wenden Sie sich an den Aministrator", domain.FriendlyName);
}
return RedirectToAction("Index");
}
else
{
return View(model);
}
}
public bool DeleteReaderGroup(ReaderGroup readerGroup)
{
var cmd = GenerateCommand();
// Remove all links to readers
UnlinkAllItemsAtOnce(new Guid("{00451937-4359-40BC-9E88-B91C89928C3F}"), readerGroup.ItemId, cmd);
// Remove all links to user groups
UnlinkAllItemsAtOnce(new Guid("{2B149B36-E169-43E9-83AE-D77798BF6DD2}"), readerGroup.ItemId, cmd);
var query = GenerateQuery(new Guid("{D0153E79-42D7-4E55-B091-6F2474A6D421}"), readerGroup.ItemId);
var result = ExecChangeLineQuery(query,cmd);
if (result)
{
cmd.Transaction.Commit();
}
else
{
cmd.Transaction.Rollback();
}
return result;
}
public bool LinkReaderToReaderGroup(Reader reader, ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{DDA62089-BA76-4EDA-A415-90241BF061BA}"), reader.ItemId, readerGroup.ItemId);
var result = ExecChangeLineQuery(query);
return result;
}
public IList<UserGroup> GetPossbileUserGroupsOfReaderGroup(ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{2D8D4867-03B3-4ADD-A0F7-6C362EF52E85}"), readerGroup.ItemId);
var result = GetManyItems<UserGroup>(query, ReadGroup<UserGroup>);
return result;
}
public IList<Reader> GetReadersOfReaderGroup(ReaderGroup group)
{
var query = GenerateQuery(new Guid("{24FDB557-BEEB-47FC-8092-8783C6517177}"), group.ItemId);
var result = GetManyItems<Reader>(query, ReadReader);
return result;
}
public IList<Reader> GetPossibleReadersOfReaderGroup(ReaderGroup group)
{
var query = GenerateQuery(new Guid("{9B148609-962E-497A-9FF8-3B2A1E1CDD74}"), group.ItemId);
var result = GetManyItems<Reader>(query, ReadReader);
return result;
}
public bool UnlinkReaderFromReaderGroup(Reader reader, ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{95DF6D6B-7A26-451E-A56A-113520112A25}"), reader.ItemId, readerGroup.ItemId);
var result = ExecChangeLineQuery(query);
return result;
}
public IList<UserGroup> GetUserGroupsOfReaderGroup(ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{C92946F2-3465-4B71-B4B5-D8DFDEEFC0D6}"), readerGroup.ItemId);
var result = GetManyItems<UserGroup>(query, ReadGroup<UserGroup>);
return result;
}
public int GetCountUserGroupsOfReaderGroup(ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{2D132DE0-6ED3-4850-AB27-EDA3D28F8653}"), readerGroup.ItemId);
var result = ExecScalar<int>(query);
return result;
}
public int GetCountReadersOfReaderGroup(ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{DF84192A-03E9-4F85-B8A8-A71A21C368E2}"), readerGroup.ItemId);
var result = ExecScalar<int>(query);
return result;
}
public bool LinkUserGroupToReaderGroup(UserGroup userGroup, ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{A9254375-DA13-4F7C-98AA-6C7B10E1C2F0}"), userGroup.ItemId, readerGroup.ItemId);
var result = ExecChangeLineQuery(query);
return result;
}
public bool LinkGroupToUserGroup(ReaderGroup group, Guid userGroupId)
{
var userGroup = dataAccess.GetUserGroupById(userGroupId);
if (userGroup == null)
{
return false;
}
var alreadyLinked = dataAccess.IsUserGroupInReaderGroup(userGroup, group);
if (alreadyLinked)
{
return false;
}
return dataAccess.LinkUserGroupToReaderGroup(userGroup, group);
}
public bool UnlinkUserGroupFromReaderGroup(UserGroup userGroup, ReaderGroup readerGroup)
{
var query = GenerateQuery(new Guid("{0B7A366C-800F-4651-B112-F073F6A85A50}"), userGroup.ItemId, readerGroup.ItemId);
var result = ExecChangeLineQuery(query);
return result;
}
public bool Edit(Guid id, ReaderGroup group)
{
var old = dataAccess.GetReaderGroupById(id);
old.FriendlyName = group.FriendlyName;
return dataAccess.UpdateReaderGroup(old);
}
public bool UnlinkGroupFromReader(ReaderGroup group, Guid readerId)
{
var reader = dataAccess.GetReaderById(readerId);
if (reader == null)
{
return false;
}
return dataAccess.UnlinkReaderFromReaderGroup(reader, group);
}
public bool UnlinkGroupFromUserGroup(ReaderGroup group, Guid userGroupId)
{
var userGroup = dataAccess.GetUserGroupById(userGroupId);
if (userGroup == null)
{
return false;
}
return dataAccess.UnlinkUserGroupFromReaderGroup(userGroup, group);
}
