public bool DeletePoszt(Poszt record)
{
OracleConnection oracleConnection = getConnection();
OracleCommand oracleCommand = new OracleCommand();
oracleCommand.CommandType = System.Data.CommandType.Text;
oracleCommand.CommandText = "DELETE FROM Poszt WHERE poszt.id = :id";
OracleParameter idParameter = new OracleParameter();
idParameter.ParameterName = "id";
idParameter.DbType = System.Data.DbType.Int32;
idParameter.Direction = System.Data.ParameterDirection.Input;
idParameter.Value = record.Id;
oracleCommand.Parameters.Add(idParameter);
oracleConnection.Open();
oracleCommand.Connection = oracleConnection;
int rows = oracleCommand.ExecuteNonQuery();
oracleConnection.Close();
return(rows != 0);
}
public bool InsertPoszt(Poszt record)
{
OracleConnection oracleConnection = getConnection();
OracleCommand oracleCommand = new OracleCommand();
oracleCommand.CommandType = System.Data.CommandType.Text;
oracleCommand.CommandText = "INSERT INTO Poszt(id, megnevezes) VALUES (:id, :megnevezes)";
OracleParameter idParameter = new OracleParameter();
idParameter.ParameterName = "id";
idParameter.DbType = System.Data.DbType.Int32;
idParameter.Direction = System.Data.ParameterDirection.Input;
idParameter.Value = record.Id;
oracleCommand.Parameters.Add(idParameter);
OracleParameter megnevezesParameter = new OracleParameter();
megnevezesParameter.ParameterName = "megnevezes";
megnevezesParameter.DbType = System.Data.DbType.String;
megnevezesParameter.Direction = System.Data.ParameterDirection.Input;
megnevezesParameter.Value = record.Megnevezes;
oracleCommand.Parameters.Add(megnevezesParameter);
oracleConnection.Open();
oracleCommand.Connection = oracleConnection;
int rows = oracleCommand.ExecuteNonQuery();
oracleConnection.Close();
return(rows != 0);
}
public bool UpdatePoszt(Poszt record)
{
OracleConnection oracleConnection = getConnection();
OracleCommand oracleCommand = new OracleCommand();
oracleCommand.CommandType = System.Data.CommandType.Text;
oracleCommand.CommandText = "UPDATE Poszt SET megnevezes = :megnevezes WHERE id = :id";
OracleParameter megnevezesParameter = new OracleParameter();
megnevezesParameter.ParameterName = "megnevezes";
megnevezesParameter.DbType = System.Data.DbType.String;
megnevezesParameter.Direction = System.Data.ParameterDirection.Input;
megnevezesParameter.Value = record.Megnevezes;
oracleCommand.Parameters.Add(megnevezesParameter);
OracleParameter idParameter = new OracleParameter();
idParameter.ParameterName = "id";
idParameter.DbType = System.Data.DbType.Int32;
idParameter.Direction = System.Data.ParameterDirection.Input;
idParameter.Value = record.Id;
oracleCommand.Parameters.Add(idParameter);
oracleConnection.Open();
oracleCommand.Connection = oracleConnection;
int rows = oracleCommand.ExecuteNonQuery();
oracleConnection.Close();
return(rows != 0);
}
public List <Poszt> GetListPoszt()
{
OracleConnection oracleConnection = getConnection();
OracleCommand command = new OracleCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT * FROM Poszt";
command.Connection = oracleConnection;
command.CommandTimeout = 0;
oracleConnection.Open();
List <Poszt> records = new List <Poszt>();
OracleDataReader oracleDataReader = command.ExecuteReader();
while (oracleDataReader.Read())
{
Poszt temp = new Poszt();
temp.Id = int.Parse(oracleDataReader["id"].ToString());
temp.Megnevezes = oracleDataReader["megnevezes"].ToString();
records.Add(temp);
}
oracleConnection.Close();
return(records);
}
public Poszt GetOnePoszt(Poszt record)
{
OracleConnection oracleConnection = getConnection();
OracleCommand command = new OracleCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT * FROM Poszt WHERE id = :id";
command.Connection = oracleConnection;
command.CommandTimeout = 0;
oracleConnection.Open();
OracleParameter idParameter = new OracleParameter();
idParameter.ParameterName = "id";
idParameter.DbType = System.Data.DbType.Int32;
idParameter.Direction = System.Data.ParameterDirection.Input;
idParameter.Value = record.Id;
command.Parameters.Add(idParameter);
Poszt temp = null;
OracleDataReader oracleDataReader = command.ExecuteReader();
if (oracleDataReader.Read())
{
temp = new Poszt();
temp.Id = int.Parse(oracleDataReader["id"].ToString());
temp.Megnevezes = oracleDataReader["megnevezes"].ToString();
}
oracleConnection.Close();
return(temp);
}
private void button_insert_Click(object sender, EventArgs e)
{
Poszt newRecord = new Poszt();
try
{
newRecord.Id = rnd.Next(10, 100000);
newRecord.Megnevezes = tb1.Text;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
bool success = dbManager.InsertPoszt(newRecord);
if (success)
{
MessageBox.Show("Sikeres rögzítés");
tb1.Text = string.Empty;
loadComboBox();
}
else
{
MessageBox.Show("Hiba az insert során!");
}
}
private void button_update_Click(object sender, EventArgs e)
{
Poszt temp = new Poszt();
try
{
temp.Id = selectedRecord.Id;
temp.Megnevezes = tb1u.Text;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
if (dbManager.UpdatePoszt(temp))
{
MessageBox.Show("Sikeres módosítás!");
tb1u.Text = string.Empty;
loadComboBox();
}
else
{
MessageBox.Show("Hiba");
}
}
private void updateFields()
{
selectedRecord = dbManager.GetOnePoszt(selectedRecord);
if (selectedRecord != null)
{
tb1u.Text = selectedRecord.Megnevezes;
}
else
{
tb1u.Text = string.Empty;
}
}
private void button_delete_Click(object sender, EventArgs e)
{
if (selectedRecord == null)
{
MessageBox.Show("Nincs elem kiválasztva a törléshez!");
return;
}
Poszt recordToDelete = selectedRecord;
bool success = dbManager.DeletePoszt(recordToDelete);
if (success)
{
loadComboBox();
}
else
{
MessageBox.Show("A törlés sikertelen volt!");
}
}
private void comboBox_contries_SelectedValueChanged(object sender, EventArgs e)
{
selectedRecord = (Poszt)comboBox_contries.SelectedItem;
updateFields();
}
