public Domain.BlogEntryDo GetBlogEntry(int id)
{
BlogEntryDo blogEntry = new BlogEntryDo();
var db = new ForumBlogsDataContext(DbConnectionString.Value);
try
{
var entry = (from b in db.BlogEntries
where b.Id == id
select b).Single();
blogEntry.Id = entry.Id;
blogEntry.EntryNumber = entry.EntryNumber;
blogEntry.AnchoredLink = entry.BlogDirectLink;
blogEntry.BlogContent = entry.BlogContent;
blogEntry.BlogPostDate = entry.BlogDate;
//blogEntry.GameFullName = entry.BlizzArea.Game.GameName;
blogEntry.GameAbbrev = entry.BlizzArea.Game.GameAbbreviation;
blogEntry.RegionAbbrev = entry.BlizzArea.Region.RegionAbbreviation;
blogEntry.RegionFullName = entry.BlizzArea.Region.RegionName;
blogEntry.Title = entry.BlogTitle;
blogEntry.LanguageAbbrev = entry.BlizzArea.Language.LanguageAbbreviation;
}
catch (InvalidOperationException)
{
return null;
}
return blogEntry;
}
public List<BlogEntryDo> ApiGetBlogEntries(string game, string region, string lang, string token)
{
//Example URL: http://www.blizzposts.com/api/bptopics/?game=wow®ion=us&lang=en&token=7af9341c77b3497fb04fd2422ab2b34d
foreach (var ch in game)
{
if (char.IsPunctuation(ch))
{
throw new BpApiException(ApiStatusCode.BadRequest);
}
}
foreach (var ch in region)
{
if (char.IsPunctuation(ch))
{
throw new BpApiException(ApiStatusCode.BadRequest);
}
}
foreach (var ch in lang)
{
if (char.IsPunctuation(ch))
{
throw new BpApiException(ApiStatusCode.BadRequest);
}
}
game = game.ToLower().Trim();
region = region.ToLower().Trim();
lang = lang.ToLower().Trim();
MiscDataContext db = new MiscDataContext(DbConnectionString.Value);
bool hasValidToken = false;
Guid tokenGuid = new Guid();
try
{
tokenGuid = new Guid(token);
hasValidToken = ((from t in db.FansiteApiTokens
where t.TokenId == tokenGuid
&& !t.Disabled
select t).Count() > 0);
}
catch (FormatException)
{
throw new BpApiException(ApiStatusCode.BadRequest);
}
if (hasValidToken)
{
FansiteApiToken fsToken = (from t in db.FansiteApiTokens
where t.TokenId == tokenGuid
&& !t.Disabled
select t).Single();
if (fsToken.LastResetDate != null)
{
TimeSpan diff = DateTime.UtcNow - fsToken.LastResetDate.Value;
if (diff.TotalHours >= 24)
{
fsToken.RequestCount = 0;
fsToken.LastResetDate = DateTime.UtcNow;
}
}
else
{
fsToken.RequestCount = 0;
fsToken.LastResetDate = DateTime.UtcNow;
}
if (fsToken.RequestCount < fsToken.RequestLimit)
{
fsToken.RequestCount++;
db.SubmitChanges();
IQueryable<ApiGetBlogEntry> queriableBlogEntries = null;
if (!String.IsNullOrEmpty(region) && !String.IsNullOrWhiteSpace(region) && region != "any")
{
queriableBlogEntries = (from b in db.ApiGetBlogEntries
where b.RegionAbbreviation == region.ToUpper()
&& b.LanguageAbbreviation == lang.ToUpper()
orderby b.BlogDate descending
select b);
}
else
{
queriableBlogEntries = from b in db.ApiGetBlogEntries
where b.LanguageAbbreviation == lang.ToUpper()
orderby b.BlogDate descending
select b;
}
if (!String.IsNullOrEmpty(game) && !String.IsNullOrWhiteSpace(game) && game != "any")
{
queriableBlogEntries = from b in queriableBlogEntries
where b.GameAbbreviation == game.ToUpper()
&& b.LanguageAbbreviation == lang.ToUpper()
orderby b.BlogDate descending
select b;
}
queriableBlogEntries = queriableBlogEntries.Take(10);
List<ApiGetBlogEntry> blogEntries = queriableBlogEntries.ToList();
List<BlogEntryDo> bpBlogEntries = new List<BlogEntryDo>();
foreach (var entry in blogEntries)
{
BlogEntryDo bpBlogEntry = new BlogEntryDo
{
GameAbbrev = entry.GameAbbreviation.ToLower(),
RegionAbbrev = entry.RegionAbbreviation.ToLower(),
LanguageAbbrev = entry.LanguageAbbreviation.ToLower(),
Id = entry.Id,
Title = entry.BlogTitle,
AnchoredLink = entry.BlogDirectLink,
BlogContent = entry.BlogContent.Replace("\n", " ").Replace("\r", " "),
EntryNumber = entry.EntryNumber,
BlogPostDate = entry.BlogDate
};
//Clean direct link:
bpBlogEntry.AnchoredLink = bpBlogEntry.AnchoredLink.Remove(0, bpBlogEntry.AnchoredLink.IndexOf("http"));
bpBlogEntry.AnchoredLink = bpBlogEntry.AnchoredLink.Remove(bpBlogEntry.AnchoredLink.IndexOf("\">"));
bpBlogEntries.Add(bpBlogEntry);
}
return bpBlogEntries;
}
else
{
throw new BpApiException(ApiStatusCode.Forbidden);
}
}
else
{
throw new BpApiException(ApiStatusCode.Forbidden);
}
}
