public void Test() { using (var context = new mashDbContext()) { // Add user. context.Users.Add(new Users { Name = "pmash2", EntryDate = DateTime.Now }); context.Users.Add(new Users { Name = "hunter2140", EntryDate = DateTime.Now }); context.SaveChanges(); // Fetch Reminders var users = context.Users.ToArray(); foreach (var user in users) { Console.WriteLine($"We found user {user.Name}!"); } } }
public UserPoints GetPointsRecord(string user) { UserPoints pointsRecord; using (var context = new mashDbContext()) { pointsRecord = context.UserPoints .Where(x => x.Viewer == user.ToLower()) .FirstOrDefault(); if (pointsRecord == null) { UserPoints newRecord = new() { Viewer = user.ToLower(), Points = 0 }; context.UserPoints.Add(newRecord); pointsRecord = newRecord; context.SaveChanges(); } } return(pointsRecord); }
static void Main(string[] args) { Console.WriteLine("Hello World!"); var envReader = new EnvReader(); DotEnv.Config(true, "mySecrets"); var channel = envReader.GetStringValue("CHANNEL"); var token = envReader.GetStringValue("BOT_PASSWORD"); var endpoint = envReader.GetStringValue("API_ENDPOINT"); #if DEBUG using (var context = new mashDbContext()) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); } #endif BotSettings settings = new(endpoint); var bot = new Bot(channel, token, settings); while (true) { bot.settings.RefreshSettings(); System.Threading.Thread.Sleep(1000); } Console.WriteLine("We made it here without error!"); }
protected override async Task ExecuteAsync(CancellationToken stoppingToken) { _logger.LogInformation($"{Directory.GetCurrentDirectory()}"); Console.WriteLine("Hello World!"); var envReader = new EnvReader(); DotEnv.Config(true, "mySecrets"); var channel = envReader.GetStringValue("CHANNEL"); var token = envReader.GetStringValue("BOT_PASSWORD"); var endpoint = envReader.GetStringValue("API_ENDPOINT"); #if DEBUG using (var context = new mashDbContext()) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); } #endif BotSettings settings = new(endpoint); var bot = new Bot(channel, token, settings); while (!stoppingToken.IsCancellationRequested) { //_logger.LogInformation("Worker running at: {time}", DateTimeOffset.Now); bot.settings.RefreshSettings(_logger); await Task.Delay(1000, stoppingToken); } }
public string Execute(string username, string[] args, BotSettings settings) { var records = new List <TodaysMessage>(); string message; using (var context = new mashDbContext()) { records = context.TodaysMessage .Where(x => x.Date >= DateTime.Now.Date) .Where(x => x.Date <= DateTime.Now.AddDays(1).Date) .OrderBy(x => x.Date) .ToList(); } if (records.Count == 1) { message = records.First().Message; } else if (records.Count > 1) { message = records.Last().Message; } else { message = "I don't know what we're doing today!"; } return(message); }
public GlobalConfigs GetConfig(string key) { using var context = new mashDbContext(); return(context.GlobalConfigs .SingleOrDefault(x => x.Key == key)); }
public void UpdateDescription(string key, string description) { using (var context = new mashDbContext()) { var record = GetConfig(key); record.Description = description; context.GlobalConfigs.Update(record); } }
public void UpdateValue(string key, string value) { using (var context = new mashDbContext()) { var record = GetConfig(key); record.Value = value; context.GlobalConfigs.Update(record); } }
public Users GetUser(string username) { Users user; using (var context = new mashDbContext()) { user = context.Users.Where(x => x.Name == username).FirstOrDefault(); } return(user); }
public void AddUser(string username) { var user = new Users { Name = username, EntryDate = DateTime.Now }; using (var context = new mashDbContext()) { context.Users.Add(user); context.SaveChanges(); } }
public static StaticCommands GetCommand(string keyword) { StaticCommands cmd = new(); keyword = CheckForBang(keyword); using (var context = new mashDbContext()) { cmd = context.StaticCommands .Where(x => x.Keyword == keyword) .FirstOrDefault(); } return(cmd); }
public static void DeleteCommand(StaticCommands cmd) { if (string.IsNullOrEmpty(cmd.Keyword)) { throw new System.ArgumentException(); } cmd.Keyword = CheckForBang(cmd.Keyword); using (var context = new mashDbContext()) { context.Remove(GetCommand(cmd.Keyword)); context.SaveChanges(); } }
public static string GetRecord(string userName) { var message = ""; var records = new List <WinLoss>(); using (var context = new mashDbContext()) { records = context.WinLoss.Where(x => x.UserName == userName).ToList(); } var wins = records.Where(x => x.DidWin == true).Count(); var losses = records.Count - wins; message = $"{userName}'s current win loss record is : {wins} - {losses}"; return(message); }
public static DateTime GetLastCheckIn(string username) { DateTime lastCheckIn; using (var context = new mashDbContext()) { lastCheckIn = context.TransactionLog .Where(x => x.Notes == "Checked in!") .Where(x => x.Receiver == username) .OrderByDescending(x => x.Date) .Select(x => x.Date) .FirstOrDefault(); } return(lastCheckIn); }
public static void UpdateCommand(StaticCommands cmd) { if (string.IsNullOrEmpty(cmd.Keyword) || string.IsNullOrEmpty(cmd.Text)) { throw new System.ArgumentException(); } cmd.Keyword = CheckForBang(cmd.Keyword); using (var context = new mashDbContext()) { var existing = GetCommand(cmd.Keyword); existing.Text = cmd.Text; context.Update(existing); context.SaveChanges(); } }
public static string PlayGame(bool betEven, string userName, int wager, UserPointsRepo mgr) { var rand = new Random(); var number = rand.Next(0, 1000); var didWin = false; Console.WriteLine($"The random number for this round is {number}"); var isEven = number % 2 == 0 ? true : false; string result = $"The number was {number}. "; if (betEven && isEven || !betEven && !isEven) { result += "YOU WIN!!!!"; didWin = true; mgr.ChangePoints(userName, "", wager, "Won OddOrEven"); } else { result += "Oh no, you lose! :("; didWin = false; mgr.ChangePoints(userName, "", wager * -1, "Lost OddOrEven"); } using (var context = new mashDbContext()) { context.WinLoss.Add(new WinLoss { UserName = userName, DidWin = didWin, Date = DateTime.Now, Game = "OddOrEven" }); context.SaveChanges(); } return(result); }
public string Execute(string username, string[] args, BotSettings settings) { // !addconfig PTS multiplier 2 if (args.Length < 4) { return($"@{username}, try !addcommand PTS multiplier 2"); } string key = args[1]; string description = args[2]; string value = args[3]; GlobalConfigsManager cfgMgr = new(); if (cfgMgr.GetConfig(key) != null) { return($"@{username}, that configuration already exists : {key}"); } using (var context = new mashDbContext()) { GlobalConfigs cfg = new() { Key = key, Description = description, Value = value, DateUpdated = DateTime.Now }; context.GlobalConfigs.Add(cfg); context.SaveChanges(); } return($"@{username}, configuration saved"); } }
public string Execute(string username, string[] args, BotSettings settings) { string result; if (username == "pmash2") { var message = new TodaysMessage { Message = String.Join(' ', args, 1, args.Length - 1), Date = DateTime.Now }; using (var context = new mashDbContext()) { context.TodaysMessage.Add(message); context.SaveChanges(); } try { PostMessage(settings.Endpoint, message.Message); } catch (Exception ex) { Console.WriteLine($"Error posting today's message: {ex.Message}"); } result = "Today's message has been updated"; } else { result = "Sorry, you're not allowed to do that"; } return(result); }
public List <GlobalConfigs> GetAllConfigs() { using var context = new mashDbContext(); return(context.GlobalConfigs.ToList()); }