public CommandResult ToggleAdminCommand(ulong user, ulong guild, bool admin)
{
NonQueryCommand updateAdmin = new NonQueryCommand("users", $"UPDATE `users` SET admin = {admin} WHERE id_user = {user} AND id_guild = {guild};");
var users = _vTubeMonDbConnection.ExecuteDbNonQueryCommand(updateAdmin);
return(new CommandResult(users > 0 ? CommandResultType.Success : CommandResultType.Failure));
}
// Customer Test Methods
private static void TestCustomers(string db_file, CommandContext commandContext)
{
Customers customers;
int record_count;
try
{
// Create command objects
QueryCommand querycmd_Customer = new QueryCommand(db_file, "Customer", typeof(Customer));
QueryCountCommand querycountcmd_Customer = new QueryCountCommand(db_file, "Customer");
NonQueryCommand nonquerycmd_Customer = new NonQueryCommand(db_file, "Customer");
// Query by matching first name and display records
querycmd_Customer.SetCommand("SELECT CustomerId,FirstName,LastName,Email FROM Customer WHERE FirstName LIKE 'a%'");
customers = new Customers(commandContext.Execute(querycmd_Customer));
Console.WriteLine(customers.ToString());
// Query record count
querycountcmd_Customer.SetCommand("SELECT COUNT(*) FROM Customer");
record_count = commandContext.ExecuteCount(querycountcmd_Customer);
Console.WriteLine("Record Count: {0}", record_count);
// Insert test records
nonquerycmd_Customer.SetCommand("INSERT INTO Customer(FirstName,LastName,Email) VALUES('Anna', 'Draftna','*****@*****.**')");
commandContext.Execute(nonquerycmd_Customer);
nonquerycmd_Customer.SetCommand("INSERT INTO Customer(FirstName,LastName,Email) VALUES('Albert', 'Smith','*****@*****.**')");
commandContext.Execute(nonquerycmd_Customer);
nonquerycmd_Customer.SetCommand("INSERT INTO Customer(FirstName,LastName,Email) VALUES('Arnold', 'Palmer','*****@*****.**')");
commandContext.Execute(nonquerycmd_Customer);
// Query by first name and display records
customers = new Customers(commandContext.Execute(querycmd_Customer));
Console.WriteLine(customers.ToString());
// Query record count
record_count = commandContext.ExecuteCount(querycountcmd_Customer);
Console.WriteLine("Record Count: {0}", record_count);
// Delete records
nonquerycmd_Customer.SetCommand("DELETE FROM Customer WHERE FirstName = 'Anna' OR FirstName = 'Albert'");
commandContext.Execute(nonquerycmd_Customer);
// Query by first name and display records
customers = new Customers(commandContext.Execute(querycmd_Customer));
Console.WriteLine(customers.ToString());
// Query record count
record_count = commandContext.ExecuteCount(querycountcmd_Customer);
Console.WriteLine("Record Count: {0}", record_count);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public CommandResult DailyCheckinCommand(ulong user, ulong guild, DateTime checkInDateTime, int dailyCash)
{
if (GetUser(user, guild) == null)
{
return(new CommandResult(CommandResultType.NotExist));
}
var queryDailiesCommand = new QueryCommand <Daily>("dailies", "*",
new WhereStatement()
{
Equality = Equality.EqualTo,
Value = $"{user}",
Target = "id_user",
UseQuotes = false
},
new WhereStatement()
{
Equality = Equality.EqualTo,
Value = $"{guild}",
Target = "id_guild",
UseQuotes = false
});
List <Daily> dailies = _vTubeMonDbConnection.ExecuteDbQueryCommand(queryDailiesCommand).ToList();
if (dailies.Any())
{
var lastCheckIn = dailies.Last();
if (lastCheckIn.CheckInDate.Value.DayOfYear == DateTime.Now.DayOfYear)
{
//already checked in
return(new CommandResult(CommandResultType.Duplicate));
}
}
_vTubeMonDbConnection.ExecuteDbNonQueryCommand(new InsertCommand <IDaily>("dailies", new Daily(user, guild, checkInDateTime)));
int newCash = TotalCash(user, guild) + dailyCash;
NonQueryCommand updateCash = new NonQueryCommand("users", $"UPDATE `users` SET vtuber_cash = {newCash} WHERE id_user = {user} AND id_guild = {guild};");
_vTubeMonDbConnection.ExecuteDbNonQueryCommand(updateCash);
return(new CommandResult(CommandResultType.Success));
}
