//изменение данных записи в таблице бд по заполненным полям и закрытие формы
private void roundBtnChange_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-9IUFQMM\SQLEXPRESS;Initial Catalog=PateticoPractic;Integrated Security=True"))
{
try
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
SqlCommand cmd_1 = conn.CreateCommand();
cmd.CommandText = "UPDATE [Shops] SET address = @Street, time_of_work = @Time WHERE id_shop = @ID";
cmd.Parameters.AddWithValue(@"ID", ShopID);
cmd.Parameters.AddWithValue(@"Street", txtForStreet.Text);
cmd.Parameters.AddWithValue(@"Time", txtForTime.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Запись успешно изменена!", "Изменение записи");
Shops Shops = new Shops();
Shops.Visible = true;
Shops.ShowInTaskbar = true;
this.Close();
GC.Collect();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
}
}
//закрытие данной формы и переход к форме списка магазинов
private void roundBtnShops_Click(object sender, EventArgs e)
{
this.Close();
GC.Collect();
Shops Shops = new Shops();
Shops.Visible = true;
Shops.ShowInTaskbar = true;
}
// добавление записи в БД после заполнения необходимых полей
private void roundBtnAdd_Click(object sender, EventArgs e)
{
if (txtForStreet.Text != "")
{
using (SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-9IUFQMM\SQLEXPRESS;Initial Catalog=PateticoPractic;Integrated Security=True"))
{
try
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO [Shops] VALUES (@street,@time)";
cmd.Parameters.AddWithValue(@"street", txtForStreet.Text);
cmd.Parameters.AddWithValue(@"time", txtForTime.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Запись успешно добавлена!", "Добавление записи");
Shops Shops = new Shops();
Shops.Visible = true;
Shops.ShowInTaskbar = true;
this.Close();
GC.Collect();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
}
}
else
{
MessageBox.Show("Введите адрес магазина!");
txtForStreet.Focus();
}
}
