예제 #1
0
        public static ModuleRatingInfo getRating(int moduleID)
        {
            ModuleRatingInfo retVal = new ModuleRatingInfo();

            retVal.ModuleID = moduleID;

            IDbCommand cmd = new SqlCommand();

            cmd.Connection  = new SqlConnection(Globals.ConnectionString);
            cmd.CommandText = "SELECT Rating, NumRatings, ThreadID " +
                              "FROM ModuleRatings WHERE ModuleID = @ModuleID";
            cmd.Parameters.Add(new SqlParameter("@ModuleID", moduleID));

            IDataReader reader = null;

            try {
                cmd.Connection.Open();
                reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

                if (reader.Read())
                {
                    retVal.Rating     = Convert.ToSingle(reader["Rating"]);
                    retVal.NumRatings = Convert.ToInt32(reader["NumRatings"]);
                    retVal.ThreadID   = Convert.ToInt32(reader["ThreadID"]);
                }
            } catch (SqlException e) {
                throw e;
            } finally {
                reader.Close();
            }

            return(retVal);
        }
예제 #2
0
        public static void updateRating(ModuleRatingInfo ri)
        {
            IDbCommand cmd = new SqlCommand();

            cmd.Connection  = new SqlConnection(Globals.ConnectionString);
            cmd.CommandText = "UPDATE ModuleRatings " +
                              "SET Rating = @Rating, NumRatings = @NumRatings WHERE ModuleID = @ModuleID";
            cmd.Parameters.Add(new SqlParameter("@Rating", ri.Rating));
            cmd.Parameters.Add(new SqlParameter("@NumRatings", ri.NumRatings));
            cmd.Parameters.Add(new SqlParameter("@ModuleID", ri.ModuleID));

            try {
                cmd.Connection.Open();
                cmd.ExecuteNonQuery();
            } catch (SqlException e) {
                throw e;
            } finally {
                cmd.Connection.Close();
            }
        }
예제 #3
0
        public static void createRating(ModuleRatingInfo ri)
        {
            IDbCommand cmd = new SqlCommand();

            cmd.Connection  = new SqlConnection(Globals.ConnectionString);
            cmd.CommandText = "INSERT INTO ModuleRatings " +
                              "( ModuleID, Rating, NumRatings, ThreadID ) " +
                              "VALUES ( @ModuleID, @Rating, @NumRatings, @ThreadID )";
            cmd.Parameters.Add(new SqlParameter("@ModuleID", ri.ModuleID));
            cmd.Parameters.Add(new SqlParameter("@Rating", ri.Rating));
            cmd.Parameters.Add(new SqlParameter("@NumRatings", ri.NumRatings));
            cmd.Parameters.Add(new SqlParameter("@ThreadID", ri.ThreadID));

            try {
                cmd.Connection.Open();
                cmd.ExecuteNonQuery();
            } catch (SqlException e) {
                throw e;
            } finally {
                cmd.Connection.Close();
            }
        }