public string CreateUser(UserDTO user)
{
db.Database.Log = x => Debug.WriteLine(x);
var usr = mapper.Map <UserDTO>(db.Users.FirstOrDefault(m => m.email == user.email));
var usr1 = mapper.Map <UserDTO>(db.Users.FirstOrDefault(m => m.adhaarNumber == user.adhaarNumber));
if (usr == null && usr1 == null)
{
try
{
db.Database.Log = x => Debug.WriteLine(x);
db.Users.Add(mapper.Map <User>(user));
db.SaveChanges();
}
catch (Exception e)
{
Console.Write(e.Message);
}
return("User Added");
}
else if (usr == null && usr1 != null)
{
return("Adhaar");
}
else if (usr != null && usr1 == null)
{
return("Email");
}
else
{
return("AdhaarEmail");
}
}
public bool Create(Person person)
{
using (CensusDataContext context = new CensusDataContext())
{
try
{
var result = (from h in context.House
where h.HouseId == person.CensusHouseNumber
select h).Single();
if (result == null)
{
throw new Exception();
}
context.Persons.Add(person);
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
}
//public bool UpdateMember(Member member)
// {
// try
// {
// using (CensusDataContext context = new CensusDataContext())
// {
// context.Entry(member).State = EntityState.Modified;
// context.SaveChanges();
// return true;
// }
// }
// catch
// {
// return false;
// }
// }
public bool DeleteById(int id)
{
try
{
using (CensusDataContext context = new CensusDataContext())
{
var memberEntry = (from m in context.Members
where m.MemberId == id
select m).ToList().First();
var requestStatusEntry = (from r in context.MemberRequestStatus
where r.MemberId == id
select r).ToList().First();
context.Members.Remove(memberEntry);
context.MemberRequestStatus.Remove(requestStatusEntry);
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool Update(int id, RequestStatus status)
{
try
{
using (CensusDataContext context = new CensusDataContext())
{
MemberRequestStatus requestStatus = GetById(id);
if (requestStatus != null)
{
context.MemberRequestStatus.Attach(requestStatus);
requestStatus.Status = status;
context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
}
public int PostHouse(HouseDTO house)
{
House newHouse = mapper.Map <House>(house);
db.Houses.Add(newHouse);
db.SaveChanges();
return(newHouse.id);
}
public bool Create(Member member)
{
using (CensusDataContext context = new CensusDataContext())
{
try
{
context.Members.Add(member);
context.SaveChanges();
if (new MemberRequestStatusRepository().Create(member.MemberId))
{
return(true);
}
context.Members.Remove(member);
context.SaveChanges();
return(false);
}
catch
{
return(false);
}
}
}
public House Create(House house)
{
using (CensusDataContext context = new CensusDataContext())
{
try
{
context.House.Add(house);
context.SaveChanges();
return(house);
}
catch
{
return(null);
}
}
}
public bool Create(int id)
{
using (CensusDataContext context = new CensusDataContext())
{
try
{
MemberRequestStatus requestStatus = new MemberRequestStatus();
requestStatus.MemberId = id;
requestStatus.Status = RequestStatus.PENDING;
context.MemberRequestStatus.Add(requestStatus);
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
//public bool UpdateMember(Member member)
// {
// try
// {
// using (CensusDataContext context = new CensusDataContext())
// {
// context.Entry(member).State = EntityState.Modified;
// context.SaveChanges();
// return true;
// }
// }
// catch
// {
// return false;
// }
// }
public bool DeleteById(int id)
{
try
{
using (CensusDataContext context = new CensusDataContext())
{
var result = (from m in context.House
where m.HouseId == id
select m).ToList().First();
context.House.Remove(result);
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public void PostPopulation(PopulationDTO ppl)
{
db.Population.Add(mapper.Map <Population>(ppl));
db.SaveChanges();
}
