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