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