public int Delete(Jatekok 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 jatekok WHERE asztalkod = :aszalkod"
};
OracleParameter asztalkodParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = ":asztalkod",
Direction = System.Data.ParameterDirection.Input,
Value = record.Asztalkod
};
command.Parameters.Add(asztalkodParameter);
command.Connection = oc;
command.Transaction = ot;
int affectedRows = 0;
try
{
affectedRows = command.ExecuteNonQuery();
ot.Commit();
}
catch (Exception)
{
ot.Rollback();
}
oc.Close();
return(affectedRows);
}
private void button_insert_Click(object sender, EventArgs e)
{
Jatekok jatek = new Jatekok()
{
Asztalkod = textBox_asztalkod.Text,
Jatekasztalneve = textBox_gametable.Text,
Krupie = textBox_krupie.Text,
Jatektipusa = comboBox_gametype.SelectedItem.ToString(),
Gyarto = textBox_gyarto.Text,
Asztallimit = textBox_limit.Text,
Asztal_datuma = dateTimePicker_kelt.Value
};
kaszinojatekoktabla.Insert(jatek);
bgWorker.RunWorkerAsync();
MessageBox.Show("Sikeres játék feltöltés!");
textBox_asztalkod.Clear();
textBox_gametable.Clear();
textBox_krupie.Clear();
textBox_gyarto.Clear();
textBox_limit.Clear();
}
public int Insert(Jatekok record)
{
OracleConnection oc = GetOracleConnection();
oc.Open();
OracleTransaction ot = oc.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
OracleCommand command = new OracleCommand()
{
CommandType = System.Data.CommandType.StoredProcedure,
CommandText = "spInsert_KaszinoJatekok"
};
OracleParameter asztalkodParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_asztalkod",
Direction = System.Data.ParameterDirection.Input,
Value = record.Asztalkod
};
command.Parameters.Add(asztalkodParameter);
OracleParameter jatekasztalneveParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_jatekasztalneve",
Direction = System.Data.ParameterDirection.Input,
Value = record.Jatekasztalneve
};
command.Parameters.Add(jatekasztalneveParameter);
OracleParameter gyartoParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_gyarto",
Direction = System.Data.ParameterDirection.Input,
Value = record.Gyarto
};
command.Parameters.Add(gyartoParameter);
OracleParameter asztallimitParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_asztallimit",
Direction = System.Data.ParameterDirection.Input,
Value = record.Asztallimit
};
command.Parameters.Add(asztallimitParameter);
OracleParameter krupieParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_krupie",
Direction = System.Data.ParameterDirection.Input,
Value = record.Krupie
};
command.Parameters.Add(krupieParameter);
OracleParameter asztal_datumaParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_asztal_datuma",
Direction = System.Data.ParameterDirection.Input,
Value = record.Asztal_datuma
};
command.Parameters.Add(asztal_datumaParameter);
OracleParameter jatektipusaParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_jatektipusa",
Direction = System.Data.ParameterDirection.Input,
Value = record.Jatektipusa
};
command.Parameters.Add(jatektipusaParameter);
OracleParameter rowcountParameter = new OracleParameter()
{
DbType = System.Data.DbType.Int32,
ParameterName = "p_out_rowcnt",
Direction = System.Data.ParameterDirection.Output
};
command.Connection = oc;
command.Transaction = ot;
oc.Close();
try
{
command.ExecuteNonQuery();
int affectedRows = int.Parse(rowcountParameter.Value.ToString());
ot.Commit();
return(affectedRows);
}
catch (Exception)
{
ot.Rollback();
return(0);
}
}