/// <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));
}
