public List <Recommendation_Meta_Item> GetRecommendC6_ForSubCategory(string SubCate, int k) { string sql; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@k", k.ToString()); parameters.Add("@SubCate", SubCate); // Recommendation_Meta_Item list = new Recommendation_Meta_Item(); List <Recommendation_Meta_Item> list = new List <Recommendation_Meta_Item>(); Recommendation_Meta_Item item; //----------------------------------------------- sql = "SELECT TOP " + k + " [RS].SCORE_GLOBAL_C6.MetaItemID, SCORE FROM [RS].SCORE_GLOBAL_C6 WHERE [RS].SCORE_GLOBAL_C6.MetaItemID " + "IN(SELECT DISTINCT MetaItemID FROM [RS].ALL_TRANSACTION WHERE UserID IN(SELECT UserID From RS.USER_TBL WHERE U_SubCategoryID = @SubCate)) ORDER BY SCORE DESC"; SqlDataReader dr = executeReader(sql, parameters); bool Check = dr.HasRows; while (dr.Read()) { item = new Recommendation_Meta_Item(); item.UserID = SubCate; //Luu tam thoi item.RecommendType = ConstantValues.RC_TYPE_LRS01; // "Best Selling"; item.MetaItemID = dr[0].ToString(); item.Quantity = 0; item.Score = Convert.ToDouble(dr[1]); list.Add(item); } dr.Close(); if (!Check) { sql = "SELECT TOP " + k + " [RS].[CLUSTER_SCORE_C6].MetaItemID, Q " + "FROM [RS].[CLUSTER_SCORE_C6] " + "WHERE [RS].[CLUSTER_SCORE_C6].MetaItemID IN(SELECT DISTINCT MetaItemID FROM [RS].ALL_TRANSACTION WHERE UserID IN( " + "SELECT UserID From RS.USER_TBL WHERE U_SubCategoryID = @SubCate)) ORDER BY Q DESC"; SqlDataReader dr2 = executeReader(sql, parameters); while (dr2.Read()) { item = new Recommendation_Meta_Item(); item.UserID = SubCate; //Luu tam thoi item.RecommendType = ConstantValues.RC_TYPE_LRS01; //"Best Selling"; item.MetaItemID = dr2[0].ToString(); // item.MetaItemName = dr2[1].ToString(); item.Quantity = 0; item.Score = Convert.ToDouble(dr2[1]); list.Add(item); } dr2.Close(); } return(list); }
public Int32 GetQualtityTraditionalUser(Recommendation_Meta_Item RC) { int QTY = 0; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@UserID", RC.UserID); parameters.Add("@MetaItemID", RC.MetaItemID); string sql = "SELECT AVG([QAV]*[WEIGHT]) AS QTY " + "FROM [RS].[ALL_TRANSACTION], [RS].[WEIGHT_MATRIX] " + "WHERE MetaItemDestination =@MetaItemID AND [MetaItemSource] = [MetaItemID] AND [WEIGHT_MATRIX].ClusterID = [ALL_TRANSACTION].ClusterID AND [UserID] = @UserID"; SqlDataReader dr = executeReader(sql, parameters); while (dr.Read()) { if (!dr.IsDBNull(0)) { double WEI = Convert.ToDouble(dr[0], CultureInfo.CreateSpecificCulture("en-GB")); QTY = (int)WEI; } } dr.Close(); //---------------------------------- if (QTY == 0) { sql = "SELECT AVG([QAV]) AS QTY " + "FROM [RS].[ALL_TRANSACTION] " + "WHERE [MetaItemID] = @MetaItemID AND [UserID] = @UserID"; SqlDataReader dr1 = executeReader(sql, parameters); while (dr1.Read()) { if (!dr1.IsDBNull(0)) { double WEI = Convert.ToDouble(dr1[0], CultureInfo.CreateSpecificCulture("en-GB")); QTY = (int)WEI; } } dr1.Close(); } //-------------------------------- return(QTY); }
public List <Recommendation_Meta_Item> GetRecommendations(string sql) { List <Recommendation_Meta_Item> list = new List <Recommendation_Meta_Item>(); SqlDataReader dr = executeReader(sql); while (dr.Read()) { Recommendation_Meta_Item item = new Recommendation_Meta_Item(); item.UserName = dr.GetString(dr.GetOrdinal("UserName")); item.UserID = dr.GetString(dr.GetOrdinal("UserID")); item.MetaItemID = dr.GetString(dr.GetOrdinal("ItemID")); item.MetaItemName = dr.GetString(dr.GetOrdinal("MetaItemName")); item.Quantity = dr.GetDouble(dr.GetOrdinal("Quantity")); list.Add(item); } dr.Close(); return(list); }
public Recommendation_Meta_Item getCandidateForUserSubCategory_R4(string u_subcategory) { Recommendation_Meta_Item item = new Recommendation_Meta_Item(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@u_subcategory", u_subcategory); string sql = "SELECT TOP 1 U_SUBCATEGORYID, ITEMFAMILLYCODE, RAV as SCORE FROM [RS].SCORE_GLOBAL_C9 where U_SUBCATEGORYID = @u_subcategory " + " AND ITEMFAMILLYCODE IN(SELECT DISTINCT ITEMFAMILLYCODE FROM [RS].NEW_META_ITEM) OrDER BY SCORE DESC"; SqlDataReader dr = executeReader(sql, parameters); while (dr.Read()) { item.UserID = dr[0].ToString(); //luu U_SubcategoryID item.MetaItemID = dr[1].ToString(); //luu famillycode item.Score = Convert.ToDouble(dr[2]); } dr.Close(); return(item); }
public double GetQualtityNewUser(Recommendation_Meta_Item RC) { double QAV = 2; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@UserID", RC.UserID); parameters.Add("@MetaItemID", RC.MetaItemID); string sql = "SELECT QAV FROM [RS].[QTY_PAR_SUBCATEGORY] WHERE [MetaItemID] = @MetaItemID AND [U_SUBCATEGORYID] = (SELECT U_SUBCATEGORYID FROM [RS].USER_TBL WHERE USERID = @UserID)"; SqlDataReader dr = executeReader(sql, parameters); while (dr.Read()) { QAV = Convert.ToDouble(dr[0]); if (QAV < 0) { QAV = 1; } } dr.Close(); return(QAV); }
//have formular here public List <Recommendation_Meta_Item> GetRecommendationR3(Predict_DAO_MCol a) { List <Recommendation_Meta_Item> list1 = new List <Recommendation_Meta_Item>(); Recommendation_Meta_Item recommendationMetaItem1 = new Recommendation_Meta_Item(); List <CONF> list2 = new List <CONF>(); List <DIST> list3 = new List <DIST>(); List <string> list4 = new List <string>(); List <string> list5 = new List <string>(); List <string> list6 = new List <string>(); List <U_I_Q> list7 = new List <U_I_Q>(); foreach (string cluster in a.GetListClusterID()) { List <CONF> confOfCluster = a.GetCONF_OfCluster(cluster); List <DIST> distOfCluster = a.GetDIST_OfCluster(cluster); List <string> listUserOfCluster = a.GetListUser_OfCluster(cluster); List <U_I_Q> traditionalUsersMore = a.GetQuantityTraditionalUsers_More(cluster); foreach (string user in listUserOfCluster) { List <string> notPurchasedOfUser = a.GetListMetaItemNotPurchased_OfUser(user, cluster); List <string> listMetaItemOfUser = a.GetListMetaItem_OfUser(user); string str = ""; double num1 = 0.0; for (int index1 = 0; index1 < notPurchasedOfUser.Count; ++index1) { double num2 = 0.0; double num3 = 0.0; double num4 = 1.0; for (int index2 = 0; index2 < listMetaItemOfUser.Count; ++index2) { for (int index3 = 0; index3 < confOfCluster.Count; ++index3) { if (confOfCluster[index3].MetaItemSource.Equals(listMetaItemOfUser[index2]) && confOfCluster[index3].MetaItemDestination.Equals(notPurchasedOfUser[index1])) { num3 = confOfCluster[index3].Confident; break; } } for (int index3 = 0; index3 < distOfCluster.Count; ++index3) { if (distOfCluster[index3].MetaItemDestination.Equals(listMetaItemOfUser[index2]) && distOfCluster[index3].MetaItemDestination.Equals(notPurchasedOfUser[index1])) { num4 = distOfCluster[index3].Distance; break; } } if (num4 != 0.0) { num2 += num3 / num4; } } if (num1 < num2 / (double)listMetaItemOfUser.Count) { num1 = num2; str = notPurchasedOfUser[index1]; } } if (num1 != 0.0) { Recommendation_Meta_Item recommendationMetaItem2 = new Recommendation_Meta_Item(); recommendationMetaItem2.UserID = user; recommendationMetaItem2.MetaItemID = str; recommendationMetaItem2.RecommendType = ConstantValues.RC_TYPE_LRS03; recommendationMetaItem2.Quantity = 0.0; for (int index = 0; index < traditionalUsersMore.Count; ++index) { if (traditionalUsersMore[index].MetaItemID.Equals(str)) { recommendationMetaItem2.Quantity = traditionalUsersMore[index].QTY; break; } } recommendationMetaItem2.Score = num1; list1.Add(recommendationMetaItem2); } } } return(list1); }