Advertisement
Guest User

Untitled

a guest
Dec 16th, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. public bool Upisi() //instancna metoda upisuje this objekat
  2. {
  3. SqlCommand cmd = Konekcija.GetCmd();
  4. cmd.CommandText = "uspRoditelj";
  5. cmd.Parameters.AddWithValue("@izbor", 1);
  6. if(this.SvojstvoID>0)
  7. cmd.Parameters.AddWithValue("@svojstvoID", this.SvojstvoID); //vodimo racuna kada prenosimo spoljasnji kljuc
  8. cmd.Parameters.AddWithValue("@ime", this.Ime);
  9. cmd.Parameters.AddWithValue("@prezime", this.Prezime);
  10. cmd.Parameters.AddWithValue("@adersa", this.Adresa);
  11. cmd.Parameters.AddWithValue("@fiksni", this.Fiksni);
  12. cmd.Parameters.AddWithValue("@mobilni", this.Mobilni);
  13. try
  14. {
  15. cmd.Connection.Open();
  16. int broj = cmd.ExecuteNonQuery();
  17. if (broj == 1) return true;
  18. else throw new Exception("roditelj nije upisan");
  19. }
  20. catch (Exception ex)
  21. {
  22. this.PorukaGreske = ex.Message;
  23. return false;
  24. }
  25. finally
  26. {
  27. cmd.Connection.Close();
  28. }
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement