public static int Add(Vote_Channel vote_channel) { const string query = "INSERT INTO vote_channel(aktiv, vote, channel) VALUES(@aktiv, @vote, @channel)"; var args = new Dictionary <string, object> { { "@aktiv", vote_channel.aktiv }, { "@vote", vote_channel.vote }, { "@channel", vote_channel.channel } }; return(Data.ExecuteWrite(query, args)); }
public static int Edit(Vote_Channel vote_channel) { const string query = "UPDATE vote_channel SET aktiv = @aktiv, vote = @vote, channel = @channel WHERE id = @id"; var args = new Dictionary <string, object> { { "@id", vote_channel.id }, { "@aktiv", vote_channel.aktiv }, { "@vote", vote_channel.vote }, { "@channel", vote_channel.channel } }; return(Data.ExecuteWrite(query, args)); }