public List <WaybillGetModel> GetAllWaybillModels(StoreLoadParams loadParams)
{
return(_dataStore.GetAll <Waybill>()
.Select(WaybillGetModel.ProjectionExpression)
.Paging(loadParams)
.ToList());
}
public List <PolygonGetModel> GetAllPolygonModels(StoreLoadParams storeLoadParams)
{
return(dataStore.GetAll <Polygon>()
.Select(PolygonGetModel.ProjectionExpression)
.Paging(storeLoadParams)
.ToList());
}
public List <ContainerTypeGetModel> GetAllContainerTypeModels(StoreLoadParams storeLoadParams)
{
return(dataStore.GetAll <ContainerType>()
.Select(ContainerTypeGetModel.ProjectionExpression)
.Paging(storeLoadParams)
.ToList());
}
public List <CarGetModel> GetAllCarModels(StoreLoadParams storeLoadParams)
{
return(dataStore.GetAll <Car>()
.Select(CarGetModel.ProjectionExpression)
.Paging(storeLoadParams)
.ToList());
}
public List <DriverGetModel> GetAllDriverModels(StoreLoadParams storeLoadParams)
{
return(_dataStore.GetAll <Driver>()
.Select(DriverGetModel.ProjectionExpression)
.Paging(storeLoadParams)
.ToList());
}
public List <ContainerGetModel> GetAllFreeContainerModels(StoreLoadParams storeLoadParams)
{
return(dataStore.GetAll <Container>()
.Where(x => x.Status == ContainerStatus.Free)
.Select(ContainerGetModel.ProjectionExpression)
.Paging(storeLoadParams)
.ToList());
}
/// <summary>
/// Успешный ответ с данными
/// </summary>
/// <param name="query"></param>
/// <param name="loadParams"></param>
protected HttpResponseMessage SuccessListFrom <T>(IQueryable <T> query, StoreLoadParams loadParams)
{
var result = ListResult <T> .From(query, loadParams);
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
/// <summary>
/// Успешный ответ с данными
/// </summary>
/// <param name="query"></param>
/// <param name="loadParams"></param>
public static ListResult <T> From(IQueryable <T> query, StoreLoadParams loadParams)
{
var total = query.Count();
var filtered = query.Count();
var data = query
.Paging(loadParams)
.ToList();
return(Ok(data, filtered, total));
}
// GET: Polygons
public ActionResult Index(int page = 1, int countOnPage = 10)
{
var storeLoadParams = new StoreLoadParams
{
Start = page - 1,
Length = countOnPage
};
var model = _polygonService.GetAllPolygonModels(storeLoadParams);
return(View(model));
}
public static IQueryable <T> Paging <T>(this IQueryable <T> query, StoreLoadParams loadParams)
{
if (loadParams == null)
{
return(query);
}
if (loadParams.Length == 0)
{
return(query);
}
var resultQuery = query;
if (loadParams.Start != 0)
{
resultQuery = resultQuery.Skip(loadParams.Start);
}
return(resultQuery.Take(loadParams.Length));
}
public List <CustomerGetModel> GetAllOrderedCustomerModels(StoreLoadParams storeLoadParams)
{
var customers = _customerService.GetAllCustomerModels(null);
var counts = _dataStore.GetAll <Request>()
.Where(x => x.Customer != null)
.GroupBy(x => x.CustomerId)
.Select(x => new OrderModel
{
CustomerId = x.Key.Value,
Count = x.Count()
})
.ToList();
counts.AddRange(
customers
.Select(x => x.Id)
.Except(counts.Select(x => x.CustomerId))
.Select(
x => new OrderModel
{
CustomerId = x,
Count = 0
}
)
);
var orderedData = customers.Join(counts, x => x.Id, x => x.CustomerId,
(customer, count) => new
{
Customer = customer,
count.Count
})
.OrderByDescending(x => x.Count)
.Select(x => x.Customer)
.ToList();
return(orderedData);
}
public HttpResponseMessage GetList(StoreLoadParams storeLoadParams = null)
{
var result = carService.GetAllCarModels(storeLoadParams);
return(Success(result));
}
public List <ContainerTypeGetModel> GetAvailableContainerTypeModels(long carId, StoreLoadParams storeLoadParams)
{
var existing = dataStore.GetAll <CarContainerType>()
.Where(x => x.CarId == carId)
.Select(x => x.ContainerTypeId)
.ToList();
var available = dataStore.GetAll <ContainerType>()
.Where(x => !existing.Contains(x.Id))
.Select(ContainerTypeGetModel.ProjectionExpression)
.Paging(storeLoadParams)
.ToList();
return(available);
}
public List <CarContainerTypeGetModel> GetAllCarContainerTypeModels(long carId, StoreLoadParams storeLoadParams)
{
var result = dataStore.GetAll <CarContainerType>()
.Where(x => x.CarId == carId)
.Select(CarContainerTypeGetModel.ProjectionExpression)
.Paging(storeLoadParams)
.ToList();
return(result);
}
public HttpResponseMessage List(StoreLoadParams storeLoadParams = null)
{
var result = polygonService.GetAllPolygonModels(storeLoadParams);
return(Success(result));
}
public HttpResponseMessage List(long id, StoreLoadParams storeLoadParams)
{
var result = _waybillsService.GetAllWaybillRequestModels(id, storeLoadParams);
return(Success(result));
}
public List <WaybillRequestGetModel> GetAllWaybillRequestModels(long waybillId, StoreLoadParams loadParams)
{
return(_dataStore.GetAll <WaybillRequest>()
.Where(x => x.WaybillId == waybillId)
.Select(WaybillRequestGetModel.ProjectionExpression)
.Paging(loadParams)
.ToList());
}
public HttpResponseMessage List(StoreLoadParams storeLoadParams)
{
var result = containerTypeService.GetAllContainerTypeModels(storeLoadParams).ToList();
return(Success(result));
}
public HttpResponseMessage GetList([FromUri] StoreLoadParams storeLoadParams = null)
{
var result = containerService.GetAllContainerModels(storeLoadParams);
return(Success(result));
}
public HttpResponseMessage List(StoreLoadParams storeLoadParams)
{
var result = _waybillsService.GetAllWaybillModels(storeLoadParams).ToList();
return(Success(result));
}