public CardEditWindow(int _cardId = 0) { InitializeComponent(); cardCreationDate_tb.Text = DateTime.Now.ToString(); if (_cardId != 0) { cardId = _cardId; using (KanbanBoardContext db = new KanbanBoardContext()) { card = new Card(); cardRep = new Repository <Card>(db); card = cardRep.GetWithInclude(c => c.Id == _cardId, c => c.Attachments).FirstOrDefault(/*x => x.Id == _cardId*/); attachment_lb.ItemsSource = attactmentCollection; foreach (Attachment a in card.Attachments) { attactmentCollection.Add((a.Path)); } cardName_tb.Text = card.Name; cardDescription_tb.Text = card.Description; cardCreationDate_tb.Text = card.CreationDate.ToString(); cardExpireDate_dp.SelectedDate = (DateTime)card.ExpireDate; } } }
static void Main(string[] args) { using (KanbanBoardContext db = new KanbanBoardContext()) { IRepository <User> repository = new Repository <User>(db); User user1 = new User { Mail = "*****@*****.**", Password = "******" }; User user2 = new User { Mail = "*****@*****.**", Password = "******" }; repository.Add(user1); repository.Add(user2); //DateTime date = new DateTime(); //var cards = db.Cards.ToList(); //foreach(Card card in cards) //{ // date = card.CreationDate; //} var users = db.Users.ToList(); foreach (User u in users) { Console.WriteLine(u.Mail); } //Console.ReadLine(); } }
public User GetUser(int _id) { using (KanbanBoardContext db = new KanbanBoardContext()) { userRepository = new Repository <User>(db); return(userRepository.Find(_id)); } }
public void AddNewColumn() { using (KanbanBoardContext db = new KanbanBoardContext()) { columnRepository = new Repository <Column>(db); Column newColumn = new Column() { Name = "newColumn" }; } }
public void AddNewTeam() { using (KanbanBoardContext db = new KanbanBoardContext()) { teamRepos = new Repository <Team>(db); Team newTeam = new Team() { Name = "newTeam" }; teamRepos.Add(newTeam); } }
public void GetUserBoard(int _userId) { using (KanbanBoardContext db = new KanbanBoardContext()) { userRepository = new Repository <User>(db); teamRepos = new Repository <Team>(db); boardRepos = new Repository <Board>(db); currentUserDb = userRepository.Find(_userId); currentTeam = teamRepos.Find((int)currentUserDb.TeamId); currentBoard = boardRepos.GetWithInclude(b => b.TeamId == currentTeam.Id, b => b.Columns, b => b.Team).FirstOrDefault(b => b.TeamId == currentTeam.Id); } }
public void AddNewProfile() { using (KanbanBoardContext db = new KanbanBoardContext()) { profileRepos = new Repository <Profile>(db); Profile newProfile = new Profile() { FirstName = "newFirstName", SecondName = "newSecondName" }; profileRepos.Add(newProfile); } }
private void ListBox_Drop(object sender, DragEventArgs e) { CardButton b = (CardButton)e.Data.GetData("Object"); using (KanbanBoardContext db = new KanbanBoardContext()) { cardsRepository = new Repository <Card>(db); Card c = cardsRepository.Find((int)b.Tag); int newColumnId = Convert.ToInt32((sender as ListBox).Tag); c.ColumnId = newColumnId; cardsRepository.Edit(c); } ReadFromDb(currentUserDb.Id); }
private void BoardName_cb_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (boardS.Count == 0) { return; } using (KanbanBoardContext db = new KanbanBoardContext()) { boardRepos = new Repository <Board>(db); currentBoard = boardRepos.GetWithInclude(b => b.Id == ((sender as ComboBox).SelectedItem as Board).Id, b => b.Columns, b => b.Team).FirstOrDefault(); } ReadFromDb(0); }
public void AddNewUser() { using (KanbanBoardContext db = new KanbanBoardContext()) { userRepository = new Repository <User>(db); User newUser = new User() { Mail = "email", Password = "******", TeamId = currentTeam.Id }; userRepository.Add(newUser); } }
public void ReadFromDb(int _id) //може айді і не треба { boardName_tb.DataContext = currentBoard; ////////////////////////не міняється ім"я дошки boardName_cb.ItemsSource = boardS; board.Clear(); boardS.Clear(); column1.Clear(); column2.Clear(); column3.Clear(); column4.Clear(); using (KanbanBoardContext db = new KanbanBoardContext()) { cardsRepository = new Repository <Card>(db); columnRepository = new Repository <Column>(db); boardRepos = new Repository <Board>(db); var b = boardRepos.GetAll(); foreach (var item in b) { boardS.Add(item); } foreach (Column column in currentBoard.Columns) { board.Add(column); } borderListBox1.Tag = curColumn1Id = board[0].Id; borderListBox2.Tag = curColumn2Id = board[1].Id; borderListBox3.Tag = curColumn3Id = board[2].Id; borderListBox4.Tag = curColumn4Id = board[3].Id; foreach (Card card in cardsRepository.GetAll(x => x.ColumnId == curColumn1Id)) { column1.Add(card); } foreach (Card card in cardsRepository.GetAll(x => x.ColumnId == curColumn2Id)) { column2.Add(card); } foreach (Card card in cardsRepository.GetAll(x => x.ColumnId == curColumn3Id)) { column3.Add(card); } foreach (Card card in cardsRepository.GetAll(x => x.ColumnId == curColumn4Id)) { column4.Add(card); } } }
public void AddNewBoard() { Column column1 = new Column { Name = "Tasks" }; Column column2 = new Column { Name = "In progress" }; Column column3 = new Column { Name = "Delayed" }; Column column4 = new Column { Name = "Ready" }; using (KanbanBoardContext db = new KanbanBoardContext()) { boardRepos = new Repository <Board>(db); Board newBoard = new Board() { Name = "NewBoard", TeamId = currentTeam.Id, Columns = { new Column { Name = "Tasks" }, new Column { Name = "In progress" }, new Column { Name = "Delayed" }, new Column { Name = "Ready" } } }; boardRepos.Add(newBoard); ReadFromDb(0); } }
private void Save_btn_Click(object sender, RoutedEventArgs e) { if (cardExpireDate_dp.SelectedDate > DateTime.Now) { using (KanbanBoardContext db = new KanbanBoardContext()) { cardRep = new Repository <Card>(db); attachmentRep = new Repository <Attachment>(db); if (card == null) { card = new Card(); card.CreationDate = DateTime.Now; card.ColumnId = MainWindow.curColumn1Id; card.ExpireDate = cardExpireDate_dp.SelectedDate; card.Name = cardName_tb.Text; card.Description = cardDescription_tb.Text; cardRep.Add(card); } else { card.ExpireDate = cardExpireDate_dp.SelectedDate; card.Name = cardName_tb.Text; card.Description = cardDescription_tb.Text; } if (attachment != null) { attachment.CardId = card.Id; attachmentRep.Add(attachment); card.Attachments.Add(attachment); } cardRep.Edit(card); (this.Owner as MainWindow).ReadFromDb(MainWindow.currentUserDb.Id); this.Close(); } } else { MessageBox.Show("Input corect ExpireDate"); } }
public MainWindow() { using (KanbanBoardContext db = new KanbanBoardContext()) { userRepository = new Repository <User>(db); User u = userRepository.GetAll().FirstOrDefault(x => x.Mail == "qwerty"); if (u == null) { AddNewDataToDB(); } } //AuthoreRegisterWind authoreRegisterWind = new AuthoreRegisterWind(); //authoreRegisterWind.ShowDialog(); // currentUser = GetDTOUser(); //(authoreRegisterWind.DataContext as LoginRegistrationViewModel).CurrentUser; InitializeComponent(); GetUserBoard(userID); boardS = new ObservableCollection <Board>(); board = new ObservableCollection <Column>(); column1 = new ObservableCollection <Card>(); column2 = new ObservableCollection <Card>(); column3 = new ObservableCollection <Card>(); column4 = new ObservableCollection <Card>(); borderListBox1.ItemsSource = column1; borderListBox2.ItemsSource = column2; borderListBox3.ItemsSource = column3; borderListBox4.ItemsSource = column4; ReadFromDb(currentUserDb.Id); column1Name_tb.DataContext = board[0]; column2Name_tb.DataContext = board[1]; column3Name_tb.DataContext = board[2]; column4Name_tb.DataContext = board[3]; }
public BoardController(KanbanBoardContext context) { _boardApp = new BoardAppService(context); }
public BoardAppService(KanbanBoardContext context) { _context = context; }
public void AddNewDataToDB() { using (KanbanBoardContext context = new KanbanBoardContext()) { User user1 = new User { Mail = "qwerty", Password = "******" }; User user2 = new User { Mail = "asd", Password = "******" }; Team team = new Team { Name = "testTeam2" }; Board board = new Board { Name = "testBoard2" }; Column column1 = new Column { Name = "Tasks" }; Column column2 = new Column { Name = "In progress" }; Column column3 = new Column { Name = "Delayed" }; Column column4 = new Column { Name = "Ready" }; Card card1 = new Card { Name = "2testCard1", CreationDate = DateTime.Now, ExpireDate = DateTime.Now.AddDays(10), Description = "Description1 from database" }; Card card2 = new Card { Name = "2testCard2", CreationDate = DateTime.Now, ExpireDate = DateTime.Now.AddDays(10), Description = "Description2 from database" }; Card card3 = new Card { Name = "2testCard3", CreationDate = DateTime.Now, ExpireDate = DateTime.Now.AddDays(10), Description = "Description3 from database" }; //Card card4 = new Card { Name = "2testCard4", CreationDate = DateTime.Now, ExpireDate = DateTime.Now.AddDays(10), Description = "Description4 from database" }; //Card card5 = new Card { Name = "2testCard5", CreationDate = DateTime.Now, ExpireDate = DateTime.Now.AddDays(10), Description = "Description5 from database" }; context.Users.Add(user1); context.Users.Add(user2); context.Teams.Add(team); context.Boards.Add(board); context.Columns.Add(column1); context.Columns.Add(column2); context.Columns.Add(column3); context.Columns.Add(column4); context.Cards.Add(card1); context.Cards.Add(card2); context.Cards.Add(card3); //context.Cards.Add(card4); //context.Cards.Add(card5); team.Users.Add(user1); team.Users.Add(user2); user1.Teams.Add(team); user2.Teams.Add(team); team.Boards.Add(board); column1.Cards.Add(card1); column1.Cards.Add(card2); column1.Cards.Add(card3); //column.Cards.Add(card4); //column.Cards.Add(card5); card1.Users.Add(user1); card2.Users.Add(user2); //card3.Users.Add(user2); //card4.Users.Add(user2); //card5.Users.Add(user2); board.Columns.Add(column1); board.Columns.Add(column2); board.Columns.Add(column3); board.Columns.Add(column4); context.SaveChanges(); user1.TeamId = team.Id; user2.TeamId = team.Id; context.SaveChanges(); } }