public async Task <bool> Delete(object id) { var Building = _repoBuilding.FindById(id); _repoBuilding.Remove(Building); return(await _repoBuilding.SaveAll()); }
public async Task <List <GlueCreateDto1> > GetGlueByBuilding(int buildingID) { var item = _repoBuilding.FindById(buildingID); var lineList = await _repoBuilding.FindAll().Where(x => x.ParentID == item.ID).Select(x => x.ID).ToListAsync(); List <int> modelNameID = _repoPlan.FindAll().Where(x => lineList.Contains(x.BuildingID)).Select(x => x.BPFCEstablishID).ToList(); var lists = await _repoGlue.FindAll().ProjectTo <GlueCreateDto1>(_configMapper).Where(x => modelNameID.Contains(x.BPFCEstablishID)).OrderByDescending(x => x.ID).Select(x => new GlueCreateDto1 { ID = x.ID, Name = x.Name, GlueID = x.GlueID, Code = x.Code, ModelNo = x.ModelNo, CreatedDate = x.CreatedDate, BPFCEstablishID = x.BPFCEstablishID, PathName = x.PathName, PartNameID = x.PartNameID, MaterialNameID = x.MaterialNameID, MaterialName = x.MaterialName, Consumption = x.Consumption, Chemical = new GlueDto1 { ID = x.GlueID, Name = x.Name } }).ToListAsync(); return(lists.DistinctBy(x => x.Name).ToList()); //return await _repoGlue.FindAll().ProjectTo<GlueCreateDto1>(_configMapper).Where(x=>x.ModalNameID == modelNameID).OrderByDescending(x => x.ID).ToListAsync(); }
public object DeliveredHistory() { var result = new List <BuildingGlueDto>(); var glues = _repoGlue.FindAll().Where(x => x.isShow == true).ToList(); foreach (var item in _repoBuildingGlue.FindAll().OrderByDescending(x => x.CreatedDate)) { var glueName = string.Empty; var model = glues.FirstOrDefault(x => x.isShow == true && x.ID == item.GlueID); if (model != null) { glueName = model.Name; } result.Add(new BuildingGlueDto { ID = item.ID, GlueName = glueName, Qty = item.Qty, BuildingName = _repoBuilding.FindById(item.BuildingID).Name, CreatedBy = item.CreatedBy, CreatedDate = item.CreatedDate }); } return(result); }
public async Task <object> GetBuildingByUserID(int userid) { var model = await _buildingUserRepository.FindAll().FirstOrDefaultAsync(x => x.UserID == userid); if (model == null) { return(new Building()); } return(_buildingRepository.FindById(model.BuildingID)); }
public async Task <object> GetBuildingByUserID(int userid) { try { var model = await _buildingUserRepository.FindAll().FirstOrDefaultAsync(x => x.UserID == userid); return(_buildingRepository.FindById(model.BuildingID)); } catch (System.Exception) { return(false); } }
public CompanyBuildingItem GetFloorItems(int?buildingId, int?companyId) { var building = _buildingRepository.FindById(buildingId.Value); var building_ids = GetUserBuildings(_buildingRepository, _userRepository); var buildingObjects = _buildingObjectRepository.FindAll().Where(x => !x.IsDeleted && x.BuildingId == buildingId && x.TypeId == 1); var result = new CompanyBuildingItem() { BuildingId = buildingId, IsAvailable = building_ids.Contains(buildingId.Value), BuildingName = building.Name }; var floors = new List <CompanyFloorItem>(); var companyBuildingObjects = companyId == null ? null : _companyBuildingObjectRepository.FindAll().Where( x => x.CompanyId == companyId.Value && x.BuildingObject.BuildingId == buildingId.Value); foreach (var buildingObject in buildingObjects) { var item = new CompanyFloorItem(); item.CompanyId = companyId; item.BuildingObjectId = buildingObject.Id; item.IsAvailable = building_ids.Contains(buildingObject.BuildingId); var cbo = companyBuildingObjects == null ? null : companyBuildingObjects.Where(x => x.BuildingObjectId == buildingObject.Id).FirstOrDefault(); if (cbo == null) { item.IsSelected = false; item.Id = null; } else { item.IsSelected = !cbo.IsDeleted; item.Id = cbo.Id; } floors.Add(item); } result.CompanyFloors = floors; return(result); }
public ActionResult BuildingInfo(int buildingId) { var model = CreateViewModel <BuildingViewModel>(); var building = _buildingRepository.FindById(buildingId); model.BuildingName = building.Name; var users = _userRepository.FindAll().Where( x => !x.IsDeleted && x.Active && x.UserRoles.Any(ur => ur.ValidFrom <DateTime.Now && !ur.IsDeleted && ur.ValidTo.AddDays(1)> DateTime.Now && ur.Role.RoleTypeId == (int)RoleTypeEnum.BA) && x.UserBuildings.Any(ub => !ub.IsDeleted && ub.BuildingId == buildingId)); var user_names = from us in users select string.Format("{0} {1}", us.FirstName, us.LastName); if (user_names.Count() > 0) { model.AdminName = string.Join(",", user_names); } return(PartialView("BuildingInfo", model)); }
public Building FindById(long id) { return(repository.FindById(id)); }
public async Task <object> GetBuildingByWorkerID(int workerId) { var model = await _buildingUserRepository.FindAll().FirstOrDefaultAsync(x => x.WorkerID == workerId); return(_buildingRepository.FindById(model.BuildingID)); }