public int Count(ShipmentDetailSearchEntity SearchShipmentDetailEntity)
{
if (SearchShipmentDetailEntity == null)
{
SearchShipmentDetailEntity = new ShipmentDetailSearchEntity();
}
IQueryable <ShipmentDetail> ShipmentDetails = context.ShipmentDetails;
Apply(ShipmentDetails, SearchShipmentDetailEntity);
return(ShipmentDetails.Count());
}
public List <ShipmentDetail> List(ShipmentDetailSearchEntity SearchShipmentDetailEntity)
{
if (SearchShipmentDetailEntity == null)
{
SearchShipmentDetailEntity = new ShipmentDetailSearchEntity();
}
IQueryable <ShipmentDetail> ShipmentDetails = context.ShipmentDetails
.Include(sd => sd.Customer)
.Include(sd => sd.City)
.Include(sd => sd.Country);
Apply(ShipmentDetails, SearchShipmentDetailEntity);
SkipAndTake(ShipmentDetails, SearchShipmentDetailEntity);
return(ShipmentDetails.ToList());
}
public List <ShipmentDetailEntity> Get(ShipmentDetailSearchEntity SearchShipmentDetailEntity)
{
return(ShipmentDetailService.Get(EmployeeEntity, SearchShipmentDetailEntity));
}
public long Count(ShipmentDetailSearchEntity SearchShipmentDetailEntity)
{
return(ShipmentDetailService.Count(EmployeeEntity, SearchShipmentDetailEntity));
}
private IQueryable <ShipmentDetail> Apply(IQueryable <ShipmentDetail> ShipmentDetails, ShipmentDetailSearchEntity SearchShipmentDetailEntity)
{
if (SearchShipmentDetailEntity.Id.HasValue)
{
ShipmentDetails = ShipmentDetails.Where(t => t.Id == SearchShipmentDetailEntity.Id.Value);
}
if (!string.IsNullOrEmpty(SearchShipmentDetailEntity.FullName))
{
ShipmentDetails = ShipmentDetails.Where(t => t.FullName.ToLower().Contains(SearchShipmentDetailEntity.FullName.ToLower()));
}
if (SearchShipmentDetailEntity.CountryId.HasValue)
{
ShipmentDetails = ShipmentDetails.Where(t => t.CountryId == SearchShipmentDetailEntity.CountryId.Value);
}
if (SearchShipmentDetailEntity.CityId.HasValue)
{
ShipmentDetails = ShipmentDetails.Where(t => t.CityId == SearchShipmentDetailEntity.CityId.Value);
}
if (!string.IsNullOrEmpty(SearchShipmentDetailEntity.Address))
{
ShipmentDetails = ShipmentDetails.Where(t => t.Address.ToLower().Contains(SearchShipmentDetailEntity.Address.ToLower()));
}
if (!string.IsNullOrEmpty(SearchShipmentDetailEntity.Phone))
{
ShipmentDetails = ShipmentDetails.Where(t => t.Phone.ToLower().Contains(SearchShipmentDetailEntity.Phone.ToLower()));
}
if (!string.IsNullOrEmpty(SearchShipmentDetailEntity.Note))
{
ShipmentDetails = ShipmentDetails.Where(t => t.Note.ToLower().Contains(SearchShipmentDetailEntity.Note.ToLower()));
}
if (SearchShipmentDetailEntity.CustomerId.HasValue)
{
ShipmentDetails = ShipmentDetails.Where(t => t.CustomerId == SearchShipmentDetailEntity.CustomerId.Value);
}
return(ShipmentDetails);
}
public List <ShipmentDetailEntity> Get(EmployeeEntity EmployeeEntity, ShipmentDetailSearchEntity ShipmentDetailSearchEntity)
{
List <ShipmentDetail> ShipmentDetails = UnitOfWork.ShipmentDetailRepository.List(ShipmentDetailSearchEntity);
return(ShipmentDetails.ToList().Select(c => new ShipmentDetailEntity(c, c.Customer, c.City, c.Country)).ToList());
}
public int Count(EmployeeEntity EmployeeEntity, ShipmentDetailSearchEntity ShipmentDetailSearchEntity)
{
return(UnitOfWork.ShipmentDetailRepository.Count(ShipmentDetailSearchEntity));
}
