public void UpdateDwellingFacility(DwellingFacility dwellingFacility) { using (var db = new DataContext(_connectionString)) { db.DwellingFacilities.Update(dwellingFacility); db.SaveChanges(); } }
public int AddDwellingFacility(DwellingFacility dwellingFacility) { using (var db = new DataContext(_connectionString)) { db.DwellingFacilities.Add(dwellingFacility); db.SaveChanges(); return(dwellingFacility.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, }); }