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