public static void TimeLogGetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e, int teanantId, int locationId, int weekNumber, int year)
{
var transactions = TimeLogDataset(teanantId, locationId, weekNumber, year);
if (e.State.SortedColumns.Count() > 0)
{
string sortString = "";
foreach (var column in e.State.SortedColumns)
{
sortString += column.FieldName + " " + column.SortOrder;
}
transactions = transactions.OrderBy(sortString);
}
else
{
transactions = transactions.OrderBy("EmployeeId");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
e.DataRowCount = transactions.Count();
}
public static void StockTakeDetailsDataRowCount(GridViewCustomBindingGetDataRowCountArgs e, int tenantId, int warehouseId, int stockTakeId)
{
var transactions = StockTakeDetailsDataset(tenantId, warehouseId, stockTakeId);
if (e.State.SortedColumns.Count() > 0)
{
string sortString = "";
foreach (var column in e.State.SortedColumns)
{
sortString += column.FieldName + " " + column.SortOrder;
}
transactions = transactions.OrderBy(sortString);
}
else
{
transactions = transactions.OrderBy("DateScanned Desc");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
e.DataRowCount = transactions.Count();
}
public static void GetPoductSerialDataRowCount(GridViewCustomBindingGetDataRowCountArgs e, int tenantId, int warehouseId)
{
var serial = GetProductSerialDataset(tenantId, warehouseId);
if (e.State.SortedColumns.Count() > 0)
{
string sortString = "";
foreach (var column in e.State.SortedColumns)
{
sortString += column.FieldName + " " + column.SortOrder;
}
serial = serial.OrderBy(sortString);
}
else
{
serial = serial.OrderBy("DateCreated Desc");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
serial = serial.Where(filterString);
}
e.DataRowCount = serial.Count();
}
public static void PTenantGetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e, int?id)
{
var transactions = GetPTenantDataset(id);
if (e.State.SortedColumns.Count() > 0)
{
string sortString = "";
foreach (var column in e.State.SortedColumns)
{
sortString += column.FieldName + " " + column.SortOrder;
}
transactions = transactions.OrderBy(sortString);
}
else
{
transactions = transactions.OrderBy("PTenantId");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
e.DataRowCount = transactions.Count();
}
public static void FinancialTransactionsGetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e, int tenantId, int warehouseId, int?accountId)
{
var accountServices = DependencyResolver.Current.GetService <IAccountServices>();
var transactions = accountServices.GetTenantAccountTransactions(tenantId, accountId ?? 0);
if (e.State.SortedColumns.Any())
{
string sortString = "";
foreach (var column in e.State.SortedColumns)
{
sortString += column.FieldName + " " + column.SortOrder;
}
transactions = transactions.OrderBy(sortString);
}
if (e.FilterExpression != string.Empty)
{
var op = CriteriaOperator.Parse(e.FilterExpression);
var filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
e.DataRowCount = transactions.Count();
}
public static void GetPalletDataRowCount(GridViewCustomBindingGetDataRowCountArgs e, int?type, bool status = false, int?PalletsDispatchID = null)
{
var pallets = GetPalletDataset(type, status, PalletsDispatchID);
if (e.State.SortedColumns.Count() > 0)
{
string sortString = "";
foreach (var column in e.State.SortedColumns)
{
sortString += column.FieldName + " " + column.SortOrder;
}
pallets = pallets.OrderBy(sortString);
}
else
{
pallets = pallets.OrderBy("DateCreated Desc");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
pallets = pallets.Where(filterString);
}
e.DataRowCount = pallets.Count();
}
public static void MyGetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
// Get the bl
LicenseBL bl = new LicenseBL();
e.DataRowCount = bl.GetLicenseCount(e.FilterExpression);
}
public static void PickListGetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e, int tenantId, int warehouseId)
{
var transactions = GetPickListDataset(tenantId, warehouseId);
if (e.State.SortedColumns.Count() > 0)
{
string sortString = "";
foreach (var column in e.State.SortedColumns)
{
sortString += column.FieldName + " " + column.SortOrder;
}
transactions = transactions.OrderBy(sortString);
}
else
{
transactions = transactions.OrderBy("IssueDate Desc");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
var filter = transactions.ToList().Where(x => x.RecurrenceInfoStartDate?.Date <= recurrenceDate.Date &&
x.RecurrenceInfoEndDate?.Date >= recurrenceDate.Date || !expectedDate.HasValue || x.ScheduledStartTime.Value.Date == expectedDate);
e.DataRowCount = transactions.Count();
}
public static void EmployeeShiftsGetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e, DateTime?searchdate, int teanantId, int warehouseId)
{
var transactions = EmployeeShiftsDataset(searchdate, teanantId, warehouseId);
if (e.State.SortedColumns.Count() > 0)
{
string sortString = "";
foreach (var column in e.State.SortedColumns)
{
sortString += column.FieldName + " " + column.SortOrder;
}
transactions = transactions.OrderBy(sortString);
}
else
{
transactions = transactions.OrderBy("TimeStamp Desc");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
e.DataRowCount = transactions.Count();
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
CriteriaOperator filter = CriteriaOperator.Parse(e.FilterExpression);
CriteriaOperator expression = CriteriaOperator.Parse("count");
e.DataRowCount = (int)Session.Evaluate(ClassInfo, expression, filter);
}
public void GetRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
int rowCount;
e.DataRowCount = GridViewCustomBindingSummaryCache.TryGetCount(e.FilterExpression, out rowCount)
? rowCount
: _data.ApplyFilter(e.FilterExpression).Count();
}
public virtual void GetGridViewDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
int rowCount;
if (CacheTryGetCount(e.FilterExpression, out rowCount))
{
e.DataRowCount = rowCount;
}
else
{
e.DataRowCount = DB.Execute((db, w) => Query(w).ApplyFilter(PrepareFilterExpression(e.FilterExpression)).Count());
}
}
public void GetDataRowCountAdvanced(GridViewCustomBindingGetDataRowCountArgs e)
{
int rowCount;
if (GridViewCustomBindingSummaryCache.TryGetCount(e.FilterExpression, out rowCount))
{
e.DataRowCount = rowCount;
}
else
{
e.DataRowCount = Model.ApplyFilter(e.FilterExpression).Count();
}
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _constantUsageService.GetConstantUsages(new GetConstantUsagesRequest { OnlyCount = true }).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _operationGroupService.GetOperationGroups(new GetOperationGroupsRequest { OnlyCount = true }).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _selectService.GetSelects(new GetSelectsRequest()).Selects.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _roleGroupService.GetRoleGroups(new GetRoleGroupsRequest()).RoleGroups.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _templateService.GetTemplates(new GetTemplatesRequest {
OnlyCount = true
}).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _templateService.GetTemplates(new GetTemplatesRequest { OnlyCount = true }).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _mirConfigurationService.Gets(new GetMirConfigurationsRequest { OnlyCount = true }).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _kpiService.GetKpis(new GetKpisRequest()).Kpis.Count;
}
public static void GetDataRowCountIncrementalFiltering(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = Model
.ApplyFilter(e.FilterExpression)
.Count();
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _weatherService.GetWeathers(new GetWeathersRequest { OnlyCount = true }).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _groupService.GetGroups(new GetGroupsRequest()).Groups.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _methodService.GetMethods(new GetMethodsRequest()).Methods.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _kpiTargetService.GetKpiTargets(new GetKpiTargetsRequest { Take = 0, Skip = 0 }).KpiTargets.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _calculatorConstantService.GetCalculatorConstants(new GetCalculatorConstantsRequest {
OnlyCount = true
}).Count;
}
public void YearlyGetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _highlightService.GetHighlights(new GetHighlightsRequest { PeriodeType = PeriodeType.Yearly, OnlyCount = true }).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _assumptionCategoryService.GetAssumptionCategories(new GetAssumptionCategoriesRequest { OnlyCount = true }).Count;
}
public void YearlyGetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _highlightService.GetHighlights(new GetHighlightsRequest { PeriodeType = PeriodeType.Yearly, OnlyCount = true }).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _calculatorConstantService.GetCalculatorConstants(new GetCalculatorConstantsRequest { OnlyCount = true }).Count;
}
public virtual void GetDataRowCountAdvanced(GridViewCustomBindingGetDataRowCountArgs e)
{
var filterString = GetFilterExpressionState(e.FilterExpression);
e.DataRowCount = _listApplicationRepository.GetFilteredApplicationsCount(filterString);
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = 50;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _userService.GetUsers(new GetUsersRequest()).Users.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _pillarService.GetPillars(new GetPillarsRequest()).Pillars.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _vesselService.GetVessels(new GetVesselsRequest { OnlyCount = true }).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _pillarService.GetPillars(new GetPillarsRequest()).Pillars.Count;
}
public static void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = Model
.Count();
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _typeService.GetTypes(new GetTypesRequest()).Types.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _typeService.GetTypes(new GetTypesRequest()).Types.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _mirConfigurationService.Gets(new GetMirConfigurationsRequest {
OnlyCount = true
}).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _artifactServie.GetArtifacts(new GetArtifactsRequest { OnlyCount = true }).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _selectService.GetSelects(new GetSelectsRequest()).Selects.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _operationGroupService.GetOperationGroups(new GetOperationGroupsRequest {
OnlyCount = true
}).Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _measurementService.GetMeasurements(new GetMeasurementsRequest()).Measurements.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _levelService.GetLevels(new GetLevelsRequest()).Levels.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _kpiTargetService.GetKpiTargets(new GetKpiTargetsRequest {
Take = 0, Skip = 0
}).KpiTargets.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _conversionService.GetConversions(new GetConversionsRequest()).Conversions.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _kpiService.GetKpis(new GetKpisRequest()).Kpis.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _periodeService.GetPeriodes(new GetPeriodesRequest()).Periodes.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _methodService.GetMethods(new GetMethodsRequest()).Methods.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _periodeService.GetPeriodes(new GetPeriodesRequest()).Periodes.Count;
}
public void GetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e)
{
e.DataRowCount = _nlsService.GetNLSList(new GetNLSListRequest { OnlyCount = true }).Count;
}
