public async Task<string> AddSubreddit( Subreddit sub ) {
sub.SubName = sub.SubName;
using ( SqlConnection conn = new SqlConnection( connstring ) ) {
string query = "insert into Subreddits (SubName,Active) values (@SubName,@Active)";
await conn.ExecuteAsync( query, new { sub.SubName, sub.Active } );
string result = "Success";
return result;
}
}
public async Task<bool> UpdateSubredditSettings( Subreddit sub ) {
using ( SqlConnection conn = new SqlConnection( connstring ) ) {
string query = "update ss " +
"set ss.AccessMask = @AccessMask " +
", ss.PermBanID = @PermBanID " +
", ss.TempBanID = @TempBanID " +
"from SubredditSettings ss inner join Subreddits s on s.SubRedditID = ss.SubRedditID " +
"where s.subname = @SubName";
int rows = await conn.ExecuteAsync( query, new { sub.Settings.AccessMask, sub.Settings.PermBanID, sub.Settings.TempBanID, sub.SubName } );
if ( rows <= 0 ) {
string insert = "insert into SubredditSettings(SubRedditID,AccessMask,PermBanID,TempBanID) " +
"(select SubRedditID, @AccessMask ,@PermBanID,@TempBanID from Subreddits where SubName = @SubName)";
conn.Execute( insert, new { sub.Settings.AccessMask, sub.Settings.PermBanID, sub.Settings.TempBanID, sub.SubName } );
}
}
return true;
}