private void btnRemove_Click(object sender, EventArgs e)
{
using (var dbn = new DBNormalTaskModel())
{
dgTaskListNormal.Rows.Clear();
var query = from x in dbn.NormalTaskDBs where x.userID == lblName.Text select x;
foreach (var item in query)
{
if (item.TaskName == dgTaskListNormal.CurrentCell.ToString())
{
dbn.NormalTaskDBs.Remove(item);
}
}
}
using (var dbi = new DBImportantTaskModel())
{
dgTaskListNormal.Rows.Clear();
var query = from y in dbi.ImportantTaskDBs where y.userID == lblName.Text select y;
foreach (var item in query)
{
if (item.TaskName == dgTaskListImportant.CurrentCell.ToString())
{
dbi.ImportantTaskDBs.Remove(item);
}
}
}
}
private void btnRemoveImportant_Click(object sender, EventArgs e)
{
using (var db = new DBImportantTaskModel())
{
db.ImportantTaskDBs.RemoveRange(db.ImportantTaskDBs.Where(item => item.TaskName == tbTaskName.Text));
db.SaveChanges();
MessageBox.Show("Tugas important berhasil dihapus");
this.Close();
}
}
private void Update()
{
using (var dbn = new DBNormalTaskModel())
{
var query = from x in dbn.NormalTaskDBs where x.userID == lblName.Text select x;
foreach (var item in query)
{
dgTaskListNormal.Rows.Add(item.TaskName, item.Deadline, item.PriorityLevel, item.IsDone);
}
}
using (var dbi = new DBImportantTaskModel())
{
var query = from y in dbi.ImportantTaskDBs where y.userID == lblName.Text select y;
foreach (var item in query)
{
dgTaskListImportant.Rows.Add(item.TaskName, item.Deadline, item.PriorityLevel, item.IsDone);
}
}
}
private void TambahImportantTask()
{
using (var db = new DBImportantTaskModel())
if (tbTaskName.Text != "" && dtpDeadline.Text != "")
{
int prioLevel;
DateTime deadline = DateTime.Parse(dtpDeadline.Text);
if (cbPriorityLevel.Text == "Important 1")
{
prioLevel = 1;
}
else if (cbPriorityLevel.Text == "Important 2")
{
prioLevel = 2;
}
else
{
prioLevel = 3;
}
ImportantTaskDB newImportantTask = new ImportantTaskDB
{
TaskName = tbTaskName.Text,
Deadline = deadline,
PriorityLevel = cbPriorityLevel.Text,
PrioLev = prioLevel,
userID = lblName.Text
};
db.ImportantTaskDBs.Add(newImportantTask);
db.SaveChanges();
MessageBox.Show("Important task baru sudah dibuat!");
Close();
}
else
{
MessageBox.Show("Masukkan nama task!");
}
}
