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!"); } }