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 ApptLabel GetApptLabel(DataTable table)
{
if (table == null || SchedulerLabels == null)
{
return(null);
}
ApptLabel label = null;
try
{
foreach (ApptLabel lbl in SchedulerLabels)
{
table.DefaultView.RowFilter = CriteriaToWhereClauseHelper.GetDataSetWhere(CriteriaOperator.Parse(lbl.LabelCriteria));
if (table.DefaultView.Count > 0 && lbl.LabelCriteria != "")
{
label = lbl;
break;
}
if (lbl.LabelCriteria == "")
{
label = lbl; //default label
}
}
}
catch (Exception e)
{
}
return(label);
}
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 ApptStatus GetApptStatus(DataTable table)
{
if (table == null || SchedulerStatuses == null)
{
return(null);
}
ApptStatus status = null;
try
{
foreach (ApptStatus sts in SchedulerStatuses)
{
table.DefaultView.RowFilter = CriteriaToWhereClauseHelper.GetDataSetWhere(CriteriaOperator.Parse(sts.StatusCriteria));
if (table.DefaultView.Count > 0 && sts.StatusCriteria != "")
{
status = sts;
break;
}
if (sts.StatusCriteria == "")
{
status = sts; //default label
}
}
}
catch (Exception e)
{
}
return(status);
}
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 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 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 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 override void OnSaveData()
{
ApptLabel saveObject = defaultBindingSource.Current as ApptLabel;
saveObject.LabelCriteria = CriteriaToWhereClauseHelper.GetDataSetWhere(ctrl_FilterControl.FilterCriteria);
var store = new StoreApptLabel()
{
Label = saveObject.ConvertTo <ApptLabelDto>()
};
var resp = ServiceClient.Post(store);
//if the response was good, then notify the others.
if (resp.ResponseStatus == null)
{
saveObject = resp.Label.ConvertTo <ApptLabel>();
Context.ServiceClient.Post(new ApptLabelsNotification()
{
FromUserName = Context.LoggedInUser.UserName,
Selector = SelectorTypes.store,
Ids = new List <int>()
{
resp.Label.Id
}
});
}
base.OnSaveData();
lblInfo.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
}
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 string ConvertToSql(string sqlUpdate, CriteriaOperator criteria)
{
var sqlWhere = CriteriaToWhereClauseHelper.GetMsSqlWhere(XpoCriteriaFixer.Fix(criteria));
var sqlTemplate = sqlUpdate.Replace("{criteria}", (string.IsNullOrEmpty(sqlWhere) ? "" : " AND " + sqlWhere));
return(sqlTemplate);
}
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 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 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 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();
}
private void ShowFilterSql()
{
CriteriaOperator criteria = ActiveFilterCriteria;
var sqlCriteria = CriteriaToWhereClauseHelper.GetMsSqlWhere(XpoCriteriaFixer.Fix(criteria));
new GenericMessageBox(sqlCriteria,
"Filter Criteria SQL Text");
}
public void CriteriaToSqlTest()
{
string xpoCriteriaText = "[Activity] Is Not Null Or [ActionOwner.Name] Like 'UNDEFINED'";
var criteria = CriteriaEditorHelper.GetCriteriaOperator(
xpoCriteriaText, typeof(BankStmt), ObjectSpace);
var sqlCriteriaText = CriteriaToWhereClauseHelper.GetOracleWhere(XpoCriteriaFixer.Fix(criteria));
Console.WriteLine(sqlCriteriaText);
}
private void BuildCriteriaExpression_Execute(object sender, SimpleActionExecuteEventArgs e)
{
var obj = (IMappingCriteriaGenerator)View.CurrentObject;
var xpoCriteriaText = obj.Criteria;
var criteria = CriteriaEditorHelper.GetCriteriaOperator(
xpoCriteriaText, obj.CriteriaObjectType, ObjectSpace);
obj.CriteriaExpression = CriteriaToWhereClauseHelper.GetOracleWhere(XpoCriteriaFixer.Fix(criteria));
}
public IList <DataRow> GetContactRows(CriteriaOperator criteria, IList <SortProperty> sorting)
{
var filter = CriteriaToWhereClauseHelper.GetDataSetWhere(criteria);
string sort = null;
if (sorting != null && sorting.Count == 1 && sorting[0].Property is OperandProperty)
{
sort = string.Format("{0} {1}", sorting[0].PropertyName, sorting[0].Direction == DevExpress.Xpo.DB.SortingDirection.Ascending ? "ASC" : "DESC");
}
return(dataSet.Tables["Contacts"].Select(filter, sort));
}
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;
}
// Note that this does not delete child objects
public void Delete(XPClassInfo classInfo, CriteriaOperator criteria)
{
var session = ((XPObjectSpace)objectSpace).Session;
var gcRecordIDGenerator = new Random();
var randomNumber = gcRecordIDGenerator.Next(1, 2147483647);
var sqlWhere = CriteriaToWhereClauseHelper.GetMsSqlWhere(XpoCriteriaFixer.Fix(criteria));
sqlWhere = string.IsNullOrEmpty(sqlWhere) ? "" : " WHERE " + sqlWhere;
var sqlNonQuery = "UPDATE " + classInfo.TableName + " SET GCRecord = "
+ randomNumber
+ sqlWhere;
session.ExecuteNonQuery(sqlNonQuery);
objectSpace.CommitChanges();
}
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 ActionResult CustomBinding(GridViewModel model)
{
var co = CriteriaOperator.Parse(model.FilterExpression);
string criterias = CriteriaToWhereClauseHelper.GetMsSqlWhere(co, true);
var sortOptions = model.SortedColumns.Select(c => new SortOption
{
Field = c.FieldName, SortIndex = c.SortIndex, SortOrder = c.SortOrder.ToString()
});
var page = QualityControl.GetMeasurementsPage(
model.Pager.PageIndex,
model.Pager.PageSize,
criterias,
sortOptions);
model.ProcessCustomBinding(
e => e.DataRowCount = page.TotalItems,
e => e.Data = page.Items);
return(PartialView("_ContactsGridView", model));
}
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 void Process(IEnumerable objs)
{
Type objType = null;
foreach (var obj in objs)
{
objType = obj.GetType();
}
if (objType == null)
{
return;
}
var criteria = new InOperator(objSpace.GetKeyPropertyName(objType),
objs);
var sqlWhere = CriteriaToWhereClauseHelper.GetMsSqlWhere(XpoCriteriaFixer.Fix(criteria));
string processCommandText = CreateProcessCommandText(sqlWhere);
using (var cmd = ((SqlConnection)objSpace.Session.Connection).CreateCommand())
{
cmd.CommandText = parameterCommandText + "\n\n" + processCommandText;
cmd.ExecuteNonQuery();
}
}
