/// <summary> /// Clones GreyFoxRole object and clones child objects with cloning or replication. /// as the parent object. /// </summary> /// <returns> A new GreyFoxRole object reflecting the replicated GreyFoxRole object.</returns> public GreyFoxRole Clone() { lock (this) { GreyFoxRole clonedGreyFoxRole = new GreyFoxRole(); clonedGreyFoxRole.iD = iD; clonedGreyFoxRole.isSynced = isSynced; clonedGreyFoxRole.name = name; clonedGreyFoxRole.description = description; clonedGreyFoxRole.isDisabled = isDisabled; return(clonedGreyFoxRole); } }
/// <summary> /// Fills the {0} from a OleIDataReader. /// </summary> public static void FillFromReader(GreyFoxRole greyFoxRole, IDataReader r, int idOffset, int dataOffset) { greyFoxRole.iD = r.GetInt32(idOffset); greyFoxRole.isSynced = true; greyFoxRole.isPlaceHolder = false; greyFoxRole.name = r.GetString(0 + dataOffset); if (!r.IsDBNull(1 + dataOffset)) { greyFoxRole.description = r.GetString(1 + dataOffset); } else { greyFoxRole.description = null; } greyFoxRole.isDisabled = r.GetBoolean(2 + dataOffset); }
internal static bool _fill(GreyFoxRole greyFoxRole) { // Clone item from cache. if (cacheEnabled) { object cachedObject = cacheFind(greyFoxRole.iD); if (cachedObject != null) { ((GreyFoxRole)cachedObject).CopyTo(greyFoxRole, true); return(greyFoxRole.isSynced); } } StringBuilder query; Database database; DbCommand dbCommand; query = new StringBuilder("SELECT "); query.Append(string.Join(",", InnerJoinFields)); query.Append(" FROM sysGlobal_Roles WHERE GreyFoxRoleID="); query.Append(greyFoxRole.iD); query.Append(";"); database = DatabaseFactory.CreateDatabase(); dbCommand = database.GetSqlStringCommand(query.ToString()); IDataReader r = database.ExecuteReader(dbCommand); if (!r.Read()) { throw(new Exception(string.Format("Cannot find GreyFoxRoleID '{0}'.", greyFoxRole.iD))); } FillFromReader(greyFoxRole, r, 0, 1); // Microsoft DAAB still needs to have the reader closed. r.Close(); // Store greyFoxRole in cache. if (cacheEnabled) { cacheStore(greyFoxRole); } return(true); }
public int Add(GreyFoxRole value) { OnCollectionChanged(EventArgs.Empty); lock (this) { count++; // Resize the array if the count is greater than the length // of the array. if (count > GreyFoxRoleArray.GetUpperBound(0) + 1) { GreyFoxRole[] tempGreyFoxRoleArray = new GreyFoxRole[count * 2]; Array.Copy(GreyFoxRoleArray, tempGreyFoxRoleArray, count - 1); GreyFoxRoleArray = tempGreyFoxRoleArray; } GreyFoxRoleArray[count - 1] = value; } return(count - 1); }
public static void FillRoles(GreyFoxUser greyFoxUser) { StringBuilder s; Database database; DbCommand dbCommand; IDataReader r; s = new StringBuilder("SELECT GreyFoxRoleID FROM sysGlobal_UsersChildren_Roles "); s.Append("WHERE GreyFoxUserID="); s.Append(greyFoxUser.iD); s.Append(";"); database = DatabaseFactory.CreateDatabase(); dbCommand = database.GetSqlStringCommand(s.ToString()); r = database.ExecuteReader(dbCommand); GreyFoxRoleCollection roles; if (greyFoxUser.roles != null) { roles = greyFoxUser.roles; roles.Clear(); } else { roles = new GreyFoxRoleCollection(); greyFoxUser.roles = roles; } while (r.Read()) { roles.Add(GreyFoxRole.NewPlaceHolder(r.GetInt32(0))); } greyFoxUser.Roles = roles; // Store GreyFoxUser in cache. if (cacheEnabled) { cacheStore(greyFoxUser); } }
public void Insert(int index, GreyFoxRole value) { OnCollectionChanged(EventArgs.Empty); lock (this) { count++; // Resize the array if the count is greater than the length // of the array. if (count > GreyFoxRoleArray.GetUpperBound(0) + 1) { GreyFoxRole[] tempGreyFoxRoleArray = new GreyFoxRole[count * 2]; Array.Copy(GreyFoxRoleArray, tempGreyFoxRoleArray, count - 1); GreyFoxRoleArray = tempGreyFoxRoleArray; } for (int x = index + 1; x == count - 2; x++) { GreyFoxRoleArray[x] = GreyFoxRoleArray[x - 1]; } GreyFoxRoleArray[index] = value; } }
/// <summary> /// Compares the object's ID to another object's ID. /// </summary> public int CompareTo(GreyFoxRole greyFoxRole) { return(this.iD - greyFoxRole.iD); }
/// <summary> /// Compares the object's ID to another object's ID. /// </summary> int IComparable.CompareTo(object obj) { GreyFoxRole greyFoxRole = (GreyFoxRole)obj; return(this.iD - greyFoxRole.iD); }
/// <summary> /// Deep copies the current GreyFoxRole to another instance of GreyFoxRole. /// This method does not provide isolated copies; use overriden method for this feature. /// </summary> /// <param name="GreyFoxRole">The GreyFoxRole to copy to.</param> public void CopyTo(GreyFoxRole greyFoxRole) { CopyTo(greyFoxRole, false); }
private static void cacheStore(GreyFoxRole greyFoxRole) { CacheManager cache = CacheFactory.GetCacheManager(); cache.Add("sysGlobal_Roles_" + greyFoxRole.iD.ToString(), greyFoxRole); }
public GreyFoxRoleCollection GetCollection(int topCount, string whereClause, string sortClause) { StringBuilder query; Database database; DbCommand dbCommand; IDataReader r; GreyFoxRoleCollection greyFoxRoleCollection; query = new StringBuilder("SELECT "); if (topCount > 0) { query.Append("TOP "); query.Append(topCount); query.Append(" "); } foreach (string columnName in InnerJoinFields) { query.Append("GreyFoxRole."); query.Append(columnName); query.Append(","); } // // Remove trailing comma // query.Length--; query.Append(" FROM sysGlobal_Roles AS GreyFoxRole"); // // Render where clause // if (whereClause != string.Empty) { query.Append(" WHERE "); query.Append(whereClause); } // // Render sort clause // if (sortClause != string.Empty) { query.Append(" ORDER BY "); query.Append(sortClause); } // // Render final semicolon // query.Append(";"); database = DatabaseFactory.CreateDatabase(); dbCommand = database.GetSqlStringCommand(query.ToString()); #if DEBUG try { r = database.ExecuteReader(dbCommand); } catch (Exception e) { string msg = e.Message; throw(new Exception(msg + " --- Query: " + query.ToString())); } #else r = database.ExecuteReader(dbCommand); #endif greyFoxRoleCollection = new GreyFoxRoleCollection(); while (r.Read()) { GreyFoxRole greyFoxRole = ParseFromReader(r, 0, 1); greyFoxRoleCollection.Add(greyFoxRole); } // Microsoft DAAB still needs to close readers. r.Close(); return(greyFoxRoleCollection); }
public bool Contains(GreyFoxRole value) { return(IndexOf(value) != -1); }