private void AddNewDriver_Click(object sender, RoutedEventArgs e)
        {
            AddNewDriver dlg = new AddNewDriver();

            dlg.conn = conn;
            dlg.mode = Mode.MODE_CREATE;
            dlg.ShowDialog();
        }
        private void EditDriver_Click(object sender, RoutedEventArgs e)
        {
            DriverSearch dlg = new DriverSearch();

            dlg.conn = conn;
            dlg.ShowDialog();
            if (dlg.idx != null)
            {
                AddNewDriver dlg2 = new AddNewDriver();
                dlg2.conn = conn;
                dlg2.mode = Mode.MODE_UPDATE;
                dlg2.idx  = dlg.idx.Value;
                dlg2.ShowDialog();
            }
        }
        private void AddDriver_Click(object sender, RoutedEventArgs e)
        {
            AddNewDriver dlg = new AddNewDriver();

            dlg.conn = conn;
            dlg.mode = Mode.MODE_CREATE;
            dlg.ShowDialog();

            try
            {
                SqlCeDataReader myReader = null;
                SqlCeCommand    command  = new SqlCeCommand("select DRV_COD, DRV_LICENSE, DRV_NAME from Driver", conn);
                myReader = command.ExecuteReader();
                while (myReader.Read())
                {
                    int    Code    = Convert.ToInt32(myReader["DRV_COD"].ToString());
                    string license = myReader["DRV_LICENSE"].ToString();
                    string name    = myReader["DRV_NAME"].ToString();
                    if (!dct_drivers.ContainsKey(license))
                    {
                        dct_drivers.Add(license, name);
                    }
                    if (!drivers.Contains(name))
                    {
                        drivers.Add(name);
                    }
                    if (!dct_drv_licen.ContainsKey(license))
                    {
                        dct_drv_licen.Add(license, Code);
                    }
                }
                myReader.Close();
                myReader.Dispose();
                comboBox1.ItemsSource = drivers;
            }
            catch (System.Exception ex)
            {
                log.Error(ex);
            }
        }