private void btn_submit_Click(object sender, EventArgs e) { // getting product id for specification,this table need for foreign key // UsingDB usingDB = new UsingDB(); int id = usingDB.GetID("FromAeDB", "GetID", "ProductID"); // adding product specifications to specifications table // usingDB.ConnectDB("FromAeDB"); string querry = $"'{spefications.txbx_model.Text}','{spefications.txbx_color.Text}','{spefications.txbx_sizes.Text}','{spefications.txbx_cards_count.Text}'," + $"'{spefications.txbx_inner_storage.Text}','{spefications.txbx_ram.Text}','{spefications.txbx_front_camera.Text}','{spefications.txbx_back_camera.Text}','{spefications.txbx_battery_volume.Text}','{id}'"; usingDB.InsertToDB("ProductSpefications", querry); usingDB.DisposeSeans(); MessageBox.Show("Elan uğurla paylaşıldı." + "\n" + "Elanlar formundan son elana baxa bilərsiz."); Form1 f = new Form1(); f.Show(); this.Visible = false; }
private void button2_Click(object sender, EventArgs e) { // adding specification control to specification group box // spefications.Location = new Point(5, 15); groupBox_spefication.Controls.Add(spefications); // showing submit button // btn_submit.Visible = true; // copy image to photos folder // FileInfo fileInfo = new FileInfo(dialog.FileName); string source = Environment.CurrentDirectory + "/images" + "/" + fileInfo.Name; File.Copy(dialog.FileName, source); // adding product photo,name and price to database // UsingDB usingDB = new UsingDB(); usingDB.ConnectDB("FromAeDB"); string values = $"'{txbx_product_name.Text}','{txbx_product_price.Text}','{fileInfo.Name.ToString()}'"; usingDB.InsertToDB("Products", values); usingDB.DisposeSeans(); }