private static void Insert(SqlDataReader reader, Dictionary<String, User> users) { String user_id = reader["user_id"].ToString(); user_id = user_id.ToLower(); if (!reader["review_helpfulness"].Equals(DBNull.Value)) { int rating = (int)reader["review_helpfulness"]; if (rating != -1) { if (!users.ContainsKey(user_id)) { User newUser = new User(user_id); newUser.Update(reader["product_category"].ToString(), rating); users.Add(user_id, newUser); } else { User curUser = users[user_id]; curUser.Update(reader["product_category"].ToString(), rating); } } } }
private static int userExpComparator(User u1, User u2) { CredibilityInfo info1 = u1.GetCredibilityInfo("Movies"); CredibilityInfo info2 = u2.GetCredibilityInfo("Movies"); if (info1.Expertise < info2.Expertise) return 1; else if (info1.Expertise > info2.Expertise) return -1; else { if (info1.RatingCount > info2.RatingCount) return -1; else if (info1.RatingCount < info2.RatingCount) return 1; else return 0; } }
private static int userTrComparator(User u1, User u2) { CredibilityInfo info1 = u1.GetCredibilityInfo("Movies"); CredibilityInfo info2 = u2.GetCredibilityInfo("Movies"); if (info1.Trustworthiness < info2.Trustworthiness) return 1; else if (info1.Trustworthiness > info2.Trustworthiness) return -1; else { if (info1.TrusteeCount > info2.TrusteeCount) return -1; else if (info1.TrusteeCount < info2.TrusteeCount) return 1; else return 0; } }
private static void InsertIntoTable(User u, String table, SqlConnection connection) { foreach(String category in User.CategoryName) { CredibilityInfo info = u.Credibility[category]; if(info != null) { String query = "insert into [" + table + "] "; query += "values (" + g_count++ + ", " + "'" + u.Name + "', " + "'" + category + "', " + info.Expertise + ", " + info.RatingCount + ", " + info.Trustworthiness + ", " + info.TrusteeCount + ")" ; SqlCommand cmd = new SqlCommand(query, connection); cmd.ExecuteNonQuery(); } } }