public static void LoadLogs() {
var vidlog = new VideoLog();
dynamic productions = new Productions();
dynamic episodes = new Episodes();
dynamic orderItems = new OrderItems();
dynamic channels = new Channels();
var orders = new Orders();
var rand = new Random();
Console.WriteLine("Deleting logs...");
vidlog.Delete();
foreach (var order in orders.All()) {
//pull the orderItems
var items = orderItems.Find(OrderID: order.ID);
//loop the items
foreach (var item in items) {
var slug = item.SKU;
if (slug == "yearly") {
Console.WriteLine("Loading Productions and Episodes for Annual...");
//create a download log for each production and episode
foreach (var p in productions.All()) {
var eps = episodes.Find(ProductionID: p.ID);
foreach (var e in eps) {
var log = new {
Slug = item.SKU,
EpisodeNumber = e.Number,
Email = order.Email,
//the download file for the episode
FileName = p.Slug + "_"+e.Number+".zip",
FileSize = e.HDFileSize,
//1 day lag
LogDate = order.CreatedAt.AddDays(1),
OrderItemID = item.ID
};
vidlog.Insert(log);
}
}
} else if (slug == "monthly") {
//create a stream log for each production and episode
Console.WriteLine("Loading Productions and Episodes for Monthly...");
foreach (var p in productions.All()) {
var eps = episodes.Find(ProductionID: p.ID);
foreach (var e in eps) {
var log = new {
Slug = item.SKU,
EpisodeNumber = e.Number,
Email = order.Email,
//the download file for the episode
FileName = p.Slug + "_" + e.Number + ".flv",
FileSize = e.StreamFileSize,
//1 day lag
LogDate = order.CreatedAt.AddDays(1),
OrderItemID = item.ID
};
vidlog.Insert(log);
}
}
} else {
var p = productions.First(Slug:item.SKU);
var eps = episodes.Find(ProductionID: p.ID);
Console.WriteLine("Loading log for {0}...",p.Slug);
foreach (var e in eps) {
var log = new {
Slug = item.SKU,
EpisodeNumber = e.Number,
Email = order.Email,
//the download file for the episode
FileName = p.Slug + "_" + e.Number + ".zip",
FileSize = e.HDFileSize,
//1 day lag
LogDate = order.CreatedAt.AddDays(1),
OrderItemID = item.ID
};
vidlog.Insert(log);
}
}
}
}
}
public void Init() {
_videoLog = new VideoLog();
}