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());
}