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