public IEnumerable <POCO.TrnSales> BulkRead(TrnSalesFilter filter = null, FilterMethods filterMethods = null)
{
IEnumerable <POCO.TrnSales> result;
var dynamicFilter = Filterer <TrnSalesFilter> .GetFilter(filter, filterMethods);
var mappingProfile = new MappingProfileForTrnSales();
using (var ctx = new posDataContext())
{
IEnumerable <TrnSale> data;
if (filter != null)
{
var enumerable = dynamicFilter as Filter[] ?? dynamicFilter.ToArray();
var filterExpression = ExpressionBuilder
.GetExpression <TrnSale>(enumerable.ToList()).Compile();
data = ctx.TrnSales.Where(filterExpression);
}
else
{
data = ctx.TrnSales;
}
result = mappingProfile.mapper.Map <List <POCO.TrnSales> >(data);
result.ToList()
.ForEach(x => x.IsNotTendered = !ctx.TrnCollections.Any(y => y.SalesId == x.Id));
}
return(result);
}
public IEnumerable <POCO.MstItem> BulkRead(MstItemFilter filter = null, FilterMethods filterMethods = null)
{
IEnumerable <POCO.MstItem> result;
var dynamicFilter = Filterer <MstItemFilter> .GetFilter(filter, filterMethods);
var mappingProfile = new MappingProfile <Data.MstItem, POCO.MstItem>();
using (var ctx = new posDataContext())
{
IEnumerable <Data.MstItem> data;
if (filter != null)
{
var enumerable = dynamicFilter as Filter[] ?? dynamicFilter.ToArray();
var filterExpression = ExpressionBuilder
.GetExpression <Data.MstItem>(enumerable.ToList()).Compile();
data = ctx.MstItems.Where(filterExpression);
}
else
{
data = ctx.MstItems;
}
result = mappingProfile.mapper.Map <IEnumerable <Data.MstItem>, IEnumerable <POCO.MstItem> >(data);
}
return(result);
}
