public List<U_I_Q> GetQuantityTraditionalUsers_More(string cluster)
{
List<U_I_Q> list = new List<U_I_Q>();
U_I_Q item;
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("@cluster", cluster);
string sql = "SELECT MetaItemID, QAV from [RS].[QTY_PAR_CLUSTER] WHERE ClusterID = @cluster";
SqlDataReader dr = executeReader(sql, parameters);
while (dr.Read())
{
item = new U_I_Q();
item.MetaItemID = dr[0].ToString();
item.QTY = Convert.ToDouble(dr[1]);
if (item.QTY < 0) item.QTY = 1;
list.Add(item);
}
dr.Close();
return list;
}
public List<Recommendation_Meta_Item> GetAllQuantity(List<Recommendation_Meta_Item> list)
{
List<U_I_Q> lstSubCate = new List<U_I_Q>();
List<U_I_Q> lstcate = new List<U_I_Q>();
U_I_Q item;
string sql = "SELECT U_SubCategoryID, MetaItemID, QAV FROM [RS].[QTY_PAR_SUBCATEGORY]";
SqlDataReader dr = executeReader(sql);
while (dr.Read())
{
item = new U_I_Q();
item.UserID = dr[0].ToString();
item.MetaItemID = dr[1].ToString();
item.QTY = Convert.ToDouble(dr[2]);
lstSubCate.Add(item);
}
dr.Close();
dr = executeReader("SELECT U_CategoryID, MetaItemID, QAV FROM [RS].[QTY_PAR_CATEGORY]");
while (dr.Read())
{
item = new U_I_Q();
item.UserID = dr[0].ToString();
item.MetaItemID = dr[1].ToString();
item.QTY = Convert.ToDouble(dr[2]);
lstcate.Add(item);
}
dr.Close();
foreach (Recommendation_Meta_Item R in list)
{
dr = executeReader("Select UserID, U_SubcategoryID From [RS].[User_TBL] Where U_SubCategoryID = '" + R.UserID + "'");
dr.Read(); string Ucate = dr[1].ToString();
dr.Close();
bool Check = false;
for (int j = 0; j < lstSubCate.Count; j++)
{
if (lstSubCate[j].UserID.Equals(Ucate))
{
R.Quantity = lstSubCate[j].QTY;
Check = true;
break;
}
}
//if Sub rong
if (!Check)
{
dr = executeReader("Select UserID, U_categoryID From [RS].[User_TBL] Where UserID = '" + R.UserID + "'");
dr.Read(); string USub = dr[1].ToString();
dr.Close();
for (int j = 0; j < lstcate.Count; j++)
{
if (lstcate[j].UserID.Equals(USub))
{
R.Quantity = lstcate[j].QTY;
break;
}
}
}
}
return list;
}