/// <summary> /// 删除反馈内容 /// </summary> /// <param name="Item">反馈对象</param> /// <returns></returns> public async Task <bool> DeleteFeedBackAsync(FeedBackItem Item) { if (Item != null) { if (await MakeConnectionUseable().ConfigureAwait(false)) { try { using (MySqlCommand Command = new MySqlCommand("Delete From FeedBackTable Where GUID=@GUID", Connection)) { Command.Parameters.AddWithValue("@GUID", Item.GUID); await Command.ExecuteNonQueryAsync().ConfigureAwait(false); } return(true); } catch (Exception ex) { LogTracer.Log(ex, $"An error was threw in { nameof(DeleteFeedBackAsync)}"); return(false); } } else { return(false); } } else { throw new ArgumentNullException(nameof(Item), "Parameter could not be null"); } }
/// <summary> /// 删除反馈内容 /// </summary> /// <param name="Item">反馈对象</param> /// <returns></returns> public async Task <bool> DeleteFeedBackAsync(FeedBackItem Item) { if (Item != null) { using (SQLConnection Connection = await GetConnectionFromPoolAsync().ConfigureAwait(false)) { if (Connection.IsConnected) { try { using (MySqlCommand Command = Connection.CreateDbCommandFromConnection <MySqlCommand>("Delete From FeedBackTable Where GUID=@GUID")) { _ = Command.Parameters.AddWithValue("@GUID", Item.GUID); _ = Command.ExecuteNonQuery(); } return(true); } catch (Exception) { return(false); } } else { return(false); } } } else { throw new ArgumentNullException(nameof(Item), "Parameter could not be null"); } }
/// <summary> /// 提交反馈内容 /// </summary> /// <param name="Item">反馈对象</param> /// <returns></returns> public async Task <bool> SetFeedBackAsync(FeedBackItem Item) { if (Item != null) { using (SQLConnection Connection = await GetConnectionFromPoolAsync().ConfigureAwait(false)) { if (Connection.IsConnected) { try { using (MySqlCommand Command = Connection.CreateDbCommandFromConnection <MySqlCommand>("Insert Into FeedBackTable Values (@UserName,@Title,@Suggestion,@Like,@Dislike,@UserID,@GUID)")) { _ = Command.Parameters.AddWithValue("@UserName", Item.UserName); _ = Command.Parameters.AddWithValue("@Title", Item.Title); _ = Command.Parameters.AddWithValue("@Suggestion", Item.Suggestion); _ = Command.Parameters.AddWithValue("@Like", Item.LikeNum); _ = Command.Parameters.AddWithValue("@Dislike", Item.DislikeNum); _ = Command.Parameters.AddWithValue("@UserID", Item.UserID); _ = Command.Parameters.AddWithValue("@GUID", Item.GUID); _ = Command.ExecuteNonQuery(); } return(true); } catch (Exception) { return(false); } } else { return(false); } } } else { throw new ArgumentNullException(nameof(Item), "Parameter could not be null"); } }
/// <summary> /// 提交反馈内容 /// </summary> /// <param name="Item">反馈对象</param> /// <returns></returns> public async Task <bool> SetFeedBackAsync(FeedBackItem Item) { if (Item != null) { if (await MakeConnectionUseable().ConfigureAwait(false)) { try { using (MySqlCommand Command = new MySqlCommand("Insert Into FeedBackTable Values (@UserName,@Title,@Suggestion,@Like,@Dislike,@UserID,@GUID)", Connection)) { Command.Parameters.AddWithValue("@UserName", Item.UserName); Command.Parameters.AddWithValue("@Title", Item.Title); Command.Parameters.AddWithValue("@Suggestion", Item.Suggestion); Command.Parameters.AddWithValue("@Like", Item.LikeNum); Command.Parameters.AddWithValue("@Dislike", Item.DislikeNum); Command.Parameters.AddWithValue("@UserID", Item.UserID); Command.Parameters.AddWithValue("@GUID", Item.GUID); await Command.ExecuteNonQueryAsync().ConfigureAwait(false); } return(true); } catch (Exception ex) { LogTracer.Log(ex, $"An error was threw in { nameof(SetFeedBackAsync)}"); return(false); } } else { return(false); } } else { throw new ArgumentNullException(nameof(Item), "Parameter could not be null"); } }
/// <summary> /// 更新反馈对象的投票信息 /// </summary> /// <param name="Item">反馈对象</param> /// <returns></returns> public async Task <bool> UpdateFeedBackVoteAsync(FeedBackItem Item) { if (Item != null) { using (SQLConnection Connection = await GetConnectionFromPoolAsync().ConfigureAwait(false)) { if (Connection.IsConnected) { try { using (MySqlCommand Command = Connection.CreateDbCommandFromConnection <MySqlCommand>("UpdateFeedBackVoteProcedure", CommandType.StoredProcedure)) { _ = Command.Parameters.AddWithValue("LNum", Item.LikeNum); _ = Command.Parameters.AddWithValue("DNum", Item.DislikeNum); _ = Command.Parameters.AddWithValue("Beh", Item.UserVoteAction); _ = Command.Parameters.AddWithValue("GID", Item.GUID); _ = Command.Parameters.AddWithValue("UID", ApplicationData.Current.LocalSettings.Values["SystemUserID"].ToString()); _ = await Command.ExecuteNonQueryAsync().ConfigureAwait(false); } return(true); } catch (Exception) { return(false); } } else { return(false); } } } else { throw new ArgumentNullException(nameof(Item), "Parameter could not be null"); } }
/// <summary> /// 更新反馈对象的投票信息 /// </summary> /// <param name="Item">反馈对象</param> /// <returns></returns> public async Task <bool> UpdateFeedBackVoteAsync(FeedBackItem Item) { if (Item != null) { if (await MakeConnectionUseable().ConfigureAwait(false)) { try { using (MySqlCommand Command = new MySqlCommand("UpdateFeedBackVoteProcedure", Connection)) { Command.CommandType = CommandType.StoredProcedure; Command.Parameters.AddWithValue("LNum", Item.LikeNum); Command.Parameters.AddWithValue("DNum", Item.DislikeNum); Command.Parameters.AddWithValue("Beh", Item.UserVoteAction); Command.Parameters.AddWithValue("GID", Item.GUID); Command.Parameters.AddWithValue("UID", ApplicationData.Current.LocalSettings.Values["SystemUserID"].ToString()); await Command.ExecuteNonQueryAsync().ConfigureAwait(false); } return(true); } catch (Exception ex) { LogTracer.Log(ex, $"An error was threw in {nameof(UpdateFeedBackVoteAsync)}"); return(false); } } else { return(false); } } else { throw new ArgumentNullException(nameof(Item), "Parameter could not be null"); } }