public static void SaveChannelLogger(ChannelLogger channelLogger)
{
var moonDb = new MoonAidAzureContext();
moonDb.Entry(channelLogger).State = EntityState.Modified;
moonDb.SaveChanges();
}
public static bool CheckUserExists(string userName)
{
var moonDb = new MoonAidAzureContext();
bool userExist = moonDb.UserProfiles.Any(up => up.UserName == userName);
return userExist;
}
public static void AddGameToStatistics(Statistic statistic, Game game)
{
var moonDb = new MoonAidAzureContext();
statistic.GamesPlayed.Add(game);
moonDb.Entry(statistic).State = EntityState.Modified;
}
public static GameInstance GetGameInstance(Guid channelId, string gameName)
{
var moonDb = new MoonAidAzureContext();
var gameInstance = moonDb.GameInstances
.FirstOrDefault(gi => gi.ChannelId == channelId && gi.Game.GameName == gameName;
return gameInstance;
}
public static Game GetGameByTwitchName(string twitchGameName)
{
var moonDb = new MoonAidAzureContext();
var game = moonDb.Games
.FirstOrDefault(g => g.GameName == twitchGameName);
return game;
}
public static ChannelLogger GetChannelLogger(Guid channelLoggerId)
{
var moonDb = new MoonAidAzureContext();
var channelLogger = moonDb.ChannelLoggers
.FirstOrDefault(cl => cl.ChannelLoggerId == channelLoggerId);
return channelLogger;
}
public static DateTime GetLastTimePlayed(Guid gameId)
{
var moonDb = new MoonAidAzureContext();
var lastTimePlayed = moonDb.GameInstances
.OrderBy(g => g.PlayedFrom)
.FirstOrDefault(g => g.Game.GameId == gameId)
.PlayedFrom;
return lastTimePlayed;
}
public static Channel CreateChannel()
{
var moonDb = new MoonAidAzureContext();
var channel = new Channel();
moonDb.Entry<Channel>(channel).State = EntityState.Added;
moonDb.SaveChanges();
return channel;
}
public static void StopStreamTimer(Statistic statistic)
{
var moonDb = new MoonAidAzureContext();
TimeSpan spanSinceLastCheck = statistic.LastUpdatedStreamTime - DateTime.Now;
statistic.TotalStreamTime += spanSinceLastCheck;
statistic.LastUpdatedStreamTime = DateTime.Now;
moonDb.Entry<Statistic>(statistic).State = EntityState.Modified;
moonDb.SaveChanges();
}
public static int CheckConnectionsOfUser(UserProfile userProfile, Guid channelId)
{
var moonDb = new MoonAidAzureContext();
var connection = moonDb.Connections.FirstOrDefault(c => c.UserProfile == userProfile && c.ChannelId == channelId);
if (connection != null && connection.FollowerConnectionCreatedAt == connection.LastSeenAt)
{
connection.TimesConnectedCount = 1;
}
else if (connection != null && connection.FollowerConnectionCreatedAt != connection.LastSeenAt)
{
connection.TimesConnectedCount += connection.TimesConnectedCount + 1;
}
}
public static Game CreateNewGame(string twitchGameName)
{
var moonDb = new MoonAidAzureContext();
var game = new Game
{
GameName = twitchGameName
};
moonDb.Games.Add(game);
moonDb.SaveChanges();
return game;
}
public static ChannelLogger CreateNewChannelLogger()
{
var moonDb = new MoonAidAzureContext();
var channelLogger = new ChannelLogger
{
LogIntervalCount = Config.MainConfig.CHANNELLOG_INTERVAL_COUNT,
MessagesCount = Config.MainConfig.CHANNELLOG_MESSAGES_COUNT
};
moonDb.Entry(channelLogger).State = EntityState.Added;
moonDb.SaveChanges();
return channelLogger;
}
public static bool DeleteChannel(Channel channel)
{
var moonDb = new MoonAidAzureContext();
try
{
moonDb.Entry(channel).State = EntityState.Deleted;
moonDb.SaveChanges();
return true;
}
catch (Exception ex)
{
throw;
}
}
public static void AddFollowers(Channel channel, IQueryable<Follow> twitchList)
{
var moonDb = new MoonAidAzureContext();
var connections = FollowToConnectionConverter(twitchList, channel);
var activity = channel.DailyActivities
.FirstOrDefault(d => d.ActivityDate == DateTime.Now);
foreach (var item in connections)
{
activity.Connections.Add(item);
}
moonDb.Entry(connections).State = EntityState.Added;
moonDb.Entry(activity).State = EntityState.Modified;
moonDb.SaveChanges();
}
public static void StartStreamTimer(Statistic statistic)
{
var moonDb = new MoonAidAzureContext();
statistic.LastUpdatedStreamTime = DateTime.Now;
moonDb.Entry<Statistic>(statistic).State = EntityState.Modified;
moonDb.SaveChanges();
//var gameInstance = GameInstanceMethods.GetGameInstance(channel.ChannelId, twitchGameName);
//if (gameInstance.TimeSpanAdded == null)
//{
// TimeSpan spanBetweenFromAndNow = gameInstance.PlayedFrom - DateTime.Now;
// gameInstance.TotalTimePlayed = spanBetweenFromAndNow;
// gameInstance.TimeSpanAdded = DateTime.Now;
//}
//else
//{
// TimeSpan spanSinceLastCheck = gameInstance.TimeSpanAdded - DateTime.Now;
// gameInstance.TotalTimePlayed += spanSinceLastCheck;
//}
}
public static Channel SwitchPublicState(Channel channel, bool publicState)
{
var moonDb = new MoonAidAzureContext();
channel.IsPublic = publicState;
moonDb.Entry(channel).State = EntityState.Modified;
moonDb.SaveChanges();
return channel;
}
public static Channel SwitchMailState(Channel channel, bool mailState)
{
var moonDb = new MoonAidAzureContext();
channel.ReceieveMailSwitch = mailState;
moonDb.Entry(channel).State = EntityState.Modified;
moonDb.SaveChanges();
return channel;
}
public static void RemoveFollowers(Channel channel, IQueryable<Connection> followersToDelete)
{
var moonDb = new MoonAidAzureContext();
moonDb.Entry(followersToDelete).State = EntityState.Deleted;
moonDb.SaveChanges();
}
public static Channel GetChannelByClientId(Guid clientId)
{
var moonDb = new MoonAidAzureContext();
var channel = moonDb.Channels
.FirstOrDefault(c => c.OwnerId == clientId);
var newActivity = new DailyActivity();
channel.DailyActivities.Add(newActivity);
return channel;
}
public static int TimesPlayedAGame(Guid gameId)
{
var moonDb = new MoonAidAzureContext();
var timesPlayed = moonDb.GameInstances
.Count(g => g.Game.GameId == gameId);
return timesPlayed;
}
public static void SaveInstance(GameInstance gameInstance)
{
var moonDb = new MoonAidAzureContext();
moonDb.Entry(gameInstance).State = EntityState.Modified;
}
public void InitDb()
{
MoonAidAzureContext db = new MoonAidAzureContext();
db.Database.Initialize(true);
}
public static void AddGameInstance(GameInstance gameinstance)
{
var moonDb = new MoonAidAzureContext();
moonDb.GameInstances.Add(gameinstance);
}
