Ejemplo n.º 1
0
        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;
        }
Ejemplo n.º 2
0
        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;
        }
Ejemplo n.º 3
0
        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;
        }
Ejemplo n.º 4
0
        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;
        }
Ejemplo n.º 5
0
        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();
                }
            }
        }
Ejemplo n.º 6
0
        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;
        }
Ejemplo n.º 7
0
        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;
        }
Ejemplo n.º 8
0
        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;
        }
Ejemplo n.º 9
0
        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;
        }
Ejemplo n.º 10
0
        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;
        }
Ejemplo n.º 11
0
        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;
        }
Ejemplo n.º 12
0
        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;
        }
Ejemplo n.º 13
0
        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;
        }
Ejemplo n.º 15
0
        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;
        }
Ejemplo n.º 16
0
        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();
             * }*/
        }
Ejemplo n.º 17
0
        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;
        }
Ejemplo n.º 18
0
        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];
            }
        }
Ejemplo n.º 19
0
        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;
        }
Ejemplo n.º 21
0
        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];
            }
        }
Ejemplo n.º 22
0
        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;
        }
Ejemplo n.º 25
0
        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;
        }
Ejemplo n.º 26
0
        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();
            }
        }
Ejemplo n.º 29
0
        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];
            }
        }
Ejemplo n.º 30
0
        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";
        }