public void UpdateUserMute(ulong userId, bool isMusted) { var idString = Converter.ConvertToString(userId); int Mute = Converter.ConvertFromBool(isMusted); using (IDbConnection connection = new SQLiteConnection(DataBaseHandler.CnnVal(nameS))) { connection.Execute($"update UserAcc set IsMuted = {Converter.ConvertFromBool(isMusted)} WHERE Id = {userId};"); } }
public void test() { using (IDbConnection connection = new SQLiteConnection(DataBaseHandler.CnnVal(nameS))) { connection.Open(); Console.WriteLine(connection.State); connection.Close(); Console.WriteLine(connection.State); } }
public void AddUser(ulong UserId) { string idString = UserId.ToString(); using (IDbConnection connection = new SQLiteConnection(DataBaseHandler.CnnVal(nameS))) { connection.Open(); Console.WriteLine(connection.State); var user = connection.Execute($"insert into UserAcc Values({ UserId }, 0, 0)"); connection.Close(); Console.WriteLine(connection.State); } }
public UserAccountModel GetUser(ulong userId) { string idString = userId.ToString(); using (IDbConnection connection = new SQLiteConnection(DataBaseHandler.CnnVal(nameS))) { var t = Global.Client.GetGuild(Config.bot.guildID).GetUser(userId); UserAccountModel model = new UserAccountModel(); //select * from UserAcc where @IdString var users = connection.Query($"SELECT * from UserAcc where Id = " + t.Id + ";"); var UsersL = users.ToList(); foreach (var p in UsersL) { //Console.WriteLine($" Id: {p.Id} \n Warnings: {p.NumberOfWarnings} \n Is Muted: {p.IsMuted}"); model.Id = (ulong)p.Id; model.NumberOfWarnings = (byte)p.NumberOfWarnings; model.IsMuted = (byte)p.IsMuted; return(model); } return(model); } }
public void UpdateUserWarning(ulong userId, byte warningAdd) { var idString = Converter.ConvertToString(userId); using (IDbConnection connection = new SQLiteConnection(DataBaseHandler.CnnVal(nameS))) { UserAccountModel model = new UserAccountModel(); connection.Open(); var users = connection.Query($"SELECT * from UserAcc where Id = " + userId + ";"); var UsersL = users.ToList(); foreach (var p in UsersL) { Console.WriteLine($" Id: {p.Id} \n Warnings: {p.NumberOfWarnings} \n Is Muted: {p.IsMuted}"); model.Id = (ulong)p.Id; model.NumberOfWarnings = (byte)p.NumberOfWarnings; model.IsMuted = (byte)p.IsMuted; connection.Execute($"update UserAcc set NumberOfWarnings = {warningAdd + model.NumberOfWarnings} WHERE Id = {userId};"); } connection.Close(); } }