public void R4(Predict_DAO_MCol dao, RecommdationSchedule schedule) { List <Recommendation_Meta_Item> recommendationR4 = this.GetRecommendationR4(dao, 2.0); this.Normaliser(recommendationR4); dao.InsertList(recommendationR4, schedule); }
public void InsertListNewUser(List <Recommendation_Meta_Item> list, RecommdationSchedule schedule) { try { int i = 0; foreach (Recommendation_Meta_Item item in list) { string str = i.ToString(); Dictionary <string, object> parameters = new Dictionary <string, object>(); string[] MetaID = item.MetaItemID.Split('_'); item.MetaItemID = MetaID[0]; item.ItemFamillyCode = MetaID[1]; parameters.Add("@F1", schedule.ScheduleID); parameters.Add("@F2", item.Quantity.ToString(CultureInfo.CreateSpecificCulture("en-GB"))); parameters.Add("@F3", item.Score.ToString(CultureInfo.CreateSpecificCulture("en-GB"))); command.Parameters.Clear(); foreach (KeyValuePair <string, object> pair in parameters) { command.Parameters.AddWithValue(pair.Key, pair.Value); } command.CommandText = "INSERT INTO [RS].[RECOMMENDATION_NEWUSERS_TBL]([ScheduleID],[MetaItemID],[U_SubCategoryID],[Quantity],[Score],[RecommendType],[ItemFamillyCode]) " + "VALUES (@F1, '" + item.MetaItemID + "','" + item.UserID + "',@F2, @F3, '" + item.RecommendType + "','" + item.ItemFamillyCode + "')"; int nbRow = command.ExecuteNonQuery(); i++; } } catch (Exception ex) { throw ex; } }
public void R3(Predict_DAO_MCol dao, RecommdationSchedule schedule) { List <Recommendation_Meta_Item> recommendationR3 = this.GetRecommendationR3(dao); List <Recommendation_Meta_Item> traditionalUsersR3 = this.GetQuantityTraditionalUsersR3(dao, recommendationR3); this.Normaliser(traditionalUsersR3); dao.InsertList(traditionalUsersR3, schedule); }
public void R1(Predict_DAO_MCol dao, RecommdationSchedule schedule) { List <Recommendation_Meta_Item> traditionalUsers1 = this.getListRecommendation_R1_TraditionalUsers(dao); List <Recommendation_Meta_Item> traditionalUsers2 = this.GetQuantityTraditionalUsers(dao, traditionalUsers1); this.Normaliser(traditionalUsers2); dao.InsertList(traditionalUsers2, schedule); }
public void R1R4_FOR_NEW_USERS(Predict_DAO_MCol dao, RecommdationSchedule schedule, Dictionary <string, double> UCA) { List <Recommendation_Meta_Item> lrc_ForNewUsers = GetListR1R4_ForNewUsers(dao, UCA); // lrc_ForNewUsers = GetQuantityNewUsers(dao, lrc_ForNewUsers); Normaliser(lrc_ForNewUsers); dao.InsertListNewUser(lrc_ForNewUsers, schedule); }
public void R4(Predict_DAO_MCol dao, RecommdationSchedule schedule, double paramR4, Dictionary <string, double> UCA, List <QTY_GAP> lst) { List <Recommendation_Meta_Item> list = GetRecommendationR4(dao, paramR4, UCA); Normaliser(list); AddGAPtoListRecommends(lst, list); dao.InsertList(list, schedule); }
public void R1(Predict_DAO_MCol dao, RecommdationSchedule schedule, int nbR1, Dictionary <string, double> UCA, List <QTY_GAP> list) { //Get recommendations for traditional users List <Recommendation_Meta_Item> lrc_ForUserTra = getListRecommendation_R1_TraditionalUsers(dao, nbR1); lrc_ForUserTra = GetQuantityTraditionalUsers(dao, lrc_ForUserTra, UCA); Normaliser(lrc_ForUserTra); AddGAPtoListRecommends(list, lrc_ForUserTra); dao.InsertList(lrc_ForUserTra, schedule); }
public void R3(Predict_DAO_MCol dao, RecommdationSchedule schedule, int nbR3, Dictionary <string, double> UCA, List <QTY_GAP> lst) { List <Recommendation_Meta_Item> list = GetRecommendationR3(dao, nbR3); list = GetQuantityTraditionalUsersR3(dao, list, UCA); dao.RemoveDuplicateR3R1(); Normaliser(list); AddGAPtoListRecommends(lst, list); dao.InsertList(list, schedule); }
public void setRCPurchasedItems(Predict_DAO dao, RecommdationSchedule schedule, int nbR2, List <QTY_GAP> lst) { }
public void LoadRecommendation(string LoginID) { Predict_DAO_MCol dao = null; RecommdationSchedule schedule = new RecommdationSchedule(); schedule.Log = "Recommendation"; schedule.LoginID = LoginID; Predict_MC predictMC = new Predict_MC(); try { dao = new Predict_DAO_MCol(); dao.beginTransaction(); RecommdationSchedule currentSchedule = dao.addRecommdationSchedule(schedule); //Settings st = getSettings(); Settings r = predictMC.GetRecommendationSeting(dao); Dictionary <string, double> UCA = predictMC.getUCA(dao); //Data service IntergrationManager manager = new IntergrationManager(); manager.execute(); //Clustering service new ClusterUsers().startClusteringAuto(); /* * * * this paragraph need to rewrite * * */ //calculate confident matrix - c4 ComputeConfident(dao); // calculate dist matrix - C5 ComputeDIST(dao); //===================================================================================== dao.CLEAN_RECOMMENDATION(); // R1 DateTime startC6 = DateTime.Now; // predictMC.R1(dao, currentSchedule, r.nbR1, UCA, lstGAP); predictMC.R1(dao, currentSchedule); DateTime endC6 = DateTime.Now; int time_Seconds_CLC6 = Convert.ToInt32((endC6 - startC6).TotalSeconds); //////R2 //DateTime startC7 = DateTime.Now; //setRCPurchasedItems(dao, currentSchedule, r.nbR2, lstGAP); //DateTime endC7 = DateTime.Now; //int time_Seconds_CLC7 = Convert.ToInt32((endC7 - startC7).TotalSeconds); //// R3 DateTime startC8 = DateTime.Now; // predictMC.R3(dao, currentSchedule, r.nbR3, UCA, lstGAP); predictMC.R3(dao, currentSchedule); DateTime endC8 = DateTime.Now; int time_Seconds_CLC8 = Convert.ToInt32((endC8 - startC8).TotalSeconds); //// R4 DateTime startC9 = DateTime.Now; // predictMC.R4(dao, currentSchedule, r.paramR4, UCA, lstGAP); predictMC.R4(dao, currentSchedule); DateTime endC9 = DateTime.Now; int time_Seconds_CLC9 = Convert.ToInt32((endC9 - startC9).TotalSeconds); ////Get R1R4 for new users DateTime startR1R4NewUsers = DateTime.Now; predictMC.R1R4_FOR_NEW_USERS(dao, currentSchedule, UCA); DateTime endR1R4NewUsers = DateTime.Now; int time_second_R1R4NewUsers = Convert.ToInt32((endR1R4NewUsers - startR1R4NewUsers).TotalSeconds); //GetPrice //dao.GetPrice(); Console.WriteLine("FINISH"); // build statistic log List <string[]> lstStatic = dao.getStaticsData(); foreach (string[] statics in lstStatic) { schedule.Log += statics[0] + statics[1] + ". "; } schedule.Log += "Time to find LRS01 : " + time_Seconds_CLC6.ToString() + ". "; //schedule.Log += "Time to find LRS02 : " + time_Seconds_CLC7.ToString() + ". "; schedule.Log += "Time to find LRS03 : " + time_Seconds_CLC8.ToString() + ". "; schedule.Log += "Time to find LRS04 : " + time_Seconds_CLC9.ToString() + ". "; schedule.Log += "Time to find recommendations for new clients : " + time_second_R1R4NewUsers.ToString() + ". "; schedule.Log += "System successfully stopped at " + DateTime.Now.ToString(); dao.updateRecommdationSchedule(schedule); dao.commitTransaction(); } catch (Exception ex) { dao.rollbackTransaction(); throw ex; } }