} //empty constructor
public User(string email, string nickname, string password, int boardId) //Constructing a user that is a board creator
{
this.email = email;
this.nickname = nickname;
this.password = password;
this.board = new Board(email, boardId);
this.boardId = boardId;
//Inserting to database
DataAccessLayer.dataUserController DUC = new DataAccessLayer.dataUserController();
DUC.Insert(this.toDalObject());//insert new user to data base table
}
public User(string email, string nickname, string password, Board b) //Constructing a user that is an assigned user
{
this.email = email;
this.nickname = nickname;
this.password = password;
this.board = b;
this.boardId = b.getBoardId();
b.addAssignedUser(email);
//Inserting to database
DataAccessLayer.dataUserController DUC = new DataAccessLayer.dataUserController();
DUC.Insert(this.toDalObject());//insert new user to data base table
}
public void loadata()
{
if (users.Count == 0) //Cant load data before deleting it
{
DataAccessLayer.dataBoardController boardController = new DataAccessLayer.dataBoardController();
DataAccessLayer.dataTaskController taskController = new DataAccessLayer.dataTaskController();
DataAccessLayer.dataColumnController columnController = new DataAccessLayer.dataColumnController();
DataAccessLayer.dataUserController UserController = new DataAccessLayer.dataUserController();
//Loading from database to dal objects
List <DataAccessLayer.dataBoard> allBoards = boardController.SelectAllBoards();
List <DataAccessLayer.dataTask> allTasks = taskController.SelectAllTasks();
List <DataAccessLayer.dataColumn> allColumns = columnController.SelectAllColumns();
List <DataAccessLayer.dataUser> allUsers = UserController.SelectAllUsers();
List <Board> boards = new List <Board>();
foreach (var dataUser in allUsers)
{
Board busBoard = null;
foreach (var dataBoard in allBoards)
{
if (dataUser.email.Equals(dataBoard.emailCreator)) //Only add the board created by the user
{
Dictionary <int, Column> busColumns = new Dictionary <int, Column>();
foreach (var dataColumn in allColumns)
{
if (dataColumn.boardId == dataBoard.boardId)
{
List <Task> busTasks = new List <Task>();
foreach (var dataTask in allTasks)
{
if (dataTask.column == dataColumn.ordinal & dataColumn.boardId == dataTask.boardId) //Only add the tasks that match the correct column
{
busTasks.Add(new Task(dataTask)); //adding to task list business task which is the copy of the data task
}
}
Column busColumn = new Column(dataColumn, busTasks);
busColumns.Add(busColumn.getKey(), busColumn);
}
}
busBoard = new Board(dataBoard, busColumns);
boards.Add(busBoard);
}
}
User busUser = new User(dataUser, busBoard);
users.Add(busUser.getEmail(), busUser);
}
foreach (var user in users)
{
if (user.Value.getBoard() == null) //A user that is not a board creator
{
foreach (var board in boards)
{
if (board.getBoardId() == user.Value.getBoardId())
{
user.Value.setBoard(board); //board is not null
board.addAssignedUser(user.Value.getEmail());
}
}
}
}
bc.loadData(users); //Loading all Boards to BoardController
}
}