public int SetStatus(Guid key, UserContentStatus status)
{
using (var db = getDb())
{
using (Transaction transaction = db.GetTransaction())
{
var statement = $"UPDATE [{_tableName}] SET STATUS = @status " +
$"WHERE [Key] = @key";
var rows = db.Execute(statement, new { status = (int)status, key = key });
transaction.Complete();
return(rows);
}
}
}
public IEnumerable <IUserContent> GetChildren(
Guid key, UserContentStatus status = UserContentStatus.Approved,
bool getAll = false, string contentType = "")
{
using (var db = getDb())
{
var sql = getBaseSql()
.Where("[ParentKey] = @0", key);
if (!contentType.IsNullOrWhiteSpace())
{
sql.Where("[UserContentType = @0", contentType);
}
if (!getAll)
{
sql.Where("Status = @0", (int)status);
}
return(db.Fetch <TUserContentDTO>(sql)
.Select(x => (IUserContent)Mapper.Map <TUserContent>(x)));
}
}
public IEnumerable <IUserContent> GetUserContent(
Guid contentKey, UserContentStatus status,
bool getAll, string userContentType = "")
{
return(_userRepo.GetByContentKey(contentKey, status, getAll, userContentType));
}