public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _constantUsageService.GetConstantUsagesForGrid(new GetConstantUsagesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).ConstantUsages;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _periodeService.GetPeriodes(new GetPeriodesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Periodes;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _vesselScheduleService.GetVesselSchedules(new GetVesselSchedulesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).VesselSchedules;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _roleGroupService.GetRoleGroups(new GetRoleGroupsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).RoleGroups;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _calculatorConstantService.GetCalculatorConstants(new GetCalculatorConstantsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).CalculatorConstants;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _assumptionCategoryService.GetAssumptionCategories(new GetAssumptionCategoriesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).AssumptionCategorys;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _groupService.GetGroups(new GetGroupsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Groups;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _conversionService.GetConversions(new GetConversionsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Conversions;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _typeService.GetTypes(new GetTypesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Types;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _weatherService.GetWeathers(new GetWeathersRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Weathers;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _levelService.GetLevels(new GetLevelsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Levels;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _pillarService.GetPillars(new GetPillarsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Pillars;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _methodService.GetMethods(new GetMethodsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Methods;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _mirConfigurationService.Gets(new GetMirConfigurationsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).MirConfigurations;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _levelService.GetLevels(new GetLevelsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Levels;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _templateService.GetTemplates(new GetTemplatesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Artifacts;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _templateService.GetTemplates(new GetTemplatesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Artifacts;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _conversionService.GetConversions(new GetConversionsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Conversions;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data =
_data.ApplyFilter(e.FilterExpression)
.ApplyFilter(e.GroupInfoList)
.ApplySorting(e.State.SortedColumns)
.Skip(e.StartDataRowIndex)
.Take(e.DataRowCount);
}
public void YearlyGetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _highlightService.GetHighlights(new GetHighlightsRequest
{
PeriodeType = PeriodeType.Yearly,
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Highlights;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = Entity.AsQueryable()
.Where(ComboFilterList)
.OrderBy(GridViewModel)
.Skip(e.StartDataRowIndex)
.Take(e.DataRowCount)
.ToList();
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
XPCollection data = new XPCollection(Session, ClassInfo);
data.Criteria = CriteriaOperator.Parse(e.FilterExpression) & GetGroupFilter(e.GroupInfoList);
data.Sorting = GetSorting(e.State.SortedColumns, e.StartDataRowIndex != 0 || e.DataRowCount != 0);
data.SkipReturnedObjects = e.StartDataRowIndex;
data.TopReturnedObjects = e.DataRowCount;
e.Data = data;
}
public virtual void GetDataAdvanced(GridViewCustomBindingGetDataArgs e)
{
var filterString = GetFilterExpressionState(e.State.FilterExpression);
var sortExpression = Utilities.GetSortExpression(e.State.SortedColumns, DefaultSortExpressionState());
e.Data = _listApplicationRepository.GetFilteredApplications(filterString)
.MakeOrderBy(new CriteriaToExpressionConverter(), sortExpression)
.Skip(e.StartDataRowIndex)
.Take(100);
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
var result = _gridResult.Records;
if (e.GroupInfoList.Count() > 0)
{
result = result.Where(x => x.VendCode == (string)e.GroupInfoList[0].KeyValue).ToList();
}
e.Data = result.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
}
public static void MarketGetData(GridViewCustomBindingGetDataArgs e, int tenantId, int warehouseId)
{
var transactions = MarketJobsDataset(tenantId);
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("Id asc");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
List <MarketJob> data = transactions.ToList();
var results = new List <MarketJobViewModel>();
var _currentDbContext = DependencyResolver.Current.GetService <IApplicationContext>();
foreach (var item in data)
{
var model = Mapper.Map(item, new MarketJobViewModel());
model.DisplayText = item.MarketRoute != null ? item.MarketRoute.Description : "";
var jobAllocation = _currentDbContext.MarketJobAllocations.FirstOrDefault(x => x.MarketJobId == item.Id && (x.MarketJobStatusId != (int)MarketJobStatusEnum.Cancelled));
model.MarketJobStatusEnum = (MarketJobStatusEnum)item.LatestJobStatusId;
if (jobAllocation != null)
{
model.ResourceName = jobAllocation.Resource.Name;
model.ResourceID = jobAllocation.ResourceId;
}
results.Add(model);
}
e.Data = results;
}
public static void GetDataSimple(GridViewCustomBindingGetDataArgs e)
{
var keys = Model
.ApplySorting(e.State.SortedColumns)
.Skip(e.StartDataRowIndex)
.Take(e.DataRowCount)
.Select(e.State.KeyFieldName);
if (keys.Count() != 0)
{
e.Data = Model.ApplyFilter(new InOperator(e.State.KeyFieldName, keys).ToString());
}
}
public static void GetDataAdvanced(GridViewCustomBindingGetDataArgs e)
{
try
{
var pageOffset = (int)e.StartDataRowIndex / e.DataRowCount;
var result = Task.Run(async() =>
await GetDataAsync("/api/v1/appointments/full?PageOffSet=" + pageOffset.ToString() + "&PageSize=" + e.DataRowCount.ToString()).ConfigureAwait(false)
).Result;
e.Data = result.GetData();
}
catch (Exception)
{
throw;
}
}
public virtual void GetGridViewData(GridViewCustomBindingGetDataArgs e)
{
var result = DB.Execute((db, w) =>
{
var items = Query(w)
.ApplyFilter(PrepareFilterExpression(e.FilterExpression))
.ApplyFilter(PrepareGroupInfoList(e.GroupInfoList))
.ApplySorting(PrepareSorting(e.State.SortedColumns))
.Skip(e.StartDataRowIndex)
.Take(e.DataRowCount);
var r = ((IQueryable <TXPOClass>)items).Select(CreateModelInstance);
return(r.ToList());
});
e.Data = result;
}
public static void PurchaseOrdersInProgressGetData(GridViewCustomBindingGetDataArgs e, int tenantId, int warehouseId)
{
var transactions = GetPurchaseOrdersInProgressDataset(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("OrderID Descending");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
var context = DependencyResolver.Current.GetService <IApplicationContext>();
var podata = transactions.ToList();
podata.ForEach(u => u.Qty = context.OrderDetail.Where(o => o.OrderID == u.OrderID).Select(q => (decimal?)q.Qty).Sum() ?? 0);
podata.ForEach(u =>
u.ProcessedQty = context.OrderProcess.Where(d => d.OrderID == u.OrderID && d.IsDeleted != true && d.InventoryTransactionTypeId != (int)InventoryTransactionTypeEnum.Returns && d.InventoryTransactionTypeId != (int)InventoryTransactionTypeEnum.Wastage &&
d.InventoryTransactionTypeId != (int)InventoryTransactionTypeEnum.WastedReturn)?.SelectMany(h => h.OrderProcessDetail)?.Where(d => d.IsDeleted != true).Select(c => c.QtyProcessed).DefaultIfEmpty(0).Sum());
podata.ForEach(u =>
u.ReturnQty = context.OrderProcess.Where(d => d.OrderID == u.OrderID && d.IsDeleted != true && (d.InventoryTransactionTypeId == (int)InventoryTransactionTypeEnum.Returns || d.InventoryTransactionTypeId == (int)InventoryTransactionTypeEnum.Wastage ||
d.InventoryTransactionTypeId == (int)InventoryTransactionTypeEnum.WastedReturn))?.SelectMany(m => m.OrderProcessDetail).Where(d => d.IsDeleted != true).Select(c => c.QtyProcessed).DefaultIfEmpty(0).Sum());
e.Data = podata;
}
public static void ResourceRequestsGetData(GridViewCustomBindingGetDataArgs e, int tenantId, int warehouseId)
{
var transactions = ResourceRequestsJobsDataset(tenantId);
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("RequestedDate Desc");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
List <ResourceRequests> data = transactions.ToList();
var results = new List <ResourceRequestsViewModel>();
foreach (var item in data)
{
var result = Mapper.Map(item, new ResourceRequestsViewModel());
result.ResourceName = item.Resources.Name;
results.Add(result);
}
e.Data = results;
}
public static void PurchaseInvoiceViewGetData(GridViewCustomBindingGetDataArgs e)
{
var transactions = InvoiceViewDataset();
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("InvoiceMasterId Descending");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
var data = transactions.ToList();
var InvoiceService = DependencyResolver.Current.GetService <IInvoiceService>();
var results = new List <InvoiceViewModel>();
data.ForEach(m =>
{
results.Add(InvoiceService.GetInvoiceMasterById(m.InvoiceMasterId));
});
e.Data = results.ToList();
}
public static void InvoiceGetData(GridViewCustomBindingGetDataArgs e, string type)
{
var transactions = InvoiceDataset(type);
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("OrderProcessID Descending");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
var invoices = transactions.ToList();
var InvoiceService = DependencyResolver.Current.GetService <IInvoiceService>();
var _currentDbContext = DependencyResolver.Current.GetService <IApplicationContext>();
invoices.ForEach(m =>
{
m.InvoiceTotal = InvoiceService.LoadInvoiceProductValuesByOrderProcessId(m.OrderProcessID).InvoiceTotal;
m.Email = string.Join(";", _currentDbContext.AccountContacts.Where(u => u.AccountID == m.AccountId && u.IsDeleted != true && u.ConTypeInvoices == true).Select(u => u.ContactEmail).ToList());
});
e.Data = invoices;
}
public static void EmployeeShiftsGetData(GridViewCustomBindingGetDataArgs 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);
}
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
var result = transactions.ToList();
var data = Mapper.Map <List <EmployeeShiftsViewModel> >(result);
e.Data = data.ToList();
}
public static void ResourceListGetData(GridViewCustomBindingGetDataArgs e, int tenantId, int warehouseId, string exportRowType)
{
var transactions = ResourceListDataset(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("ResourceId Desc");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
if (exportRowType != "All")
{
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
}
e.Data = transactions.ToList();
}
public static void ConsignmentData(GridViewCustomBindingGetDataArgs e, int tenantId, int warehouseId, int?consignmentId)
{
var transactions = ConsignmentDataset(tenantId, warehouseId, consignmentId);
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("DateCreated Desc");
}
if (e.FilterExpression != string.Empty)
{
CriteriaOperator op = CriteriaOperator.Parse(e.FilterExpression);
string filterString = CriteriaToWhereClauseHelper.GetDynamicLinqWhere(op);
transactions = transactions.Where(filterString);
}
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
var context = DependencyResolver.Current.GetService <IApplicationContext>();
var result = transactions.ToList();
result.ForEach(u => u.EmailCount = context.TenantEmailNotificationQueues.Count(c => c.OrderId == u.OrderID && c.TenantEmailTemplatesId == 4));
e.Data = result.ToList();
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _outputCategoryService.GetOutputCategories(new GetOutputCategoriesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).OutputCategories;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _nlsService.GetNLSList(new GetNLSListRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).NLSList;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _constantUsageService.GetConstantUsagesForGrid(new GetConstantUsagesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).ConstantUsages;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _kpiService.GetKpis(new GetKpisRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Kpis;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _assumptionCategoryService.GetAssumptionCategories(new GetAssumptionCategoriesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).AssumptionCategorys;
}
public static void PickListGetData(GridViewCustomBindingGetDataArgs 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);
}
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
var filter = transactions.ToList();
//filter = filter.Where(x => x.RecurrenceInfoStartDate?.Date <= recurrenceDate.Date
// && x.RecurrenceInfoEndDate?.Date >= recurrenceDate.Date || !expectedDate.HasValue || x.ScheduledStartTime.Value.Date == expectedDate).ToList();
var _currentDbContext = DependencyResolver.Current.GetService <IApplicationContext>();
foreach (var item in filter)
{
item.FullShip = true;
if (item.OrderDetails.Count() > 0)
{
bool fullShip = true;
foreach (var detail in item.OrderDetails)
{
var available = _currentDbContext.InventoryStocks.AsNoTracking().Where(x => x.TenantId == tenantId && x.ProductId == detail.ProductId && x.WarehouseId == warehouseId).FirstOrDefault()?.Available ?? 0;
var qtyToProcess = detail.ProcessedQty - detail.ReturnedQty;
if (available < qtyToProcess)
{
fullShip = false;
break;
}
}
item.FullShip = fullShip;
}
}
e.Data = filter.ToList();
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _vesselScheduleService.GetVesselSchedules(new GetVesselSchedulesRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).VesselSchedules;
}
public void GetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _selectService.GetSelects(new GetSelectsRequest
{
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Selects;
}
public void YearlyGetData(GridViewCustomBindingGetDataArgs e)
{
e.Data = _highlightService.GetHighlights(new GetHighlightsRequest
{
PeriodeType = PeriodeType.Yearly,
Skip = e.StartDataRowIndex,
Take = e.DataRowCount
}).Highlights;
}
