public void UpdateLandFacility(LandFacility landFacility)
{
using (var db = new DataContext(_connectionString))
{
db.LandFacilities.Update(landFacility);
db.SaveChanges();
}
}
public int AddLandFacility(LandFacility landFacility)
{
using (var db = new DataContext(_connectionString))
{
db.LandFacilities.Add(landFacility);
db.SaveChanges();
return(landFacility.Id);
}
}
public Facility ConvertDBFacilityToFacility(DwellingFacility dFacility, LandFacility lFacility, NonResidentialFacility nrFacility)
{
return(new Facility()
{
Id = dFacility != null ? dFacility.Id : lFacility != null ? lFacility.Id : nrFacility.Id,
FileReference = dFacility != null ? "D/" + dFacility.Id : lFacility != null ? "L/" + lFacility.Id : "NR/" + nrFacility.Id,
Name = dFacility != null ? dFacility.Name : lFacility != null ? lFacility.Name : nrFacility.Name,
ClientCode = dFacility != null ? dFacility.ClientCode : lFacility != null ? lFacility.ClientCode : nrFacility.ClientCode,
PropType = dFacility != null ? dFacility.PropType : lFacility != null ? lFacility.PropType : nrFacility.PropType,
Parcel = dFacility != null ? dFacility.Parcel : lFacility != null ? lFacility.Parcel : nrFacility.Parcel,
Portion = dFacility != null ? dFacility.Portion : lFacility != null ? lFacility.Portion : nrFacility.Portion,
FarmName = dFacility != null ? dFacility.FarmName : lFacility != null ? lFacility.FarmName : nrFacility.FarmName,
LandLoc = dFacility != null ? dFacility.LandLoc : lFacility != null ? lFacility.LandLoc : nrFacility.LandLoc,
Type = dFacility != null ? dFacility.Type : lFacility != null ? lFacility.Type : nrFacility.Type,
ValuationDate = dFacility != null?dFacility.ValuationDate.ToString() : lFacility != null?lFacility.ValuationDate.ToString() : nrFacility.ValuationDate.ToString(),
SGDiagram = dFacility != null ? dFacility.SGDiagram : lFacility != null ? lFacility.SGDiagram : nrFacility.SGDiagram,
AreaHA = dFacility != null ? dFacility.AreaHA : lFacility != null ? lFacility.AreaHA : nrFacility.AreaHA,
RegOwner = dFacility != null ? dFacility.RegOwner : lFacility != null ? lFacility.RegOwner : nrFacility.RegOwner,
OwnershipCategory = dFacility != null ? dFacility.OwnershipCategory : lFacility != null ? lFacility.OwnershipCategory : nrFacility.OwnershipCategory,
Zoning = dFacility != null ? dFacility.Zoning : lFacility != null ? lFacility.Zoning : nrFacility.Zoning,
RegDivision = dFacility != null ? dFacility.RegDivision : lFacility != null ? lFacility.RegDivision : nrFacility.RegDivision,
UserDept = dFacility != null ? dFacility.UserDept : lFacility != null ? lFacility.UserDept : nrFacility.UserDept,
ConditionRating = dFacility != null ? dFacility.ConditionRating : lFacility != null ? lFacility.ConditionRating : nrFacility.ConditionRating,
IntendUseOfTheProperty = dFacility != null ? dFacility.IntendUseOfTheProperty : lFacility != null ? lFacility.IntendUseOfTheProperty : nrFacility.IntendUseOfTheProperty,
CurrentUse = dFacility != null ? dFacility.CurrentUse : lFacility != null ? lFacility.CurrentUse : nrFacility.CurrentUse,
FacilityType = dFacility != null ? "Dwelling" : lFacility != null ? "Land" : "NonResidential",
MapCoordinate = new MapCoordinate()
{
Longitude = dFacility != null?dFacility.GPSCoordinatesEast.Replace(",", ".") : lFacility != null?lFacility.GPSCoordinatesEast.Replace(",", ".") : nrFacility.GPSCoordinatesEast.Replace(",", "."),
Latitude = dFacility != null?dFacility.GPSCoordinatesSouth.Replace(",", ".") : lFacility != null?lFacility.GPSCoordinatesSouth.Replace(",", ".") : nrFacility.GPSCoordinatesSouth.Replace(",", "."),
},
VestingInformation = dFacility != null ? dFacility.VestingInformation : lFacility != null ? lFacility.VestingInformation : nrFacility.VestingInformation,
Comments = dFacility != null ? dFacility.Comments : lFacility != null ? lFacility.Comments : nrFacility.Comments,
UserId = dFacility != null ? dFacility.UserId : lFacility != null ? lFacility.UserId : nrFacility.UserId,
Status = dFacility != null ? ((FacilityStatus)dFacility.Status).AsString(EnumFormat.Description) : lFacility != null ? ((FacilityStatus)lFacility.Status).AsString(EnumFormat.Description) : ((FacilityStatus)nrFacility.Status).AsString(EnumFormat.Description),
CreatedBy = dFacility != null ? dFacility.CreatedBy : lFacility != null ? lFacility.CreatedBy : nrFacility.CreatedBy,
CreatedDate = dFacility != null ? dFacility.CreatedDate : lFacility != null ? lFacility.CreatedDate : nrFacility.CreatedDate,
ModifiedBy = dFacility != null ? dFacility.ModifiedBy : lFacility != null ? lFacility.ModifiedBy : nrFacility.ModifiedBy,
ModifiedDate = dFacility != null ? dFacility.ModifiedDate : lFacility != null ? lFacility.ModifiedDate : nrFacility.ModifiedDate,
});
}
