public static ChatCommand GetCommandFromDBAtRow(int rowNumber) { Func <SqlDataReader, ChatCommand> getCommandParameters = (reader) => { ChatCommand command = new ChatCommand(reader["TriggerText"].ToString(), reader["ResponseText"].ToString(), reader["ChannelName"].ToString(), reader["IsUniversal"] as bool? ?? false, reader["MustBeExact"] as bool? ?? false, reader["WhisperResponse"] as bool? ?? false, reader["SubscriberOnly"] as bool? ?? false, reader["ModeratorOnly"] as bool? ?? false, reader["BroadcasterOnly"] as bool? ?? false); return(command); }; return(Database.GetEntryAt("COMMANDS", rowNumber, getCommandParameters)); }
public static void AddCommandToDB(ChatCommand command) { string tableName = "COMMANDS"; string columnNames = "TriggerText, ResponseText, ChannelName, IsUniversal, MustBeExact, WhisperResponse, SubscriberOnly, ModeratorOnly"; string parameterNames = @"@triggerText, @responseText, @channelName, @isUniversal, @mustBeExact, @whisperResponse, @subscriberOnly, @moderatorOnly"; Action <SqlCommand> addParameters = (insertCommand) => { insertCommand.Parameters.AddWithValue("@triggerText", command.TriggerText); insertCommand.Parameters.AddWithValue("@responseText", command.responseText); insertCommand.Parameters.AddWithValue("@channelName", command.ChannelName); insertCommand.Parameters.AddWithValue("@isUniversal", command.IsUniversal); insertCommand.Parameters.AddWithValue("@mustBeExact", command.MustBeExact); insertCommand.Parameters.AddWithValue("@whisperResponse", command.WhisperResponse); insertCommand.Parameters.AddWithValue("@subscriberOnly", command.SubscriberOnly); insertCommand.Parameters.AddWithValue("@moderatorOnly", command.ModeratorOnly); insertCommand.Parameters.AddWithValue("@moderatorOnly", command.BroadcasterOnly); }; Database.InsertEntry(tableName, columnNames, parameterNames, addParameters); }
public static ChatCommand GetCommandFromDBAtRow(int rowNumber) { Func<SqlDataReader, ChatCommand> getCommandParameters = (reader) => { ChatCommand command = new ChatCommand(reader["TriggerText"].ToString(), reader["ResponseText"].ToString(), reader["ChannelName"].ToString(), reader["IsUniversal"] as bool? ?? false, reader["MustBeExact"] as bool? ?? false, reader["WhisperResponse"] as bool? ?? false, reader["SubscriberOnly"] as bool? ?? false, reader["ModeratorOnly"] as bool? ?? false, reader["BroadcasterOnly"] as bool? ?? false); return command; }; return Database.GetEntryAt("COMMANDS", rowNumber, getCommandParameters); }
public static void AddCommandToDB(ChatCommand command) { string tableName = "COMMANDS"; string columnNames = "TriggerText, ResponseText, ChannelName, IsUniversal, MustBeExact, WhisperResponse, SubscriberOnly, ModeratorOnly"; string parameterNames = @"@triggerText, @responseText, @channelName, @isUniversal, @mustBeExact, @whisperResponse, @subscriberOnly, @moderatorOnly"; Action<SqlCommand> addParameters = (insertCommand) => { insertCommand.Parameters.AddWithValue("@triggerText", command.TriggerText); insertCommand.Parameters.AddWithValue("@responseText", command.responseText); insertCommand.Parameters.AddWithValue("@channelName", command.ChannelName); insertCommand.Parameters.AddWithValue("@isUniversal", command.IsUniversal); insertCommand.Parameters.AddWithValue("@mustBeExact", command.MustBeExact); insertCommand.Parameters.AddWithValue("@whisperResponse", command.WhisperResponse); insertCommand.Parameters.AddWithValue("@subscriberOnly", command.SubscriberOnly); insertCommand.Parameters.AddWithValue("@moderatorOnly", command.ModeratorOnly); insertCommand.Parameters.AddWithValue("@moderatorOnly", command.BroadcasterOnly); }; Database.InsertEntry(tableName, columnNames, parameterNames, addParameters); }