/// <summary>
/// Fetch Data from server to plot graph Age wise
/// </summary>
/// <returns></returns>
public IList <AgeWisePopulationDTO> FetchAgeWisePopulationDAL()
{
using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext())
{
List <PopulationRegistrationEntity> peopleList = db.PopulationRegistrationEntity.ToList();
List <AgeWisePopulationEntity> ageWisePopulation = new List <AgeWisePopulationEntity>();
int currentYear = DateTime.Now.Year;
foreach (PopulationRegistrationEntity person in peopleList)
{
int peopleAge = currentYear - person.DOB.Year;
int index = ageWisePopulation.FindIndex(x => x.Age == peopleAge);
if (index == -1)
{
ageWisePopulation.Add(new AgeWisePopulationEntity()
{
Age = peopleAge,
Count = 1
});
}
else
{
ageWisePopulation[index].Count++;
}
}
return(mapAgeWisePopulationEntity2DTO.Map <IList <AgeWisePopulationDTO> >(ageWisePopulation));
}
}
/// <summary>
/// Fetch Data from server to plot graph StateWise people.
/// </summary>
/// <returns></returns>
public IList <StateWisePopulationDTO> FetchStateWisePopulationDAL()
{
using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext())
{
List <HouseListingEntity> houseList = db.HouseListingEntity.ToList();
List <StateWisePopulationEntity> stateWisepopulation = new List <StateWisePopulationEntity>();
foreach (HouseListingEntity house in houseList)
{
int index = stateWisepopulation.FindIndex(x => x.State.Equals(house.State));
if (index == -1)
{
if (house.NationalPopulationEntities.Count > 0)
{
stateWisepopulation.Add(new StateWisePopulationEntity()
{
State = house.State,
Count = house.NationalPopulationEntities.Count
});
}
}
else
{
stateWisepopulation[index].Count += house.NationalPopulationEntities.Count;
}
}
return(mapStateWisePopulationEntity2DTO.Map <IList <StateWisePopulationDTO> >(stateWisepopulation));
}
}
/// <summary>
/// Validates the User's Email & Password Upon Login
/// </summary>
/// <param name="email"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public UserDTO ValidateUserLoginDAL(string email, string pwd)
{
using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext())
{
UserEntity user = db.UserEntity.Where(e => e.EmailID == email && e.Password == pwd).FirstOrDefault();
UserDTO userDTO = mapUserEntity2DTO.Map <UserDTO>(user);
return(userDTO);
}
}
/// <summary>
/// Get a list of all Users Whose Id is given.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public UserDTO GetUserByIdDAL(int id)
{
using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext())
{
UserEntity user = db.UserEntity.Find(id);
UserDTO userDTO = mapUserEntity2DTO.Map <UserDTO>(user);
return(userDTO);
}
}
/// <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>
/// Get populationDetails from database using ID of person
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public PopulationRegistrationDTO GetPopulationRegistrationByIdDAL(int id)
{
using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext())
{
PopulationRegistrationEntity populationRegistrationEntity = db.PopulationRegistrationEntity.Find(id);
PopulationRegistrationDTO populationRegistrationDTO = mapPopulationRegistrationEntity2DTO.Map <PopulationRegistrationDTO>(populationRegistrationEntity);
return(populationRegistrationDTO);
}
}
/// <summary>
/// Get a list of all Users Whose Requests are Approved.
/// </summary>
/// <returns></returns>
public IList <UserDTO> GetApprovedUsersDAL()
{
try
{
using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext())
{
IList <UserEntity> approvedUsers = db.UserEntity.Where(d => d.IsApproved == ApprovalStatus.Approved).ToList();
IList <UserDTO> users = mapUserEntity2DTO.Map <IList <UserDTO> >(approvedUsers);
return(users);
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e);
return(null);
}
}
/// <summary>
/// Validates the User's Email & Aadhar Upon SignUp
/// </summary>
/// <param name="email"></param>
/// <param name="aadhar"></param>
/// <returns></returns>
public UserDTO ValidateUserSignUpDAL(string email, string aadhar)
{
using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext())
{
UserEntity user = new UserEntity();
if (db.UserEntity.Where(e => e.EmailID == email).FirstOrDefault() != null)
{
user.EmailID = email;
}
if (db.UserEntity.Where(e => e.AadharNo == aadhar).FirstOrDefault() != null)
{
user.AadharNo = aadhar;
}
UserDTO userDTO = mapUserEntity2DTO.Map <UserDTO>(user);
return(userDTO);
}
}
/// <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);
}
}
/// <summary>
/// Add a new User to DataBase
/// </summary>
/// <param name="userDTO"></param>
/// <returns></returns>
public UserDTO AddUserDAL(UserDTO userDTO)
{
try
{
using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext())
{
UserEntity userEntity;
userEntity = mapUserDTO2Entity.Map <UserEntity>(userDTO);
UserEntity createdUserEntity = db.UserEntity.Add(userEntity);
db.SaveChanges();
UserDTO createdUserDTO = mapUserEntity2DTO.Map <UserDTO>(createdUserEntity);
return(createdUserDTO);
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e);
return(null);
}
}
/// <summary>
/// Add Population Details to DataBase.
/// </summary>
/// <param name="populationRegistrationDTO"></param>
/// <returns></returns>
public PopulationRegistrationDTO AddPopulationDAL(PopulationRegistrationDTO populationRegistrationDTO)
{
try
{
using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext())
{
PopulationRegistrationEntity populationEntity;
populationEntity = mapPopulationRegistrationDTO2Entity.Map <PopulationRegistrationEntity>(populationRegistrationDTO);
PopulationRegistrationEntity createdPopulationRegistrationEntity = db.PopulationRegistrationEntity.Add(populationEntity);
db.SaveChanges();
PopulationRegistrationDTO createdUserDTO = mapPopulationRegistrationEntity2DTO.Map <PopulationRegistrationDTO>(createdPopulationRegistrationEntity);
return(createdUserDTO);
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e);
return(null);
}
}
/// <summary>
/// Update User's Request Status in Database
/// </summary>
/// <param name="id"></param>
/// <param name="stat"></param>
/// <returns></returns>
public UserDTO UpdateUserDAL(int id, ApprovalStatus stat)
{
using (CensusDataDigitalizationContext db = new CensusDataDigitalizationContext())
{
try
{
UserEntity user = db.UserEntity.Find(id);
user.IsApproved = stat;
//db.UserEntity.Add(user);
db.SaveChanges();
UserDTO userDTO = mapUserEntity2DTO.Map <UserDTO>(user);
return(userDTO);
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e);
return(null);
}
}
}
