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(); }