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