Example #1
0
        public static LTD_InfoCategory GetDefaultLtdInfoCategory()
        {
            LTD_InfoCategory ltdInfoCategory = null;

            Database db = HaveDb();
            if (db != null)
            {
                long totalPages = 0;
                long totalItems = 0;
                List<LTD_InfoCategory> categoryList = GetPagedLtdInfoCategory(1, 1, out totalPages, out totalItems, "", " Where IsDefault=@0", true);
                if (totalItems > 0)
                {
                    ltdInfoCategory = categoryList[0];
                }
                else if (totalItems ==0)
                {
                    categoryList = DataSource.GetPagedLtdInfoCategory(1, 1, out totalPages, out totalItems, "", "");
                    if (totalItems > 0)
                    {
                        ltdInfoCategory = categoryList[0];
                    }
                }
            }
            else
            {
                Dictionary<Guid, LTD_InfoCategory> allLtdInfoCategoryList = FileSource.LoadLTDInfoCategoryData();
                foreach (KeyValuePair<Guid, LTD_InfoCategory> item in allLtdInfoCategoryList)
                {
                    ltdInfoCategory = item.Value;
                    if (item.Value.IsDefault == true)
                    {
                        ltdInfoCategory = item.Value;
                        break;
                    }
                }
            }

            return ltdInfoCategory;
        }
Example #2
0
        public static CNS_DataRefType GetCnsDataRefType(string dataRefType)
        {
            CNS_DataRefType cnsDataRefType = null;

            Database db = HaveDb();
            if (db != null)
            {
                cnsDataRefType = db.SingleOrDefault<CNS_DataRefType>("SELECT * FROM CNS_DataRefType Where DataRefType=@0", dataRefType);
            }
            else
            {
                Dictionary<Guid, CNS_DataRefType> allCnsDataRefTypeList = FileSource.LoadCNSDataRefTypeData();
                foreach (KeyValuePair<Guid, CNS_DataRefType> item in allCnsDataRefTypeList)
                {
                    if (item.Value.DataRefType == dataRefType)
                    {
                        cnsDataRefType = item.Value;
                        break;
                    }
                }
            }
            return cnsDataRefType;
        }