private void button4_Click(object sender, EventArgs e)
{
DataBaseConnector db = new DataBaseConnector();
foreach (var p in PageContents)
{
BindingModel.Page page = new BindingModel.Page(p.PlaceInGroup, p.Number, p.Name, p.Type, p.Model, p.YoutubeLink1, p.YoutubeLink2, p.GameLink1, p.GameLink2, p.Id);
db.ChangeData(page);
}
CleareAll();
// button2.Enabled = true;
}
private void InsertElements()
{
DataBaseConnector db = new DataBaseConnector();
Book.NameBook = textBox1.Text;
db.InsertNewBook(Book);
foreach (var p in PageContents)
{
BindingModel.Page page = new BindingModel.Page(p.PlaceInGroup, p.Number, p.Name, p.Type, p.Model, p.YoutubeLink1, p.YoutubeLink2, p.GameLink1, p.GameLink2, Book.Id);
db.InsertPagesInBook(page);
}
CleareAll();
button2.Enabled = true;
}
public void ChangeData(BindingModel.Page page)
{
DbConnection.Open();
using (MySqlCommand command = new MySqlCommand("ChangeLink", DbConnection)
{
CommandType = CommandType.StoredProcedure
})
{
command.Parameters.AddWithValue("@id", page.BookId);
command.Parameters.AddWithValue("@Typ", page.Type);
command.Parameters.AddWithValue("@Model", page.Model);
command.Parameters.AddWithValue("@Link", page.GameLink1);
command.ExecuteNonQuery();
}
DbConnection.Close();
}
public void InsertPagesInBook(BindingModel.Page page)
{
DbConnection.Open();
using (MySqlCommand command = new MySqlCommand("InsertTargetUa", DbConnection)
{
CommandType = CommandType.StoredProcedure
})
{
command.Parameters.AddWithValue("@Number", page.Number);
command.Parameters.AddWithValue("@Name", page.Name);
command.Parameters.AddWithValue("@Type", page.Type);
command.Parameters.AddWithValue("@3D", page.Model);
command.Parameters.AddWithValue("@YT", page.YoutubeLink1);
command.Parameters.AddWithValue("@YT2", page.YoutubeLink2);
command.Parameters.AddWithValue("@G", page.GameLink1);
command.Parameters.AddWithValue("@G2", page.GameLink2);
command.Parameters.AddWithValue("@AG", page.BookId);
command.Parameters.AddWithValue("@PinG", page.PlaceInGroup);
command.ExecuteNonQuery();
}
DbConnection.Close();
}