/// <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);
}
}
