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