/// <summary> /// Deletes this item /// </summary> /// <returns></returns> /// <exception cref="AttributeNotFoundException">Class attribute parameter 'Mutable' must be seted to 'true'</exception> public virtual bool Delete() { ActiveRecordAttribute attribute = null; CheckTypeAtrribute(this.GetType(), ref attribute); if (!attribute.Mutable) { throw new AttributeNotFoundException("Class attribute parameter 'Mutable' must be seted to 'true'"); } if (!ActiveRecordMaster.Delete(this.GetType(), this)) { return(false); } //Cascade Delete if (ActiveRecordMaster.HasJoinedBase(this.GetType()) != null) { if (ActiveRecordMaster.GetAttribute(this.GetType().BaseType) != null) { if (!ActiveRecordMaster.Delete(this.GetType().BaseType, this)) { return(false); } } } return(true); }
/// <summary> /// Finds an item by primary key. /// </summary> /// <param name="type">The type.</param> /// <param name="id">The id.</param> /// <returns></returns> public static ActiveRecordBase Find(Type type, object id) { CheckTypeAtrribute(type); try { PrimaryKeyAttribute pk = ActiveRecordMaster.GetPrimaryKey(type); if (pk == null) { return(null); } Criteria criteria = Criteria.For(type); criteria.SQLString = ActiveRecordMaster.MakePrimaryKeySelect(type); criteria.AddParameter("@CODE", pk.CurrentPropertyInfo.Name, id); List <ActiveRecordBase> list = ActiveRecordMaster.ExecuteQueryCriteria(type, criteria); if (list != null && list.Count > 0) { return(list[0]); } return(null); } catch (Exception ex) { LogManager.Log("Monty.ActiveRecord", LogCategory.Error, String.Format("Error when tries to execute ActiveRecordBase.FindAll(type: [{0}])", type), ex); return(null); } }
/// <summary> /// Lazy load a property (HasMany). /// </summary> /// <typeparam name="TPropertyClass">The type of the property class.</typeparam> /// <param name="attr">The attr.</param> /// <returns></returns> /// <exception cref="AttributeNotFoundException"></exception> private List <TPropertyClass> LazyLoadMany <TPropertyClass>(HasManyAttribute attr) where TPropertyClass : ActiveRecordBase { ActiveRecordAttribute attribute = ActiveRecordMaster.GetAttribute(this.GetType()); if (attribute == null) { throw new AttributeNotFoundException(); } try { PrimaryKeyAttribute pk = ActiveRecordMaster.GetPrimaryKey(this.GetType()); if (pk == null) { return(null); } Criteria criteria = Criteria.For <TPropertyClass>(); criteria.SQLString = ActiveRecordMaster.MakeHasManySelect(this.GetType(), attr.CurrentPropertyInfo.Name); criteria.AddParameter("@CODE", pk.CurrentPropertyInfo.Name, pk.CurrentPropertyInfo.GetValue(this, null)); return(ActiveRecordMaster.ExecuteQueryCriteria <TPropertyClass>(criteria)); } catch (Exception ex) { LogManager.Log("Monty.ActiveRecord", LogCategory.Error, String.Format("Error when tries to execute ActiveRecordBase.FindByForeignKey(attr: [{0}])", attr), ex); return(null); } }
/// <summary> /// Checks the type atrribute. /// </summary> /// <param name="type">The type.</param> public static void CheckTypeAtrribute(Type type) { ActiveRecordAttribute attribute = ActiveRecordMaster.GetAttribute(type); PrimaryKeyAttribute pk = ActiveRecordMaster.GetPrimaryKey(type); CheckTypeAtrribute(type, ref attribute, ref pk); }
/// <summary> /// Removes the data. /// </summary> static void RemoveData() { Output("Removing data"); ActiveRecordMaster.ExecuteNonQuery("DELETE FROM montyTDocument"); ActiveRecordMaster.ExecuteNonQuery("DELETE FROM montyTPerson"); ActiveRecordMaster.ExecuteNonQuery("DELETE FROM montyTJob"); Output("Data removed"); }
/// <summary> /// Creates a person via SQL. /// </summary> /// <param name="name">The name.</param> /// <param name="birthday">The birthday.</param> /// <param name="currentJob">The current job.</param> /// <returns></returns> static Person CreatePersonSQL(string name, DateTime?birthday, Job currentJob) { string sql = string.Format("INSERT INTO montyTPerson (Name, Birthday, CurrentJob) VALUES ('{0}', null, {1});SELECT last_insert_id() AS 'Identity';", name, currentJob.Id); ActiveRecordMaster.ExecuteNonQuery(sql); return(null); }
/// <summary> /// Lazy load a property (HasMany). /// </summary> /// <typeparam name="TPropertyClass">The type of the property class.</typeparam> /// <param name="property">The property.</param> /// <returns></returns> protected List <TPropertyClass> LazyLoadMany <TPropertyClass>(string property) where TPropertyClass : ActiveRecordBase { HasManyAttribute attr = ActiveRecordMaster.GetHasMany(this.GetType(), property); List <TPropertyClass> items = this.LazyLoadMany <TPropertyClass>(attr); return(items); }
/// <summary> /// Gets the id. /// </summary> /// <returns></returns> public object GetId() { PrimaryKeyAttribute pk = ActiveRecordMaster.GetPrimaryKey(this.GetType()); if (pk == null) { return(null); } return(pk.GetValue(this)); }
/// <summary> /// Sets the id. /// </summary> /// <param name="id">The id.</param> public void SetId(object id) { PrimaryKeyAttribute pk = ActiveRecordMaster.GetPrimaryKey(this.GetType()); if (pk == null) { return; } pk.SetValue(this, id); }
/// <summary> /// Check if the criteria return results. /// </summary> /// <param name="type">The type.</param> /// <param name="id">The id.</param> /// <returns></returns> public static bool Exists(Type type, object id) { PrimaryKeyAttribute pk = ActiveRecordMaster.GetPrimaryKey(type); Criteria criteria = Criteria.For(type); criteria .AddFilter(criteria.Eq(pk.CurrentPropertyInfo.Name, id)); return(ActiveRecordBase.Exists(type, criteria)); }
/// <summary> /// Customs the non query criteria. /// </summary> /// <param name="type">The type.</param> /// <param name="criteria">The criteria.</param> /// <returns></returns> /// <exception cref="AttributeNotFoundException"></exception> public static bool CustomNonQueryCriteria(Type type, Criteria criteria) { CheckTypeAtrribute(type); try { //Commit Filters criteria.CommitFilters(); return(ActiveRecordMaster.ExecuteNonQueryCriteria(type, criteria)); } catch (Exception ex) { LogManager.Log("Monty.ActiveRecord", LogCategory.Error, String.Format("Error when tries to execute ActiveRecordBase.CustomNonQueryCriteria(type: [{0}], criteria: [{1}])", type, criteria), ex); return(false); } }
/// <summary> /// Customs the find all. /// </summary> /// <param name="type">The type.</param> /// <param name="criteria">The criteria.</param> /// <param name="customSQL">The custom SQL.</param> /// <returns></returns> /// <exception cref="AttributeNotFoundException"></exception> public static List <ActiveRecordBase> CustomFindAll(Type type, Criteria criteria, string customSQL) { CheckTypeAtrribute(type); try { criteria.SQLString = customSQL; //Commit Filters criteria.CommitFilters(); return(ActiveRecordMaster.ExecuteQueryCriteria(type, criteria)); } catch (Exception ex) { LogManager.Log("Monty.ActiveRecord", LogCategory.Error, String.Format("Error when tries to execute ActiveRecordBase.CustomFindAll(type: [{0}], customSQL: [{1}])", type, customSQL), ex); return(null); } }
/// <summary> /// Finds all. /// </summary> /// <param name="type">The type.</param> /// <param name="criteria">The criteria.</param> /// <returns></returns> public static List <ActiveRecordBase> FindAll(Type type, Criteria criteria) { CheckTypeAtrribute(type); try { criteria.SQLString = ActiveRecordMaster.MakeFullSelect(type); //Commit Filters criteria.CommitFilters(); return(ActiveRecordMaster.ExecuteQueryCriteria(type, criteria)); } catch (Exception ex) { LogManager.Log("Monty.ActiveRecord", LogCategory.Error, String.Format("Error when tries to execute ActiveRecordBase.FindAll(type: [{0}])", type), ex); throw ex; } }
/// <summary> /// Returns only a selected field of all itens on criteria /// </summary> /// <typeparam name="TProjectionType">The type of the projection type.</typeparam> /// <param name="type">The type.</param> /// <param name="criteria">The criteria.</param> /// <param name="field">The field.</param> /// <returns></returns> public static List <TProjectionType> ProjectionFindAll <TProjectionType>(Type type, Criteria criteria, string field) { CheckTypeAtrribute(type); try { criteria.SQLString = ActiveRecordMaster.MakeProjectionFullSelect(type, field); //Commit Filters criteria.CommitFilters(); return(ActiveRecordMaster.ExecuteProjectionQueryCriteria <TProjectionType>(criteria)); } catch (Exception ex) { LogManager.Log("Monty.ActiveRecord", LogCategory.Error, String.Format("Error when tries to execute ActiveRecordBase.FindAll(type: [{0}])", type), ex); return(null); } }
/// <summary> /// Return a portion of the itens on the criteria. /// </summary> /// <param name="type">The type.</param> /// <param name="criteria">The criteria.</param> /// <param name="currentPage">The current page.</param> /// <param name="pageSize">Size of the page.</param> /// <param name="numberOfPages">The number of pages.</param> /// <param name="numberOfItems">The number of items.</param> /// <param name="findNumberOfPages">if set to <c>true</c> [find number of pages].</param> /// <returns></returns> /// <exception cref="AttributeNotFoundException"></exception> public static List <ActiveRecordBase> SlicedFindAll(Type type, Criteria criteria, int currentPage, int pageSize, out int numberOfPages, out int numberOfItems, bool findNumberOfPages) { CheckTypeAtrribute(type); try { if (findNumberOfPages) { //Count float count = ActiveRecordBase.Count(type, criteria); numberOfItems = (int)count; count = ((float)count / pageSize); numberOfPages = (count) != ((int)count) ? ((int)count) + 1 : ((int)count); } else { numberOfItems = -1; numberOfPages = -1; } //Query criteria.IncludeOrderBy = true; criteria.SQLString = ActiveRecordMaster.MakeFullSelect(type); criteria.CommitFilters(); //.CommitSlicedFilters((currentPage - 1) * pageSize, pageSize); //MakePaginator criteria.MakePaginator(currentPage, pageSize); return(ActiveRecordMaster.ExecuteQueryCriteria(type, criteria)); } catch (Exception ex) { LogManager.Log("Monty.ActiveRecord", LogCategory.Error, String.Format("Error when tries to execute ActiveRecordBase.SlicedFindAll(type: [{0}])", type), ex); numberOfItems = 0; numberOfPages = 0; return(null); } }
/// <summary> /// Return the number of items /// </summary> /// <param name="type">The type.</param> /// <param name="criteria">The criteria.</param> /// <returns></returns> public static int Count(Type type, Criteria criteria) { CheckTypeAtrribute(type); try { criteria.SQLString = ActiveRecordMaster.MakeCountSelect(type); //Commit Filters criteria.IncludeOrderBy = false; criteria.CommitFilters(); object count = ActiveRecordMaster.ExecuteScalarQueryCriteria(type, criteria); return(int.Parse(count.ToString())); } catch (Exception ex) { LogManager.Log("Monty.ActiveRecord", LogCategory.Error, String.Format("Error when tries to execute ActiveRecordBase.Count(type: [{0}])", type), ex); return(0); } }
/// <summary> /// Lazy load a property (BelongsTo). /// </summary> /// <typeparam name="TPropertyClass">The type of the property class.</typeparam> /// <param name="property">The property.</param> /// <returns></returns> protected TPropertyClass LazyLoad <TPropertyClass>(string property) where TPropertyClass : ActiveRecordBase { if (!this.LazyObjects.ContainsKey(property)) { return(null); } BelongsToAttribute attr = ActiveRecordMaster.GetBelongsTo(this.GetType(), property); if (this.LazyObjects[property] == null || String.IsNullOrEmpty(this.LazyObjects[property].ToString())) { return(null); } TPropertyClass item = ActiveRecordBase <TPropertyClass> .Find(this.LazyObjects[property]); if (attr.NotFoundBehaviour == NotFoundBehaviour.Exception && item == null) { throw new ObjectNotFoundException(typeof(TPropertyClass).Name); } return(item); }