Ejemplo n.º 1
0
 private void upd_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         int   index = int.Parse(datgrid.SelectedIndex.ToString());
         CTest DabGr = (CTest)datgrid.SelectedItem;
         var   data  = new CTest {
             Number = int.Parse(Numb_Copy.Text.ToString()), FIO = FIO_Copy.Text.ToString(), Phy = int.Parse(Phy_Copy.Text.ToString()), Math = int.Parse(Math_Copy.Text.ToString())
         };
         string        sql     = ("UPDATE Tabl SET Number=" + int.Parse(Numb_Copy.Text.ToString()) + ", FIO= '" + FIO_Copy.Text.ToString() + "', Phy=" + int.Parse(Phy_Copy.Text.ToString()) + ", Math=" + int.Parse(Math_Copy.Text.ToString()) + " WHERE Number = " + DabGr.Number.ToString());
         SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
         command.ExecuteNonQuery();
         datgrid.Items.RemoveAt(index);
         datgrid.Items.Insert(index, data);
     }
     catch
     {
         Err.Content           = "ОШИБКА: Такой номер (" + Numb_Copy.Text.ToString() + ") уже существует";
         datgrid.SelectedIndex = -1;
     }
     Math_Copy.Text      = "";  Phy_Copy.Text = ""; FIO_Copy.Text = ""; Numb_Copy.Text = "";
     Del.IsEnabled       = false;
     Numb_Copy.IsEnabled = false;
     FIO_Copy.IsEnabled  = false;
     Math_Copy.IsEnabled = false;
     Phy_Copy.IsEnabled  = false;
     upd.IsEnabled       = false;
 }
Ejemplo n.º 2
0
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();

            dlg.ShowDialog();

            string db_name = dlg.FileName;

            m_dbConnection = new SQLiteConnection("Data Source=" + db_name + ";Version=3;");
            m_dbConnection.Open();

            string           sql     = "SELECT * FROM Tabl ORDER BY Number";
            SQLiteCommand    command = new SQLiteCommand(sql, m_dbConnection);
            SQLiteDataReader reader  = command.ExecuteReader();

            while (reader.Read())
            {
                var data = new CTest {
                    Number = int.Parse(reader["Number"].ToString()), FIO = reader["FIO"].ToString(), Phy = int.Parse(reader["Phy"].ToString()), Math = int.Parse(reader["Math"].ToString())
                };
                datgrid.Items.Add(data);
            }
            AddBut.IsEnabled  = true;
            Numb.IsEnabled    = true;
            FIO.IsEnabled     = true;
            Math.IsEnabled    = true;
            Phy.IsEnabled     = true;
            datgrid.IsEnabled = true;
        }
Ejemplo n.º 3
0
        private void Del_Click(object sender, RoutedEventArgs e)
        {
            CTest         DabGr   = (CTest)datgrid.SelectedItem;
            string        sql     = ("DELETE FROM Tabl WHERE(Number=" + DabGr.Number.ToString() + " AND FIO = '" + DabGr.FIO.ToString() + "'" + " AND Phy = " + DabGr.Phy.ToString() + " And Math = " + DabGr.Math.ToString() + ")");
            SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);

            command.ExecuteNonQuery();
            datgrid.Items.RemoveAt(int.Parse(datgrid.SelectedIndex.ToString()));
            Del.IsEnabled       = false;
            Numb_Copy.IsEnabled = false;
            FIO_Copy.IsEnabled  = false;
            Math_Copy.IsEnabled = false;
            Phy_Copy.IsEnabled  = false;
            upd.IsEnabled       = false;
        }
Ejemplo n.º 4
0
        private void datgrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (datgrid.SelectedIndex > -1)
            {
                CTest DaT = (CTest)datgrid.SelectedItem;
                Err.Content    = "";
                Math_Copy.Text = DaT.Math.ToString(); Phy_Copy.Text = DaT.Phy.ToString(); FIO_Copy.Text = DaT.FIO.ToString(); Numb_Copy.Text = DaT.Number.ToString();

                Del.IsEnabled       = true;
                Numb_Copy.IsEnabled = true;
                FIO_Copy.IsEnabled  = true;
                Math_Copy.IsEnabled = true;
                Phy_Copy.IsEnabled  = true;
                upd.IsEnabled       = true;
            }
        }
Ejemplo n.º 5
0
 private void Button_Click_1(object sender, RoutedEventArgs e)
 {
     try
     {
         string        sql     = "INSERT INTO Tabl (Number,FIO,Phy,Math) VALUES (" + Numb.Text.ToString() + ",'" + FIO.Text.ToString() + "'," + Phy.Text.ToString() + "," + Math.Text.ToString() + ")";
         SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
         var           data    = new CTest {
             Number = int.Parse(Numb.Text.ToString()), FIO = FIO.Text.ToString(), Phy = int.Parse(Phy.Text.ToString()), Math = int.Parse(Math.Text.ToString())
         };
         datgrid.Items.Add(data);
         command.ExecuteNonQuery();
         Numb.Text = "";
         FIO.Text  = "";
         Phy.Text  = "";
         Math.Text = "";
         //string sql = "SELECT Number FROM Table ORDER BY int_field DESC LIMIT 1";
     }
     catch
     {
         Err.Content = "ОШИБКА: Такой номер (" + Numb.Text.ToString() + ") уже существует";
     }
 }