public async Task <Customer> CreateOrUpdateAsync(Customer customer) { Customer record = null; using (var db = new CustomerEntities()) { if (customer.Id != 0) { record = db.Customers.SingleOrDefault(c => c.Id == customer.Id); if (record != null) { record.FirstName = customer.FirstName; record.LastName = customer.LastName; record.PhoneNumber = customer.PhoneNumber; record.Email = customer.Email; await db.SaveChangesAsync(); } } else { record = db.Customers.Create(); record.FirstName = customer.FirstName; record.LastName = customer.LastName; record.Email = customer.Email; record.PhoneNumber = customer.PhoneNumber; db.Customers.Add(record); await db.SaveChangesAsync(); } return(record); } }
private async Task <bool> Save(File file) { db.Files.Add(file); await db.SaveChangesAsync(); return(true); }
public async Task <bool> DeleteAsync(int id) { bool isDeleted = false; using (var db = new CustomerEntities()) { var customer = db.Customers.SingleOrDefault(c => c.Id == id); if (customer != null) { db.Entry(customer).State = EntityState.Deleted; await db.SaveChangesAsync(); isDeleted = true; } } return(isDeleted); }