private void RemoveStreamChatFromDb(long streamId)
{
using (var context = new ChatDataContext()) {
var existingChat = context.Chats.Where(item => item.streamId == streamId);
context.RemoveRange(existingChat);
context.SaveChanges();
}
}
// removes any in-progress live stream downloads since the last run from the database
public Task RemoveLeftOverLiveStreamDownloads()
{
List <Stream> streams;
Console.WriteLine("Checking for dead streams...");
using (var mainDataContext = new MainDataContext()) {
streams = mainDataContext.Streams.Where(stream => stream.vodId != 0 && stream.downloading).ToList();
mainDataContext.RemoveRange(streams);
if (streams.Count > 0)
{
using (var chatDataContext = new ChatDataContext()) {
chatDataContext.RemoveRange(chatDataContext.Chats.Where(chat => streams.Select(stream => stream.streamId).Contains(chat.streamId)));
chatDataContext.SaveChanges();
}
}
mainDataContext.SaveChanges();
}
Console.WriteLine("Done!");
return(Task.CompletedTask);
}
