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();
        }
Ejemplo n.º 2
0
 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");
     }
 }