コード例 #1
0
        private void picExit_Click(object sender, EventArgs e)
        {
            this.Close();
            GC.Collect();
            createWorkout createWorkout = new createWorkout();

            createWorkout.Visible = true;
            createWorkout.Visible = true;
        }
コード例 #2
0
 private void changeBtn_Click(object sender, EventArgs e) // Добавление обновленных данных о тренировке в базу данных
 {
     if (txtName.Text != "" && txtContent.Text != "" && txtPremiumWork.Text != "")
     {
         using (SqlConnection conn = new SqlConnection(@"Data Source=AYE\SQLEXPRESS;Initial Catalog=SmartWorkouts;Integrated Security=True"))
         {
             try
             {
                 conn.Open();
                 SqlCommand cmd   = conn.CreateCommand();
                 SqlCommand cmd_2 = conn.CreateCommand();
                 cmd_2.CommandText = "SELECT Number_Premium_Work FROM [Premium_Works] WHERE Name_Premium_Work = @name ";
                 cmd_2.Parameters.AddWithValue(@"name", txtPremiumWork.Text);
                 int premWork = Convert.ToInt32(cmd_2.ExecuteScalar());
                 cmd.CommandText = "UPDATE  [Workouts] SET Name_Workout =@Name,Description_Workout =@Content,Number_Premium_Workout = @PremiumWork WHERE ID_Workout =@id ";
                 cmd.Parameters.AddWithValue(@"id", WorkId);
                 cmd.Parameters.AddWithValue(@"Name", txtName.Text);
                 cmd.Parameters.AddWithValue(@"Content", txtContent.Text);
                 cmd.Parameters.AddWithValue(@"PremiumWork", premWork);
                 cmd.ExecuteNonQuery();
                 MessageBox.Show("Запись успешно изменена!");
                 createWorkout createWorkout = new createWorkout();
                 createWorkout.Visible       = true;
                 createWorkout.ShowInTaskbar = true;
                 this.Close();
                 GC.Collect();
             }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.ToString());
             }
             finally
             {
                 conn.Close();
             }
         }
     }
     else
     {
         MessageBox.Show("Введите данные!");
     }
 }
コード例 #3
0
 private void btnAdd_Click(object sender, EventArgs e) // Добавление новой тренировки в базу данных
 {
     if (txtName.Text != "" && txtContent.Text != "" && txtPremiumWork.Text != "")
     {
         using (SqlConnection conn = new SqlConnection(@"Data Source=AYE\SQLEXPRESS;Initial Catalog=SmartWorkouts;Integrated Security=True"))
         {
             try
             {
                 conn.Open();
                 SqlCommand cmd = conn.CreateCommand();
                 cmd.CommandText = "INSERT INTO [Workouts] VALUES (@Name,@Content,@PremiumWork)";
                 cmd.Parameters.AddWithValue(@"Name", txtName.Text);
                 cmd.Parameters.AddWithValue(@"Content", txtContent.Text);
                 cmd.Parameters.AddWithValue(@"PremiumWork", typeEX.Work);
                 cmd.ExecuteNonQuery();
                 MessageBox.Show("Запись успешно добавлена!");
                 createWorkout createWorkout = new createWorkout();
                 createWorkout.Visible       = true;
                 createWorkout.ShowInTaskbar = true;
                 this.Close();
                 GC.Collect();
             }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.ToString());
             }
             finally
             {
                 conn.Close();
             }
         }
     }
     else
     {
         MessageBox.Show("Введите данные!");
     }
 }