protected void Dispose(bool disposing)
{
if (disposing)
{
if (_repository != null)
{
_repository.Dispose();
_repository = null;
}
}
}
public List <VLCMilkCollection> GetVLCMilkCollectionByCount(int?pageNumber, int?count)
{
var takePage = pageNumber ?? PagingConstant.DefaultPageNumber;
var takeCount = count ?? PagingConstant.DefaultRecordCount;
PlatformDBEntities context = new PlatformDBEntities();
var vlcMilkCollections = context.VLCMilkCollections
.OrderBy(c => c.VLCMilkCollectionId)
.Skip((takePage - 1) * takeCount)
.Take(takeCount)
.ToList <Sql.VLCMilkCollection>();
return(vlcMilkCollections);
}
public List <User> GetUsersByCount(int?pageNumber, int?count)
{
var takePage = pageNumber ?? PagingConstant.DefaultPageNumber;
var takeCount = count ?? PagingConstant.DefaultRecordCount;
PlatformDBEntities context = new PlatformDBEntities();
var users = context.Users
.OrderBy(c => c.UserId)
.Skip((takePage - 1) * takeCount)
.Take(takeCount)
.ToList <Sql.User>();
return(users);
}
public List <DockMilkCollectionDtl> GetDockMilkCollectionByCount(int?pageNumber, int?count)
{
var takePage = pageNumber ?? PagingConstant.DefaultPageNumber;
var takeCount = count ?? PagingConstant.DefaultRecordCount;
PlatformDBEntities context = new PlatformDBEntities();
var dockMilkCollections = context.DockMilkCollectionDtls
.OrderBy(c => c.DockMilkCollectionDtlI)
.Skip((takePage - 1) * takeCount)
.Take(takeCount)
.ToList <Sql.DockMilkCollectionDtl>();
return(dockMilkCollections);
}
public List <CustomerBank> GetCustomerByCount(int?pageNumber, int?count)
{
var takePage = pageNumber ?? PagingConstant.DefaultPageNumber;
var takeCount = count ?? PagingConstant.DefaultRecordCount;
PlatformDBEntities context = new PlatformDBEntities();
var customerBanks = context.CustomerBanks
.Where(c => c.IsDeleted == false)
.OrderBy(c => c.CustomerBankId)
.Skip((takePage - 1) * takeCount)
.Take(takeCount)
.ToList <Sql.CustomerBank>();
return(customerBanks);
}
public List <VLC> GetVLCByCount(int?pageNumber, int?count)
{
var takePage = pageNumber ?? PagingConstant.DefaultPageNumber;
var takeCount = count ?? PagingConstant.DefaultRecordCount;
PlatformDBEntities context = new PlatformDBEntities();
var vlcs = context.VLCs
.Where(c => c.IsDeleted == false)
.OrderBy(c => c.VLCId)
.Skip((takePage - 1) * takeCount)
.Take(takeCount)
.ToList <Sql.VLC>();
return(vlcs);
}
public ProductCategoryRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public DCOrderRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public ModuleDashboardRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public SiteRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public CustomerWalletRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public UnitOfWork()
{
_repository = new PlatformDBEntities();
}
public VLCPaymentDetailRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public VLCExpenseDetailRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public DockMilkCollectionDtlRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public CustomerAgricultureRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public SiteConfigurationRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public ProductOrderDtlRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public VLCWalletRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public DockReportRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public DistributionCenterRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public VLCMilkCollectionRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public CustomerPaymentRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public MilkRateRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public CustomerBankRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public CustomerSessionRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public ProductSalesRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public ProductSiteMappingRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public EmployeeRepository(PlatformDBEntities repository)
{
_repository = repository;
}
public ItemRepository(PlatformDBEntities repository)
{
_repository = repository;
}
