public IActionResult Index(int?deliveryAreaId)
{
ViewBag.breadcrumbs = commonService.Breadcrumbs_ForDeliveryAreaAddresses(deliveryAreaId ?? 0).DeleteOrDisableLast();
var deliveryArea = service.GetById <DeliveryArea>(deliveryAreaId);
ViewBag.deliveryAreaLabel = "";
if (deliveryArea != null)
{
ViewBag.deliveryAreaLabel = " към район " + deliveryArea.Description;
var lawUnit = service.GetById <LawUnit>(deliveryArea.LawUnitId);
if (lawUnit != null)
{
ViewBag.deliveryAreaLabel += " с призовкар " + lawUnit.FullName;
}
}
ViewBag.ExpiredType_ddl = service.ExpiredTypeDDL();
var filter = new DeliveryAreaAddressFilterVM()
{
DeliveryAreaId = deliveryAreaId ?? 0,
ExpiredType = 1
};
SetHelpFile(HelpFileValues.Nom3);
return(View(filter));
}
public IQueryable <DeliveryAreaAddressVM> DeliveryAreaAddressSelect(DeliveryAreaAddressFilterVM filter)
{
var cities = repo.AllReadonly <EkEkatte>().AsQueryable();
var streets = repo.AllReadonly <EkStreet>().AsQueryable();
var numberTypes = repo.AllReadonly <DeliveryNumberType>().AsQueryable();
var result = repo.AllReadonly <DeliveryAreaAddress>()
.Where(x => x.DeliveryAreaId == filter.DeliveryAreaId && (
((filter.DateFrom ?? DateTime.MinValue) <= (x.DateFrom ?? DateTime.MinValue) && (x.DateFrom ?? DateTime.MinValue) <= (filter.DateTo ?? DateTime.MaxValue)) ||
((filter.DateFrom ?? DateTime.MinValue) <= (x.DateTo ?? DateTime.MaxValue) && (x.DateTo ?? DateTime.MaxValue) <= (filter.DateTo ?? DateTime.MaxValue)) ||
((x.DateFrom ?? DateTime.MinValue) <= (filter.DateFrom ?? DateTime.MinValue) && (filter.DateFrom ?? DateTime.MinValue) <= (x.DateTo ?? DateTime.MaxValue)) ||
((x.DateFrom ?? DateTime.MinValue) <= (filter.DateTo ?? DateTime.MaxValue) && (filter.DateTo ?? DateTime.MaxValue) <= (x.DateTo ?? DateTime.MaxValue))
) &&
(filter.ExpiredType != 0 || (x.DateExpired != null && (filter.DateExpiredFrom ?? DateTime.MinValue) <= (x.DateExpired ?? DateTime.MinValue) && (x.DateExpired ?? DateTime.MinValue) <= (filter.DateExpiredTo ?? DateTime.MaxValue))) &&
(filter.ExpiredType != 1 || x.DateExpired == null)
)
.Select(x => new DeliveryAreaAddressVM()
{
Id = x.Id,
City = cities.Where(c => c.Ekatte == x.CityCode).Select(EkatteCityName()).FirstOrDefault(),
Street = streets.Where(s => s.Code == x.StreetCode && s.Ekatte == x.CityCode).Select(c => c.Name).FirstOrDefault(),
ResidentionArea = streets.Where(s => s.Code == x.ResidentionAreaCode && s.Ekatte == x.CityCode).Select(c => c.Name).FirstOrDefault(),
NumberType = numberTypes.Where(n => n.Id == x.NumberType).Select(c => c.Label).FirstOrDefault(),
NumberFrom = x.NumberFrom,
NumberTo = x.NumberTo,
BlockName = x.BlockName,
DateFrom = x.DateFrom,
DateTo = x.DateTo,
DateExpired = x.DateExpired
})
.AsQueryable();
return(result);
}
public IActionResult ListData(IDataTablesRequest request, DeliveryAreaAddressFilterVM filter)
{
var data = service.DeliveryAreaAddressSelect(filter);
return(request.GetResponse(data));
}
