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