public int AddReward(RewardsModel reward) { using (SqlConnection connection = new SqlConnection(_connectionString)) { using (SqlCommand command = connection.CreateCommand()) { SqlParameter titleParameter = new SqlParameter(); titleParameter.ParameterName = "Title"; titleParameter.Value = reward.Title; command.Parameters.Add(titleParameter); SqlParameter descriptionParameter = new SqlParameter(); descriptionParameter.ParameterName = "Description"; descriptionParameter.Value = reward.Description; command.Parameters.Add(descriptionParameter); command.CommandText = "INSERT INTO Rewards (Title, Description) output INSERTED.Id VALUES (@Title, @Description)"; try { connection.Open(); return((int)command.ExecuteScalar()); } catch (Exception e) { Console.WriteLine(e); } } } return(-1); }
public IEnumerable <RewardsModel> GetRewardsByUserId(int id) { List <RewardsModel> rewardsList = new List <RewardsModel>(); using (SqlConnection connection = new SqlConnection(_connectionString)) { using (SqlCommand command = connection.CreateCommand()) { SqlParameter userId = new SqlParameter(); userId.ParameterName = "userId"; userId.Value = id; command.Parameters.Add(userId); command.CommandText = "SELECT Id,Title,Description FROM Rewards JOIN RewardsUser on Rewards.Id=RewardsUser.RewardId" + " WHERE UserId=@userId"; connection.Open(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { RewardsModel reward = new RewardsModel() { Id = reader.GetInt32(0), Title = reader.GetString(1), Description = reader.GetString(2) }; rewardsList.Add(reward); } } } } return(rewardsList); }
public IEnumerable <RewardsModel> GetRewardsList() { List <RewardsModel> rewardsList = new List <RewardsModel>(); using (SqlConnection connection = new SqlConnection(_connectionString)) { using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "SELECT * FROM Rewards"; connection.Open(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { RewardsModel reward = new RewardsModel() { Id = reader.GetInt32(0), Title = reader.GetString(1), Description = reader.GetString(2) }; rewardsList.Add(reward); } } } } return(rewardsList); }
public bool RemoveReward(int userId, int rewardId) { RewardsModel rewardRemoved = ReturnRewardById(rewardId) ?? throw new ArgumentNullException("Reward is null"); UsersModel userRemoved = ReturnUserById(userId) ?? throw new ArgumentNullException("User is null"); return(userRemoved.Rewards.Remove(rewardRemoved)); }
public static RewardsViewModel ConvertRewardToViewModel(this RewardsModel domainRewardModel) { return(new RewardsViewModel() { Id = domainRewardModel.Id, Title = domainRewardModel.Title, Description = domainRewardModel.Description, }); }
public bool UpdateReward(RewardsModel reward) { RewardsModel rewardUpdated = ReturnRewardById(reward.Id); if (storageRewards[storageRewards.IndexOf(rewardUpdated)] is null) { return(false); } storageRewards[storageRewards.IndexOf(rewardUpdated)] = reward; return(true); }
public void ShouldBeAbleToAddReward() { // Arrange RewardsModel reward = new RewardsModel(); // Act int rewardId = storage.AddReward(reward); RewardsModel rewardReturned = storage.ReturnRewardById(rewardId); // Assert Assert.NotNull(rewardReturned); }
public void VerifiesThatTheAddedRewardHasValidId() { // Arrange int expectedId = 6; RewardsModel reward = new RewardsModel(); // Act int actualId = storage.AddReward(reward); // Assert Assert.Equal(expectedId, actualId); }
public void VerifiesUpdateReward() { // Arrange RewardsModel oldReward = storage.ReturnRewardById(0); RewardsModel newReward = new RewardsModel { Id = 0, Title = "Новое название", Description = "Получен в Туссенте" }; // Act storage.UpdateReward(newReward); // Assert Assert.NotEqual(oldReward.Title, newReward.Title); }
public List <RewardsModel> getInnovatorRewards(PostRewards rewards) { string sqlQuery = ""; sqlQuery = "SELECT Users.mobileXP,Users.registerXP,Pitch.SubmitPitchXP,Pitch.ProgressXP from Users Join Pitch On Users.UserId='" + rewards.userId + "' Where Users.UserId=Pitch.UserId"; string ConnectionString = ConfigurationManager.ConnectionStrings["Mysql"].ConnectionString; MySqlConnection connection = new MySqlConnection(ConnectionString); List <RewardsModel> rewardsModels = new List <RewardsModel>(); RewardsModel model = null; MySqlCommand sql; ArrayList arra = new ArrayList(); connection.Open(); try { sql = connection.CreateCommand(); sql.CommandText = sqlQuery; MySqlDataReader reader = sql.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { model = new RewardsModel(); model.mobileXP = Convert.ToInt32(reader["mobileXP"]); model.registerXP = Convert.ToInt32(reader["registerXP"]); model.submitPitchXP = Convert.ToInt32(reader["SubmitPitchXP"]); model.progressXP = Convert.ToInt32(reader["ProgressXP"]); rewardsModels.Add(model); } return(rewardsModels); } else { return(new List <RewardsModel>()); } } catch (Exception) { throw; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } }
public bool RemoveRewardById(int id) { RewardsModel removedReward = ReturnRewardById(id); if (removedReward is null) { return(false); } foreach (UsersModel user in storageUsers) { RemoveReward(user.Id, id); user.RewardsIsCheck.Remove(user.RewardsIsCheck[storageRewards.IndexOf(removedReward) - 1]); } return(storageRewards.Remove(removedReward)); }
public bool UpdateReward(RewardsModel reward) { using (SqlConnection connection = new SqlConnection(_connectionString)) { using (SqlCommand command = connection.CreateCommand()) { SqlParameter idParameter = new SqlParameter(); idParameter.ParameterName = "Id"; idParameter.Value = reward.Id; command.Parameters.Add(idParameter); SqlParameter titleParameter = new SqlParameter(); titleParameter.ParameterName = "Title"; titleParameter.Value = reward.Title; command.Parameters.Add(titleParameter); SqlParameter descriptionParameter = new SqlParameter(); descriptionParameter.ParameterName = "Description"; descriptionParameter.Value = reward.Description; command.Parameters.Add(descriptionParameter); command.CommandText = "UPDATE Rewards SET Title=@Title, Description=@Description WHERE Id=@Id"; try { connection.Open(); if (command.ExecuteNonQuery() != 0) { return(true); } } catch (Exception e) { Console.WriteLine(e); } } } return(false); }
public int AddReward(RewardsModel reward) { reward.Id = storageRewards.Max(task => task.Id) + 1; storageRewards.Add(reward); return(reward.Id); }