public FloorViewModel DeactivateFloor(int floorId)
{
var dbFloor = GetFloorById(floorId);
if (dbFloor != null)
{
// deactivate floor
var deactivatedFloor = dbFloor;
deactivatedFloor.IsActive = false;
appDb.Entry(dbFloor).CurrentValues.SetValues(deactivatedFloor);
// when floor is deactivated - rooms on that floor are deactivated too
var numRooms = GetAllRooms(floorId);
foreach (var room in numRooms)
{
// if room is reserved you can deactivate that room
if (room.IsReserved == true)
{
continue;
}
else
{
var chRoom = room;
chRoom.IsActive = false;
appDb.Entry(room).CurrentValues.SetValues(chRoom);
}
}
appDb.SaveChanges();
FloorViewModel f = GetFloor(dbFloor);
return(f);
}
return(null);
}
// GET: Indoor
#region Events
public ActionResult IndoorStep2(int floorID, string Name)
{
//1)Get Floor record by Floor ID
FloorViewModel floor = _FLOORBAL.GetFloorByID(floorID);
List <APViewModel> aps = _APBAL.GetAPByFloorID(floorID);
ViewBag.BuildName = Name;
if (!string.IsNullOrEmpty(floor.FloorPlanSHPPath))
{
ViewBag.FileName = string.Concat("..", Url.Content(floor.FloorPlanSHPPath));
// will be used in Indoor/ReadJsonFile
ViewBag.FloorPlanSHPPath = floor.FloorPlanSHPPath;
}
else
{
ViewBag.FileName = "";
}
IndoorStep2ViewModel model = new IndoorStep2ViewModel();
ViewBag.APs = aps;
model.InstallationParameters = new InstallationParametersViewModel();
model.OptionalParameters = new OptionalParametersViewModel();
model.CBSD = new CBSDViewModel();
ViewBag.BuildingID = floor.BuildingID;
return(View(model));
}
public async Task <IHttpActionResult> Create([FromBody] FloorViewModel viewmodel)
{
var model = Mapper.Map <Floor>(viewmodel);
var result = await _floorService.Create(model);
return(Ok(Mapper.Map <FloorViewModel>(result)));
}
private FloorViewModel GetFloor(Floor floor)
{
Floor fl = appDb.Floors.First(x => x.FloorNo == floor.FloorNo && floor.IsActive == floor.IsActive && floor.NumberOfRooms == floor.NumberOfRooms);
FloorViewModel fvm = FloorToViewModel(fl);
return(fvm);
}
private void FloorView_OnLoaded(object sender, RoutedEventArgs e)
{
_floorViewModel = DataContext as FloorViewModel;
if (_floorViewModel == null)
{
throw new Exception("floorViewModel is not loaded in FloorView");
}
if (_floorViewModel.FloorID != 0)
{
if (!string.IsNullOrWhiteSpace(_floorViewModel.Photo))
{
var imagePath = _userAvatorService.GetAvator(_floorViewModel.Photo);
SetFloorPhoto(imagePath);
}
var floorDoors = _floorViewModel.Doors.FindAll(x => x.FloorID == _floorViewModel.FloorID);
if (floorDoors.Any())
{
foreach (var floorDoor in floorDoors)
{
var panel = CreateDoorControl(floorDoor);
MyCanvas.Children.Add(panel);
dropDoors.Add(panel);
}
}
}
}
public List <FloorViewModel> GetDevicesByFloorID()
{
List <FloorViewModel> floorViewModels = new List <FloorViewModel>();
List <Workpoint> workpoints = deviceManager.WorkpointGetAll();
List <Hub> hubs = deviceManager.HubGetAll();
List <Floor> floors = FloorGetAll();
foreach (Floor floor in floors)
{
FloorViewModel floorItems = new FloorViewModel();
floorItems.ID = floor.ID;
floorItems.Name = floor.Name;
floorItems.Filename = floor.Filename;
floorItems.Type = floor.Type;
floorItems.OfficeID = floor.OfficeID;
floorItems.IsActive = floor.IsActive;
floorItems.IsDeleted = floor.IsDeleted;
floorItems.Filename = floor.Filename;
floorItems.OfficeName = OfficeGetByID(floorItems.OfficeID).Name;
floorItems.ListOfWorkpoints = deviceManager.WorkpointGetAll().Where(w => w.FloorID.Equals(floor.ID)).ToList();
floorItems.ListOfHubs = deviceManager.HubGetAll().Where(h => h.FloorID.Equals(floor.ID)).ToList();
floorViewModels.Add(floorItems);
}
return(floorViewModels);
}
public async Task <IActionResult> Edit(int id, FloorViewModel fvm)
{
if (id != fvm.Floor.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
// get old entry
var oldEntry = _context.Floors.Find(fvm.Floor.ID);
var ogImage = oldEntry.FilePath;
// update values
_context.Entry(oldEntry).CurrentValues.SetValues(fvm.Floor);
// store file
try
{
if (fvm.File.Length > 0)
{
if (Path.GetExtension(fvm.File.FileName).ToLower() == ".svg")
{
// get file name
string _FileName = $@"{Guid.NewGuid()}.svg";
string _Path = Path.Combine(_hostingEnvironment.WebRootPath, "Floors", _FileName);
using (var stream = new FileStream(_Path, FileMode.Create))
{
await fvm.File.CopyToAsync(stream);
oldEntry.FilePath = "/Floors/" + _FileName;
}
}
else
{
ViewBag.Message = "Invalid file uploaded. Please select an SVG file.";
oldEntry.FilePath = ogImage;
}
}
else
{
// no file uploaded
oldEntry.FilePath = ogImage;
}
}
catch (Exception e)
{
ViewBag.Message = "Unable to upload file.";
oldEntry.FilePath = ogImage;
}
// commit changes
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
return(View(fvm));
}
public void Add(FloorViewModel model)
{
var entity = new HMS_Floor
{
FloorName = model.FloorName,
Active = true
};
_genericRepository.Add(entity);
}
public FloorController(ApplicationDbContext db, IMapper mapper)
{
_db = db;
_mapper = mapper;
FloorVm = new FloorViewModel()
{
Buildings = _db.Buildings.ToList(),
Floor = new Models.Floor()
};
}
public void Edit(FloorViewModel model)
{
var entity = new HMS_Floor
{
FloorName = model.FloorName,
Active = model.Active,
Id = model.Id
};
_genericRepository.Edit(entity);
}
public Result UpdateFloor(FloorViewModel model)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[12];
aParams[0] = new NpgsqlParameter("Name", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[0].Value = model.FloorName;
aParams[1] = new NpgsqlParameter("Description", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[1].Value = model.Description;
aParams[2] = new NpgsqlParameter("FloorPlanSHPPath", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[2].Value = model.FloorPlanSHPPath;
aParams[3] = new NpgsqlParameter("BuildingID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[3].Value = model.BuildingID;
aParams[4] = new NpgsqlParameter("FloorNo", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[4].Value = model.FloorNo;
aParams[5] = new NpgsqlParameter("FloorPlanOrginalFileName", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[5].Value = model.FloorPlanOrginalFileName;
aParams[6] = new NpgsqlParameter("FloorID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[6].Value = model.FloorID;
aParams[7] = new NpgsqlParameter("Lat", NpgsqlTypes.NpgsqlDbType.Double);
aParams[7].Value = model.Latitude;
aParams[8] = new NpgsqlParameter("Long", NpgsqlTypes.NpgsqlDbType.Double);
aParams[8].Value = model.Longitude;
aParams[9] = new NpgsqlParameter(AppConstants.LastModifiedOn, NpgsqlTypes.NpgsqlDbType.Timestamp);
aParams[9].Value = DateTime.Now;
aParams[10] = new NpgsqlParameter(AppConstants.LastModifiedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[10].Value = 0;
aParams[11] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[11].Value = true;
int res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateFloor, aParams);
if (res > 0)
{
result.Status = Status.Success;
}
else
{
result.Status = Status.Failure;
}
}
catch (Exception Ex)
{
dbOps.Abort();
result.Status = Status.Failure;
}
return(result);
}
public JavaScriptResult Create(FloorViewModel rackvm)
{
try
{
_floorService.Add(Mapper.Map <Floor>(rackvm));
return(JavaScript($"ShowResult('{"Data saved successfully."}','{"success"}','{"redirect"}','{"/APanel/Floor"}')"));
}
catch (Exception ex)
{
return(JavaScript($"ShowResult('{ex.Message}','failure')"));
}
}
public FloorViewModel Get(int id)
{
var model = _genericRepository.Get(id);
var viewModel = new FloorViewModel()
{
Id = model.Id,
Active = model.Active,
FloorName = model.FloorName
};
return(viewModel);
}
public JsonResult DeactivateFloor(int FloorId)
{
if (ModelState.IsValid)
{
FloorViewModel f = _adminRepository.DeactivateFloor(FloorId);
if (f != null)
{
return(Json(f, JsonRequestBehavior.AllowGet));
}
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public JsonResult CreateFloor(Floor floor)
{
if (ModelState.IsValid)
{
FloorViewModel f = _adminRepository.CreateFloor(floor);
if (f != null)
{
return(Json(f, JsonRequestBehavior.AllowGet));
}
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
public FloorViewModel UpdateFloor(Floor floor)
{
var dbFloor = GetFloorById(floor.ID);
if (dbFloor != null && dbFloor.NumberOfRooms <= floor.NumberOfRooms)
{
appDb.Entry(dbFloor).CurrentValues.SetValues(floor);
appDb.SaveChanges();
FloorViewModel f = GetFloor(floor);
return(f);
}
return(null);
}
public JsonResult GetFloorsByNumOfFloor(FloorViewModel floor)
{
try
{
UserService service = new UserService();
var floors = service.GetFloorsByNumOfFloor(floor);
return(Json(floors));
}
catch (Exception ex)
{
throw;
}
}
public Result AddFloor(FloorViewModel model)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
NpgsqlParameter[] aParams = new NpgsqlParameter[9];
aParams[0] = new NpgsqlParameter("Name", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[0].Value = model.FloorName;
aParams[1] = new NpgsqlParameter("Description", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[1].Value = model.Description;
aParams[2] = new NpgsqlParameter("FloorPlanSHPPath", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[2].Value = model.FloorPlanSHPPath;
aParams[3] = new NpgsqlParameter("BuildingID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[3].Value = model.BuildingID;
aParams[4] = new NpgsqlParameter("FloorNo", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[4].Value = model.FloorNo;
aParams[5] = new NpgsqlParameter("FloorPlanOrginalFileName", NpgsqlTypes.NpgsqlDbType.Varchar);
aParams[5].Value = model.FloorPlanOrginalFileName;
aParams[6] = new NpgsqlParameter("Lat", NpgsqlTypes.NpgsqlDbType.Double);
aParams[6].Value = model.Latitude;
aParams[7] = new NpgsqlParameter("Long", NpgsqlTypes.NpgsqlDbType.Double);
aParams[7].Value = model.Longitude;
aParams[8] = new NpgsqlParameter(AppConstants.CreatedBy, NpgsqlTypes.NpgsqlDbType.Integer);
aParams[8].Value = 0;
int res = (int)dbOps.ExecuteScalar(AppConstants.QueryConstants.AddFloor, aParams);
if (res > 0)
{
result.Status = Status.Success;
result.Values = res.ToString();
}
else
{
result.Status = Status.Failure;
}
}
catch (Exception Ex)
{
dbOps.Abort();
result.Status = Status.Failure;
}
return(result);
}
public async Task <IActionResult> Create(FloorViewModel fvm)
{
if (ModelState.IsValid)
{
// store file
try
{
if (fvm.File.Length > 0)
{
if (Path.GetExtension(fvm.File.FileName).ToLower() == ".svg")
{
// get file name
string _FileName = $@"{Guid.NewGuid()}.svg";
string _Folder = Path.Combine(_hostingEnvironment.WebRootPath, "Floors");
string _Path = Path.Combine(_Folder, _FileName);
// make folder if needed
if (!Directory.Exists(_Folder))
{
Directory.CreateDirectory(_Folder);
}
using (var stream = new FileStream(_Path, FileMode.Create))
{
await fvm.File.CopyToAsync(stream);
fvm.Floor.FilePath = "/Floors/" + _FileName;
}
}
else
{
ViewBag.Message = "Invalid file uploaded. Please select an SVG file.";
}
}
}
catch (Exception e)
{
ViewBag.Message = "Unable to upload file.";
}
// commit changes
_context.Floors.Add(fvm.Floor);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(fvm));
}
private FloorViewModel FloorToViewModel(Floor fls)
{
FloorViewModel floor = new FloorViewModel();
List <Room> rooms = GetAllRooms().Where(x => x.FloorId == fls.ID).ToList();
floor.ID = fls.ID;
floor.FloorNo = fls.FloorNo;
floor.TotalRooms = fls.NumberOfRooms;
floor.IsActive = fls.IsActive;
floor.Entered = rooms.Count();
floor.ForEnter = fls.NumberOfRooms - rooms.Count();
floor.Free = rooms.Where(c => c.IsReserved == false).Count();
floor.Reserved = rooms.Where(c => c.IsReserved == true).Count();
return(floor);
}
// for floor
public List <FloorViewModel> GetAllFloors()
{
List <Floor> dbFloors = appDb.Floors.OrderBy(x => x.FloorNo).ToList();
List <FloorViewModel> fvms = new List <FloorViewModel>();
FloorViewModel floor = new FloorViewModel();
foreach (var item in dbFloors)
{
floor = FloorToViewModel(item);
fvms.Add(floor);
floor = null;
}
return(fvms);
}
public bool UpdateFloor(FloorViewModel model)
{
try
{
Floor floor = _context.Floor.Where(x => x.FloorId == model.FloorID).First();
floor.FloorName = model.FloorName;
_context.Floor.Update(floor);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool AddFloor(FloorViewModel model)
{
try
{
Floor floor = new Floor();
floor.FloorName = model.FloorName;
_context.Floor.Add(floor);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Edit(FloorViewModel floor)
{
if (ModelState.IsValid)
{
if (_floorManager.CheckDuplicate(floor))
{
ViewBag.DuplicateError = "Floor Already Exists!!";
return(View(floor));
}
else
{
_floorManager.Edit(floor);
return(RedirectToAction("Index"));
}
}
return(View(floor));
}
public List <FloorViewModel> GetFloorsByBuildingID(int _id)
{
DBOperations dbOps = new DBOperations();
List <FloorViewModel> objs = new List <FloorViewModel>();
try
{
//dbOps.ProcName = AppConstants.USP_GETINSTALLATIONPARAMETERSBYID;
NpgsqlParameter[] aParams = new NpgsqlParameter[1];
aParams[0] = new NpgsqlParameter("_id", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = _id;
dbOps.ExecuteReader(AppConstants.USP_GETFLOORSBYBUILDINGID, aParams);
//dbOps.ExecuteReader(_id);
if (!(dbOps.DataReader == null))
{
using (dbOps.DataReader)
{
while (dbOps.DataReader.Read())
{
FloorViewModel obj = new FloorViewModel
{
FloorID = Helper.HandleDBNull <int>(dbOps.DataReader[0]),
FloorName = Helper.HandleDBNull <string>(dbOps.DataReader[1]),
FloorPlanSHPPath = Helper.HandleDBNull <string>(dbOps.DataReader[2]),
FloorNo = Helper.HandleDBNull <int>(dbOps.DataReader[3]),
FloorPlanOrginalFileName = Helper.HandleDBNull <string>(dbOps.DataReader[4]),
Latitude = Helper.HandleDBNull <double>(dbOps.DataReader[5]),
Longitude = Helper.HandleDBNull <double>(dbOps.DataReader[6]),
Description = Helper.HandleDBNull <string>(dbOps.DataReader[7]),
BuildingID = Helper.HandleDBNull <int>(dbOps.DataReader[8])
};
objs.Add(obj);
}
}
}
return(objs);
}
catch (Exception Ex)
{
throw Ex;
}
}
public ActionResult Edit(int id, FloorViewModel model)
{
try
{
bool result = _floorService.UpdateFloor(model);
if (result)
{
return(RedirectToAction(nameof(Index)));
}
throw new Exception();
}
catch
{
ModelState.AddModelError(string.Empty, "Ooops! Something went wrong!");
return(View());
}
}
private void FillFloorsForSection(int flatsPerFloor, int startFlatNumber)
{
const int startFloorNumber = 2;
int sectionStartFlatNumber = startFlatNumber;
Dictionary <int, float> areasDict = sectionType == SectionType.Furniture ? mebelFlatAreas : hospitalFlatAreas;
for (int floorNumber = startFloorNumber; floorNumber <= StaticsProvider.TotalFloorsCount; floorNumber++)
{
var floorModel = new FloorModel
{
FloorNumber = floorNumber, Section = sectionType,
MinFlatNumber = sectionStartFlatNumber + (floorNumber - startFloorNumber) * flatsPerFloor,
};
floorModel.MaxFlatNumber = floorModel.MinFlatNumber + flatsPerFloor - 1;
var floorViewModel = new FloorViewModel(floorModel);
var flats = new List <FlatViewModel>();
for (int flatIndex = 1; flatIndex < flatsPerFloor + 1; flatIndex++)
{
var flatModel = new FlatModel
{
Area = areasDict[flatIndex],
FloorNumber = floorViewModel.FloorNumber,
Number = startFlatNumber,
Section = sectionType
};
var flat = new FlatViewModel(flatModel);
flats.Add(flat);
startFlatNumber++;
}
floorViewModel.PopulateFlats(flats);
var decorator = new FloorDecoratorViewModel(floorViewModel);
allFloors.Add(decorator);
}
allFloors.Reverse();
predicatedFloors.AddRange(allFloors);
}
public FloorViewModel GetFloorDetails(int id)
{
try
{
Floor floor = _context.Floor.Where(x => x.FloorId == id).First();
FloorViewModel model = new FloorViewModel
{
FloorID = floor.FloorId,
FloorName = floor.FloorName
};
return(model);
}
catch (Exception)
{
FloorViewModel emptyModel = new FloorViewModel();
return(emptyModel);
}
}
public ActionResult ManageFloor(int?floorID, int?buildingID, string Name, string operation)
{
FloorViewModel model = null;
if (floorID == null)
{
model = new FloorViewModel();
}
else
{
//get floor plan by ID
model = _FLOORBAL.GetFloorByID(floorID.Value);
}
if (model == null)
{
ViewBag.msg = "No record found";
model = new FloorViewModel();
}
string message = string.Empty;
if (operation != null)
{
if (operation == AppConstants.ADDED)
{
message = "Floor added successfully.";
}
else if (operation == AppConstants.UPDATED)
{
message = "Floor updated successfully.";
}
ViewBag.Message = message;
}
model.Buildings = DropDownBinding.GetDropDown(AppConstants.USP_GETBUILDINGSFORDROPDOWN, 0, "SELECT Building");
ViewBag.BuildingID = buildingID;
return(View(model));
}
private void SelectFloorCanvas(FloorViewModel floorViewModel)
{
MainCanvas.Children.Clear();
_dropDoorDict.Clear();
SetFloorPhoto(floorViewModel.Photo, MainCanvas);
var floorDoors = floorViewModel.Doors.FindAll(x => x.FloorID == floorViewModel.FloorID);
if (floorDoors.Any())
{
foreach (var floorDoor in floorDoors)
{
var panel = CreateDoorControl(floorDoor, MainCanvas);
_dropDoorDict.Add(floorDoor.DoorID, panel);
MainCanvas.Children.Add(panel);
}
}
MainFloorName.Text = floorViewModel.Name;
_selectedFloorViewModel = floorViewModel;
}
