public void BanUserFromSub(Guid subId, Guid userId, DateTime dateBanned, Guid bannedBy, string reason, DateTime?expires = null)
{
_conn.Perform(conn =>
{
var existing = conn.Single <SubUserBan>(x => x.SubId == userId && x.SubId == subId && x.IsActive == true);
if (existing != null)
{
existing.BannedBy = bannedBy;
existing.Reason = reason;
existing.CreatedAt = dateBanned;
existing.Expires = expires;
existing.IsActive = expires.Value == TimeHelper.CurrentTime() ? false : true;
conn.Update(existing);
}
else
{
existing = new SubUserBan();
existing.Id = Guid.NewGuid();
existing.BannedBy = bannedBy;
existing.Reason = reason;
existing.CreatedAt = dateBanned;
existing.Expires = expires;
existing.SubId = subId;
existing.UserId = userId;
existing.IsActive = true;
conn.Insert(existing);
}
});
}
public void BanUserFromSub(Guid subId, Guid userId, string userName, DateTime dateBanned, Guid bannedBy, string reasonPrivate, string reasonPublic)
{
_conn.Perform(conn =>
{
var existing = conn.Single <SubUserBan>(x => x.UserId == userId && x.SubId == subId);
if (existing != null)
{
existing.BannedBy = bannedBy;
existing.ReasonPrivate = reasonPrivate;
existing.ReasonPublic = reasonPublic;
existing.DateBanned = dateBanned;
conn.Update(existing);
}
else
{
existing = new SubUserBan();
existing.Id = GuidUtil.NewSequentialId();
existing.BannedBy = bannedBy;
existing.ReasonPrivate = reasonPrivate;
existing.ReasonPublic = reasonPublic;
existing.DateBanned = dateBanned;
existing.SubId = subId;
existing.UserId = userId;
existing.UserName = userName;
conn.Insert(existing);
}
});
}
public void BanUserFromSub(Guid subId, Guid userId, string userName, DateTime? bannedUntil, DateTime dateBanned, Guid bannedBy, string reasonPrivate, string reasonPublic)
{
_conn.Perform(conn =>
{
var existing = conn.Single<SubUserBan>(x => x.UserId == userId && x.SubId == subId);
if (existing != null)
{
existing.BannedUntil = bannedUntil;
existing.BannedBy = bannedBy;
existing.ReasonPrivate = reasonPrivate;
existing.ReasonPublic = reasonPublic;
existing.DateBanned = dateBanned;
conn.Update(existing);
}
else
{
existing = new SubUserBan();
existing.Id = GuidUtil.NewSequentialId();
existing.BannedUntil = bannedUntil;
existing.BannedBy = bannedBy;
existing.ReasonPrivate = reasonPrivate;
existing.ReasonPublic = reasonPublic;
existing.DateBanned = dateBanned;
existing.SubId = subId;
existing.UserId = userId;
existing.UserName = userName;
conn.Insert(existing);
}
});
}
public SubUserBanWrapped Wrap(SubUserBan item)
{
return(Wrap(new List <SubUserBan> {
item
})[0]);
}
public SubUserBanWrapped(SubUserBan userBan)
{
Item = userBan;
}
public SubUserBanWrapped(SubUserBan userBan)
{
Item = userBan;
}
