public int Count(ReceiptNoteSearchEntity ReceiptNoteSearchEntity)
{
if (ReceiptNoteSearchEntity == null)
{
ReceiptNoteSearchEntity = new ReceiptNoteSearchEntity();
}
IQueryable <ReceiptNote> ReceiptNotes = context.ReceiptNotes;
Apply(ReceiptNotes, ReceiptNoteSearchEntity);
return(ReceiptNotes.Count());
}
public List <ReceiptNote> List(ReceiptNoteSearchEntity ReceiptNoteSearchEntity)
{
if (ReceiptNoteSearchEntity == null)
{
ReceiptNoteSearchEntity = new ReceiptNoteSearchEntity();
}
IQueryable <ReceiptNote> ReceiptNotes = context.ReceiptNotes
.Include(rn => rn.WareHouse)
.Include(rn => rn.Supplier)
.Include(rn => rn.ReceiptNoteLines).ThenInclude(rnl => rnl.Product);
Apply(ReceiptNotes, ReceiptNoteSearchEntity);
SkipAndTake(ReceiptNotes, ReceiptNoteSearchEntity);
return(ReceiptNotes.ToList());
}
public List <ReceiptNoteEntity> Get(EmployeeEntity EmployeeEntity, ReceiptNoteSearchEntity ReceiptNoteSearchEntity)
{
List <ReceiptNote> ReceiptNotes = UnitOfWork.ReceiptNoteRepository.List(ReceiptNoteSearchEntity);
return(ReceiptNotes.ToList().Select(rn => new ReceiptNoteEntity(rn, rn.WareHouse, rn.Supplier)).ToList());
}
public int Count(EmployeeEntity EmployeeEntity, ReceiptNoteSearchEntity ReceiptNoteSearchEntity)
{
return(UnitOfWork.ReceiptNoteRepository.Count(ReceiptNoteSearchEntity));
}
public List<ReceiptNoteEntity> Get(ReceiptNoteSearchEntity SearchReceiptNoteEntity)
{
return ReceiptNoteService.Get(EmployeeEntity, SearchReceiptNoteEntity);
}
public long Count(ReceiptNoteSearchEntity SearchReceiptNoteEntity)
{
return ReceiptNoteService.Count(EmployeeEntity, SearchReceiptNoteEntity);
}
private IQueryable <ReceiptNote> Apply(IQueryable <ReceiptNote> ReceiptNotes, ReceiptNoteSearchEntity ReceiptNoteSearchEntity)
{
if (ReceiptNoteSearchEntity.Id.HasValue)
{
ReceiptNotes = ReceiptNotes.Where(wh => wh.Id == ReceiptNoteSearchEntity.Id.Value);
}
if (ReceiptNoteSearchEntity.WareHouseId.HasValue)
{
ReceiptNotes = ReceiptNotes.Where(wh => wh.WareHouseId == ReceiptNoteSearchEntity.WareHouseId.Value);
}
if (ReceiptNoteSearchEntity.SupplierId.HasValue)
{
ReceiptNotes = ReceiptNotes.Where(wh => wh.SupplierId == ReceiptNoteSearchEntity.SupplierId.Value);
}
if (ReceiptNoteSearchEntity.ReceiptNoteNo.HasValue)
{
ReceiptNotes = ReceiptNotes.Where(wh => wh.ReceiptNoteNo == ReceiptNoteSearchEntity.ReceiptNoteNo.Value);
}
if (!string.IsNullOrEmpty(ReceiptNoteSearchEntity.Title))
{
ReceiptNotes = ReceiptNotes.Where(wh => wh.Title.ToLower().Contains(ReceiptNoteSearchEntity.Title.ToLower()));
}
if (!string.IsNullOrEmpty(ReceiptNoteSearchEntity.Address))
{
ReceiptNotes = ReceiptNotes.Where(wh => wh.Address.ToLower().Contains(ReceiptNoteSearchEntity.Address.ToLower()));
}
if (!string.IsNullOrEmpty(ReceiptNoteSearchEntity.PhoneNumber))
{
ReceiptNotes = ReceiptNotes.Where(wh => wh.PhoneNumber.ToLower().Contains(ReceiptNoteSearchEntity.PhoneNumber.ToLower()));
}
if (!string.IsNullOrEmpty(ReceiptNoteSearchEntity.Comment))
{
ReceiptNotes = ReceiptNotes.Where(wh => wh.Comment.ToLower().Contains(ReceiptNoteSearchEntity.Comment.ToLower()));
}
if (ReceiptNoteSearchEntity.Lock.HasValue)
{
ReceiptNotes = ReceiptNotes.Where(wh => wh.Lock == ReceiptNoteSearchEntity.Lock.Value);
}
if (ReceiptNoteSearchEntity.EmployeeId.HasValue)
{
ReceiptNotes = ReceiptNotes.Where(wh => wh.EmployeeId == ReceiptNoteSearchEntity.EmployeeId.Value);
}
return(ReceiptNotes);
}
