public DataTable FetchAllOrderedByCreatedOn(int formId)
{
var dt = new ViewableFileCollection(formId).LoadAll().ToDataTable();
dt.DefaultView.Sort = "createdon desc";
return(dt.DefaultView.ToTable());
}
/// <summary>
/// Sorts each file in descending order in this collection and returns the sorted collection
/// </summary>
public ViewableFileCollection OrderByDesc(string fieldName)
{
var sortedFiles = this.OrderByDescending(file => file.GetStoredValue(fieldName));
ViewableFileCollection sortedCollection = new ViewableFileCollection(this.EncapsulatedForm);
sortedCollection.Clear();
sortedCollection.AddRange(sortedFiles);
return(sortedCollection);
}
public DataTable FetchAll(int formId, string orderfield, bool orderdesc)
{
ViewableFileCollection orderedFiles = new ViewableFileCollection(formId);
orderedFiles.LoadAll();
// if (!orderdesc)
// orderedFiles.AddRange(FileCollection.LoadAll(formId).OrderBy(file => file.GetStoredValue(orderfield)));
// else
// orderedFiles.AddRange(FileCollection.LoadAll(formId).OrderByDescending(file => file.GetStoredValue(orderfield)));
return(orderedFiles.ToDataTable());
}