private void BtnForward_Click(object sender, EventArgs e) { IT_Support it = new IT_Support(); connection.Open(); OracleCommand cmd = new OracleCommand("redirect", connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("id_ticket", OracleDbType.Int32).Value = textIDTicket.Text; cmd.Parameters.Add("angajat_adresat", OracleDbType.Varchar2).Value = textAsgnNameIT.Text; cmd.ExecuteNonQuery(); connection.Close(); this.Hide(); it.Show(); }
private void BtnTickets_Click(object sender, EventArgs e) { /* connection.Open(); * OracleCommand cmd = new OracleCommand("afisare_tickete", connection); * cmd.CommandType = System.Data.CommandType.StoredProcedure; * cmd.Parameters.Add("registru", OracleDbType.RefCursor).Direction = ParameterDirection.Output; * * OracleDataAdapter adapter = new OracleDataAdapter(); * adapter.SelectCommand = cmd; * DataTable dataTable = new DataTable(); * adapter.Fill(dataTable); * dataGridViewTickets.DataSource = dataTable; * * connection.Close();*/ IT_Support it = new IT_Support(); it.Show(); }
private void BtnUpdate_Click(object sender, EventArgs e) { IT_Support it = new IT_Support(); connection.Open(); OracleCommand cmd = new OracleCommand("actualizare_suport_it", connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("id_ticket", OracleDbType.Int32).Value = textIDTicket.Text; cmd.Parameters.Add("stare", OracleDbType.Varchar2).Value = comboStateIT.GetItemText(comboStateIT.SelectedItem); cmd.ExecuteNonQuery(); OracleCommand cmd1 = new OracleCommand("actualizare_ticket", connection); cmd1.CommandType = System.Data.CommandType.StoredProcedure; cmd1.Parameters.Add("id_ticket", OracleDbType.Int32).Value = textIDTicket.Text; cmd1.Parameters.Add("cost_aprox", OracleDbType.Int32).Value = textCostIT.Text; cmd1.ExecuteNonQuery(); MessageBox.Show("The ticket was successfully updated :)"); connection.Close(); this.Hide(); it.Show(); }