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