//Выполняется при загрузке формы, заполнение таблиц данными из БД, настройка элементов управления private void Services_Load(object sender, EventArgs e) { try { formDescriptor = this; reconnectBtn.Font = new Font(reconnectBtn.Font.Name, 10, FontStyle.Regular | FontStyle.Underline); servicesTable.RowsDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#f1f2f6"); servicesTable.AlternatingRowsDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#ffffff"); groupsTable.RowsDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#f1f2f6"); groupsTable.AlternatingRowsDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#ffffff"); DBConnection.GetServicesGroups(); groupsTable.DataSource = DBConnection.dtServicesGroups; if (groupsTable.Rows.Count > 0) { groupsTable.Rows[0].Selected = true; ReadGroupsTableRow(0); } DBConnection.GetServicesInGroup(serviceGroupID); servicesTable.DataSource = DBConnection.dtServicesInGroup; if (servicesTable.Rows.Count > 0) { servicesTable.Rows[0].Selected = true; ReadServicesTableRow(0); } } catch (Exception ex) { exceptPanel.Visible = true; richTextBox1.Text = ex.ToString(); } }
//Удаление выбранной группы услуг private void delGroupBtn_Click(object sender, EventArgs e) { try { if (groupsTable.Rows.Count == 0) { MessageBox.Show("Нет записей для удаления!"); return; } DialogResult result = MessageBox.Show("Подтвердите удаление.", "Удаление", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); //диалоговое окно if (result == DialogResult.OK) { DBConnection.DeleteServiceGroup(serviceGroupID); DBConnection.GetServicesGroups(); groupsTable.DataSource = DBConnection.dtServicesGroups; if (DBConnection.dtServicesGroups.Rows.Count > 0) { ReadGroupsTableRow(0); } } } catch (Exception ex) { exceptPanel.Visible = true; richTextBox1.Text = ex.ToString(); } }
//Редактирование группы услуг, обновление данных в связанных таблицах private void saveServicesGroupBtn_Click(object sender, EventArgs e) { try { if (name.Text == "") { MessageBox.Show("Заполните все поля!"); return; } DBConnection.EditServiceGroup(Services.serviceGroupID, name.Text); DBConnection.GetServicesGroups(); Services.formDescriptor.groupsTable.DataSource = DBConnection.dtServicesGroups; Services.ReadGroupsTableRow(0); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
//Происходит при загрузке формы, настройка элементов управления private void AddServiceToRequest_Load(object sender, EventArgs e) { try { DBConnection.GetServices(); DBConnection.GetServicesGroups(); servicesGroup.DataSource = DBConnection.dtServicesGroups; servicesGroup.DisplayMember = "Наименование"; servicesGroup.ValueMember = "ID"; DBConnection.GetServicesInGroup(servicesGroup.SelectedValue.ToString()); service.DataSource = DBConnection.dtServicesInGroup; service.DisplayMember = "Название"; service.ValueMember = "id"; dateStart.Value = Convert.ToDateTime("2018-12-19"); dateEnd.Value = Convert.ToDateTime("2019-01-19"); calculate_cost_and_display(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }