private LocationsInDistrict GetLocationInDistrictByName(int districtId, string location) { LocationsInDistrict getDistrictLocation = TipezeNyumbaUnitOfWork.Repository <LocationsInDistrict>() .Get(u => u.districtID == districtId && u.location.ToLower() == location.ToLower()); return(getDistrictLocation); }
public bool UpdateHouseDetails(int id, HouseModel houseDetails) { District checkDistrictHouseIsLocated = GetDistrictByName(houseDetails.districtHouseIsLocated); if (checkDistrictHouseIsLocated == null) { return(false); } LocationsInDistrict checkLocationInDistrict = GetLocationInDistrictByName(checkDistrictHouseIsLocated.districtID, houseDetails.districtHouseIsLocated); if (checkLocationInDistrict == null) { return(false); } HouseState checkHouseState = GetHouseStatesByName(houseDetails.houseState); if (checkHouseState == null) { return(false); } FenceType checkFenceType = GetFenceTypeByName(houseDetails.fenceType); if (checkFenceType == null) { return(false); } House houseToUpdate = TipezeNyumbaUnitOfWork.Repository <House>().Get(u => u.houseID == id); if (houseToUpdate == null) { return(false); } houseToUpdate.districtHouseIsLocated = checkDistrictHouseIsLocated.districtID; houseToUpdate.locationWithInDistrict = checkLocationInDistrict.districtLocationID; houseToUpdate.bedrooms = houseDetails.bedrooms; houseToUpdate.masterBedroomEnsuite = houseDetails.masterBedroomEnsuite; houseToUpdate.selfContained = houseDetails.selfContained; houseToUpdate.numberOfGarages = houseDetails.numberOfGarages; houseToUpdate.fenceType = checkFenceType.fenceTypeID; houseToUpdate.dateHouseWillBeAvailable = Convert.ToDateTime(houseDetails.dateHouseWillBeAvailable); houseToUpdate.price = houseDetails.price; houseToUpdate.modeOfPayment = Convert.ToInt32(houseDetails.modeOfPayment); houseToUpdate.dateUploaded = Convert.ToDateTime(houseDetails.dateUploaded); houseToUpdate.description = houseDetails.description; houseToUpdate.currentHouseState = checkHouseState.houseStateID; houseToUpdate.HouseContactDetail.phoneNumber1 = houseDetails.phoneNumber1; houseToUpdate.HouseContactDetail.phoneNumber2 = houseDetails.phoneNumber2; houseToUpdate.HouseContactDetail.whatsAppContactNumber = houseDetails.whatsAppContactNumber; houseToUpdate.HouseContactDetail.email = houseDetails.email; TipezeNyumbaUnitOfWork.Repository <House>().Attach(houseToUpdate); TipezeNyumbaUnitOfWork.SaveChanges(); return(true); }
public bool AddHouse(HouseModel newHouseModel) { District checkDistrictHouseIsLocated = GetDistrictByName(newHouseModel.districtHouseIsLocated); if (checkDistrictHouseIsLocated == null) { return(false); } LocationsInDistrict checkLocationInDistrict = GetLocationInDistrictByName(checkDistrictHouseIsLocated.districtID, newHouseModel.locationInDistrict); if (checkLocationInDistrict == null) { return(false); } HouseState checkHouseState = GetHouseStatesByName(newHouseModel.houseState); if (checkHouseState == null) { return(false); } FenceType checkFenceType = GetFenceTypeByName(newHouseModel.fenceType); if (checkFenceType == null) { return(false); } int activatedState = _fieldStateManagement.GetActivatedState().fieldStateID; House newHouse = new House() { districtHouseIsLocated = checkDistrictHouseIsLocated.districtID, locationWithInDistrict = checkLocationInDistrict.districtLocationID, bedrooms = newHouseModel.bedrooms, masterBedroomEnsuite = newHouseModel.masterBedroomEnsuite, selfContained = newHouseModel.selfContained, numberOfGarages = newHouseModel.numberOfGarages, fenceType = checkFenceType.fenceTypeID, dateHouseWillBeAvailable = Convert.ToDateTime(newHouseModel.dateHouseWillBeAvailable), price = newHouseModel.price, modeOfPayment = Convert.ToInt32(newHouseModel.modeOfPayment), dateUploaded = DateTime.Now, description = newHouseModel.description, currentHouseState = checkHouseState.houseStateID, state = activatedState }; HouseContactDetail houseContactDetail = new HouseContactDetail() { houseID = newHouse.houseID, phoneNumber1 = newHouseModel.phoneNumber1, phoneNumber2 = newHouseModel.phoneNumber2, whatsAppContactNumber = newHouseModel.whatsAppContactNumber, email = newHouseModel.email, state = activatedState }; HouseOwner setHouseOwner = new HouseOwner() { userID = newHouseModel.userId, houseID = newHouseModel.houseID, status = activatedState }; TipezeNyumbaUnitOfWork.Repository <House>().Add(newHouse); TipezeNyumbaUnitOfWork.Repository <HouseContactDetail>().Add(houseContactDetail); TipezeNyumbaUnitOfWork.Repository <HouseOwner>().Add(setHouseOwner); TipezeNyumbaUnitOfWork.SaveChanges(); return(true); }