public List <Ecigik> Select()
{
List <Ecigik> records = new List <Ecigik>();
OracleConnection oc = new OracleConnection();
oc.Open();
OracleCommand command = new OracleCommand()
{
CommandType = System.Data.CommandType.Text,
CommandText = "SELECT m.nev, e.sorszam FROM " +
" ecigik e INNER JOIN markak m ON m.id = e.marka_id"
};
command.Connection = oc;
OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Ecigik ecigi = new Ecigik();
ecigi.Sorszam = reader["sorszam"].ToString();
ecigi.Marka = reader["nev"].ToString();
records.Add(ecigi);
}
oc.Close();
return(records);
}
public List <Ecigik> Select()
{
List <Ecigik> records = new List <Ecigik>();
OracleConnection oc = new OracleConnection();
oc.Open();
OracleCommand command = new OracleCommand()
{
CommandType = System.Data.CommandType.Text,
CommandText = "Select gy.nev, e.tipus, e.sorszam FROM ecigik e"
+ "INNER JOIN gyartok gy ON gy.id = e.gyarto_id"
};
command.Connection = oc;
OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Ecigik ecigi = new Ecigik();
ecigi.Sorszam = reader["sorszam"].ToString();
ecigi.Tipus = reader["tipus"].ToString();
ecigi.Gyarto = reader["nev"].ToString();
records.Add(ecigi);
}
oc.Close();
return(records);
}
public int Delete(Ecigik record)
{
OracleConnection oc = new OracleConnection();
oc.Open();
OracleTransaction ot = oc.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
OracleCommand command = new OracleCommand()
{
CommandType = System.Data.CommandType.Text,
CommandText = "DELETE FROM ecigik WHERE sorszam =:sorszam"
};
OracleParameter sorszamParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = ":sorszam",
Direction = System.Data.ParameterDirection.Input,
Value = record.Sorszam
};
command.Parameters.Add(sorszamParameter);
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 btnDelete_Click(object sender, EventArgs e)
{
int toroltSorok = 0;
foreach (DataGridViewRow selectedRows in dgwEcigik.SelectedRows)
{
Ecigik TorlendoRecord = new Ecigik();
TorlendoRecord.Sorszam = selectedRows.Cells["sorszam"].Value.ToString();
toroltSorok += TableManager.Delete(TorlendoRecord);
}
MessageBox.Show(string.Format("{0} Sor lett törölve.", toroltSorok));
if (toroltSorok != 0)
{
bgWorker.RunWorkerAsync();
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
Ecigik ecigi = new Ecigik()
{
Sorszam = tbSorszam.Text,
Nev = tbNev.Text,
Szin = cbSzin.SelectedItem.ToString(),
Marka = tbMarka.Text,
Watt = int.Parse(tbWatt.Text),
Megjelenesev = dtp_MegjelenesEv.Value,
Tipus = tbTipus.Text
};
TableManager.Insert(ecigi);
bgWorker.RunWorkerAsync();
MessageBox.Show("Sikeres feltöltés.");
tbSorszam.Clear();
tbNev.Clear();
tbMarka.Clear();
tbWatt.Clear();
tbTipus.Clear();
}
public int Insert(Ecigik 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_ecigik"
};
//paraméterek! Hiszen fontos, hogy ne égessük bele a progiba az adatokat, ezért kellenek paraméterek!!!!
OracleParameter sorszamParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_sorszam",
Direction = System.Data.ParameterDirection.Input,
Value = record.Sorszam
};
command.Parameters.Add(sorszamParameter);
OracleParameter nevParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_nev",
Direction = System.Data.ParameterDirection.Input,
Value = record.Nev
};
command.Parameters.Add(nevParameter);
OracleParameter szinParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_szin",
Direction = System.Data.ParameterDirection.Input,
Value = record.Szin
};
command.Parameters.Add(szinParameter);
OracleParameter markaParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_marka",
Direction = System.Data.ParameterDirection.Input,
Value = record.Marka
};
command.Parameters.Add(markaParameter);
OracleParameter wattParameter = new OracleParameter()
{
DbType = System.Data.DbType.Int32,
ParameterName = "p_watt",
Direction = System.Data.ParameterDirection.Input,
Value = record.Watt
};
command.Parameters.Add(wattParameter);
OracleParameter megjeleneseveParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_megjelenesev",
Direction = System.Data.ParameterDirection.Input,
Value = record.Megjelenesev
};
command.Parameters.Add(megjeleneseveParameter);
OracleParameter tipusParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_tipus",
Direction = System.Data.ParameterDirection.Input,
Value = record.Tipus
};
command.Parameters.Add(tipusParameter);
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);
}
}
public int Insert(Ecigik record)
{
OracleConnection oc = new OracleConnection();
oc.Open();
OracleTransaction ot = oc.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
OracleCommand command = new OracleCommand()
{
CommandType = System.Data.CommandType.StoredProcedure,
CommandText = "spInsert_ecigik"
};
OracleParameter sorszamParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_sorszam",
Direction = System.Data.ParameterDirection.Input,
Value = record.Sorszam
};
command.Parameters.Add(sorszamParameter);
OracleParameter nevParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_nev",
Direction = System.Data.ParameterDirection.Input,
Value = record.Nev
};
command.Parameters.Add(nevParameter);
OracleParameter szinParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_szin",
Direction = System.Data.ParameterDirection.Input,
Value = record.Szin
};
command.Parameters.Add(szinParameter);
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 wattParameter = new OracleParameter()
{
DbType = System.Data.DbType.Int32,
ParameterName = "p_watt",
Direction = System.Data.ParameterDirection.Input,
Value = record.Watt
};
command.Parameters.Add(wattParameter);
OracleParameter megjelenesParameter = new OracleParameter()
{
DbType = System.Data.DbType.DateTime,
ParameterName = "p_megjelenesev",
Direction = System.Data.ParameterDirection.Input,
Value = record.Megjelenesev
};
command.Parameters.Add(megjelenesParameter);
OracleParameter tipusParameter = new OracleParameter()
{
DbType = System.Data.DbType.String,
ParameterName = "p_tipus",
Direction = System.Data.ParameterDirection.Input,
Value = record.Tipus
};
command.Parameters.Add(tipusParameter);
OracleParameter rowCountParameter = new OracleParameter()
{
DbType = System.Data.DbType.Int32,
ParameterName = "p_out_rowcnt",
Direction = System.Data.ParameterDirection.Output
};
command.Connection = oc;
command.Transaction = ot;
try
{
command.ExecuteNonQuery();
int affectedRows = int.Parse(rowCountParameter.Value.ToString());
ot.Commit();
return(affectedRows);
}
catch (Exception)
{
ot.Rollback();
return(0);
}
oc.Close();
}
