/// <summary> /// Gets the Result of House Listing From DataBase using Id of House /// </summary> /// <param name="id"></param> /// <returns></returns> public HouseListingDTO GetHouseListingByIdDAL(int id) { using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext()) { HouseListingEntity houseListingEntity = db.HouseListingEntity.Find(id); HouseListingDTO houseListingDTO = mapHouseListingEntity2DTO.Map <HouseListingDTO>(houseListingEntity); return(houseListingDTO); } }
/// <summary> /// Add the House Record to DataBase /// </summary> /// <param name="houseListingDTO"></param> /// <returns></returns> public HouseListingDTO AddHouseListingDAL(HouseListingDTO houseListingDTO) { try { using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext()) { HouseListingEntity houseListingEntity = mapHouseListingDTO2Entity.Map <HouseListingEntity>(houseListingDTO); HouseListingEntity createdHouseListingEntity = db.HouseListingEntity.Add(houseListingEntity); db.SaveChanges(); HouseListingDTO createdHouseListingDTO = mapHouseListingEntity2DTO.Map <HouseListingDTO>(createdHouseListingEntity); return(createdHouseListingDTO); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return(null); } }