public async Task<IList<IInquiryCustomer>> GetList()
{
using (var context = new CustomerInquiryContext())
{
return await context.Customers.Include(x => x.Transactions).ToListAsync<IInquiryCustomer>();
}
}
public async Task<IInquiryCustomer> Get(long internalId)
{
using (var context = new CustomerInquiryContext())
{
return await context.Customers.FirstOrDefaultAsync(x => x.Id == internalId);
}
}
public async Task<IInquiryCustomer> GetCustomer(IInquiryCriteria criteria)
{
using (var context = new CustomerInquiryContext())
{
return await context.Customers.Include(x => x.Transactions).FirstOrDefaultAsync(x => x.Id == criteria.CustomerId || x.Email == criteria.Email);
}
}
public async Task <IList <ITransaction> > GetByCustomer()
{
using (var context = new CustomerInquiryContext())
{
return(await context.Transactions.ToListAsync <ITransaction>());
}
}
public async Task <ITransaction> Get(long internalId)
{
using (var context = new CustomerInquiryContext())
{
return(await context.Transactions.FirstOrDefaultAsync(x => x.Id == internalId));
}
}
public async Task<IInquiryCustomer> Save(IInquiryCustomer item)
{
using (var context = new CustomerInquiryContext())
{
context.Customers.AddOrUpdate(item as InquiryCustomer);
context.SaveChanges();
}
return await Get(item.Id);
}
public async void Delete(long internalId)
{
using (var context = new CustomerInquiryContext())
{
var customer = new InquiryCustomer { Id = internalId };
context.Customers.Attach(customer);
context.Customers.Remove(customer);
await context.SaveChangesAsync();
}
}
public async Task <ITransaction> Save(ITransaction item)
{
using (var context = new CustomerInquiryContext())
{
context.Transactions.AddOrUpdate(item as Transaction);
context.SaveChanges();
}
return(await Get(item.Id));
}
public static async Task InitializeAsync(CustomerInquiryContext context)
{
using (context)
{
context.Database.EnsureCreated();
if (!context.Customers.Any())
{
context.Customers.AddRange(InitCustomerData());
await context.SaveChangesAsync();
}
}
}
public async void Delete(long internalId)
{
using (var context = new CustomerInquiryContext())
{
var transaction = new Transaction {
Id = internalId
};
context.Transactions.Attach(transaction);
context.Transactions.Remove(transaction);
await context.SaveChangesAsync();
}
}
public static Customer GetCustomerByIdOrEmail(decimal customerId = 0, string email = "")
{
var customer = default(Customer);
using (var context = new CustomerInquiryContext())
{
if (customerId > 0)
{
customer = context.Customers.Include("Transactions").FirstOrDefault(c => c.Id == customerId);
}
else if (!string.IsNullOrEmpty(email))
{
customer = context.Customers.Include("Transactions").FirstOrDefault(c => c.Email.ToLower() == email.ToLower());
}
}
return(customer);
}
public CustomersRepository(CustomerInquiryContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
