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;
}
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;
}
