private void btnStart_Click(object sender, RoutedEventArgs e) { using (llblanca_lara1Entities db = new llblanca_lara1Entities()) { tasks task = new tasks { project_id = _projectId, name = txtName.Text, description = txtDescription.Text, created_at = DateTime.Now, status = txtStatus.Text, start = Convert.ToDateTime(txtStart.Text), end = Convert.ToDateTime(txtEnd.Text) }; try { db.tasks.Add(task); db.SaveChanges(); task_user taskUser = new task_user() { created_at = DateTime.Now, id_task = task.id, id_user = _userId }; db.task_user.Add(taskUser); db.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } this.Close(); }
private void btnRemoveTask_Click(object sender, RoutedEventArgs e) { try { int taskId = Convert.ToInt32(taskTest[1].TrimStart(' ')); MessageBoxResult result = MessageBox.Show($"Вы точно уверены, что хотите удалить проект {taskTest[3].TrimStart(' ')}?", "Delete", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { using (llblanca_lara1Entities db = new llblanca_lara1Entities()) { tasks t = db.tasks.Where(p => p.id == taskId).FirstOrDefault(); task_user tas = db.task_user.Where(ts => ts.id_task == t.id).FirstOrDefault(); if (tas != null) { db.task_user.Remove(tas); db.SaveChanges(); } db.tasks.Remove(t); db.SaveChanges(); MessageBox.Show($"Task {taskTest[3].TrimStart(' ')} is delete"); } } else { return; } } catch (Exception ex) { MessageBox.Show("Task is not selected"); } }