public async Task <IActionResult> EditSubdivision(int subdivisionId) { var PTV_Battle_Reserv_Warehouse = new List <PTV_Battle_Reserv_WarehouseViewModel>(); var subdivision = await _context.Set <Subdivision>() .Include(x => x.BattleСrew) .Include(x => x.Reserve) .Include(x => x.Warehouse) .FirstOrDefaultAsync(x => x.SubdivisionId == subdivisionId); subdivision.Reserve.Reserve_PTVs = await _context.ReservePTV.Where(x => x.ReserveId == subdivision.ReservId).ToListAsync(); subdivision.BattleСrew.BattleСrew_PTV = await _context.BattleСrew_PTV.Where(x => x.BattleСrewId == subdivision.BattleСrewId).ToListAsync(); subdivision.Warehouse.Warehouse_PTVs = await _context.Warehouse_PTV.Where(x => x.WarehouseId == subdivision.WarehouseId).ToListAsync(); var norma = await _context.Norms.AsNoTracking().Include(x => x.Norms_PTVs) .FirstOrDefaultAsync(x => x.CategoryesId == subdivision.CategoryesId); var ptv = await _context.PTV.ToListAsync(); foreach (var item in norma.Norms_PTVs) { var countBattleСrew = subdivision.BattleСrew.BattleСrew_PTV.FirstOrDefault(x => x.PTVId == item.PTVId); var countReserv = subdivision.Reserve.Reserve_PTVs.FirstOrDefault(x => x.PTVId == item.PTVId); var countWarehouse = subdivision.Warehouse.Warehouse_PTVs.FirstOrDefault(x => x.PTVId == item.PTVId); PTV_Battle_Reserv_Warehouse.Add(new PTV_Battle_Reserv_WarehouseViewModel { PTV = ptv.FirstOrDefault(x => x.PTVId == item.PTVId), BattleCrewView = new BattleCrewView { CountNormal = (item.NormsCount * (subdivision.CountCarInBattleCrew / 2)), CountNow = (countBattleСrew == null ? 0 : countBattleСrew.Count), CountEnd = (countBattleСrew == null ? 0 : countBattleСrew.NeedPTV) }, ReservView = new ReservView { CountNormal = (item.NormsCount * (subdivision.CountCarInBattleCrew / 2)), CountNow = (countReserv == null ? 0 : countReserv.Count), CountEnd = (countReserv == null ? 0 : countReserv.NeedPTV) }, WarehouseView = new WarehouseView { CountNormal = (item.OnCar != true ? decimal.ToInt32(item.WarehouseNormsCount) : decimal.ToInt32(((subdivision.CountCarInBattleCrew * item.NormsCount) * item.WarehouseNormsCount)) / 2), CountNow = (countWarehouse == null ? 0 : countWarehouse.Count), CountEnd = (countWarehouse == null ? 0 : countWarehouse.NeedPTV), }, }); } var model = new BattleCrew_ReservViewModel { Subdivision = subdivision, PTV_Battle_Reserv_WarehouseViewModel = PTV_Battle_Reserv_Warehouse }; return(View(model)); }
public IEnumerable <Directory> GetAllDirectories() { var dbDirectories = _context.Set <DbDirectory>() .Include(x => x.Materials).ToList(); return(dbDirectories.Select(ConvertDBModel).ToList()); }
public IEnumerable <Material> GetAllMaterials(bool includeDirectory = false) { if (includeDirectory) { return(_context.Set <Material>().Include(m => m.Directory).AsNoTracking().ToList()); } return(_context.Materials.ToList()); }
public IEnumerable <Directory> GetAllDirectories(bool includeMaterials = false) { if (includeMaterials) { return(_context.Set <Directory>().Include(d => d.Materials).AsNoTracking().ToList()); } return(_context.Directories.ToList()); }
public IEnumerable <Book> GetAllBooks(bool IncludeAuthors = false) { if (IncludeAuthors) { return(context.Set <Book>().Include(x => x.Author).AsNoTracking().ToList()); } else { return(context.book.ToList()); } }
public IEnumerable <Worker> GetAllWorkers(bool includeProject = false) { if (includeProject) { return(context.Set <Worker>().Include(x => x.Project).AsNoTracking().ToList()); } else { return(context.Worker.ToList()); } }
public IEnumerable <Project> GetAllProjects(bool includeWorkers = false) { if (includeWorkers) { return(context.Set <Project>().Include(x => x.Workers).AsNoTracking().ToList()); } else { return(context.Project.ToList()); } }
public IEnumerable <Directory> GetAllDirectorys(bool includeMaterial = false) { if (includeMaterial) { return(context.Set <Directory>().Include(x => x.Materials).AsNoTracking().ToList()); } else { return(context.Directory.ToList()); } }
public IEnumerable <Content> GetAllBooks(bool includeDirectory = false) { if (includeDirectory) { return(context.Set <Content>().Include(x => x.Directory).AsNoTracking().ToList()); } else { return(context.Books.ToList()); } }
public IEnumerable <Log> GetAllLogs(bool IncludeData = false) { if (IncludeData) { return(context.Set <Log>().Include(x => x.Book).Include(y => y.Reader).AsNoTracking().ToList()); } else { return(context.log.ToList()); } }
public IEnumerable <Directory> GetAllDirectories(bool includeContent = false) { if (includeContent) { return(context.Set <Directory>().Include(x => x.Books).AsNoTracking().ToList()); } else { return(context.Directory.ToList()); } }
public IEnumerable <Properties> GetAllProperties(bool includeProperties = false) { if (includeProperties) { return(context.Set <Properties>().AsNoTracking().ToList()); } else { return(context.Properties.ToList()); } }
public IEnumerable <Material> GetAllMaterials(bool IncludeDirectory = false) { if (IncludeDirectory) { return(context.Set <Material>().Include(x => x.Directory).AsNoTracking().ToList()); } else { return(context.Material.ToList()); } }
public IEnumerable <Product> GetAllItems(bool includeProducts = false) { if (includeProducts) { return(context.Set <Product>().AsNoTracking().ToList()); } else { return(context.Products.ToList()); } }
public IEnumerable <Customer> GetAllCustomers(bool includeCustomer = false) { if (includeCustomer) { return(context.Set <Customer>().AsNoTracking().ToList()); } else { return(context.Customers.ToList()); } }
public IEnumerable <Product> GetAllProducts(bool includeCategories = false) { if (includeCategories) { return(_context.Set <Product>().Include(x => x.Category).AsNoTracking().ToList()); } else { return(_context.Products.ToList()); } }
public IEnumerable <Category> GetAllCategories(bool includeProducts = false) { if (includeProducts) { return(_context.Set <Category>().Include(x => x.Product ).AsNoTracking().ToList()); } else { return(_context.Categories.ToList()); } }
public EFRepository(EFDBContext dbContext) { _dbContext = dbContext ?? throw new ArgumentNullException("Context boş olamaz."); _dbContext.Database.CommandTimeout = 100; _dbSet = dbContext.Set <T>(); }
public EntityRepositoryBase(EFDBContext dbContext) { _dbContext = dbContext ?? throw new ArgumentNullException("Db Context null!"); _dbSet = dbContext.Set <T>(); }
public IEnumerable <Clothes> GetAllClothes() { return(context.Set <Clothes>().Include(x => x.Brand).Include(x => x.Tag).Include(x => x.Image).ToList()); }
public Repository(EFDBContext context) { _context = context; _dbSet = _context.Set <T>(); }
public virtual IList <TEntity> FindAllBy(System.Linq.Expressions.Expression <Func <TEntity, bool> > predicate) { return(context.Set <TEntity>().Where(predicate).ToList()); }
public GenericRepository(EFDBContext context) { this.context = context; this.dbSet = context.Set <TEntity>(); }
public int Count(Func <T, bool> predicate) { return(_context.Set <T>().Where(predicate).Count()); }
public EFBaseRepository(EFDBContext context) { _context = context; _dbSet = _context.Set <TEntity>(); }
/// <summary> /// 获取所有实体集合 /// </summary> /// <returns></returns> public List <TEntity> GetAllList() => _dbcontext.Set <TEntity>().ToList();
public IEnumerable <Dishes> GetAllDishes() { return(context.Set <Dishes>().Include(x => x.Category).Include(x => x.Tag).Include(x => x.Image).ToList()); }
public EFCustumRepository(EFDBContext context) { this.context = context; _dbSet = context.Set <T>(); }
public IEnumerable <Directory> GetAllDirectorys(bool includeMaterials = false) { return(includeMaterials ? context.Set <Directory>().Include(x => x.Materials).AsNoTracking().ToList() : context.Directories.ToList()); }