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