public void Add(int userId, int awardId) { AwardedUser awardedUser = new AwardedUser(userId, awardId); if (this.awardedUsers.Contains(awardedUser)) { throw new CollisionException(); } this.awardedUsers.Add(awardedUser); FileHelper.WriteAwardedUsersData(this.awardedUsers); }
public void Add(int userId, int awardId) { AwardedUser awardedUser = new AwardedUser(userId, awardId); if (this.awardedUsers.Contains(awardedUser)) { throw new ArgumentException("User already has this award"); } this.awardedUsers.Add(awardedUser); FileHelper.WriteAwardedUsersData(this.awardedUsers); }
public void Delete(int userId, int awardId) { AwardedUser awardedUser = new AwardedUser(userId, awardId); if (!this.awardedUsers.Contains(awardedUser)) { throw new ArgumentException("The user does not exist or the user does not have this award"); } this.awardedUsers.Remove(awardedUser); FileHelper.WriteAwardedUsersData(this.awardedUsers); }
public void Add(AwardedUser awardedUser) { using (SqlConnection sqlConnection = new SqlConnection(_connectionString)) { var command = sqlConnection.CreateCommand(); command.CommandText = "AddAwardedUser"; command.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter parName = new SqlParameter("@id_user", awardedUser.IdUser); command.Parameters.Add(parName); SqlParameter parDOB = new SqlParameter("@id_award", awardedUser.IdAward); command.Parameters.Add(parDOB); sqlConnection.Open(); command.ExecuteNonQuery(); } }
private void UpdateUser(HttpContext context) { string jsonStr; context.Response.ContentType = "application/json"; if (_enumerable == null) { _enumerable = _bll.Users.GetAllUsers().GetEnumerator(); } if (_enumerable.MoveNext()) { var objUser = new AwardedUser( _enumerable.Current.Id, _enumerable.Current.Name, _enumerable.Current.DateOfBirth, _enumerable.Current.Login, _enumerable.Current.Password, _enumerable.Current.Role ); foreach (var item in _enumerable.Current.AwardList) { objUser.AwardList.Add(_bll.Awards.GetAward(item)); } jsonStr = JsonConvert.SerializeObject(objUser); context.Response.Write(jsonStr); } else { context.Response.Write(null); _enumerable = null; } }