public async Task <bool> Delete(Customer_CustomerGrouping Customer_CustomerGrouping)
{
Customer_CustomerGroupingDAO Customer_CustomerGroupingDAO = await DataContext.Customer_CustomerGrouping.Where(x => x.CustomerId == Customer_CustomerGrouping.CustomerId && x.CustomerGroupingId == Customer_CustomerGrouping.CustomerGroupingId).FirstOrDefaultAsync();
DataContext.Customer_CustomerGrouping.Remove(Customer_CustomerGroupingDAO);
await DataContext.SaveChangesAsync();
return(true);
}
public async Task <bool> Update(Customer_CustomerGrouping Customer_CustomerGrouping)
{
Customer_CustomerGroupingDAO Customer_CustomerGroupingDAO = DataContext.Customer_CustomerGrouping.Where(x => x.CustomerId == Customer_CustomerGrouping.CustomerId && x.CustomerGroupingId == Customer_CustomerGrouping.CustomerGroupingId).FirstOrDefault();
Customer_CustomerGroupingDAO.CustomerId = Customer_CustomerGrouping.CustomerId;
Customer_CustomerGroupingDAO.CustomerGroupingId = Customer_CustomerGrouping.CustomerGroupingId;
await DataContext.SaveChangesAsync();
return(true);
}
public async Task <bool> Create(Customer_CustomerGrouping Customer_CustomerGrouping)
{
Customer_CustomerGroupingDAO Customer_CustomerGroupingDAO = new Customer_CustomerGroupingDAO();
Customer_CustomerGroupingDAO.CustomerId = Customer_CustomerGrouping.CustomerId;
Customer_CustomerGroupingDAO.CustomerGroupingId = Customer_CustomerGrouping.CustomerGroupingId;
await DataContext.Customer_CustomerGrouping.AddAsync(Customer_CustomerGroupingDAO);
await DataContext.SaveChangesAsync();
return(true);
}
public async Task <Customer_CustomerGrouping> Get(long CustomerId, long CustomerGroupingId)
{
Customer_CustomerGrouping Customer_CustomerGrouping = await DataContext.Customer_CustomerGrouping.Where(x => x.CustomerId == CustomerId && x.CustomerGroupingId == CustomerGroupingId).Select(Customer_CustomerGroupingDAO => new Customer_CustomerGrouping()
{
CustomerId = Customer_CustomerGroupingDAO.CustomerId,
CustomerGroupingId = Customer_CustomerGroupingDAO.CustomerGroupingId,
Customer = Customer_CustomerGroupingDAO.Customer == null ? null : new Customer
{
Id = Customer_CustomerGroupingDAO.Customer.Id,
Username = Customer_CustomerGroupingDAO.Customer.Username,
DisplayName = Customer_CustomerGroupingDAO.Customer.DisplayName,
PhoneNumber = Customer_CustomerGroupingDAO.Customer.PhoneNumber,
Email = Customer_CustomerGroupingDAO.Customer.Email,
},
CustomerGrouping = Customer_CustomerGroupingDAO.CustomerGrouping == null ? null : new CustomerGrouping
{
Id = Customer_CustomerGroupingDAO.CustomerGrouping.Id,
Name = Customer_CustomerGroupingDAO.CustomerGrouping.Name,
},
}).FirstOrDefaultAsync();
return(Customer_CustomerGrouping);
}
