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);
}
