public static string GetCount(
BaseColumn col,
WhereClause where,
OrderBy orderBy,
int pageIndex,
int pageSize)
{
SqlBuilderColumnSelection colSel = new SqlBuilderColumnSelection(false, false);
colSel.AddColumn(col, SqlBuilderColumnOperation.OperationType.Count);
return PhotoClubsTable.Instance.GetColumnStatistics(colSel, null, where.GetFilter(), null, orderBy, pageIndex, pageSize);
}
public static String[] GetValues(
BaseColumn col,
WhereClause where,
OrderBy orderBy,
int maxItems)
{
// Create the filter list.
SqlBuilderColumnSelection retCol = new SqlBuilderColumnSelection(false, true);
retCol.AddColumn(col);
return(AreasTable.Instance.GetColumnValues(retCol, null, where.GetFilter(), null, orderBy, BaseTable.MIN_PAGE_NUMBER, maxItems));
}
public static string GetSum(
BaseColumn col,
WhereClause where,
OrderBy orderBy,
int pageIndex,
int pageSize)
{
SqlBuilderColumnSelection colSel = new SqlBuilderColumnSelection(false, false);
colSel.AddColumn(col, SqlBuilderColumnOperation.OperationType.Sum);
return(View_StatsView.Instance.GetColumnStatistics(colSel, null, where.GetFilter(), null, orderBy, pageIndex, pageSize));
}
public static void ParseData(List <KeyValuePair <string, string> > values, ref SqlBuilderColumnSelection requestedCols, ref SqlBuilderColumnSelection workingSelCols,
ref SqlBuilderColumnSelection distinctSelCols, ref OrderBy orderBy, ref KeylessVirtualTable table)
{
foreach (KeyValuePair <string, string> value in values)
{
switch (value.Key)
{
case "SelectColumns":
JSONDataSource jsonDS = JsonConvert.DeserializeObject <JSONDataSource>(value.Value);
ConstructDataSourceObjectFromPostRequest(jsonDS, ref requestedCols, ref workingSelCols, ref distinctSelCols, ref orderBy, ref table);
break;
}
}
}
public static string GetSum(
BaseColumn col,
BaseFilter join,
WhereClause where,
OrderBy orderBy,
int pageIndex,
int pageSize)
{
SqlBuilderColumnSelection colSel = new SqlBuilderColumnSelection(false, false);
colSel.AddColumn(col, SqlBuilderColumnOperation.OperationType.Sum);
return(AvailableWorkshopsTable.Instance.GetColumnStatistics(colSel, join, where.GetFilter(), null, orderBy, pageIndex, pageSize));
}
public static string GetCount(
BaseColumn col,
BaseFilter join,
WhereClause where,
OrderBy orderBy,
int pageIndex,
int pageSize)
{
SqlBuilderColumnSelection colSel = new SqlBuilderColumnSelection(false, false);
colSel.AddColumn(col, SqlBuilderColumnOperation.OperationType.Count);
return(View_FieldTripSelectionsView.Instance.GetColumnStatistics(colSel, join, where.GetFilter(), null, orderBy, pageIndex, pageSize));
}
/// <summary>
/// This is a shared function that can be used to get an array of PhotoClubsRecord records using a where and order by clause clause with pagination.
/// </summary>
public static ArrayList PostGetRecordList(SqlBuilderColumnSelection requestedSelection, SqlBuilderColumnSelection workingSelection, SqlBuilderColumnSelection distinctSelection,
BaseFilter join, BaseFilter filter, GroupBy groupBy, OrderBy sortOrder, int startIndex, int count, ref int totalCount, Boolean fromDataSource,
KeylessVirtualTable table = null, Boolean isGetColumnValues = false)
{
ArrayList recList = null;
if (table == null)
{
recList = PhotoClubsTable.Instance.GetRecordListResponseForPost(PhotoClubsTable.Instance.TableDefinition, requestedSelection, workingSelection, distinctSelection,
join, filter, groupBy, sortOrder, startIndex, count, ref totalCount, fromDataSource, isGetColumnValues);
}
else if (table != null)
{
recList = table.GetDataSourceResponseForPost(requestedSelection, workingSelection, distinctSelection, join, filter,
groupBy, sortOrder, startIndex, count, ref totalCount, true);
}
return recList;
}
public static void ConstructDataSourceObjectFromPostRequest(JSONDataSource jsonDS, ref SqlBuilderColumnSelection requestedCols, ref SqlBuilderColumnSelection workingSelCols,
ref SqlBuilderColumnSelection distinctSelCols, ref OrderBy orderBy, ref KeylessVirtualTable table)
{
DataSource ds = new DataSource();
ds.Initialize(jsonDS.Name, DatabaseObjects.GetTableObject(jsonDS.Table), jsonDS.PageSize, jsonDS.PageIndex, jsonDS.GenerateTotal);
if ((jsonDS.JSelectItems != null))
{
foreach (JDataSourceSelectItem jsonSItem in jsonDS.JSelectItems)
{
ds.AddSelectItem(ConstructSelectItemFromPostRequest(jsonSItem));
}
}
requestedCols = new SqlBuilderColumnSelection(jsonDS.ExpandForeignKeyColumns, jsonDS.IsDistinct);
workingSelCols = new SqlBuilderColumnSelection(jsonDS.ExpandForeignKeyColumns, jsonDS.IsDistinct);
distinctSelCols = new SqlBuilderColumnSelection(jsonDS.ExpandForeignKeyColumns, jsonDS.IsDistinct);
List <BaseColumn> columnsList = null;
if (jsonDS.isTotalRecordArray)
{
columnsList = ds.CreateColumnSelectionsForTotal(ref requestedCols, ref workingSelCols, ref distinctSelCols);
}
else
{
columnsList = ds.CreateColumnSelections(ref requestedCols, ref workingSelCols, ref distinctSelCols);
}
table = ds.CreateVirtualTable(columnsList.ToArray());
if ((jsonDS.JOrderByList != null))
{
foreach (JOrderBy jsonOrderBy in jsonDS.JOrderByList)
{
ds.AddAggregateOrderBy(jsonOrderBy.ColumnName, OrderByItem.ToOrderDir(jsonOrderBy.OrderDirection));
}
}
ds.UpdateOrderBy(columnsList);
orderBy = ds.OrderBy;
}
/// <summary>
/// This is a shared function that can be used to get total number of records that will be returned using the where clause.
/// </summary>
public static int PostGetRecordCount(SqlBuilderColumnSelection selectCols, BaseFilter join, BaseFilter finalFilter)
{
return((int)AreasTable.Instance.GetCountResponseForPost(AreasTable.Instance.TableDefinition, selectCols, join, finalFilter));
}
public static String[] GetValues(
BaseColumn col,
BaseFilter join,
WhereClause where,
OrderBy orderBy,
int maxItems)
{
// Create the filter list.
SqlBuilderColumnSelection retCol = new SqlBuilderColumnSelection(false, true);
retCol.AddColumn(col);
return UsersTable.Instance.GetColumnValues(retCol, join, where.GetFilter(), null, orderBy, BaseTable.MIN_PAGE_NUMBER, maxItems);
}
public static string GetSum(
BaseColumn col,
BaseFilter join,
WhereClause where,
OrderBy orderBy,
int pageIndex,
int pageSize)
{
SqlBuilderColumnSelection colSel = new SqlBuilderColumnSelection(false, false);
colSel.AddColumn(col, SqlBuilderColumnOperation.OperationType.Sum);
return UsersTable.Instance.GetColumnStatistics(colSel, join, where.GetFilter(), null, orderBy, pageIndex, pageSize);
}
/// <summary>
/// Return an array of values from the database. The values returned are DISTINCT values.
/// For example, GetColumnValues("Employees", "City") will return a list of all Cities
/// from the Employees table. There will be no duplicates in the list.
/// This function adds a Where Clause. So you can say something like "Country = 'USA'" and in this
/// case only cities in the US will be returned.
/// You can use the IN operator to compare the values. You can also use the resulting array to display
/// such as String.Join(", ", GetColumnValues("Employees", "City", "Country = 'USA'")
/// to display: New York, Chicago, Los Angeles, San Francisco
/// </summary>
/// <returns>An array of values for the given field as an Object.</returns>
public static string[] GetColumnValues(string tableName, string fieldName, string whereStr)
{
// Find the
PrimaryKeyTable bt = null;
bt = (PrimaryKeyTable)DatabaseObjects.GetTableObject(tableName);
if (bt == null)
{
throw new Exception("GETCOLUMNVALUES(" + tableName + ", " + fieldName + ", " + whereStr + "): " + Resource("Err:NoRecRetrieved"));
}
BaseColumn col = bt.TableDefinition.ColumnList.GetByCodeName(fieldName);
if (col == null)
{
throw new Exception("GETCOLUMNVALUES(" + tableName + ", " + fieldName + ", " + whereStr + "): " + Resource("Err:NoRecRetrieved"));
}
string[] values = null;
try
{
// Always start a transaction since we do not know if the calling function did.
SqlBuilderColumnSelection sqlCol = new SqlBuilderColumnSelection(false, true);
sqlCol.AddColumn(col);
WhereClause wc = new WhereClause();
if (!(whereStr == null) && whereStr.Trim().Length > 0)
{
wc.iAND(whereStr);
}
BaseClasses.Data.BaseFilter join = null;
values = bt.GetColumnValues(sqlCol, join, wc.GetFilter(), null, null, BaseTable.MIN_PAGE_NUMBER, BaseTable.MAX_BATCH_SIZE);
}
catch
{
}
// The value can be null. In this case, return an empty array since
// that is an acceptable value.
if (values == null)
{
values = new string[0];
}
return values;
}
public static string GetCount(
BaseColumn col,
WhereClause where,
OrderBy orderBy,
int pageIndex,
int pageSize)
{
SqlBuilderColumnSelection colSel = new SqlBuilderColumnSelection(false, false);
colSel.AddColumn(col, SqlBuilderColumnOperation.OperationType.Count);
return EstimateTable.Instance.GetColumnStatistics(colSel, null, where.GetFilter(), null, orderBy, pageIndex, pageSize);
}
public static string GetSum(
BaseColumn col,
WhereClause where,
OrderBy orderBy,
int pageIndex,
int pageSize)
{
SqlBuilderColumnSelection colSel = new SqlBuilderColumnSelection(false, false);
colSel.AddColumn(col, SqlBuilderColumnOperation.OperationType.Sum);
return VwPropSBondBudgetView.Instance.GetColumnStatistics(colSel, null, where.GetFilter(), null, orderBy, pageIndex, pageSize);
}
