private void add_SMALL_User_SubCategories(List <string> list_User_Categories,
ref List <List <User_SubCategories> > list_SMALL_User_SubCategories,
User_SubCategories subCat)
{
for (int i = 0; i < list_User_Categories.Count; i++)
{
if (subCat.U_CategoryID.Equals(list_User_Categories[i]))
{
list_SMALL_User_SubCategories[i].Add(subCat);
}
}
}
// V2.0 ----------------------------------------------------------------------------------------------------------------------------------------------------
public List <User_SubCategories> getAllSubCategories()
{
//string strSelect = "SELECT [U_SubCategoryID] ,[SubCategoryName] ,[U_CategoryID] FROM [RS].[USER_SUBCATEGORY_TBL]";
string strSelect = "SELECT DISTINCT [U_SubCategoryID],[U_CategoryID] FROM [RS].[USER_TBL]";
SqlDataReader dr = executeReader(strSelect);
List <User_SubCategories> list = new List <User_SubCategories>();
while (dr.Read())
{
User_SubCategories obj = new User_SubCategories();
obj.U_SubCategoryID = dr.GetString(dr.GetOrdinal("U_SubCategoryID"));
//obj.SubCategoryName = dr.GetString(dr.GetOrdinal("SubCategoryName"));
obj.U_CategoryID = dr.GetString(dr.GetOrdinal("U_CategoryID"));
list.Add(obj);
}
dr.Close();
return(list);
}
private void add_SMALL_User_SubCategories(List<string> list_User_Categories,
ref List<List<User_SubCategories>> list_SMALL_User_SubCategories,
User_SubCategories subCat)
{
for (int i = 0; i < list_User_Categories.Count; i++)
if (subCat.U_CategoryID.Equals(list_User_Categories[i]))
list_SMALL_User_SubCategories[i].Add(subCat);
}
// V2.0 ----------------------------------------------------------------------------------------------------------------------------------------------------
public List<User_SubCategories> getAllSubCategories()
{
//string strSelect = "SELECT [U_SubCategoryID] ,[SubCategoryName] ,[U_CategoryID] FROM [RS].[USER_SUBCATEGORY_TBL]";
string strSelect = "SELECT DISTINCT [U_SubCategoryID],[U_CategoryID] FROM [RS].[USER_TBL]";
SqlDataReader dr = executeReader(strSelect);
List<User_SubCategories> list = new List<User_SubCategories>();
while (dr.Read())
{
User_SubCategories obj = new User_SubCategories();
obj.U_SubCategoryID = dr.GetString(dr.GetOrdinal("U_SubCategoryID"));
//obj.SubCategoryName = dr.GetString(dr.GetOrdinal("SubCategoryName"));
obj.U_CategoryID = dr.GetString(dr.GetOrdinal("U_CategoryID"));
list.Add(obj);
}
dr.Close();
return list;
}
