public void UpdatePolaznik(int id,string ime, string prezime, DateTime datumRodjenja, string OIB, bool gradjaninRH, int? rankId, string brojIskaznice, string komentar, string kontakt) { string procedureName = "upd_Polaznik"; SQLWrapper sql = new SQLWrapper(CommandType.StoredProcedure, procedureName); sql.AddParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, id); sql.AddParameter("@Ime", SqlDbType.NVarChar, 50, ParameterDirection.Input, ime); sql.AddParameter("@Prezime", SqlDbType.NVarChar, 50, ParameterDirection.Input, prezime); sql.AddParameter("@DatumRodjenja", SqlDbType.DateTime, null, ParameterDirection.Input, datumRodjenja); sql.AddParameter("@OIB", SqlDbType.NVarChar, 15, ParameterDirection.Input, OIB); sql.AddParameter("@GradjaninRH", SqlDbType.Bit, null, ParameterDirection.Input, gradjaninRH); if (rankId.HasValue && rankId.Value != -1) sql.AddParameter("@RankID", SqlDbType.Int, 4, ParameterDirection.Input, rankId); if (!String.IsNullOrEmpty(brojIskaznice)) sql.AddParameter("@BrojIskaznice", SqlDbType.NVarChar, 20, ParameterDirection.Input, brojIskaznice); if (!String.IsNullOrEmpty(komentar)) sql.AddParameter("@Komentar", SqlDbType.NVarChar, 500, ParameterDirection.Input, komentar); if (!String.IsNullOrEmpty(kontakt)) sql.AddParameter("@Kontakt", SqlDbType.NVarChar, 50, ParameterDirection.Input, kontakt); sql.ExecuteNonQuery(); }
public void UpdateOcjena(int ocjenaId, int sadrzaj, int predavac, int trajanje, int brzina, int literatura, int korisnost) { string procedureName = "upd_Ocjena"; SQLWrapper sql = new SQLWrapper(CommandType.StoredProcedure, procedureName); sql.AddParameter("@OcjenaID", SqlDbType.Int, 4, ParameterDirection.Input, ocjenaId); sql.AddParameter("@Sadrzaj", SqlDbType.Int, 4, ParameterDirection.Input, sadrzaj); sql.AddParameter("@Predavac", SqlDbType.Int, 4, ParameterDirection.Input, predavac); sql.AddParameter("@Trajanje", SqlDbType.Int, 4, ParameterDirection.Input, trajanje); sql.AddParameter("@Brzina", SqlDbType.Int, 4, ParameterDirection.Input, brzina); sql.AddParameter("@Literatura", SqlDbType.Int, 4, ParameterDirection.Input, literatura); sql.AddParameter("@Korisnost", SqlDbType.Int, 4, ParameterDirection.Input, korisnost); sql.ExecuteNonQuery(); }