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