// Load All Objects from Database
public List <ObjectData> GetObjects()
{
List <ObjectData> objects = new List <ObjectData>();
DALProperty property = new DALProperty();
DataSet ds = property.getObjects();
objects = (from tmp in ds.Tables[0].AsEnumerable()
select new ObjectData
{
SiteID = tmp.Field <int?>("SiteID") == null ? 0 : tmp.Field <int>("SiteID"),
ObjectID = tmp.Field <int>("ObjectID"),
ObjName = tmp.Field <string>("ObjName"),
ObjType = tmp.Field <string>("ObjType"),
ObjSubType = tmp.Field <string>("ObjSubType"),
Obj_Ref_1 = tmp.Field <string>("Obj_Ref_1"),
Obj_Ref_2 = tmp.Field <string>("Obj_Ref_2"),
Obj_Ref_3 = tmp.Field <string>("Obj_Ref_3"),
Obj_Ref_4 = tmp.Field <string>("Obj_Ref_4"),
Obj_Ref_5 = tmp.Field <string>("Obj_Ref_5"),
Obj_Ref_6 = tmp.Field <string>("Obj_Ref_6"),
Obj_Ref_7 = tmp.Field <string>("Obj_Ref_7"),
Obj_Ref_8 = tmp.Field <string>("Obj_Ref_8"),
Obj_Ref_9 = tmp.Field <string>("Obj_Ref_9"),
Obj_Ref_10 = tmp.Field <string>("Obj_Ref_10"),
}).ToList();
return(objects);
}
public List<MenuTree> GetTreeData()
{
List<MenuTree> objects = new List<MenuTree>();
DALProperty property = new DALProperty();
DataSet ds = property.getObjects();
objects = (from tmp in ds.Tables[0].AsEnumerable()
select new MenuTree
{
ObjType = tmp.Field<string>("ObjType"),
ObjSubType = tmp.Field<string>("ObjSubType"),
ObjName = tmp.Field<string>("ObjName"),
}).ToList();
return objects;
}
public List <MenuTree> GetTreeData()
{
List <MenuTree> objects = new List <MenuTree>();
DALProperty property = new DALProperty();
DataSet ds = property.getObjects();
objects = (from tmp in ds.Tables[0].AsEnumerable()
select new MenuTree
{
ObjType = tmp.Field <string>("ObjType"),
ObjSubType = tmp.Field <string>("ObjSubType"),
ObjName = tmp.Field <string>("ObjName"),
}).ToList();
return(objects);
}
// Load All Objects from Database
public List<ObjectData> GetObjects()
{
List<ObjectData> objects = new List<ObjectData>();
DALProperty property = new DALProperty();
DataSet ds = property.getObjects();
objects = (from tmp in ds.Tables[0].AsEnumerable()
select new ObjectData
{
SiteID = tmp.Field<int?>("SiteID") == null ? 0 : tmp.Field<int>("SiteID"),
ObjectID = tmp.Field<int>("ObjectID"),
ObjName = tmp.Field<string>("ObjName"),
ObjType = tmp.Field<string>("ObjType"),
ObjSubType = tmp.Field<string>("ObjSubType"),
Obj_Ref_1 = tmp.Field<string>("Obj_Ref_1"),
Obj_Ref_2 = tmp.Field<string>("Obj_Ref_2"),
Obj_Ref_3 = tmp.Field<string>("Obj_Ref_3"),
Obj_Ref_4 = tmp.Field<string>("Obj_Ref_4"),
Obj_Ref_5 = tmp.Field<string>("Obj_Ref_5"),
Obj_Ref_6 = tmp.Field<string>("Obj_Ref_6"),
Obj_Ref_7 = tmp.Field<string>("Obj_Ref_7"),
Obj_Ref_8 = tmp.Field<string>("Obj_Ref_8"),
Obj_Ref_9 = tmp.Field<string>("Obj_Ref_9"),
Obj_Ref_10 = tmp.Field<string>("Obj_Ref_10"),
}).ToList();
return objects;
}
