public void AddUserAward(UsersAwards userAward) { if (userAward != null) { this.userAwardsDao.AddUserAward(userAward); } }
public void AddUserAward(UsersAwards userAward) { if (userAward != null) { this.cacheLogicUserAward.Delete(AllUsersAwardsCacheKey); this.userAwardsDao.AddUserAward(userAward); } }
public bool RemoveAwardFromUser(string userName, string awardTitle) { UsersAwards usersAwardsForDelete = usersAwards.FirstOrDefault(uA => uA.Award.Title == awardTitle && uA.User.Name == userName); if (usersAwardsForDelete == null) { return(false); } usersAwards.Remove(usersAwardsForDelete); return(true); }
public void AddUserAward(UsersAwards userAward) { using (IDbConnection sqlConnection = new SqlConnection(this.connectionString)) { var command = sqlConnection.CreateCommand(); command.CommandText = "[AddUserAward]"; command.CommandType = CommandType.StoredProcedure; SqlParameter parameterIdUser = new SqlParameter("@IdUser", userAward.IdUser); command.Parameters.Add(parameterIdUser); SqlParameter parameterIdAward = new SqlParameter("@IdAward", userAward.IdAward); command.Parameters.Add(parameterIdAward); sqlConnection.Open(); command.ExecuteNonQuery(); } }
public void UpdUserAward(UsersAwards userAward) { this.userAwardsDao.UpdUserAward(userAward); }
public static void Main(string[] args) { var userAdminLogic = DependencyResolver.UserAdminLogic; var userLogic = DependencyResolver.UserLogic; var awardsLogic = DependencyResolver.AwardLogic; var userAwardsLogik = DependencyResolver.UserAwardsLogic; Awards ironCross = new Awards { Title = "Iron_Kross", }; Awards medalForHonor = new Awards { Title = "MedalForHonor", }; Awards redStar = new Awards { Title = "Award_Of_Red_Star", }; Awards goldMedal = new Awards { Title = "GoldMedal", }; Awards silverMedal = new Awards { Title = "SilverMedal", }; UsersAwards usersAwards = new UsersAwards { IdUser = 1, IdAward = 0, }; awardsLogic.AddAward(ironCross); awardsLogic.AddAward(medalForHonor); awardsLogic.AddAward(redStar); awardsLogic.AddAward(goldMedal); awardsLogic.AddAward(silverMedal); AddUser(userLogic); AddUser(userLogic); AddUser(userLogic); userLogic.DeleteUser(3); AddUser(userLogic); AddUser(userLogic); AddUser(userLogic); var user2 = new User { Id = 2, Name = "Peter", DateOfBirth = new DateTime(56), }; var user3 = new User { Id = 1, Name = "Irvin", DateOfBirth = new DateTime(1986, 07, 24), }; userLogic.UpdateUser(user2); userLogic.UpdateUser(user3); ShowUser(userLogic); ShowAward(awardsLogic); ShowUserAward(userAwardsLogik); ShowAwardsOfUser(userAwardsLogik, user3); }