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