private IQueryable <Carrier> Apply(IQueryable <Carrier> Carriers, CarrierSearchEntity CarrierSearchEntity)
{
if (CarrierSearchEntity.Id.HasValue)
{
Carriers = Carriers.Where(T => T.Id == CarrierSearchEntity.Id.Value);
}
if (!string.IsNullOrEmpty(CarrierSearchEntity.Code))
{
Carriers = Carriers.Where(T => T.Code.ToLower().Contains(CarrierSearchEntity.Code.ToLower()));
}
if (!string.IsNullOrEmpty(CarrierSearchEntity.Name))
{
Carriers = Carriers.Where(T => T.Name.ToLower().Contains(CarrierSearchEntity.Name.ToLower()));
}
if (!string.IsNullOrEmpty(CarrierSearchEntity.Address))
{
Carriers = Carriers.Where(T => T.Address.ToLower().Contains(CarrierSearchEntity.Address.ToLower()));
}
if (!string.IsNullOrEmpty(CarrierSearchEntity.Phone))
{
Carriers = Carriers.Where(T => T.Phone.ToLower().Contains(CarrierSearchEntity.Phone.ToLower()));
}
if (!string.IsNullOrEmpty(CarrierSearchEntity.Note))
{
Carriers = Carriers.Where(T => T.Note.ToLower().Contains(CarrierSearchEntity.Note.ToLower()));
}
if (CarrierSearchEntity.IsActive.HasValue)
{
Carriers = Carriers.Where(T => T.IsActive == CarrierSearchEntity.IsActive.Value);
}
return(Carriers);
}
public int Count(CarrierSearchEntity CarrierSearchEntity)
{
if (CarrierSearchEntity == null)
{
CarrierSearchEntity = new CarrierSearchEntity();
}
IQueryable <Carrier> Carriers = context.Carriers;
Carriers = Apply(Carriers, CarrierSearchEntity);
return(Carriers.Count());
}
public List <Carrier> List(CarrierSearchEntity CarrierSearchEntity)
{
if (CarrierSearchEntity == null)
{
CarrierSearchEntity = new CarrierSearchEntity();
}
IQueryable <Carrier> Carriers = context.Carriers;
Carriers = Apply(Carriers, CarrierSearchEntity);
Carriers = SkipAndTake(Carriers, CarrierSearchEntity);
return(Carriers.ToList());
}
public void Update_LastItemHasCodeFPT_UpdateNewAddressInDatabase()
{
CarrierSearchEntity CarrierSearchEntity = new CarrierSearchEntity {
Code = "FPT"
};
List <Carrier> carriers = CarrierRepository.List(CarrierSearchEntity);
Carrier Carrier = carriers.LastOrDefault();
Assert.AreNotEqual(null, Carrier);
Carrier.Address = "17 Duy Tân Cầu Giấy";
CarrierRepository.Update(Carrier);
UnitOfWork.Complete();
Carrier Existed = CarrierRepository.Get(Carrier.Id);
Assert.AreEqual(Carrier.Address, Existed.Address);
}
public void Search_FirstItemAllAttribute_IsItSelf()
{
List <Carrier> Carriers = CarrierRepository.List(null);
Carrier Carrier = Carriers.LastOrDefault();
CarrierSearchEntity CarrierSearchEntity = new CarrierSearchEntity
{
Id = Carrier.Id,
Code = Carrier.Code,
Name = Carrier.Name,
Address = Carrier.Address,
Phone = Carrier.Phone,
Note = Carrier.Note
};
Carriers = CarrierRepository.List(CarrierSearchEntity);
Assert.AreEqual(1, Carriers.Count);
}
public List <CarrierEntity> Get(EmployeeEntity EmployeeEntity, CarrierSearchEntity CarrierSearchEntity)
{
List <Carrier> Carriers = UnitOfWork.CarrierRepository.List(CarrierSearchEntity);
return(Carriers.Select(c => new CarrierEntity(c)).ToList());
}
public int Count(EmployeeEntity EmployeeEntity, CarrierSearchEntity CarrierSearchEntity)
{
return(UnitOfWork.CarrierRepository.Count(CarrierSearchEntity));
}
public List <CarrierEntity> Get(CarrierSearchEntity CarrierSearchEntity)
{
return(CarrierService.Get(EmployeeEntity, CarrierSearchEntity));
}
public long Count(CarrierSearchEntity CarrierSearchEntity)
{
return(CarrierService.Count(EmployeeEntity, CarrierSearchEntity));
}
