private void buttonReservation_Click(object sender, EventArgs e)
        {
            oracleConnection1.Open();
            oracleCommand1.CommandText = "insert into item values('" + textBoxID.Text + "','" + comboBoxCate.SelectedItem + "','" + textBoxName.Text + "','" + textBoxPrice.Text + "','" + textBoxMileage.Text + "')";
            oracleCommand1.ExecuteNonQuery();

            oracleCommand2.CommandText = "insert into description values('" + textBoxID.Text + "','" + comboBoxCate.SelectedItem + "','" + textBox1.Text + "')";
            oracleCommand2.ExecuteNonQuery();

            stockTableAdapter1.Fill(dataSet11.STOCK);
            StockTable = dataSet11.Tables["STOCK"];

            string str = "item_id='" + textBoxID.Text + "'";

            DataRow[] foundRows = StockTable.Select(str);
            string    stock     = "1";

            foreach (DataRow mydataRow in foundRows)
            {
                stock = mydataRow["sto_stock"].ToString();
            }

            DateTime day  = dateTimePicker1.Value;
            string   date = day.Year + "-" + day.Month + "-" + day.Day;

            oracleCommand3.CommandText = "insert into stock values ('" + textBoxID.Text + "','" + comboBoxCate.SelectedItem + "','" + stock + "',to_date('" + date + "','YYYY-MM-DD'),'" + textBoxLoc.Text + "','" + textBoxState.Text + "','" + textBoxStock.Text + "')";
            oracleCommand3.ExecuteNonQuery();
            MessageBox.Show("물건이 추가되었습니다");
            this.Visible = false;
            itemForm.Activate();
            oracleConnection1.Close();
            itemForm.F5(sender, e);
        }
        private void label3_Click(object sender, EventArgs e)
        {
            this.Visible = false;
            FormAdminItemItem frm = new FormAdminItemItem(mainform);

            frm.Owner = this;
            frm.Show();
            frm.Activate();
        }
Example #3
0
 private void button1_Click(object sender, EventArgs e)
 {
     this.Visible = false;
     itemForm.Activate();
 }