private void loadTask()
{
flpTasks.Controls.Clear();
using (var dbContext = new TODOContext())
{
tasks = dbContext.Tasks.Where(c => c.CardId == card.Id).ToList();
comments = dbContext.Comments.Where(c => c.CardId == card.Id).ToList();
}
foreach (var task in tasks)
{
UCTask ucTask = new UCTask(task);
ucTask.DataUpdated += new EventHandler(UCTask_DataUpdated);
flpTasks.Controls.Add(ucTask);
}
UCAddCard ucAdd = new UCAddCard();
ucAdd.BtnAddClick += new EventHandler(UCAdd_BtnAddClick);
flpTasks.Controls.Add(ucAdd);
foreach (var comment in comments)
{
UCComment ucComment = new UCComment(comment);
flpTasks.Controls.Add(ucComment);
}
UCAddComment ucAddComment = new UCAddComment(card);
ucAddComment.CmtAdded += new EventHandler(UCAddCmt_CmtAdded);
flpTasks.Controls.Add(ucAddComment);
}
public void Insert(TODOItem item)
{
using (TODOContext db = new TODOContext())
{
db.Todos.Add(item);
db.SaveChanges();
}
}
public void Update(TODOItem todo)
{
using (TODOContext db = new TODOContext())
{
db.Todos.Attach(todo);
db.Entry(todo).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public SettingForm()
{
InitializeComponent();
using (var dbContext = new TODOContext())
{
us = dbContext.UserSettings.Find(1);
switchStartWithWindow.Checked = us.StartWithWin;
switchNoti.Checked = us.Noti;
}
}
private void gunaCheckBox1_CheckedChanged(object sender, EventArgs e)
{
using (var dbContext = new TODOContext())
{
task.IsDone = gunaCheckBox1.Checked;
dbContext.Tasks.AddOrUpdate(task);
dbContext.SaveChanges();
loadData();
}
}
public TODOItem GetItemById(int id)
{
TODOItem todo;
using (TODOContext db = new TODOContext())
{
todo = db.Todos.Find(id);
}
return(todo);
}
protected void UCAddBoard_btnAddClick(object sender, EventArgs e)
{
Board newBoard = new Board();
newBoard.Name = "My Board";
using (var dbContext = new TODOContext())
{
dbContext.Boards.Add(newBoard);
dbContext.SaveChanges();
}
loadData();
}
protected void UCAdd_BtnAddClick(object sender, EventArgs e)
{
Task task = new Task();
task.CardId = card.Id;
task.Name = "My task";
using (var dbContext = new TODOContext())
{
dbContext.Tasks.Add(task);
dbContext.SaveChanges();
}
loadTask();
}
protected void UCAddList_btnAddClick(object sender, EventArgs e)
{
Card newCard = new Card();
newCard.Name = "My Card";
newCard.BoardId = board.Id;
newCard.StartTime = DateTime.Now;
newCard.EndTime = DateTime.Now;
using (var dbContext = new TODOContext())
{
dbContext.Cards.Add(newCard);
dbContext.SaveChanges();
}
loadData();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
using (var dbContext = new TODOContext())
{
task.Name = gunaTextBox1.Text;
task.UpdatedAt = DateTime.Now;
dbContext.Tasks.AddOrUpdate(task);
dbContext.SaveChanges();
}
if (this.DataUpdated != null)
{
this.DataUpdated(this, e);
}
this.Close();
}
private void cbIsDone_CheckedChanged_1(object sender, EventArgs e)
{
using (var dbContext = new TODOContext())
{
card.IsDone = cbIsDone.Checked;
card.UpdatedAt = DateTime.Now;
dbContext.Cards.AddOrUpdate(card);
dbContext.SaveChanges();
}
if (this.eventLoadData != null)
{
this.eventLoadData(this, e);
}
}
private void switchNoti_CheckedChanged(object sender, EventArgs e)
{
using (var dbContext = new TODOContext())
{
us.Noti = switchNoti.Checked;
dbContext.UserSettings.AddOrUpdate(us);
dbContext.SaveChanges();
}
if (switchNoti.Checked)
{
AlertForm af = new AlertForm();
af.setAlert("Notifications will be displayed here", AlertForm.alertTypeEnum.Info);
}
}
public IEnumerable <TODOItem> GetAllTasks()
{
IEnumerable <TODOItem> todos;
using (TODOContext db = new TODOContext())
{
//todos = (from todo in db.Todos
// select todo).ToList();
//todos = db.Todos.Select(i => i).ToList();
todos = db.Todos.ToList();
}
return(todos);
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (var dbContext = new TODOContext())
{
var cardInDb = dbContext.Cards.SingleOrDefault(i => i.Id == card.Id);
if (cardInDb != null)
{
dbContext.Cards.Remove(cardInDb);
dbContext.SaveChanges();
}
}
if (this.DataUpdated != null)
{
this.DataUpdated(this, e);
}
this.Close();
}
private void btnAddCmt_Click(object sender, EventArgs e)
{
Comment cmt = new Comment();
cmt.CardId = card.Id;
cmt.Content = tbCmtContent.Text;
using (var dbContext = new TODOContext())
{
dbContext.Comments.Add(cmt);
dbContext.SaveChanges();
}
if (CmtAdded != null)
{
CmtAdded(sender, e);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
using (var dbContext = new TODOContext())
{
card.Name = tbCardName.Text;
card.StartTime = dateStartTime.Value.Date + timeStartTime.Value.TimeOfDay;
card.EndTime = dateEndTime.Value.Date + timeEndTime.Value.TimeOfDay;
card.IsDone = cbIsDone.Checked;
card.Notification = switchNoti.Checked;
card.UpdatedAt = DateTime.Now;
dbContext.Cards.AddOrUpdate(card);
dbContext.SaveChanges();
}
if (this.DataUpdated != null)
{
this.DataUpdated(this, e);
}
this.Close();
}
private void loadData()
{
flpCards.Controls.Clear();
using (var dbContext = new TODOContext())
{
cards = dbContext.Cards.Where(c => c.BoardId == board.Id).ToList();
}
foreach (var card in cards)
{
UCCollection ucCollection = new UCCollection(card);
ucCollection.eventLoadData += new EventHandler(UCCard_LoadData);
ucCollection.ClickCard += new EventHandler <CardEventArgs>(UCCard_Click);
flpCards.Controls.Add(ucCollection);
}
UCAddCard ucAddCollection = new UCAddCard();
ucAddCollection.BtnAddClick += new EventHandler(UCAddList_btnAddClick);
flpCards.Controls.Add(ucAddCollection);
}
private void loadData()
{
flpListBoard.Controls.Clear();
using (var dbContext = new TODOContext())
{
boards = dbContext.Boards.ToList();
}
foreach (var board in boards)
{
UCBoard ucBoard = new UCBoard(board);
ucBoard.LoadData += new EventHandler(UCBoard_btnClick);
ucBoard.ClickBoard += new EventHandler <BoardEventArgs>(UCBoard_Click);
flpListBoard.Controls.Add(ucBoard);
}
UCAddBoard ucAddBoard = new UCAddBoard();
ucAddBoard.ButtonClick += new EventHandler(UCAddBoard_btnAddClick);
flpListBoard.Controls.Add(ucAddBoard);
}
private void switchStartWithWindow_CheckedChanged(object sender, EventArgs e)
{
if (switchStartWithWindow.Checked == true)
{
AutoStartup.AddApplicationToStartup();
}
else
{
AutoStartup.RemoveApplicationFromStartup();
}
using (var dbContext = new TODOContext())
{
us.StartWithWin = switchStartWithWindow.Checked;
dbContext.UserSettings.AddOrUpdate(us);
dbContext.SaveChanges();
}
if (switchStartWithWindow.Checked)
{
AlertForm af = new AlertForm();
af.setAlert("The application will start with Window", AlertForm.alertTypeEnum.Info);
}
}
public TodoController(TODOContext context)
{
this.context = context;
}
public BLLTodoList(TODOContext context)
{
this.context = context;
}
public UserDetailsController(TODOContext context, JwtSettings jwtSettings)
{
_context = context;
_jwtSettings = jwtSettings;
}
public TodoRepository(TODOContext context)
{
_context = context;
}
public UserController(TODOContext context, IMapper mapper)
{
this.context = context;
this.mapper = mapper;
}
public BLLUser(TODOContext context)
{
this.context = context;
}
public TODOTasksController(TODOContext context)
{
_context = context;
}
public SecurityManager(TODOContext context, JwtSettings jwtSettings)
{
_context = context;
_jwtSettings = jwtSettings;
}
public UserService(TODOContext context)
{
this.context = context;
}
public TodoService(TODOContext context)
{
this.context = context;
}
public TodoRepository(TODOContext db)
{
this.db = db;
}
