public JsonResult PendingTasks(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery<Task>(input.filters, x => !x.Complete);
var employeeItems = items.ToList().Where(x => x.GetEmployees().Any(y => y.EntityId == input.ParentId)).AsQueryable();
var gridItemsViewModel = _pendingTaskGrid.GetGridItemsViewModel(input.PageSortFilter, employeeItems, "pendingGridContainer");
return Json(gridItemsViewModel, JsonRequestBehavior.AllowGet);
}
public JsonResult PurchaseOrderLineItems(GridItemsRequestModel input)
{
var items = _repository.Query <PurchaseOrderLineItem>(x => x.PurchaseOrder.EntityId == input.EntityId && !x.Completed);
var model = _receivePurchaseOrderLineItemGrid.GetGridItemsViewModel(input.PageSortFilter, items);
return(Json(model, JsonRequestBehavior.AllowGet));
}
public JsonResult Photos(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery <Photo>();
var gridItemsViewModel = _photoListGrid.GetGridItemsViewModel(input.PageSortFilter, items);
return(Json(gridItemsViewModel, JsonRequestBehavior.AllowGet));
}
public JsonResult VendorContacts(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery <VendorContact>(input.filters, x => x.Vendor.EntityId == input.ParentId);
var gridItemsViewModel = _vendorContactListGrid.GetGridItemsViewModel(input.PageSortFilter, items);
return(Json(gridItemsViewModel, JsonRequestBehavior.AllowGet));
}
public JsonResult Employees(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery <Employee>(input.filters);
var gridItemsViewModel = _employeeListGrid.GetGridItemsViewModel(input.PageSortFilter, items);
return(Json(gridItemsViewModel, JsonRequestBehavior.AllowGet));
}
public JsonResult ListTypes(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery <LISTTYPE>(input.filters);
var gridItemsViewModel = _listTypeListGrid.GetGridItemsViewModel(input.PageSortFilter, items, typeof(LISTTYPE).Name + "Grid");
return(Json(gridItemsViewModel, JsonRequestBehavior.AllowGet));
}
public JsonResult PendingTasks(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery <Task>(input.filters, x => !x.Complete);
var employeeItems = items.ToList().Where(x => x.GetEmployees().Any(y => y.EntityId == input.ParentId)).AsQueryable();
var gridItemsViewModel = _pendingTaskGrid.GetGridItemsViewModel(input.PageSortFilter, employeeItems, "pendingGridContainer");
return(Json(gridItemsViewModel, JsonRequestBehavior.AllowGet));
}
public JsonResult CompletedTasks(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery<Task>(input.filters,
x => x.Field.EntityId == input.ParentId && x.Complete);
var gridItemsViewModel = _completedTaskGrid.GetGridItemsViewModel(input.PageSortFilter, items,
"completeGridContainer");
return Json(gridItemsViewModel, JsonRequestBehavior.AllowGet);
}
public JsonResult PurchaseOrderLineItems(GridItemsRequestModel input)
{
var purchaseOrder = _repository.Find<PurchaseOrder>(input.EntityId);
if (purchaseOrder == null) return null;
IQueryable<PurchaseOrderLineItem> items = purchaseOrder.GetLineItems().AsQueryable();
if (input.PageSortFilter.SortColumn.IsEmpty()) items = items.OrderBy(x => x.Product.Name);
var model = _purchaseOrderLineItemGrid.GetGridItemsViewModel(input.PageSortFilter, items, "poliGrid");
return Json(model, JsonRequestBehavior.AllowGet);
}
public JsonResult CompletedTasks(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery <Task>(input.filters,
x => x.Field.EntityId == input.ParentId && x.Complete);
var gridItemsViewModel = _completedTaskGrid.GetGridItemsViewModel(input.PageSortFilter, items,
"completeGridContainer");
return(Json(gridItemsViewModel, JsonRequestBehavior.AllowGet));
}
public JsonResult Documents(GridItemsRequestModel input)
{
var field = _repository.Find<Field>(input.ParentId);
var documentWhereClause = _dynamicExpressionQuery.PrepareExpression<Document>(input.filters);
IEnumerable<Document> items;
if (documentWhereClause == null)
{
items = field.GetDocuments();
}else
{
items = field.GetDocuments().Where(documentWhereClause.Compile());
}
var gridItemsViewModel = _documentListGrid.GetGridItemsViewModel(input.PageSortFilter, items.AsQueryable(),
"documentGridContainer");
return Json(gridItemsViewModel, JsonRequestBehavior.AllowGet);
}
public JsonResult Vendors(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery<Vendor>();
Action<IGridColumn,Vendor> mod = (c,v) =>
{
if (c.GetType() == typeof(ImageButtonColumn<Vendor>) && c.ColumnIndex==10)
{
var col = (ImageButtonColumn<Vendor>) c;
col.AddActionUrlParameters(new Dictionary<string,string>{{ "ParentId", v.EntityId.ToString()}});
}
};
_vendorListGrid.AddColumnModifications(mod);
var gridItemsViewModel = _vendorListGrid.GetGridItemsViewModel(input.PageSortFilter, items);
return Json(gridItemsViewModel, JsonRequestBehavior.AllowGet);
}
public JsonResult PurchaseOrderLineItems(GridItemsRequestModel input)
{
var purchaseOrder = _repository.Find <PurchaseOrder>(input.EntityId);
if (purchaseOrder == null)
{
return(null);
}
IQueryable <PurchaseOrderLineItem> items = purchaseOrder.GetLineItems().AsQueryable();
if (input.PageSortFilter.SortColumn.IsEmpty())
{
items = items.OrderBy(x => x.Product.Name);
}
var model = _purchaseOrderLineItemGrid.GetGridItemsViewModel(input.PageSortFilter, items, "poliGrid");
return(Json(model, JsonRequestBehavior.AllowGet));
}
public JsonResult Documents(GridItemsRequestModel input)
{
var field = _repository.Find <Field>(input.ParentId);
var documentWhereClause = _dynamicExpressionQuery.PrepareExpression <Document>(input.filters);
IEnumerable <Document> items;
if (documentWhereClause == null)
{
items = field.GetDocuments();
}
else
{
items = field.GetDocuments().Where(documentWhereClause.Compile());
}
var gridItemsViewModel = _documentListGrid.GetGridItemsViewModel(input.PageSortFilter, items.AsQueryable(),
"documentGridContainer");
return(Json(gridItemsViewModel, JsonRequestBehavior.AllowGet));
}
public JsonResult Vendors(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery <Vendor>();
Action <IGridColumn, Vendor> mod = (c, v) =>
{
if (c.GetType() == typeof(ImageButtonColumn <Vendor>) && c.ColumnIndex == 10)
{
var col = (ImageButtonColumn <Vendor>)c;
col.AddActionUrlParameters(new Dictionary <string, string> {
{ "ParentId", v.EntityId.ToString() }
});
}
};
_vendorListGrid.AddColumnModifications(mod);
var gridItemsViewModel = _vendorListGrid.GetGridItemsViewModel(input.PageSortFilter, items);
return(Json(gridItemsViewModel, JsonRequestBehavior.AllowGet));
}
public JsonResult Photos(GridItemsRequestModel input)
{
var field = _repository.Find <Field>(input.ParentId);
Expression <Func <Photo, bool> > photoWhereClause =
_dynamicExpressionQuery.PrepareExpression <Photo>(input.filters);
IEnumerable <Photo> items;
if (photoWhereClause == null)
{
items = field.GetPhotos();
}
else
{
items = field.GetPhotos().Where(photoWhereClause.Compile());
}
var gridItemsViewModel = _photoListGrid.GetGridItemsViewModel(input.PageSortFilter, items.AsQueryable(),
"photoGridContainer");
return(Json(gridItemsViewModel, JsonRequestBehavior.AllowGet));
}
public JsonResult EmailTemplates(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery<EmailTemplate>();
var gridItemsViewModel = _emailTemplateListGrid.GetGridItemsViewModel(input.PageSortFilter, items);
return Json(gridItemsViewModel, JsonRequestBehavior.AllowGet);
}
public JsonResult Photos(GridItemsRequestModel input)
{
var field = _repository.Find<Field>(input.ParentId);
Expression<Func<Photo, bool>> photoWhereClause =
_dynamicExpressionQuery.PrepareExpression<Photo>(input.filters);
IEnumerable<Photo> items;
if(photoWhereClause==null)
{
items = field.GetPhotos();
}
else
{
items = field.GetPhotos().Where(photoWhereClause.Compile());
}
var gridItemsViewModel = _photoListGrid.GetGridItemsViewModel(input.PageSortFilter, items.AsQueryable(),
"photoGridContainer");
return Json(gridItemsViewModel, JsonRequestBehavior.AllowGet);
}
public JsonResult Chemicals(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery<Chemical>(input.filters);
var gridItemsViewModel = _chemicalListGrid.GetGridItemsViewModel(input.PageSortFilter, items);
return Json(gridItemsViewModel, JsonRequestBehavior.AllowGet);
}
public JsonResult PurchaseOrderLineItems(GridItemsRequestModel input)
{
var items = _repository.Query<PurchaseOrderLineItem>(x=>x.PurchaseOrder.EntityId == input.EntityId && !x.Completed);
var model = _receivePurchaseOrderLineItemGrid.GetGridItemsViewModel(input.PageSortFilter, items);
return Json(model, JsonRequestBehavior.AllowGet);
}
public JsonResult Documents(GridItemsRequestModel input)
{
var items = _dynamicExpressionQuery.PerformQuery<Document>();
var gridItemsViewModel = _documentListGrid.GetGridItemsViewModel(input.PageSortFilter, items);
return Json(gridItemsViewModel, JsonRequestBehavior.AllowGet);
}
