public async void Delete(int id) { using (var entities = new TradingCompanyEntities()) { var data = entities.Set <tbl>().FindAsync(id).Result; if (data == null) { throw new NullReferenceException(nameof(tbl)); } entities.Entry(data).State = EntityState.Deleted; entities.Set <tbl>().Remove(data);// _mapper.Map<tbl>(entity)); await entities.SaveChangesAsync(); } }
public async void Add(dto entity) { using (var entities = new TradingCompanyEntities()) { entities.Set <tbl>().Add(_mapper.Map <tbl>(entity)); await entities.SaveChangesAsync(); } }
public dto GetById(int id) { var entity = new dto(); using (var entities = new TradingCompanyEntities()) { entity = _mapper.Map <dto>(entities.Set <tbl>().FindAsync(id).Result); if (Includes != null) { DbQuery <tbl> query = entities.Set <tbl>(); Includes.ForEach(x => query = query.Include(x)); } } if (entity == null) { throw new NullReferenceException(nameof(dto)); } return(entity); }
public List <dto> Get() { var data = new List <dto>(); using (var entities = new TradingCompanyEntities()) { data = _mapper.Map <List <dto> >(entities.Set <tbl>().ToList()); if (Includes != null) { DbQuery <tbl> query = entities.Set <tbl>(); Includes.ForEach(x => query = query.Include(x)); } } if (data == null) { throw new NullReferenceException(nameof(dto)); } return(data); }
public List <AddressDTO> GetByCountry(string country) { var entity = new List <AddressDTO>(); using (var entities = new TradingCompanyEntities()) { entity = _mapper.Map <List <AddressDTO> >(entities.Set <tblAddress>().Where(adr => adr.Country.ToLower() == country.ToLower()).ToList()); } if (entity.Count == 0) { throw new NullReferenceException(nameof(AddressDTO)); } return(entity); }
public List <AddressDTO> GetByUserId(int id) { var entity = new List <AddressDTO>(); using (var entities = new TradingCompanyEntities()) { entity = _mapper.Map <List <AddressDTO> >(entities.Set <tblAddress>().Where(adr => adr.UserId == id).ToList()); } if (entity == null) { throw new NullReferenceException(nameof(AddressDTO)); } return(entity); }
public async void Update(dto entity, int entityId) { using (var entities = new TradingCompanyEntities()) { var data = entities.Set <tbl>().FindAsync(entityId).Result; if (data == null) { throw new NullReferenceException(nameof(dto)); } var jpa = _mapper.Map <tbl>(entity); entities.Entry(data).CurrentValues.SetValues(jpa); entities.Entry(data).State = EntityState.Detached; entities.Entry(data).State = EntityState.Modified; await entities.SaveChangesAsync(); } }
public List <UserDTO> GetByCountry(string country) { var entity = new List <UserDTO>(); using (var entities = new TradingCompanyEntities()) { entity = _mapper.Map <List <UserDTO> >(entities.tblUsers.Where(user => user.tblAddresses.Any(x => x.Country == country)).FirstOrDefaultAsync().Result); if (Includes != null) { DbQuery <tblUser> query = entities.Set <tblUser>(); Includes.ForEach(x => query = query.Include(x)); } } if (entity == null) { throw new NullReferenceException(nameof(List <UserDTO>)); } return(entity); }
public UserDTO GetByNumber(string number) { var entity = new UserDTO(); using (var entities = new TradingCompanyEntities()) { entity = _mapper.Map <UserDTO>(entities.tblUsers.Where(user => user.PhoneNumber == number).FirstOrDefaultAsync().Result); if (Includes != null) { DbQuery <tblUser> query = entities.Set <tblUser>(); Includes.ForEach(x => query = query.Include(x)); } } if (entity == null) { throw new NullReferenceException(nameof(UserDTO)); } return(entity); }