/// <summary> /// Gets an IList with page of instances of value. /// </summary> /// <param name="pageNumber">The page number.</param> /// <param name="pageSize">Size of the page.</param> /// <param name="totalPages">total pages</param> public static List <ItemFieldValue> GetPage(int pageNumber, int pageSize, out int totalPages) { totalPages = 1; IDataReader reader = DBItemFieldValues.GetPage(pageNumber, pageSize, out totalPages); return(LoadListFromReader(reader)); }
/// <summary> /// Gets an instance of value. /// </summary> /// <param name="valueGuid"> valueGuid </param> private void GetValue(Guid valueGuid) { using (IDataReader reader = DBItemFieldValues.GetOne(valueGuid)) { PopulateFromReader(reader); } }
private void GetValueByItemField(Guid itemGuid, Guid fieldGuid) { using (IDataReader reader = DBItemFieldValues.GetByItemField(itemGuid, fieldGuid)) { //need to do something here } }
/// <summary> /// Updates this instance of value. Returns true on success. /// </summary> /// <returns>bool</returns> private bool Update() { return(DBItemFieldValues.Update( this.ValueGuid, this.SiteGuid, this.FeatureGuid, this.ModuleGuid, this.ItemGuid, this.FieldGuid, this.FieldValue)); }
/// <summary> /// Updates this instance of value. Returns true on success. /// </summary> /// <returns>bool</returns> private bool Update() { return(DBItemFieldValues.Update( this.valueGuid, this.siteGuid, this.featureGuid, this.moduleGuid, this.itemGuid, this.fieldGuid, this.fieldValue)); }
/// <summary> /// Persists a new instance of value. Returns true on success. /// </summary> /// <returns></returns> private bool Create() { this.ValueGuid = Guid.NewGuid(); int rowsAffected = DBItemFieldValues.Create( this.ValueGuid, this.SiteGuid, this.FeatureGuid, this.ModuleGuid, this.ItemGuid, this.FieldGuid, this.FieldValue); return(rowsAffected > 0); }
/// <summary> /// Persists a new instance of value. Returns true on success. /// </summary> /// <returns></returns> private bool Create() { this.valueGuid = Guid.NewGuid(); int rowsAffected = DBItemFieldValues.Create( this.valueGuid, this.siteGuid, this.featureGuid, this.moduleGuid, this.itemGuid, this.fieldGuid, this.fieldValue); return(rowsAffected > 0); }
public static List <ItemFieldValue> GetPageOfValues( Guid moduleGuid, Guid definitionGuid, string field, int pageNumber, int pageSize, out int totalPages, out int totalRows, string searchTerm = "", //string searchField = "", bool descending = false) { totalPages = 1; IDataReader reader = DBItemFieldValues.GetPageOfValuesForField(moduleGuid, definitionGuid, field, pageNumber, pageSize, searchTerm, descending); var values = LoadListFromReader(reader, true); totalRows = _totalRows; if (pageSize > 0) { totalPages = totalRows / pageSize; } if (totalRows <= pageSize) { totalPages = 1; } else { int remainder; Math.DivRem(totalRows, pageSize, out remainder); if (remainder > 0) { totalPages += 1; } } return(values); }
/// <summary> /// Deletes Item Values by FieldGuild. Returns true on success. /// </summary> /// <param name="fieldGuid"></param> /// <returns></returns> public static bool DeleteByField(Guid fieldGuid) { return(DBItemFieldValues.DeleteByField(fieldGuid)); }
/// <summary> /// Gets all values for item with ItemGuid. Returns List<ItemFieldValue> /// </summary> /// <param name="itemGuid"></param> /// <returns></returns> public static List <ItemFieldValue> GetItemValues(Guid itemGuid) { return(LoadListFromReader(DBItemFieldValues.GetByItemGuid(itemGuid))); }
public static List <ItemFieldValue> GetByFieldGuidForModule(Guid fieldGuid, int moduleId) { IDataReader reader = DBItemFieldValues.GetByGuidForModule(fieldGuid, moduleId); return(LoadListFromReader(reader)); }
public static List <ItemFieldValue> GetByFieldGuid(Guid fieldGuid) { IDataReader reader = DBItemFieldValues.GetByFieldGuid(fieldGuid); return(LoadListFromReader(reader)); }
/// <summary> /// Gets all values for items with ModuleGuid. Returns List<ItemFieldValue> /// </summary> /// <param name="moduleGuid"></param> /// <returns></returns> public static List <ItemFieldValue> GetItemValuesByModule(Guid moduleGuid) { return(LoadListFromReader(DBItemFieldValues.GetByModuleGuid(moduleGuid))); }
/// <summary> /// Gets an IList with all instances of value. /// </summary> public static List <ItemFieldValue> GetAll() { IDataReader reader = DBItemFieldValues.GetAll(); return(LoadListFromReader(reader)); }
/// <summary> /// Gets a count of value. /// </summary> public static int GetCount() { return(DBItemFieldValues.GetCount()); }
/// <summary> /// Gets a List of ItemFieldValue using an array of ItemID /// </summary> /// <param name="itemIds"></param> /// <returns></returns> public static List <ItemFieldValue> GetByItemGuids(List <Guid> itemGuids) { IDataReader reader = DBItemFieldValues.GetByItemGuids(itemGuids); return(LoadListFromReader(reader)); }
/// <summary> /// Deletes Item Values by ItemGuild. Returns true on success. /// </summary> /// <param name="itemGuid"></param> /// <returns></returns> public static bool DeleteByItem(Guid itemGuid) { return(DBItemFieldValues.DeleteByItem(itemGuid)); }
/// <summary> /// Gets all values for items with ModuleGuid. Returns List<ItemFieldValue> /// </summary> /// <param name="moduleGuid"></param> /// <returns></returns> public static List <ItemFieldValue> GetItemValuesByDefinition(Guid definitionGuid) { return(LoadListFromReader(DBItemFieldValues.GetByDefinitionGuid(definitionGuid))); }
/// <summary> /// Deletes Items by Module. Returns true on success. /// </summary> /// <param name="moduleGuid"> moduleGuid </param> /// <returns>bool</returns> public static bool DeleteByModule(Guid moduleGuid) { return(DBItemFieldValues.DeleteByModule(moduleGuid)); }
/// <summary> /// Deletes Items by Site. Returns true on success. /// </summary> public static bool DeleteBySite(Guid siteGuid) { return(DBItemFieldValues.DeleteBySite(siteGuid)); }
/// <summary> /// Deletes an instance of value. Returns true on success. /// </summary> /// <param name="valueGuid"> valueGuid </param> /// <returns>bool</returns> public static bool Delete( Guid valueGuid) { return(DBItemFieldValues.Delete( valueGuid)); }