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