public void Add(UserAndAward userAndAward)
{
var record = $"{userAndAward.UserId} {userAndAward.AwardId}";
if (this.CheckFile(record))
{
throw new ArgumentException("The record already on the list");
}
using (StreamWriter sw = new StreamWriter(this.fullPath, true))
{
sw.WriteLine($"{userAndAward.UserId} {userAndAward.AwardId}");
}
}
public void Add(int userId, int awardId)
{
var userAndAward = new UserAndAward()
{
UserId = userId,
AwardId = awardId,
};
try
{
this.userAndAwardDao.Add(userAndAward);
}
catch (ArgumentException e)
{
throw e;
}
}
public void Add(UserAndAward userAndAward)
{
using (var sqlConnection = new SqlConnection(this.connectionString))
{
var command = sqlConnection.CreateCommand();
command.CommandText = "AddDependency";
command.CommandType = CommandType.StoredProcedure;
SqlParameter parameterAwardId = new SqlParameter("@AwardId", userAndAward.AwardId);
command.Parameters.Add(parameterAwardId);
SqlParameter parameterUserId = new SqlParameter("@UserId", userAndAward.UserId);
command.Parameters.Add(parameterUserId);
sqlConnection.Open();
command.ExecuteNonQuery();
}
}
