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