public List <Novenyek> Select()
{
List <Novenyek> records = new List <Novenyek>();
OracleCommand command = new OracleCommand();
command.Connection = connectionopen();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT id_noveny, viragzas, kor, fajta, ar, uzletek_Id FROM novenyek";
OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Novenyek noveny = new Novenyek();
noveny.Id_noveny = (string)reader["id_noveny"];
noveny.Viragzas = (string)reader["viragzas"];
noveny.Kor = (string)reader["kor"];
noveny.Fajta = (string)reader["fajta"];
noveny.Ar = int.Parse(reader["ar"].ToString());
noveny.Uzletek_id = int.Parse(reader["uzletek_Id"].ToString());
records.Add(noveny);
}
reader.Close();
return(records);
}
private void buttonFelvisz_Click(object sender, EventArgs e)
{
try
{
Novenyek noveny = new Novenyek()
{
Id_noveny = textBoxID.Text,
Fajta = textBoxFajta.Text,
Kor = textBoxKor.Text,
Viragzas = comboBox1.SelectedItem.ToString(),
Ar = int.Parse(textBoxAra.Text),
Uzletek_id = int.Parse(textBoxUzletek.Text)
};
tablaManager.Insert(noveny);
bgWorker.RunWorkerAsync();
MessageBox.Show("Sikeres feltöltés!");
textBoxID.Clear();
textBoxFajta.Clear();
textBoxKor.Clear();
textBoxAra.Clear();
dvg_noveny.Rows.Clear();
BgWorekr_DoWork();
BgWorker_RunWorkerComplete();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public int Insert(Novenyek record)
{
OracleCommand command = new OracleCommand();
command.Connection = connectionopen();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "INSERT INTO novenyek(id_noveny, viragzas, kor, fajta, ar, uzletek_Id) VALUES(:id_noveny, :viragzas, :kor, :fajta, :ar, :uzletek_Id)";
OracleParameter pid = new OracleParameter();
pid.ParameterName = ":id_noveny";
pid.OracleDbType = OracleDbType.Varchar2;
pid.Direction = System.Data.ParameterDirection.Input;
pid.Value = record.Id_noveny;
OracleParameter pviragzas = new OracleParameter();
pviragzas.ParameterName = ":viragzas";
pviragzas.OracleDbType = OracleDbType.Varchar2;
pviragzas.Direction = System.Data.ParameterDirection.Input;
pviragzas.Value = record.Viragzas;
OracleParameter pkor = new OracleParameter();
pkor.ParameterName = ":kor";
pkor.OracleDbType = OracleDbType.Varchar2;
pkor.Direction = System.Data.ParameterDirection.Input;
pkor.Value = record.Kor;
OracleParameter petfajta = new OracleParameter();
petfajta.ParameterName = ":fajta";
petfajta.OracleDbType = OracleDbType.Varchar2;
petfajta.Direction = System.Data.ParameterDirection.Input;
petfajta.Value = record.Fajta;
OracleParameter par = new OracleParameter();
par.ParameterName = ":ar";
par.OracleDbType = OracleDbType.Varchar2;
par.Direction = System.Data.ParameterDirection.Input;
par.Value = record.Ar;
OracleParameter puzletid = new OracleParameter();
puzletid.ParameterName = ":uzletek_Id";
puzletid.OracleDbType = OracleDbType.Long;
puzletid.Direction = System.Data.ParameterDirection.Input;
puzletid.Value = record.Uzletek_id;
command.Parameters.Add(pid);
command.Parameters.Add(pviragzas);
command.Parameters.Add(pkor);
command.Parameters.Add(petfajta);
command.Parameters.Add(par);
command.Parameters.Add(puzletid);
return(command.ExecuteNonQuery());
}
private void buttonDelete_Click(object sender, EventArgs e)
{
int torolt_sorok = 0;
foreach (DataGridViewRow select in dvg_noveny.SelectedRows)
{
Novenyek torolrecord = new Novenyek();
torolrecord.Id_noveny = select.Cells["id_noveny"].Value.ToString();
torolt_sorok += tablaManager.Delete(torolrecord);
}
MessageBox.Show(string.Format("{0} sor lett törölve!", torolt_sorok));
if (torolt_sorok != 0)
{
bgWorker.RunWorkerAsync();
}
dvg_noveny.Rows.Clear();
BgWorekr_DoWork();
BgWorker_RunWorkerComplete();
}
public int Delete(Novenyek record)
{
OracleConnection oc = GetOracleConnection();
oc.Open();
OracleTransaction ot = oc.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
OracleCommand command = new OracleCommand()
{
CommandType = System.Data.CommandType.Text,
CommandText = "DELETE FROM novenyek WHERE id_noveny = :id_noveny"
};
OracleParameter idszamParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = ":p_id_noveny",
Direction = System.Data.ParameterDirection.Input,
Value = record.Id_noveny
};
command.Parameters.Add(idszamParameter);
command.Connection = oc;
command.Transaction = ot;
int affectedRows = 0;
try
{
affectedRows = command.ExecuteNonQuery();
ot.Commit();
}
catch (Exception)
{
ot.Rollback();
}
return(affectedRows);
}
