private void Add_button_Click(object sender, EventArgs e) { dataSet = BusinessLogic.ReadTransmissions(); AddEditTransmissionForm AddTransmission = new AddEditTransmissionForm(dataSet.Transmissions, null); AddTransmission.Text = "Добавление трансмиссии"; this.Enabled = false; AddTransmission.ShowDialog(); if (AddTransmission.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteTransmissions(dataSet); ReloadTransmissions(); } this.Enabled = true; }
private void Add_button_Click(object sender, EventArgs e) { dataSet = BusinessLogic.ReadAuditoriums(); AddEditAuditoriumsForm AddAuditorium = new AddEditAuditoriumsForm(dataSet.Auditoriums, null); AddAuditorium.Text = "Добавление аудитории"; this.Enabled = false; AddAuditorium.ShowDialog(); if (AddAuditorium.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteAuditoriums(dataSet); ReloadAuditoriums(); } this.Enabled = true; }
private void Add_button_Click(object sender, EventArgs e) { dataSet = BusinessLogic.ReadCarriersStatuses(); AddEditCarriersStatusesForm AddCarriersStatus = new AddEditCarriersStatusesForm(dataSet.CarriersStatuses, null); AddCarriersStatus.Text = "Добавление статуса ТС"; this.Enabled = false; AddCarriersStatus.ShowDialog(); if (AddCarriersStatus.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteCarriersStatuses(dataSet); ReloadCarriersStatuses(); } this.Enabled = true; }
private void Add_button_Click(object sender, EventArgs e) { ReloadGroups(); AddEditGroupForm AddGroup = new AddEditGroupForm(dataSet.Groups, dataSet.Categories, dataSet.TheoryTeachers, null); AddGroup.Text = "Добавление группы"; this.Enabled = false; AddGroup.ShowDialog(); if (AddGroup.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteGroups(dataSet); ReloadGroups(); } this.Enabled = true; }
private void Delete_button_Click(object sender, EventArgs e) { LastSelectionIndex = -1; if (Workers_dataGridView.SelectedRows.Count != 1) { MessageBox.Show("Не выбрана строка для удаления", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } DialogResult result = MessageBox.Show("Вы действительно хотите удалить выбранную запись?", "Подтверждение удаления", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { try { int ID = Convert.ToInt32(Workers_dataGridView.SelectedRows[0].Cells["ID"].Value); string Post = Workers_dataGridView.SelectedRows[0].Cells["PostColumn"].Value.ToString(); if (Post == "преподаватель теории") { AutoschoolDataSet TempDataSet = new AutoschoolDataSet(); TempDataSet = BusinessLogic.ReadTheoryTeacherByID(ID); dataSet.TheoryTeachers.Rows.Find(TempDataSet.TheoryTeachers.Rows[0][0].ToString()).Delete(); dataSet = BusinessLogic.WriteTheoryTeachers(dataSet); ReloadWorkers(); } else if (Post == "инструктор") { AutoschoolDataSet TempDataSet = new AutoschoolDataSet(); TempDataSet = BusinessLogic.ReadInstructorByID(ID); dataSet.Instructors.Rows.Find(TempDataSet.Instructors.Rows[0][0].ToString()).Delete(); dataSet = BusinessLogic.WriteInstructors(dataSet); ReloadWorkers(); } else if (Post == "мастер сервиса") { AutoschoolDataSet TempDataSet = new AutoschoolDataSet(); TempDataSet = BusinessLogic.ReadServiceMasterByID(ID); dataSet.ServiceMasters.Rows.Find(TempDataSet.ServiceMasters.Rows[0][0].ToString()).Delete(); dataSet = BusinessLogic.WriteServiceMasters(dataSet); ReloadWorkers(); } } catch { MessageBox.Show("Не удалось удалить выбранную строку.\nСкорее всего, на данную строку имеются ссылки из других таблиц", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); ReloadWorkers(); } } }
private void Edit_button_Click(object sender, EventArgs e) { dataSet = BusinessLogic.ReadWorkStatuses(); LastSelectionIndex = WorkStatuses_dataGridView.SelectedRows[0].Index; AddEditWorkStatusesForm EditWorkStatus = new AddEditWorkStatusesForm(dataSet.WorkStatuses, dataSet.WorkStatuses.Rows.Find(WorkStatuses_dataGridView.SelectedRows[0].Cells["ID"].Value)); EditWorkStatus.Text = "Редактирование рабочего статуса"; this.Enabled = false; EditWorkStatus.ShowDialog(); if (EditWorkStatus.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteWorkStatuses(dataSet); ReloadWorkStatuses(); } this.Enabled = true; }
private void Edit_button_Click(object sender, EventArgs e) { dataSet = BusinessLogic.ReadAuditoriums(); LastSelectionIndex = Auditoriums_dataGridView.SelectedRows[0].Index; AddEditAuditoriumsForm EditAuditorium = new AddEditAuditoriumsForm(dataSet.Auditoriums, dataSet.Auditoriums.Rows.Find(Auditoriums_dataGridView.SelectedRows[0].Cells["ID"].Value)); EditAuditorium.Text = "Редактирование аудитории"; this.Enabled = false; EditAuditorium.ShowDialog(); if (EditAuditorium.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteAuditoriums(dataSet); ReloadAuditoriums(); } this.Enabled = true; }
private void Edit_button_Click(object sender, EventArgs e) { LastSelectionIndex = Groups_dataGridView.SelectedRows[0].Index; ReloadGroups(); AddEditGroupForm EditGroup = new AddEditGroupForm(dataSet.Groups, dataSet.Categories, dataSet.TheoryTeachers, dataSet.Groups.Rows.Find(Groups_dataGridView.SelectedRows[0].Cells["ID"].Value)); EditGroup.Text = "Редактирование группы"; this.Enabled = false; EditGroup.ShowDialog(); if (EditGroup.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteGroups(dataSet); ReloadGroups(); } this.Enabled = true; }
private void Add_button_Click(object sender, EventArgs e) { ReloadCarriers(); AddEditCarrierForm AddCarrier = new AddEditCarrierForm(dataSet.Carriers, dataSet.Categories, dataSet.CarriersStatuses, dataSet.Transmissions, null); AddCarrier.Text = "Добавление ТС"; this.Enabled = false; AddCarrier.ShowDialog(); if (AddCarrier.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteCarriers(dataSet); ReloadCarriers(); } this.Enabled = true; }
private void Add_button_Click(object sender, EventArgs e) { ReloadCarriersRepairs(); AddEditCarrierRepairForm AddCarrierRepair = new AddEditCarrierRepairForm(dataSet.CarriersRepairs, dataSet.ServiceMasters, dataSet.Carriers, null); AddCarrierRepair.Text = "Добавление ремонта ТС"; this.Enabled = false; AddCarrierRepair.ShowDialog(); if (AddCarrierRepair.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteCarriersRepairs(dataSet); ReloadCarriersRepairs(); } this.Enabled = true; }
private void Add_button_Click(object sender, EventArgs e) { ReloadCarriersUses(); AddEditCarrierUseForm AddCarrierUse = new AddEditCarrierUseForm(dataSet.CarriersUses, dataSet.Instructors, dataSet.Carriers, null); AddCarrierUse.Text = "Добавление ТС инструктору"; this.Enabled = false; AddCarrierUse.ShowDialog(); if (AddCarrierUse.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteCarriersUses(dataSet); ReloadCarriersUses(); } this.Enabled = true; }
private void Edit_button_Click(object sender, EventArgs e) { dataSet = BusinessLogic.ReadTransmissions(); LastSelectionIndex = Transmissions_dataGridView.SelectedRows[0].Index; AddEditTransmissionForm EditTransmission = new AddEditTransmissionForm(dataSet.Transmissions, dataSet.Transmissions.Rows.Find(Transmissions_dataGridView.SelectedRows[0].Cells["ID"].Value)); EditTransmission.Text = "Редактирование трансмиссии"; this.Enabled = false; EditTransmission.ShowDialog(); if (EditTransmission.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteTransmissions(dataSet); ReloadTransmissions(); } this.Enabled = true; }
private void Edit_button_Click(object sender, EventArgs e) { dataSet = BusinessLogic.ReadCategories(); LastSelectionIndex = Categories_dataGridView.SelectedRows[0].Index; AddEditCategoryForm EditCategory = new AddEditCategoryForm(dataSet.Categories, dataSet.Categories.Rows.Find(Categories_dataGridView.SelectedRows[0].Cells["ID"].Value)); EditCategory.Text = "Редактирование категории"; this.Enabled = false; EditCategory.ShowDialog(); if (EditCategory.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteCategories(dataSet); ReloadCategories(); } this.Enabled = true; }
private void AddReplacement_button_Click(object sender, EventArgs e) { AutoschoolDataSet dataSet = BusinessLogic.ReadReplacementsCarriers(); AddReplacementFromNeedsReplacementForm AddReplacementCarrier = new AddReplacementFromNeedsReplacementForm(dataSet.ReplacementsCarriers, dataSet.CarriersUses, dataSet.Carriers, dataSet.Instructors, CarriersToReplacement_dataGridView.SelectedRows[0]); AddReplacementCarrier.Text = "Добавление замены ТС инструктора"; this.Enabled = false; AddReplacementCarrier.ShowDialog(); if (AddReplacementCarrier.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteReplacementsCarriers(dataSet); Get_button_Click(sender, e); } this.Enabled = true; }
private void Add_button_Click(object sender, EventArgs e) { ReloadInstructorsCategories(); AddEditInstructorsCategoriesForm AddInstructorCategory = new AddEditInstructorsCategoriesForm(dataSet.InstructorsCategories, dataSet.Instructors, dataSet.Categories, null); AddInstructorCategory.Text = "Добавление категории инструктору"; this.Enabled = false; AddInstructorCategory.ShowDialog(); if (AddInstructorCategory.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteInstructorsCategories(dataSet); ReloadInstructorsCategories(); } this.Enabled = true; }
void InstructorChanged() { if (Instructor_comboBox.SelectedIndex != -1 && FormLoad && GroupSelected) { // отбираем ТС, прикрепленные к выбранному инструктору ChoosenInstructor_label.Text = Instructor_comboBox.Text; SelectedInstructorID = Convert.ToInt32(Instructor_comboBox.SelectedValue); dataSetForCarriersUses = BusinessLogic.ReadCarriersUsesByInstructorID(Convert.ToInt32(Instructor_comboBox.SelectedValue)); carriersUsesDataTable = dataSetForCarriersUses.CarriersUses; // получаем категорию, на которую обучается группа int CategoryID = groupsDataTable[Group_comboBox.SelectedIndex].Category; CarriersUses_dataGridView.Rows.Clear(); // добавляем в таблицу только те ТС, категория которых соответствует категории обучения группы for (int i = 0; i < carriersUsesDataTable.Rows.Count; i++) { if (Convert.ToInt32(carriersUsesDataTable[i][5]) == CategoryID) { CarriersUses_dataGridView.Rows.Add(carriersUsesDataTable[i][3], carriersUsesDataTable[i][4], carriersUsesDataTable[i][1], carriersUsesDataTable[i][2], carriersUsesDataTable[i][0]); } } if (carriersUsesDataTable.Rows.Count == 0) { MessageBox.Show("У выбранного инструктора отсутствуют прикрепленные ТС. \nДо тех пор, пока инструктору не будет прикреплено хотя бы одно ТС, работа с ним будет невозможна.", "Ошибка"); } else if (CarriersUses_dataGridView.RowCount == 0) { MessageBox.Show("У выбранного инструктора отсутствуют прикрепленные ТС той категории, на которую обучается группа, выбранная курсанту. \nДо тех пор, пока инструктору не будет прикреплено хотя бы одно ТС соответствующей категории, работа с ним в этой группе будет невозможна.", "Ошибка"); } ChangeSelectedCarrier(); } else { CarriersUses_dataGridView.Rows.Clear(); ChoosenInstructor_label.Text = ""; SelectedInstructorID = -1; } /*ChoosenCarrier_label.Text = ""; * SelectedCarrierID = -1; * SelectedCarrierUseID = -1; * if (CarriersUses_dataGridView.RowCount == 1) * { * CarriersUses_dataGridView.Rows[0].Selected = true; * ChangeSelectedCarrier(); * }*/ }
private void Edit_button_Click(object sender, EventArgs e) { LastSelectionIndex = Carriers_dataGridView.SelectedRows[0].Index; ReloadCarriers(); AddEditCarrierForm EditCarrier = new AddEditCarrierForm(dataSet.Carriers, dataSet.Categories, dataSet.CarriersStatuses, dataSet.Transmissions, dataSet.Carriers.Rows.Find(Carriers_dataGridView.SelectedRows[0].Cells["ID"].Value)); EditCarrier.Text = "Редактирование ТС"; this.Enabled = false; EditCarrier.ShowDialog(); if (EditCarrier.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteCarriers(dataSet); ReloadCarriers(); } this.Enabled = true; }
void ReloadTransmissions() { dataSet = BusinessLogic.ReadTransmissions(); Transmissions_dataGridView.DataSource = dataSet; Transmissions_dataGridView.DataMember = "Transmissions"; Transmissions_dataGridView.Columns["ID"].Visible = false; Transmissions_dataGridView.Columns["Transmission"].Visible = false; IDColumn.DataPropertyName = "ID"; NameColumn.DataPropertyName = "Transmission"; if (LastSelectionIndex != -1) { Transmissions_dataGridView.CurrentCell = Transmissions_dataGridView[1, LastSelectionIndex]; } }
private void Add_button_Click(object sender, EventArgs e) { dataSet = BusinessLogic.ReadWorkers(); AddEditWorkerForm AddWorker = new AddEditWorkerForm(null, null, dataSet.WorkStatuses, dataSet); AddWorker.Text = "Добавление сотрудника"; this.Enabled = false; AddWorker.ShowDialog(); if (AddWorker.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteTheoryTeachers(dataSet); dataSet = BusinessLogic.WriteInstructors(dataSet); dataSet = BusinessLogic.WriteServiceMasters(dataSet); ReloadWorkers(); } this.Enabled = true; }
private void Add_button_Click(object sender, EventArgs e) { ReloadReplacementsCarriers(); //dataSet = BusinessLogic.ReadReplacementsCarriers(); AddEditReplacementCarrierForm AddReplacementCarrier = new AddEditReplacementCarrierForm(dataSet.ReplacementsCarriers, dataSet.CarriersUses, dataSet.Carriers, dataSet.Instructors, null); AddReplacementCarrier.Text = "Добавление замены ТС инструктора"; this.Enabled = false; AddReplacementCarrier.ShowDialog(); if (AddReplacementCarrier.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteReplacementsCarriers(dataSet); ReloadReplacementsCarriers(); } this.Enabled = true; }
void ReloadAuditoriums() { dataSet = BusinessLogic.ReadAuditoriums(); Auditoriums_dataGridView.DataSource = dataSet; Auditoriums_dataGridView.DataMember = "Auditoriums"; Auditoriums_dataGridView.Columns["ID"].Visible = false; Auditoriums_dataGridView.Columns["Name"].Visible = false; IDColumn.DataPropertyName = "ID"; NameColumn.DataPropertyName = "Name"; if (LastSelectionIndex != -1) { Auditoriums_dataGridView.CurrentCell = Auditoriums_dataGridView[1, LastSelectionIndex]; } }
void ReloadCategories() { dataSet = BusinessLogic.ReadCategories(); Categories_dataGridView.DataSource = dataSet; Categories_dataGridView.DataMember = "Categories"; Categories_dataGridView.Columns["ID"].Visible = false; Categories_dataGridView.Columns["Name"].Visible = false; IDColumn.DataPropertyName = "ID"; NameColumn.DataPropertyName = "Name"; if (LastSelectionIndex != -1) { Categories_dataGridView.CurrentCell = Categories_dataGridView[1, LastSelectionIndex]; } }
void ReloadCarriers() { dataSetForCarriers = BusinessLogic.ReadCarriers(); Carriers_dataGridView.DataSource = dataSetForCarriers; Carriers_dataGridView.DataMember = "Carriers"; Carriers_dataGridView.Columns["ID"].Visible = false; Carriers_dataGridView.Columns["Brand"].Visible = false; Carriers_dataGridView.Columns["Model"].Visible = false; Carriers_dataGridView.Columns["StateNumber"].Visible = false; Carriers_dataGridView.Columns["Color"].Visible = false; Carriers_dataGridView.Columns["Transmission"].Visible = false; Carriers_dataGridView.Columns["Category"].Visible = false; Carriers_dataGridView.Columns["Status"].Visible = false; Carriers_dataGridView.Columns["FinalName"].Visible = false; IDColumn.DataPropertyName = "ID"; BrandColumn.DataPropertyName = "Brand"; ModelColumn.DataPropertyName = "Model"; StateNumberColumn.DataPropertyName = "StateNumber"; ColorColumn.DataPropertyName = "Color"; TransmissionColumn.DataSource = dataSetForCarriers.Transmissions; TransmissionColumn.DisplayMember = "Transmission"; TransmissionColumn.ValueMember = "ID"; TransmissionColumn.DataPropertyName = "Transmission"; CategoryColumn.DataSource = dataSetForCarriers.Categories; CategoryColumn.DisplayMember = "Name"; CategoryColumn.ValueMember = "ID"; CategoryColumn.DataPropertyName = "Category"; StatusColumn.DataSource = dataSetForCarriers.CarriersStatuses; StatusColumn.DisplayMember = "Name"; StatusColumn.ValueMember = "ID"; StatusColumn.DataPropertyName = "Status"; FinalNameColumn.DataPropertyName = "FinalName"; if (Carriers_dataGridView.RowCount == 1) { Carriers_dataGridView.Rows[0].Cells["BrandColumn"].Selected = true; ChangeSelectedCarrier(); } }
private void Edit_button_Click(object sender, EventArgs e) { LastSelectionIndexInPracticeLessons = PracticeLessonsOfStudent_dGV.SelectedRows[0].Index; dataSet = BusinessLogic.ReadPracticeLessons(); AddEditPracticeLessonForm EditPracticeLesson; EditPracticeLesson = new AddEditPracticeLessonForm(dataSet.PracticeLessons, dataSet.Students, null, dataSet.PracticeLessons.Rows.Find(PracticeLessonsOfStudent_dGV.SelectedRows[0].Cells["ID"].Value)); EditPracticeLesson.Text = "Редактирование практического занятия"; this.Enabled = false; EditPracticeLesson.ShowDialog(); if (EditPracticeLesson.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WritePracticeLessons(dataSet); ReloadPracticeLessonsNeedsForReplacement(); } this.Enabled = true; }
private void Edit_button_Click(object sender, EventArgs e) { LastSelectionIndex = CarriersUses_dataGridView.SelectedRows[0].Index; ReloadCarriersUses(); AddEditCarrierUseForm EditCarrierUse = new AddEditCarrierUseForm(dataSet.CarriersUses, dataSet.Instructors, dataSet.Carriers, dataSet.CarriersUses.Rows.Find(CarriersUses_dataGridView.SelectedRows[0].Cells["ID"].Value)); EditCarrierUse.Text = "Редактирование ТС инструктора"; this.Enabled = false; EditCarrierUse.ShowDialog(); if (EditCarrierUse.DialogResult == DialogResult.OK) { dataSet = BusinessLogic.WriteCarriersUses(dataSet); ReloadCarriersUses(); } this.Enabled = true; }
private void AddRepairSelectedCarrier_button_Click(object sender, EventArgs e) { AutoschoolDataSet TempDS = new AutoschoolDataSet(); TempDS = BusinessLogic.ReadCarriersRepairs(); AddRepairFromFormCarriersForm AddCarrierRepair = new AddRepairFromFormCarriersForm(TempDS.CarriersRepairs, TempDS.ServiceMasters, TempDS.Carriers, TempDS.Carriers.Rows.Find(Carriers_dataGridView.SelectedRows[0].Cells["ID"].Value)); this.Enabled = false; AddCarrierRepair.ShowDialog(); if (AddCarrierRepair.DialogResult == DialogResult.OK) { TempDS = BusinessLogic.WriteCarriersRepairs(TempDS); ReloadCarriers(); } this.Enabled = true; }
private void AddEditPracticeLessonForm_Load(object sender, EventArgs e) { SelectedStudent_comboBox.DataSource = studentsDataTable; SelectedStudent_comboBox.DisplayMember = "FIO"; SelectedStudent_comboBox.ValueMember = "ID"; SelectedStudent_comboBox.AutoCompleteMode = AutoCompleteMode.Append; SelectedStudent_comboBox.AutoCompleteSource = AutoCompleteSource.ListItems; FactDate_dateTimePicker.Checked = false; FactTime_dateTimePicker.Checked = false; if (dataRow != null) { SelectedStudent_comboBox.SelectedValue = dataRow["Student"].ToString(); AutoschoolDataSet TempDS = BusinessLogic.ReadStudentByID(Convert.ToInt32(SelectedStudent_comboBox.SelectedValue)); int GroupID = Convert.ToInt32(TempDS.Students[0][6].ToString()); Group_label.Text = BusinessLogic.ReadGroupByID(GroupID).Groups[0][1].ToString(); AppointedDate_dateTimePicker.Text = dataRow["AppointedDate"].ToString(); AppointedTime_dateTimePicker.Text = dataRow["AppointedTime"].ToString(); if (dataRow["FactDate"].ToString() != "01.01.0001 0:00:00") { FactDate_dateTimePicker.Text = dataRow["FactDate"].ToString(); FactDate_dateTimePicker.Checked = true; FactTime_dateTimePicker.Text = dataRow["FactTime"].ToString(); FactTime_dateTimePicker.Checked = true; } } else { if (SelectedStudent != null) { SelectedStudent_comboBox.SelectedValue = SelectedStudent["ID"].ToString(); Group_label.Text = BusinessLogic.ReadGroupByID(Convert.ToInt32(SelectedStudent["Group"].ToString())).Groups[0][1].ToString(); } else { SelectedStudent_comboBox.SelectedIndex = -1; } } FormLoad = true; }
void ReloadReplacingCarriers() { dataSetForReplacingCarriers = BusinessLogic.ReadCarriersByStatusName("Резерв"); ReplacingCarriers_dataGridView.DataSource = dataSetForReplacingCarriers; ReplacingCarriers_dataGridView.DataMember = "Carriers"; ReplacingCarriers_dataGridView.Columns["ID"].Visible = false; ReplacingCarriers_dataGridView.Columns["Brand"].Visible = false; ReplacingCarriers_dataGridView.Columns["Model"].Visible = false; ReplacingCarriers_dataGridView.Columns["StateNumber"].Visible = false; ReplacingCarriers_dataGridView.Columns["Color"].Visible = false; ReplacingCarriers_dataGridView.Columns["Transmission"].Visible = false; ReplacingCarriers_dataGridView.Columns["Category"].Visible = false; ReplacingCarriers_dataGridView.Columns["Status"].Visible = false; ReplacingCarriers_dataGridView.Columns["FinalName"].Visible = false; ID2Column.DataPropertyName = "ID"; Brand2Column.DataPropertyName = "Brand"; Model2Column.DataPropertyName = "Model"; StateNumber2Column.DataPropertyName = "StateNumber"; Color2Column.DataPropertyName = "Color"; Transmission2Column.DataSource = dataSetForReplacingCarriers.Transmissions; Transmission2Column.DisplayMember = "Transmission"; Transmission2Column.ValueMember = "ID"; Transmission2Column.DataPropertyName = "Transmission"; Category2Column.DataSource = dataSetForReplacingCarriers.Categories; Category2Column.DisplayMember = "Name"; Category2Column.ValueMember = "ID"; Category2Column.DataPropertyName = "Category"; Status2Column.DataSource = dataSetForReplacingCarriers.CarriersStatuses; Status2Column.DisplayMember = "Name"; Status2Column.ValueMember = "ID"; Status2Column.DataPropertyName = "Status"; if (ReplacingCarriers_dataGridView.RowCount == 1) { ReplacingCarriers_dataGridView.Rows[0].Cells["Brand2Column"].Selected = true; ChangeSelectedReplacingCarrier(); } }
void ReloadCarriers() { dataSet = BusinessLogic.ReadCarriers(); Carriers_dataGridView.DataSource = dataSet; Carriers_dataGridView.DataMember = "Carriers"; Carriers_dataGridView.Columns["ID"].Visible = false; Carriers_dataGridView.Columns["Brand"].Visible = false; Carriers_dataGridView.Columns["Model"].Visible = false; Carriers_dataGridView.Columns["StateNumber"].Visible = false; Carriers_dataGridView.Columns["Color"].Visible = false; Carriers_dataGridView.Columns["Transmission"].Visible = false; Carriers_dataGridView.Columns["Category"].Visible = false; Carriers_dataGridView.Columns["Status"].Visible = false; Carriers_dataGridView.Columns["FinalName"].Visible = false; IDColumn.DataPropertyName = "ID"; BrandColumn.DataPropertyName = "Brand"; ModelColumn.DataPropertyName = "Model"; StateNumberColumn.DataPropertyName = "StateNumber"; ColorColumn.DataPropertyName = "Color"; TransmissionColumn.DataSource = dataSet.Transmissions; TransmissionColumn.DisplayMember = "Transmission"; TransmissionColumn.ValueMember = "ID"; TransmissionColumn.DataPropertyName = "Transmission"; CategoryColumn.DataSource = dataSet.Categories; CategoryColumn.DisplayMember = "Name"; CategoryColumn.ValueMember = "ID"; CategoryColumn.DataPropertyName = "Category"; StatusColumn.DataSource = dataSet.CarriersStatuses; StatusColumn.DisplayMember = "Name"; StatusColumn.ValueMember = "ID"; StatusColumn.DataPropertyName = "Status"; if (LastSelectionIndex != -1) { Carriers_dataGridView.CurrentCell = Carriers_dataGridView[1, LastSelectionIndex]; } }
void ReloadServiceMasters() { dataSet = BusinessLogic.ReadServiceMasters(); ServiceMasters_dataGridView.DataSource = dataSet; ServiceMasters_dataGridView.DataMember = "ServiceMasters"; ServiceMasters_dataGridView.Columns["ID"].Visible = false; ServiceMasters_dataGridView.Columns["Surname"].Visible = false; ServiceMasters_dataGridView.Columns["FirstName"].Visible = false; ServiceMasters_dataGridView.Columns["PatronymicName"].Visible = false;; ServiceMasters_dataGridView.Columns["WorkStatus"].Visible = false; ServiceMasters_dataGridView.Columns["FIO"].Visible = false; ServiceMasters_dataGridView.Columns["WorkStatusName"].Visible = false; IDColumn.DataPropertyName = "ID"; SurnameColumn.DataPropertyName = "Surname"; FirstNameColumn.DataPropertyName = "FirstName"; PatronymicNameColumn.DataPropertyName = "PatronymicName"; WorkStatusColumn.DataPropertyName = "WorkStatusName"; }