void WikiFile_AfterDownloadUpdate(object sender, FileDownloadUpdateEventArgs e)
{
var umbracoHelper = new UmbracoHelper(UmbracoContext.Current);
var content = umbracoHelper.TypedContent(e.ProjectId);
UpdateProjectExamineIndex(content, e.Downloads);
}
protected virtual void FireAfterDownloadUpdate(FileDownloadUpdateEventArgs e)
{
if (AfterDownloadUpdate != null)
AfterDownloadUpdate(this, e);
}
public void UpdateDownloadCount(int fileId, bool ignoreCookies, bool isPackage)
{
var cookie = HttpContext.Current.Request.Cookies["ProjectFileDownload" + fileId];
if (cookie != null && ignoreCookies == false)
return;
var downloads = 0;
var projectId = 0;
var reader = Application.SqlHelper.ExecuteReader("Select downloads, nodeId from wikiFiles where id = @id;", Application.SqlHelper.CreateParameter("@id", fileId));
if (reader.Read())
{
downloads = reader.GetInt("downloads");
projectId = reader.GetInt("nodeId");
}
downloads = downloads + 1;
Application.SqlHelper.ExecuteNonQuery(
"update wikiFiles set downloads = @downloads where id = @id;",
Application.SqlHelper.CreateParameter("@id", fileId),
Application.SqlHelper.CreateParameter("@downloads", downloads));
var totalDownloads = Application.SqlHelper.ExecuteScalar<int>("Select SUM(downloads) from wikiFiles where nodeId = @projectId;", Application.SqlHelper.CreateParameter("@projectId", projectId));
if (isPackage)
{
var memberHelper = new Umbraco.Web.Security.MembershipHelper(Umbraco.Web.UmbracoContext.Current);
var memberId = memberHelper.GetCurrentMemberId();
var currentMemberId = memberId == -1 ? 0 : memberId;
//update download count update
Application.SqlHelper.ExecuteNonQuery(
@"insert into projectDownload(projectId,memberId,timestamp)
values((select nodeId from wikiFiles where id = @id) ,@memberId, getdate())",
Application.SqlHelper.CreateParameter("@id", fileId),
Application.SqlHelper.CreateParameter("@memberId", currentMemberId));
}
var e = new FileDownloadUpdateEventArgs { ProjectId = projectId, Downloads = totalDownloads };
FireAfterDownloadUpdate(e);
cookie = new HttpCookie("ProjectFileDownload" + fileId) { Expires = DateTime.Now.AddHours(1) };
HttpContext.Current.Response.Cookies.Add(cookie);
}
private static void OnFileDownloadProgressUpdated(FileDownloadUpdateEventArgs e)
{
FileDownloadProgressUpdated?.Invoke(null, e);
}
void WikiFile_AfterDownloadUpdate(object sender, FileDownloadUpdateEventArgs e)
{
var umbracoHelper = new UmbracoHelper(UmbracoContext.Current);
var content = umbracoHelper.TypedContent(e.ProjectId);
UpdateProjectExamineIndex(content, e.Downloads);
}
