/// <summary> /// Dodavanje vo relacijata Vraboten /// </summary> /// <returns></returns> private int DodadiVoDBVraboten() { string insertVrab = @"INSERT INTO VRABOTEN (VRABOTEN_ID, IME_VRABOTEN, PREZIME_VRABOTEN, EMBG, DATUM_NA_RAGJANJE, ADRESA_NA_ZHIVEENJE) VALUES (:VRAB_ID, :IME, :PREZIME, :EMBG, :DAT, :ADR)"; OracleCommand cmd = new OracleCommand(insertVrab, Conn); try { OracleParameter prm = new OracleParameter("VRAB_ID", OracleDbType.Int64); prm.Value = this.VrabotenID; cmd.Parameters.Add(prm); prm = new OracleParameter("IME", OracleDbType.Varchar2); prm.Value = this.tbIme.Text.Trim(); cmd.Parameters.Add(prm); prm = new OracleParameter("PREZIME", OracleDbType.Varchar2); prm.Value = this.tbPrezime.Text.Trim(); cmd.Parameters.Add(prm); prm = new OracleParameter("EMBG", OracleDbType.Char); prm.Value = this.tbEmbg.Text.Trim(); cmd.Parameters.Add(prm); prm = new OracleParameter("DAT", OracleDbType.Date); if (tbDen.Text.Trim() != "") { int d = int.Parse(tbDen.Text.Trim()); int m = int.Parse(tbMesec.Text.Trim()); int y = int.Parse(tbGodina.Text.Trim()); DateTime dt; try { dt = new DateTime(y, m, d); prm.Value = dt; } catch (Exception e) { MessageBoxForm mbf = new MessageBoxForm("Невалиден датум!", false); mbf.Show(); } } else { prm.Value = null; } cmd.Parameters.Add(prm); prm = new OracleParameter("ADR", OracleDbType.Varchar2); string adresa = ""; adresa += this.tbAdresa.Text.Trim(); if (this.tbGrad.Text.Trim() != "") { adresa += ", " + this.tbGrad.Text.Trim(); } if (adresa != "") { prm.Value = adresa; } else { prm.Value = null; } cmd.Parameters.Add(prm); } catch (Exception ex) { return(-1); } cmd.CommandType = CommandType.Text; int br; try { br = cmd.ExecuteNonQuery(); } catch (Exception) { br = -1; } return(br); }