private void btnCreatePremium_Click(object sender, EventArgs e)
{
this.Visible = false;
this.ShowInTaskbar = false;
createPremiumWork premiumWork = new createPremiumWork();
premiumWork.ShowDialog();
}
private void picExit_Click(object sender, EventArgs e)
{
createPremiumWork createPremium = new createPremiumWork();
createPremium.Visible = true;
createPremium.ShowInTaskbar = true;
this.Close();
GC.Collect();
}
private void btnAdd_Click(object sender, EventArgs e) // Добавление премиум-подписки в базу данных
{
if (txtName.Text != "" && txtContent.Text != "" && txtPrice.Text != "")
{
try
{
double price = double.Parse(txtPrice.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 [Premium_Works] VALUES (@NamePremiumWork,@ContentPremiumWork,@PricePremiumWork)";
cmd.Parameters.AddWithValue(@"NamePremiumWork", txtName.Text);
cmd.Parameters.AddWithValue(@"ContentPremiumWork", txtContent.Text);
cmd.Parameters.AddWithValue(@"PricePremiumWork", txtPrice.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Запись успешно добавлена!");
createPremiumWork createPremium = new createPremiumWork();
createPremium.Visible = true;
createPremium.ShowInTaskbar = true;
this.Close();
GC.Collect();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
}
}
catch
{
MessageBox.Show("Введите корректную цену!");
txtPrice.Text = "";
}
}
else
{
MessageBox.Show("Введите данные!");
}
}
private void btnAdd_Click(object sender, EventArgs e) // Добавление в базу данных обновленной информации о подписке
{
using (SqlConnection conn = new SqlConnection(@"Data Source=AYE\SQLEXPRESS;Initial Catalog=SmartWorkouts;Integrated Security=True"))
{
double price = 0;
try
{
price = double.Parse(txtPrice.Text);
try
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE [Premium_Works] SET Name_Premium_Work = @NamePremiumWork, Description_Premium_Work = @ContentPremiumWork, Price_Premium_Work = @Price WHERE Number_Premium_Work = @ID";
cmd.Parameters.AddWithValue(@"ID", UserID);
cmd.Parameters.AddWithValue(@"NamePremiumWork", txtName.Text);
cmd.Parameters.AddWithValue(@"ContentPremiumWork", txtContent.Text);
cmd.Parameters.AddWithValue(@"Price", txtPrice.Text);
cmd.ExecuteNonQuery();
createPremiumWork createPremiumWork = new createPremiumWork();
createPremiumWork.Visible = true;
createPremiumWork.ShowInTaskbar = true;
this.Close();
GC.Collect();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
}
catch
{
MessageBox.Show("Введите корректную цену!");
txtPrice.Text = "";
}
}
}
