public void RecordDownloadHistory(string iPAddress)
{
DBDownloadTicket.AddDownloadHistory(
Guid.NewGuid(),
this.guid,
DateTime.UtcNow,
iPAddress);
IncrementDownloadCount();
}
private bool Update()
{
return(DBDownloadTicket.Update(
this.guid,
this.productGuid,
this.fullfillTermsGuid,
this.downloadsAllowed,
this.expireAfterDays,
this.countAfterDownload,
this.purchaseTime,
this.downloadedCount));
}
public static DataTable GetPage(
Guid storeGuid,
int pageNumber,
int pageSize)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("Guid", typeof(Guid));
dataTable.Columns.Add("StoreGuid", typeof(Guid));
dataTable.Columns.Add("OrderGuid", typeof(Guid));
dataTable.Columns.Add("UserGuid", typeof(Guid));
dataTable.Columns.Add("ProductGuid", typeof(Guid));
dataTable.Columns.Add("FullfillTermsGuid", typeof(Guid));
dataTable.Columns.Add("DownloadsAllowed", typeof(int));
dataTable.Columns.Add("ExpireAfterDays", typeof(int));
dataTable.Columns.Add("CountAfterDownload", typeof(bool));
dataTable.Columns.Add("PurchaseTime", typeof(DateTime));
dataTable.Columns.Add("DownloadedCount", typeof(int));
dataTable.Columns.Add("TotalPages", typeof(int));
using (IDataReader reader = DBDownloadTicket.GetPageByStore(
storeGuid,
pageNumber,
pageSize))
{
while (reader.Read())
{
DataRow row = dataTable.NewRow();
row["Guid"] = reader["Guid"];
row["StoreGuid"] = reader["StoreGuid"];
row["OrderGuid"] = reader["OrderGuid"];
row["UserGuid"] = reader["UserGuid"];
row["ProductGuid"] = reader["ProductGuid"];
row["FullfillTermsGuid"] = reader["FullfillTermsGuid"];
row["DownloadsAllowed"] = reader["DownloadsAllowed"];
row["ExpireAfterDays"] = reader["ExpireAfterDays"];
row["CountAfterDownload"] = reader["CountAfterDownload"];
row["PurchaseTime"] = reader["PurchaseTime"];
row["DownloadedCount"] = reader["DownloadedCount"];
row["TotalPages"] = Convert.ToInt32(reader["TotalPages"]);
dataTable.Rows.Add(row);
}
}
return(dataTable);
}
private void GetFullfillDownloadTicket(Guid guid)
{
using (IDataReader reader = DBDownloadTicket.Get(guid))
{
if (reader.Read())
{
this.guid = new Guid(reader["Guid"].ToString());
this.storeGuid = new Guid(reader["StoreGuid"].ToString());
this.orderGuid = new Guid(reader["OrderGuid"].ToString());
this.userGuid = new Guid(reader["UserGuid"].ToString());
this.productGuid = new Guid(reader["ProductGuid"].ToString());
this.fullfillTermsGuid = new Guid(reader["FullfillTermsGuid"].ToString());
this.downloadsAllowed = Convert.ToInt32(reader["DownloadsAllowed"]);
this.expireAfterDays = Convert.ToInt32(reader["ExpireAfterDays"]);
this.countAfterDownload = Convert.ToBoolean(reader["CountAfterDownload"]);
this.purchaseTime = Convert.ToDateTime(reader["PurchaseTime"]);
this.downloadedCount = Convert.ToInt32(reader["DownloadedCount"]);
}
}
}
private bool Create()
{
Guid newID = Guid.NewGuid();
this.guid = newID;
int rowsAffected = DBDownloadTicket.Add(
this.guid,
this.storeGuid,
this.orderGuid,
this.userGuid,
this.productGuid,
this.fullfillTermsGuid,
this.downloadsAllowed,
this.expireAfterDays,
this.countAfterDownload,
this.purchaseTime,
this.downloadedCount);
return(rowsAffected > 0);
}
public static bool MoveOrder(
Guid orderGuid,
Guid newUserGuid)
{
return(DBDownloadTicket.MoveOrder(orderGuid, newUserGuid));
}
public static IDataReader GetDownloadHistory(Guid ticketGuid)
{
return(DBDownloadTicket.GetDownloadHistory(ticketGuid));
}
public static IDataReader GetByOrder(Guid orderGuid)
{
return(DBDownloadTicket.GetByOrder(orderGuid));
}
public static bool DeleteByOrder(Guid orderGuid)
{
return(DBDownloadTicket.DeleteByOrder(orderGuid));
}
public static bool Delete(Guid guid)
{
return(DBDownloadTicket.Delete(guid));
}
private void IncrementDownloadCount()
{
this.downloadedCount += 1;
DBDownloadTicket.IncrementDownloadCount(this.guid);
}
