private void button1_Click(object sender, EventArgs e) { db_connect(); OracleCommand cum = new OracleCommand(); cum.Connection = conn; cum.CommandText = "insert into Painting (P_name,Price,Year,Artist_id) values('" + textBox2.Text + "','" + textBox3.Text + "','" + textBox1.Text + "','" + textBox4.Text + "')"; cum.CommandType = CommandType.Text; cum.ExecuteNonQuery(); String pname = textBox2.Text; comm = new OracleCommand(); comm.CommandText = "select P_id from Painting where P_name ='" + pname + "'"; comm.CommandType = CommandType.Text; da = new OracleDataAdapter(comm.CommandText, conn); dt = new DataTable(); da.Fill(dt); int t = dt.Rows.Count; dr = dt.Rows[i]; string pid = dr["P_id"].ToString(); cum.Connection = conn; cum.CommandText = "insert into Adds values(" + pid + "," + id + ", SYSDATE)"; cum.CommandType = CommandType.Text; cum.ExecuteNonQuery(); MessageBox.Show("Painting Added!!"); conn.Close(); this.Hide(); Form mpf = new MProfile(id); mpf.Show(); }
private void button1_Click(object sender, EventArgs e) { Form k = new MProfile(id); k.Show(); this.Close(); }
private void button1_Click(object sender, EventArgs e) { db_connect(); comm = new OracleCommand(); comm.CommandText = "select * from Manager where manager_id='" + textBox1.Text + "' and Password='******'"; comm.CommandType = CommandType.Text; da = new OracleDataAdapter(comm.CommandText, conn); dt = new DataTable(); da.Fill(dt); int t = dt.Rows.Count; if (t == 1) { DialogResult dr = MessageBox.Show("Logged in Successfully"); if (dr == DialogResult.OK) { Form lg = new MProfile(textBox1.Text); this.Close(); lg.Show(); } } else { DialogResult dr = MessageBox.Show("Login Failed , Please Try Again"); textBox1.Text = String.Empty; textBox2.Text = String.Empty; } }
private void button4_Click(object sender, EventArgs e) { db_connect(); OracleCommand cum = new OracleCommand(); cum.Connection = conn; cum.CommandText = "insert into Cleaner (cl_name,phone,manager_id) values('" + textBox2.Text + "','" + textBox3.Text + "','" + id + "')"; cum.CommandType = CommandType.Text; cum.ExecuteNonQuery(); MessageBox.Show("Cleaner Employed"); conn.Close(); this.Hide(); Form pf = new MProfile(id); pf.Show(); }