예제 #1
0
        public static Category GetCategoryByID(int CategoryID)
        {
            Category category = null;

            DataTable dtCategories = SQLWrapper.GetDataTable(new SelectQueryData { TableName = "CMN_Categories",  FilterCondition = "CategoryID = " + CategoryID.ToString(), OrderBy = "Sequence" });
            if (dtCategories.Rows.Count > 0)
            {
                category = new Category();
                category.CategoryID = Convert.ToInt32(dtCategories.Rows[0]["CategoryID"]);
                category.CategoryName = dtCategories.Rows[0]["CategoryName"].ToString();
                category.ForUser = DALAppUser.GetUserByID(Convert.ToInt32(dtCategories.Rows[0]["UserID"]));
                category.Sequence = Convert.ToInt32(dtCategories.Rows[0]["Sequence"]);
            }
            return category;
        }
예제 #2
0
 private int getIndexOfCategory(Category category)
 {
     int returnData = -1;
     for (int i = 0; i <= chklstCategory.Items.Count - 1; i++)
     {
         Category cat = (Category)chklstCategory.Items[i];
         if (cat.CategoryID == category.CategoryID)
         {
             returnData = i;
             break;
         }
     }
     return returnData;
 }