public bool UpdateFacility(Facility facility)
{
bool isUpdated = false;
switch ((int)facility.FacilityTypes)
{
case 1:
using (var dataAccess = new DataAccess.Repositories.DwellingFacilityRepository(appSettings.ConnectionString))
{
facility.Id = dataAccess.AddDwellingFacility(facility.ConvertToDwellingFacility(facility));
break;
}
case 2:
using (var dataAccess = new DataAccess.Repositories.LandFacilityRepository(appSettings.ConnectionString))
{
facility.Id = dataAccess.AddLandFacility(facility.ConvertToLandFacility(facility));
break;
}
case 3:
using (var dataAccess = new DataAccess.Repositories.NonResidentialFacilityRepository(appSettings.ConnectionString))
{
facility.Id = dataAccess.AddNonResidentialFacilities(facility.ConvertToNonResidentialFacility(facility));
break;
}
}
return(isUpdated = true);
}
public bool DeleteFacility(Facility facility)
{
bool isDeleted = false;
facility.Status = "Deleted";
switch (facility.FacilityType)
{
case "Dwelling":
using (var dataAccess = new DataAccess.Repositories.DwellingFacilityRepository(appSettings.ConnectionString))
{
dataAccess.UpdateDwellingFacility(facility.ConvertToDwellingFacility(facility));
break;
}
case "Land":
using (var dataAccess = new DataAccess.Repositories.LandFacilityRepository(appSettings.ConnectionString))
{
dataAccess.UpdateLandFacility(facility.ConvertToLandFacility(facility));
break;
}
case "NonResidential":
using (var dataAccess = new DataAccess.Repositories.NonResidentialFacilityRepository(appSettings.ConnectionString))
{
dataAccess.UpdateNonResidentialFacilities(facility.ConvertToNonResidentialFacility(facility));
break;
}
}
return(isDeleted = true);
}
public Facility getFacilityById(int id, FacilityTypes facilityType)
{
Facility facility = new Facility();
switch ((int)facilityType)
{
case 1:
using (var dataAccess = new DataAccess.Repositories.DwellingFacilityRepository(appSettings.ConnectionString))
{
facility = facility.ConvertDBFacilityToFacility(dataAccess.GetDwellingFacilityById(id), null, null);
break;
}
case 2:
using (var dataAccess = new DataAccess.Repositories.LandFacilityRepository(appSettings.ConnectionString))
{
facility = facility.ConvertDBFacilityToFacility(null, dataAccess.GetLandFacilityById(id), null);
break;
}
case 3:
using (var dataAccess = new DataAccess.Repositories.NonResidentialFacilityRepository(appSettings.ConnectionString))
{
facility = facility.ConvertDBFacilityToFacility(null, null, dataAccess.GetNonResidentialFacilityById(id));
break;
}
}
return(facility);
}
public List <Facility> GetAllFacilities()
{
List <Facility> facilities = new List <Facility>();
Facility facility = new Facility();
using (var dataAccess = new DataAccess.Repositories.DwellingFacilityRepository(appSettings.ConnectionString))
{
var _facilities = facility.ConvertDwellingToFacility(dataAccess.GetDwellingFacilities());
facilities.AddRange(_facilities);
}
using (var dataAccess = new DataAccess.Repositories.LandFacilityRepository(appSettings.ConnectionString))
{
var _facilities = facility.ConvertLandToFacility(dataAccess.GetLandFacilities());
facilities.AddRange(_facilities);
}
using (var dataAccess = new DataAccess.Repositories.NonResidentialFacilityRepository(appSettings.ConnectionString))
{
var _facilities = facility.ConvertNonResidentialToFacility(dataAccess.GetNonResidentialFacilities());
facilities.AddRange(_facilities);
}
return(facilities);
}
public List <FacilityType> GetFacilityZonings()
{
List <FacilityType> facilityTypes = new List <FacilityType>();
using (var dataAccess = new DataAccess.Repositories.DwellingFacilityRepository(appSettings.ConnectionString))
{
FacilityType facilityType = new FacilityType()
{
Name = "Dwellings",
FacilityZonings = new List <FacilityZoning>()
};
var dwellingFacilities = dataAccess.GetDwellingFacilities();
var zonings = dwellingFacilities.Select(d => d.Zoning.ToLower().Trim()).Distinct();
foreach (var zoning in zonings)
{
FacilityZoning facilityZoning = new FacilityZoning()
{
Name = zoning,
SignedOff = dwellingFacilities.Where(d => d.Zoning.ToLower().Trim() == zoning.ToLower().Trim() && d.Status == (int)FacilityStatus.Completed).Count(),
Total = dwellingFacilities.Where(d => d.Zoning.ToLower().Trim() == zoning.ToLower().Trim()).Count(),
};
facilityType.FacilityZonings.Add(facilityZoning);
}
facilityTypes.Add(facilityType);
}
using (var dataAccess = new DataAccess.Repositories.LandFacilityRepository(appSettings.ConnectionString))
{
FacilityType facilityType = new FacilityType()
{
Name = "Land",
FacilityZonings = new List <FacilityZoning>()
};
var landFacilities = dataAccess.GetLandFacilities();
var zonings = landFacilities.Select(d => d.Zoning.ToLower().Trim()).Distinct();
foreach (var zoning in zonings)
{
FacilityZoning facilityZoning = new FacilityZoning()
{
Name = zoning,
SignedOff = landFacilities.Where(d => d.Zoning.ToLower().Trim() == zoning.ToLower().Trim() && d.Status == (int)FacilityStatus.Completed).Count(),
Total = landFacilities.Where(d => d.Zoning.ToLower().Trim() == zoning.ToLower().Trim()).Count()
};
facilityType.FacilityZonings.Add(facilityZoning);
}
facilityTypes.Add(facilityType);
}
using (var dataAccess = new DataAccess.Repositories.NonResidentialFacilityRepository(appSettings.ConnectionString))
{
FacilityType facilityType = new FacilityType()
{
Name = "Non Residential Buildings",
FacilityZonings = new List <FacilityZoning>()
};
var nonResidentialFacilities = dataAccess.GetNonResidentialFacilities();
var zonings = nonResidentialFacilities.Select(d => d.Zoning).Distinct();
foreach (var zoning in zonings)
{
FacilityZoning facilityZoning = new FacilityZoning()
{
Name = zoning,
SignedOff = nonResidentialFacilities.Where(d => d.Zoning.ToLower().Trim() == zoning.ToLower().Trim() && d.Status == (int)FacilityStatus.Completed).Count(),
Total = nonResidentialFacilities.Where(d => d.Zoning.ToLower().Trim() == zoning.ToLower().Trim()).Count()
};
facilityType.FacilityZonings.Add(facilityZoning);
}
facilityTypes.Add(facilityType);
}
return(facilityTypes);
}
public List <MapCoordinate> GetMapCoordinates()
{
List <MapCoordinate> mapCoordinates = new List <MapCoordinate>();
using (var dataAccess = new DataAccess.Repositories.DwellingFacilityRepository(appSettings.ConnectionString))
{
var dwellingFacilities = dataAccess.GetDwellingFacilities();
foreach (var item in dwellingFacilities)
{
if (!string.IsNullOrEmpty(item.GPSCoordinatesEast) && !string.IsNullOrEmpty(item.GPSCoordinatesSouth))
{
MapCoordinate mapCoordinate = new MapCoordinate()
{
Longitude = item.GPSCoordinatesEast.Replace(",", "."),
Latitude = item.GPSCoordinatesSouth.Replace(",", "."),
Description = string.Format("Dwelling: {0} - {1}", item.ClientCode, item.Name),
FacilityId = item.Id,
FacilityType = FacilityTypes.Dwellings
};
mapCoordinates.Add(mapCoordinate);
}
}
}
using (var dataAccess = new DataAccess.Repositories.LandFacilityRepository(appSettings.ConnectionString))
{
var landFacilities = dataAccess.GetLandFacilities();
foreach (var item in landFacilities)
{
if (!string.IsNullOrEmpty(item.GPSCoordinatesEast) && !string.IsNullOrEmpty(item.GPSCoordinatesSouth))
{
MapCoordinate mapCoordinate = new MapCoordinate()
{
Longitude = item.GPSCoordinatesSouth,
Latitude = item.GPSCoordinatesEast,
Description = string.Format("Land: {0} - {1}", item.ClientCode, item.Name),
FacilityId = item.Id,
FacilityType = FacilityTypes.Land
};
mapCoordinates.Add(mapCoordinate);
}
}
}
using (var dataAccess = new DataAccess.Repositories.NonResidentialFacilityRepository(appSettings.ConnectionString))
{
var nonResidentialFacilities = dataAccess.GetNonResidentialFacilities();
foreach (var item in nonResidentialFacilities)
{
if (!string.IsNullOrEmpty(item.GPSCoordinatesEast) && !string.IsNullOrEmpty(item.GPSCoordinatesSouth))
{
MapCoordinate mapCoordinate = new MapCoordinate()
{
Longitude = item.GPSCoordinatesSouth,
Latitude = item.GPSCoordinatesEast,
Description = string.Format("Non Residential: {0} - {1}", item.ClientCode, item.Name),
FacilityId = item.Id,
FacilityType = FacilityTypes.NonResidentialBuildings
};
mapCoordinates.Add(mapCoordinate);
}
}
}
return(mapCoordinates);
}
public List <DashboardWedge> GetDashboardWedges()
{
List <DashboardWedge> list = new List <DashboardWedge>();
List <Facility> facilities = new List <Facility>();
List <string> dashboardWedges = new List <string>();
dashboardWedges.Add("Number of properties");
dashboardWedges.Add("Signed off properties");
dashboardWedges.Add("Non Residential Buildings");
dashboardWedges.Add("Dwellings");
dashboardWedges.Add("Land");
List <DataAccess.Tables.DwellingFacility> dwellingFacilities = new List <DataAccess.Tables.DwellingFacility>();
List <DataAccess.Tables.LandFacility> landFacilities = new List <DataAccess.Tables.LandFacility>();
List <DataAccess.Tables.NonResidentialFacility> nonResidentialFacilities = new List <DataAccess.Tables.NonResidentialFacility>();
using (var dataAccess = new DataAccess.Repositories.DwellingFacilityRepository(appSettings.ConnectionString))
{
dwellingFacilities = dataAccess.GetDwellingFacilities();
}
using (var dataAccess = new DataAccess.Repositories.LandFacilityRepository(appSettings.ConnectionString))
{
landFacilities = dataAccess.GetLandFacilities();
}
using (var dataAccess = new DataAccess.Repositories.NonResidentialFacilityRepository(appSettings.ConnectionString))
{
nonResidentialFacilities = dataAccess.GetNonResidentialFacilities();
}
foreach (var wedge in dashboardWedges)
{
DashboardWedge dashboardWedge = new DashboardWedge();
dashboardWedge.Name = wedge;
if (dashboardWedge.Name == "Number of properties")
{
dashboardWedge.Total = dwellingFacilities.Count();
dashboardWedge.Total = dashboardWedge.Total + landFacilities.Count();
dashboardWedge.Total = dashboardWedge.Total + nonResidentialFacilities.Count();
}
if (dashboardWedge.Name == "Signed off properties")
{
dashboardWedge.Total = dwellingFacilities.Where(d => d.Status == (int)FacilityStatus.Completed).Count();
dashboardWedge.Total = dashboardWedge.Total + landFacilities.Where(d => d.Status == (int)FacilityStatus.Completed).Count();
dashboardWedge.Total = dashboardWedge.Total + nonResidentialFacilities.Where(d => d.Status == (int)FacilityStatus.Completed).Count();
}
if (dashboardWedge.Name == "Non Residential Buildings")
{
dashboardWedge.Total = dwellingFacilities.Count();
}
if (dashboardWedge.Name == "Dwellings")
{
dashboardWedge.Total = landFacilities.Count();
}
if (dashboardWedge.Name == "Land")
{
dashboardWedge.Total = nonResidentialFacilities.Count();
}
list.Add(dashboardWedge);
}
return(list);
}