public static void StockTakeDetailsData(GridViewCustomBindingGetDataArgs 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);
}
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
e.Data = transactions.ToList();
}
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 WorksOrdersCompletedGetData(GridViewCustomBindingGetDataArgs e, int tenantId, int?propertyId)
{
var transactions = GetWorksOrdersCompletedDataset(tenantId, propertyId);
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);
e.Data = transactions.ToList();
}
public static void GetProductSerialData(GridViewCustomBindingGetDataArgs 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);
}
serial = serial.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
e.Data = serial.ToList();
}
public static void PTenantGetData(GridViewCustomBindingGetDataArgs 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);
}
if (!id.HasValue)
{
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
}
e.Data = transactions.ToList();
}
public static void GetPalletData(GridViewCustomBindingGetDataArgs 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);
}
pallets = pallets.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
e.Data = pallets.ToList();
}
public static void UnallocatedJobsGetDataRowCount(GridViewCustomBindingGetDataRowCountArgs e, int tenantId)
{
var transactions = GetUnallocatedJobsDataset(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("DateUpdated 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 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 static void InvoiceGetDataRowCount(GridViewCustomBindingGetDataRowCountArgs 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);
}
e.DataRowCount = transactions.Count();
}
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 FinancialTransactionsGetData(GridViewCustomBindingGetDataArgs 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())
{
var 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);
}
transactions = transactions.Skip(e.StartDataRowIndex).Take(e.DataRowCount);
e.Data = transactions.ToList();
}
public static void GetPalletTrackingDataRowCount(GridViewCustomBindingGetDataRowCountArgs e, int tenantId, int warehouseId)
{
var pallets = GetPalletTrackingDataset(tenantId, warehouseId);
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 MarketRouteProgressGetData(GridViewCustomBindingGetDataArgs e, int teanantId)
{
var transactions = MarketRouteProgressDataset(teanantId);
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");
}
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 employeeLists = transactions.ToList();
e.Data = employeeLists.ToList();
}
public static void NotificationQueueGetData(GridViewCustomBindingGetDataArgs e, int tenantId)
{
var transactions = GetNotificationQueueDataset(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("ScheduledProcessingTime");
}
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);
e.Data = transactions.ToList();
}
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 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 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 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();
}