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