private void frmLocations_Load(object sender, EventArgs e)
        {
            cboSortSearch.Items.Add(new ComboBoxItem { Text = "Location ID", Value = "LocationID" });
            cboSortSearch.Items.Add(new ComboBoxItem { Text = "Location Description", Value = "Description" });
            cboSortSearch.SelectedIndex = 0;

            dgvLocations.AutoGenerateColumns = false;
            dgvLocations.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

            switch (FormMode)
            {
                case FormMode.Edit:
                    dgvLocations.ReadOnly = false;
                    this.WindowState = FormWindowState.Maximized;
                    db = new CalibrationDb();
                    break;
                case FormMode.Select:
                    dgvLocations.ReadOnly = true;
                    dgvLocations.AllowUserToAddRows = false;
                    btnSave.Visible = false;
                    break;
            }

            db.Locations.Load();
            GetLocations();
        }
 private void btnRefresh_Click(object sender, EventArgs e)
 {
     db = new CalibrationDb();
     db.CheckFixtures.Load();
     GetFixtures();
 }
 private void btnRefresh_Click(object sender, EventArgs e)
 {
     db = new CalibrationDb();
     db.Instruments.Load();
     GetInstruments();
 }
        private void frmFixtures_Load(object sender, EventArgs e)
        {
            cboSortSearch.Items.Add(new ComboBoxItem { Text = "Fixture ID", Value = "CheckFixtureID" });
            cboSortSearch.Items.Add(new ComboBoxItem { Text = "Fixture Description", Value = "Description" });
            cboSortSearch.SelectedIndex = 0;

            dgvFixtures.AutoGenerateColumns = false;
            dgvFixtures.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

            this.WindowState = FormWindowState.Maximized;

            db = new CalibrationDb();
            db.CheckFixtures.Load();
            GetFixtures();
        }
        private void frmInstruments_Load(object sender, EventArgs e)
        {
            cboSortSearch.Items.Add(new ComboBoxItem { Text = "Instrument ID", Value = "InstrumentID" });
            cboSortSearch.Items.Add(new ComboBoxItem { Text = "Instrument Description", Value = "Description" });
            cboSortSearch.Items.Add(new ComboBoxItem { Text = "Serial Number", Value = "SerialNumber" });
            cboSortSearch.SelectedIndex = 0;

            dgvInstruments.AutoGenerateColumns = false;
            dgvInstruments.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

            switch (FormMode)
            {
                case FormMode.Edit:
                    dgvInstruments.ReadOnly = false;
                    DataGridViewTextBoxColumn objProcedureColumn = new DataGridViewTextBoxColumn { HeaderText = "Procedure", Name = "txtProcedureColumn", DataPropertyName = "Procedure" };
                    dgvInstruments.Columns.Insert(8, objProcedureColumn);
                    DataGridViewCheckBoxColumn objOutOfServiceColumn = new DataGridViewCheckBoxColumn { HeaderText = "Out Of Service", Name = "chkOutOfServiceColumn", DataPropertyName = "OutOfService" };
                    dgvInstruments.Columns.Insert(9, objOutOfServiceColumn);
                    CalendarColumn objOutOfServiceDateColumn = new CalendarColumn { HeaderText = "Out Of Service Date", Name = "dtpOutOfServiceDateColumn", DataPropertyName = "OutOfServiceDate", SortMode = DataGridViewColumnSortMode.Automatic };
                    dgvInstruments.Columns.Insert(10, objOutOfServiceDateColumn);

                    this.WindowState = FormWindowState.Maximized;
                    db = new CalibrationDb();
                    break;
                case FormMode.Select:
                    btnSave.Visible = false;
                    btnRefresh.Visible = false;
                    dgvInstruments.ReadOnly = true;
                    break;
            }

            db.Instruments.Load();
            GetInstruments();
        }