public int getBuildingId(string ownerEmail) { var buildingId = (from b in _buildingRepository.GetBuildings() where b.OwnerEmail == ownerEmail select b.BuildingId).FirstOrDefault(); return(buildingId); }
public int GetNoOfRoom(int buildId) { var nor = from b in _buildingRepository.GetBuildings() where b.BuildingId == buildId select b.TotalNumberOfRooms; return(Convert.ToInt32(nor)); }
public ActionResult <Models.FastFindBindingModel> Get(string searchTerm) { var buildingFilters = new List <Tuple <string, object> >(); buildingFilters.Add(new Tuple <string, object>("BuildingName LIKE {0}", $"%{searchTerm}%")); var buildings = _buildingRepository.GetBuildings(buildingFilters); var unitFilters = new List <Tuple <string, object> >(); unitFilters.Add(new Tuple <string, object>("UnitName LIKE {0}", $"%{searchTerm}%")); var units = _unitRepository.GetUnits(unitFilters); var rentFilters = new List <Tuple <string, object> >(); rentFilters.Add(new Tuple <string, object>("UnitName LIKE {0}", $"%{searchTerm}%")); var rents = _rentRepository.GetRents(rentFilters); var model = new Models.FastFindBindingModel(); model.Buildings = buildings; model.Units = units; model.Rents = rents; return(Ok(model)); }
public IActionResult Index(string searchTerm) { var buildingFilters = new List <Tuple <string, object> >(); buildingFilters.Add(new Tuple <string, object>("BuildingName LIKE {0}", $"%{searchTerm}%")); var buildings = _buildingRepository.GetBuildings(buildingFilters); var unitFilters = new List <Tuple <string, object> >(); unitFilters.Add(new Tuple <string, object>("UnitName LIKE {0}", $"%{searchTerm}%")); var units = _unitRepository.GetUnits(unitFilters); var rentFilters = new List <Tuple <string, object> >(); rentFilters.Add(new Tuple <string, object>("UnitName LIKE {0}", $"%{searchTerm}%")); var rents = _rentRepository.GetRents(rentFilters); var viewModel = new FastFindViewModel(); viewModel.Buildings = buildings; viewModel.Units = units; viewModel.Rents = rents; return(View(viewModel)); }
public async Task <IEnumerable <Building> > GetBuildings(BuildingUserParams userParams = null) { var buildings = await _buildingsRepo.GetBuildings( userParams, new Expression <Func <Building, object> >[] { b => b.BuildingCategory }); return(buildings); }
public ActionResult GetBuildings() { try { var buildings = _buildingRepo.GetBuildings(""); return(AngularJsonResult(buildings)); } catch (Exception ex) { //log here throw; } }
public BuildingViewModel(IBuildingRepository buildingRepository) { try { Buildings = new ObservableCollection<Building>(buildingRepository.GetBuildings()); HeatSuppliers = new ObservableCollection<HeatSupplier>(buildingRepository.GetSuppliers()); _supplierRepository = buildingRepository; _view = new CreateBuildingView() {DataContext = this}; } catch (Exception error) { int x; } }
public async Task <IActionResult> GetBuildings() { var buildingsFromRepo = await _repo.GetBuildings(); if (buildingsFromRepo == null) { return(BadRequest()); } return(Ok( buildingsFromRepo.Select(p => new { Id = p.Id, Address = p.Address.ToString() }))); }
public HttpResponseMessage GetBuildings() { try { var buildings = _repo.GetBuildings(); if (buildings == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } HttpResponseMessage response = Request.CreateResponse <IEnumerable <Building> >(HttpStatusCode.OK, buildings); return(response); } catch (Exception ex) { string msg = ex.Message; HttpResponseMessage response = Request.CreateResponse <string>(HttpStatusCode.InternalServerError, msg); return(response); } }
private object GetBuildingsByStateChart() { var chartData = _buildingRepository.GetBuildings() .GroupBy(b => b.State) .Select(group => new { label = group.Key, value = group.Count() }).ToArray(); var dataSource = new { chart = new { caption = "Buildings by State", subCaption = "this is the subcaption", xAxisName = "State", yAxisName = "Number of Buildings", //numberSuffix = "K", theme = "ocean" }, data = chartData }; var chartJson = new { type = "column2D", //width = "100%", //height = "100%", dataFormat = "json", dataSource = dataSource }; return(chartJson); }
public async Task <FileRowForUploadDto> AutoRoomDataRow(FileRowForUploadDto fileRow, ManifestFileUploadUserParams userParams) { Room room = null; // Expression<Func<Building, bool>> queryFilter = null; // if (userParams.BuildingId != null) { // queryFilter = b => b.Id == userParams.BuildingId; // } // if (userParams.BuildingTypeId != null) { // Func<Room, int> capacityType = null; // queryFilter = b => b.BuildingCategoryId == userParams.BuildingTypeId; // var buildingType = await _buildingTypeRepo.GetByID (userParams.BuildingTypeId); // if (buildingType.InSurge) { // capacityType = r => r.SurgeCapacity; // } { // capacityType = r => r.Capacity; // } // var building = _buildingRepo.GetFirstOrDefault ( // b => // b.BuildingCategoryId == userParams.BuildingTypeId && // b.Rooms.Select ( // capacityType).Sum () > // b.Rooms.Select ( // r => r.Stays.Count ( // s => s.CheckedOut == false && // s.CheckedIn == true && // !(DateTime.Compare (s.CheckInDate, DateTime.Today) > 0))).Count () && // b.Rooms.Select ( // r => r.Stays.Count ( // s => s.CheckedOut == false && // s.CheckedIn == true && // !(DateTime.Compare (s.CheckInDate, DateTime.Today) > 0) && // !s.Guest.Gender.Equals (rowForUpload.Gender))).Count () == 0, // new Expression<Func<Building, object>>[] { // b => b.Rooms // }, // b => b.OrderBy (x => x.BuildingCategoryId).ThenBy (x => x.Number) // ); // room = building.Result.Rooms.FirstOrDefault ( // r => (r.Stays.Count ( // s => s.CheckedOut == false && // s.CheckedIn == true && // !(DateTime.Compare (s.CheckInDate, DateTime.Today) > 0)) < capacityType.Invoke (r)) && // r.Stays.Count ( // s => s.CheckedOut == false && // s.CheckedIn == true && // !(DateTime.Compare (s.CheckInDate, DateTime.Today) > 0) && // !s.Guest.Gender.Equals (rowForUpload.Gender)) == 0 // ); // } else { foreach (var buildingType in await _buildingTypeRepo.GetAsync()) { Building building; string capacityType; if (buildingType.InSurge) { capacityType = "SurgeCapacity"; } else { capacityType = "Capacity"; } building = (await _buildingRepo.GetBuildings(null, null, b => b.BuildingCategoryId == buildingType.Id && b.Rooms.Where( r => r.Stays.Where( s => s.CheckedOut == false && s.CheckedIn == true && !(DateTime.Compare(s.CheckInDate.Date, DateTime.Today) > 0) ).Count() < ((int)r.GetType().GetProperty(capacityType).GetValue(r))).Count() != 0 && b.Rooms.Where( r => r.Stays.Where( s => s.CheckedOut == false && s.CheckedIn == true && !(DateTime.Compare(s.CheckInDate.Date, DateTime.Today) > 0) && !s.Guest.Gender.Equals(fileRow.Gender)).Count() == 0).Count() != 0, true, b => b.OrderBy(x => x.BuildingCategoryId).ThenBy(x => x.Number))).FirstOrDefault(); if (building == null) { continue; } room = building.Rooms.FirstOrDefault( r => (r.Stays.Where( s => s.CheckedOut == false && s.CheckedIn == true && !(DateTime.Compare(s.CheckInDate.Date, DateTime.Today) > 0) ).Count() < ((int)r.GetType().GetProperty(capacityType).GetValue(r))) && r.Stays.Where( s => s.CheckedOut == false && s.CheckedIn == true && !(DateTime.Compare(s.CheckInDate.Date, DateTime.Today) > 0) && !s.Guest.Gender.Equals(fileRow.Gender)).Count() == 0 ); if (room != null) { break; } } fileRow.RoomId = room.Id; fileRow.BuildingId = room.BuildingId; return(fileRow); }
public async Task <IActionResult> GetBuildings() { return(Ok(await _buildingRepository.GetBuildings())); }
public IEnumerable <Building> GetBuildings() { return(buildingRepository.GetBuildings()); }
public ActionResult <IEnumerable <Building> > Get() { return(Ok(_buildingRepository.GetBuildings())); }
public IActionResult Index() { var buildings = _buildingRepository.GetBuildings(); return(View(buildings)); }