public static int SelektovanjeOdeljenja(Odeljenja select, int BrojPoStrani, int TrenutnaStrana)
{
try
{
SqlCommand Cm = new SqlCommand();
Cm.Connection = Cn;
Cm.CommandType = CommandType.StoredProcedure;
Cm.CommandText = "dbo.odeljenjaSELECT";
int Ret = 99;
//@BrojPoStrani int = 20, @TrenutnaStrana int, @BrojOdeljenja int, @GodinaSkolovanja int, @SkolskaGodina int = year
Cm.Parameters.Add(new SqlParameter("@BrojPoStrani", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, BrojPoStrani));
Cm.Parameters.Add(new SqlParameter("@TrenutnaStrana", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, TrenutnaStrana));
Cm.Parameters.Add(new SqlParameter("@BrojOdeljenja", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, select.BrojOdeljenja));
Cm.Parameters.Add(new SqlParameter("@GodinaSkolovanja", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, select.RazredniID));
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)
{
return(99);
}
}
public static int DodavanjeOdeljenja(Odeljenja dodati)
{
try
{
SqlCommand Cm = new SqlCommand();
Cm.Connection = Cn;
Cm.CommandType = CommandType.StoredProcedure;
Cm.CommandText = "dbo.odeljenjaUPDATE";
int Ret = 99;
Cm.Parameters.Add(new SqlParameter("@OdeljenjeID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, dodati.OdeljenjeID));
Cm.Parameters.Add(new SqlParameter("@RazredniID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Current, dodati.RazredniID));
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)
{
return(99);
}
}
