private List<UserVO> GetUserList(DbCommand command)
{
List<UserVO> userList = new List<UserVO>();
IDataReader reader = null;
try {
reader = Database.ExecuteReader(command);
LogDebug("DataReader created, retrieving requested UserVOs...");
while(reader.Read()) {
UserVO user = new UserVO();
user.UserID = reader.GetInt32(0);
user.Username = reader.GetString(1);
user.Rating = reader.GetInt32(2);
user.Password = reader.GetString(3);
user.RegisterDate = reader.GetDateTime(4);
userList.Add(user);
}
LogDebug("List created!");
}
catch (Exception e) {
LogError("Something exploded in trying to retrieve a user VO!", e);
throw new Exception("Something exploded in trying to retrieve a user VO!", e);
}
finally {
base.CloseReader(reader);
}
return userList;
}
public void UpdateUser(UserVO user)
{
DbCommand command = Database.GetSqlStringCommand(UPDATE_USER);
try {
Database.AddInParameter(command, USER_ID, DbType.Int32, user.UserID);
Database.AddInParameter(command, USERNAME, DbType.String, user.Username);
Database.AddInParameter(command, RATING, DbType.Int32, user.Rating);
Database.AddInParameter(command, PASSWORD, DbType.String, user.Password);
Database.AddInParameter(command, REGISTER_DATE, DbType.DateTime, user.RegisterDate);
Database.ExecuteScalar(command);
}
catch (Exception e) {
LogError("Something exploded while updating user " + user.UserID + " " + e.Message);
throw new Exception("Something exploded while updating user " + user.UserID + " " + e.Message);
}
}
private UserVO FillInUserVO(ref IDataReader reader)
{
UserVO user = new UserVO();
user.UserID = reader.GetInt32(0);
user.Username = reader.GetString(1);
user.Rating = reader.GetInt32(2);
user.Password = reader.GetString(3);
user.RegisterDate = reader.GetDateTime(4);
return user;
}
public UserVO InsertUser(UserVO user)
{
int uID = 0;
try {
DbCommand command = Database.GetSqlStringCommand(INSERT_USER);
Database.AddInParameter(command, USERNAME, DbType.String, user.Username);
Database.AddInParameter(command, RATING, DbType.Int32, user.Rating);
Database.AddInParameter(command, PASSWORD, DbType.String, user.Password);
Database.AddInParameter(command, REGISTER_DATE, DbType.DateTime, user.RegisterDate);
uID = Convert.ToInt32(Database.ExecuteScalar(command));
}
catch (Exception e) {
LogError("Something exploded while trying to insert a user!", e);
throw new Exception("Something exploded while trying to insert a user!", e);
}
return GetUser(uID);
}
public void DeleteUser(UserVO user)
{
int rowsAffected = 0;
try {
DbCommand command = Database.GetSqlStringCommand(DELETE_USER);
Database.AddInParameter(command, USER_ID, DbType.Int32, user.UserID);
rowsAffected = Database.ExecuteNonQuery(command);
}
catch (Exception e) {
LogError("Something exploded while deleting a user from the database!", e);
throw new Exception("Something exploded while deleting a user from the database!", e);
}
if (rowsAffected == 0) {
LogError("No user found with an ID of " + user.UserID);
throw new Exception("The delete command didn't delete anything!");
}
}
public void CreateNewUser(string username, string password)
{
UserDAO dao = new UserDAO();
UserVO newUser = new UserVO();
//Check to see if there's already a user of that name
if (CheckIfUsernameTaken(username)) {
throw new Exception(USERNAME_TAKEN_EXCEPTION);
}
newUser.Username = username;
newUser.Password = HashPassword(password);
newUser.RegisterDate = DateTime.Now;
newUser.Rating = 0;
InsertUser(newUser);
}
private UserVO InsertUser(UserVO newUser)
{
try {
using(TransactionScope ts = new TransactionScope()){
UserDAO dao = new UserDAO();
LogDebug("Inserting Employee " + newUser.Username);
newUser = dao.InsertUser(newUser);
LogDebug("User succesfully inserted!");
ts.Complete();
}
}
catch (Exception e) {
LogError(e.ToString());
throw e;
}
return newUser;
}
public void UpdateComment(UserVO user)
{
UserDAO dao = new UserDAO();
dao.UpdateUser(user);
}
