public async Task <ClientPolicyDTO> AddClientPolicy(ClientPolicyDTO newClientPolicy) { ClientPolicy clientPolicy = null; List <int> idsToRemove = new List <int>(); using (var context = new EnsuranceDBEntities()) { var existingClientPolicy = context.ClientPolicies .Any(cp => cp.ClientId == newClientPolicy.ClientId && cp.PolicyId == newClientPolicy.PolicyId); if (!existingClientPolicy) { clientPolicy = new ClientPolicy { ClientId = newClientPolicy.ClientId, PolicyId = newClientPolicy.PolicyId, StartDate = DateTime.Now }; context.ClientPolicies.Add(clientPolicy); await context.SaveChangesAsync(); } else { throw new Exception("The client already has this policy."); } } return(newClientPolicy); }
public async Task DeleteClientPolicy(int id) { using (var context = new EnsuranceDBEntities()) { var tmpClientPolicy = new ClientPolicy { Id = id }; context.ClientPolicies.Attach(tmpClientPolicy); context.ClientPolicies.Remove(tmpClientPolicy); await context.SaveChangesAsync(); } }