private void AddTask_Loaded(object sender, RoutedEventArgs e) { if (taskID == 0) { typeList = new List <string>() { "Анализ и проектирование", "Установка оборудования", "Техническое обслуживание и сопровождение" }; TypeCB.ItemsSource = typeList; StatusTB.Text = "Запланирована"; } else { NameField.IsReadOnly = true; DescTB.IsReadOnly = true; ComplexityField.IsReadOnly = true; NeedTime.IsReadOnly = true; AddBtn.IsEnabled = false; } MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); try { if (taskID == 0) { List <string> perfList = new List <string>(); dbHandler db = new dbHandler(); executors = db.GetExecutors(conn, id); foreach (KeyValuePair <int, string> keyValue in executors) { perfList.Add(keyValue.Value); } PerfCB.ItemsSource = perfList; } else { GetTask(conn, taskID); } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } finally { conn.Close(); conn.Dispose(); } }
private void SalaryBtn_Click(object sender, RoutedEventArgs e) { MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); try { dbHandler db = new dbHandler(); coeffList = db.GetCoefficients(conn, id); executors = db.GetExecutors(conn, id); GetSalary(conn); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } finally { conn.Close(); conn.Dispose(); } }
private void Manager_Loaded(object sender, RoutedEventArgs e) { LoginLabel.Content = "Ваш логин: " + login; FullNameLabel.Content = "ФИО Менеджера: " + fullName; var statusList = new List <string>() { "Любой статус", "Запланирована", "Выполняется", "Завершена", "Отменена" }; StatusCB.ItemsSource = statusList; MySqlConnection conn = DBUtils.GetDBConnection(); conn.Open(); try { dbHandler db = new dbHandler(); executors = db.GetExecutors(conn, id); ExecutorsCB.Items.Add("Все исполнители"); foreach (KeyValuePair <int, string> keyValue in executors) { ExecutorsCB.Items.Add(keyValue.Value); } GetTasks(conn); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } finally { conn.Close(); conn.Dispose(); } }