private static long?proposeProjectLocationId(Session paramSession, BimProjectMetadata paramBimProjectMetadata) { if (paramBimProjectMetadata == null) { return(null); } string str1 = paramBimProjectMetadata.GlobalId; string str2 = paramBimProjectMetadata.Name; if (string.ReferenceEquals(str1, null) || str1.Trim().Length == 0) { System.Collections.IList list1 = paramSession.createSQLQuery("select ID from BC_PROJECT where NAME = :name and (DELETED = 0 or DELETED is null)").setString("name", str2).list(); return(list1.Count == 0 ? null : Convert.ToInt64(((Number)list1[0]).longValue())); } System.Collections.IList list = paramSession.createSQLQuery("select ID from BC_PROJECT where GLOBALID = :globalId and (DELETED = 0 or DELETED is null)").setString("globalId", str1).list(); return(list.Count == 0 ? null : Convert.ToInt64(((Number)list[0]).longValue())); }
private static BimProjectMetadata gatherProjectMetadata(Session paramSession, long paramLong) { SQLQuery sQLQuery = paramSession.createSQLQuery("SELECT NAME, GLOBALID, PARENT_ID from BC_PROJECT where ID = :id"); sQLQuery.setLong("id", paramLong); System.Collections.IList list = sQLQuery.list(); if (list.Count == 0) { return(null); } object[] arrayOfObject = (object[])list[0]; string str1 = (string)arrayOfObject[0]; string str2 = (string)arrayOfObject[1]; Number number = (Number)arrayOfObject[2]; BimProjectMetadata bimProjectMetadata = new BimProjectMetadata(); bimProjectMetadata.GlobalId = str2; bimProjectMetadata.Name = str1; if (number != null) { bimProjectMetadata.Parent = gatherProjectMetadata(paramSession, number.longValue()); } return(bimProjectMetadata); }