public static List <Ucenik> IzlistavanjeUcenika(int TrenutnaStrana, int BrojPoStrani, int Razred, int RedniBroj, string NazivUcenika = "") { // CREATE PROCEDURE skola.UceniciIzlistavanje // (@Razred int, @RedniBroj int, @NazivUcenika nvarchar(50)) try { SqlCommand Cm = new SqlCommand(); Cm.Connection = Cn; Cm.CommandType = CommandType.StoredProcedure; Cm.CommandText = "skola.UceniciIzlistavanje "; int Ret = 99; Cm.Parameters.Add(new SqlParameter("@TrenutnaStrana", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, TrenutnaStrana)); Cm.Parameters.Add(new SqlParameter("@BrojPoStrani", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, BrojPoStrani)); Cm.Parameters.Add(new SqlParameter("@Razred", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, Razred)); Cm.Parameters.Add(new SqlParameter("@RedniBroj", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, RedniBroj)); Cm.Parameters.Add(new SqlParameter("@NazivUcenika", SqlDbType.NVarChar, 50, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, NazivUcenika)); Cm.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, true, 0, 0, "", DataRowVersion.Current, Ret)); Cn.Open(); SqlDataReader dR = Cm.ExecuteReader(); List <Ucenik> ucenici = new List <Ucenik>(); while (dR.Read()) { Ucenik u = new Ucenik(dR.GetInt32(0), dR.GetString(1), dR.GetString(2), dR.GetString(3), dR.GetString(4), dR.GetInt32(5), dR.GetDateTime(6), dR.GetString(7), dR.GetString(8), dR.GetString(9), dR.GetString(10), dR.GetString(11), dR.GetString(12), dR.GetString(13), dR.GetString(14), dR.GetString(15), dR.GetString(16), dR.GetString(17), dR.GetString(18), dR.GetString(19), dR.GetString(20)); ucenici.Add(u); } //Console.WriteLine(ucenici[0].Ime, ucenici[0].Prezime, ucenici[0].DatumRodjenja); Cn.Close(); return(ucenici); }catch (Exception e) { Cn.Close(); Console.WriteLine(e.Message); return(null); } }
public static int IzmenaUcenika(Ucenik izmeniti) { try { SqlCommand Cm = new SqlCommand(); Cm.Connection = Cn; Cm.CommandType = CommandType.StoredProcedure; Cm.CommandText = "dbo.uceniciUPDATE"; int Ret = 99; Cm.Parameters.Add(new SqlParameter("@MaticniBroj", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.MaticniBroj)); Cm.Parameters.Add(new SqlParameter("@Ime", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.Ime)); Cm.Parameters.Add(new SqlParameter("@Prezime", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.Prezime)); Cm.Parameters.Add(new SqlParameter("@JMBG", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.JMBG)); Cm.Parameters.Add(new SqlParameter("@OdeljenjeID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.OdeljenjeID)); Cm.Parameters.Add(new SqlParameter("@DatumRodjenja", SqlDbType.Date, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.DatumRodjenja)); Cm.Parameters.Add(new SqlParameter("@MestoRodjenja", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.MestoRodjenja)); Cm.Parameters.Add(new SqlParameter("@OpstinaRodjenja", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.OpstinaRodjenja)); Cm.Parameters.Add(new SqlParameter("@DrzavaRodjenja", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.DrzavaRodjenja)); Cm.Parameters.Add(new SqlParameter("@KontaktTelefonUcenika", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.KontaktTelefonUcenika)); Cm.Parameters.Add(new SqlParameter("@EmailUcenika", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.EmailUcenika)); Cm.Parameters.Add(new SqlParameter("@ImeOca", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.ImeOca)); Cm.Parameters.Add(new SqlParameter("@PrezimeOca", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.PrezimeOca)); Cm.Parameters.Add(new SqlParameter("@KontaktTelefonOca", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.KontaktTelefonOca)); Cm.Parameters.Add(new SqlParameter("@EmailOca", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.EmailOca)); Cm.Parameters.Add(new SqlParameter("@ImeMajke", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.ImeMajke)); Cm.Parameters.Add(new SqlParameter("@PrezimeMajke", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.PrezimeMajke)); Cm.Parameters.Add(new SqlParameter("@KontaktTelefonMajke", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.KontaktTelefonMajke)); Cm.Parameters.Add(new SqlParameter("@EmailMajke", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.EmailMajke)); Cm.Parameters.Add(new SqlParameter("@LoginSifra", SqlDbType.NVarChar, 4000, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, izmeniti.LoginSifra)); Cm.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, true, 0, 0, "", DataRowVersion.Current, Ret)); Cn.Open(); Cm.ExecuteNonQuery(); Cn.Close(); Ret = (int)Cm.Parameters["@RETURN_VALUE"].Value; return(Ret); } catch (Exception ex) { Console.WriteLine(ex); return(99); } }