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 <PolicyDTO> UpdatePolicy(PolicyDTO updatePolicy)
{
var context1 = new EnsuranceDBEntities();
using (var context = new EnsuranceDBEntities())
{
var policy = context.Policies
.Where(p => (p.Id == updatePolicy.Id))
.FirstOrDefault();
if (policy != null)
{
policy.Name = updatePolicy.Name;
policy.Description = updatePolicy.Description;
policy.CoverageType = updatePolicy.CoverageType;
policy.CoveragePercentage = updatePolicy.CoveragePercentage;
policy.CoverageTime = updatePolicy.CoverageTime;
policy.Cost = updatePolicy.Cost;
policy.RiskType = updatePolicy.RiskType;
await context.SaveChangesAsync();
}
else
{
throw new Exception("The policy does not exist.");
}
}
return(updatePolicy);
}
public async Task <PolicyDTO> AddPolicy(PolicyDTO newPolicy)
{
Policy policy = null;
using (var context = new EnsuranceDBEntities())
{
var existingPolicy = context.Policies
.Any(p => (p.Name == newPolicy.Name.Trim()));
if (!existingPolicy)
{
policy = new Policy
{
Name = newPolicy.Name,
Description = newPolicy.Description,
CoverageType = newPolicy.CoverageType,
CoveragePercentage = newPolicy.CoveragePercentage,
CoverageTime = newPolicy.CoverageTime,
Cost = newPolicy.Cost,
RiskType = newPolicy.RiskType
};
context.Policies.Add(policy);
await context.SaveChangesAsync();
newPolicy.Id = policy.Id;
}
else
{
throw new Exception("A policy with the same name already exists.");
}
}
return(newPolicy);
}
public PolicyCompleteDTO GetPolicyComplete(int id)
{
PolicyCompleteDTO policy;
using (var context = new EnsuranceDBEntities())
{
policy = context.Policies.AsNoTracking()
.Where(p => p.Id == id)
.Select(p => new PolicyCompleteDTO
{
Id = p.Id,
Name = p.Name,
Description = p.Description,
CoverageType = p.CoverageType,
CoveragePercentage = p.CoveragePercentage,
CoverageTime = p.CoverageTime,
Cost = p.Cost,
RiskType = p.RiskType,
CoverageName = p.Coverage.Name,
RiskName = p.Risk.Name
}).FirstOrDefault();
}
return(policy);
}
public async Task DeletePolicy(int id)
{
using (var context = new EnsuranceDBEntities())
{
var policy = new Policy {
Id = id
};
context.Policies.Attach(policy);
context.Policies.Remove(policy);
await context.SaveChangesAsync();
}
}
public List <PolicyBasicInfoDTO> GetPoliciesBasicInfo()
{
List <PolicyBasicInfoDTO> policiesMin = new List <PolicyBasicInfoDTO>();
using (var context = new EnsuranceDBEntities())
{
policiesMin = context.Policies.AsNoTracking()
.Select(p => new PolicyBasicInfoDTO
{
Id = p.Id,
Name = p.Name
}).ToList();
}
return(policiesMin);
}
public List <RiskDTO> GetRisks()
{
List <RiskDTO> risks = new List <RiskDTO>();
using (var context = new EnsuranceDBEntities())
{
risks = context.Risks.AsNoTracking()
.Select(r => new RiskDTO
{
Id = r.Id,
Name = r.Name
}).ToList();
}
return(risks);
}
public List <CoverageDTO> GetCoverages()
{
List <CoverageDTO> coverages = new List <CoverageDTO>();
using (var context = new EnsuranceDBEntities())
{
coverages = context.Coverages.AsNoTracking()
.Select(c => new CoverageDTO
{
Id = c.Id,
Name = c.Name
}).ToList();
}
return(coverages);
}
public List <ClientBasicInfoDTO> GetClientsBasicInfo()
{
List <ClientBasicInfoDTO> clientsMin = new List <ClientBasicInfoDTO>();
using (var context = new EnsuranceDBEntities())
{
clientsMin = context.Clients.AsNoTracking()
.Select(c => new ClientBasicInfoDTO
{
Id = c.Id,
FirstName = c.FirstName,
LastName = c.LastName
}).ToList <ClientBasicInfoDTO>();
}
return(clientsMin);
}
public RiskDTO GetRisk(int id)
{
RiskDTO risk;
using (var context = new EnsuranceDBEntities())
{
risk = context.Policies.AsNoTracking()
.Where(r => r.Id == id)
.Select(r => new RiskDTO
{
Id = r.Id,
Name = r.Name
}).FirstOrDefault();
}
return(risk);
}
public CoverageDTO GetCoverage(int id)
{
CoverageDTO coverage;
using (var context = new EnsuranceDBEntities())
{
coverage = context.Coverages.AsNoTracking()
.Where(c => c.Id == id)
.Select(c => new CoverageDTO
{
Id = c.Id,
Name = c.Name
}).FirstOrDefault();
}
return(coverage);
}
public ClientBasicInfoDTO GetClientBasicInfo(int id)
{
ClientBasicInfoDTO clientBasicInfo = null;
using (var context = new EnsuranceDBEntities())
{
clientBasicInfo = context.Clients.AsNoTracking()
.Where(c => c.Id == id)
.Select(c => new ClientBasicInfoDTO
{
Id = c.Id,
FirstName = c.FirstName,
LastName = c.LastName
}).FirstOrDefault <ClientBasicInfoDTO>();
}
return(clientBasicInfo);
}
//public Repository(IEnsuranceContext context)
//{
// this.context = context;
//}
#region Authentication
public AuthenticatedUser AuthenticateUser(Authentication login)
{
AuthenticatedUser user = null;
using (var context = new EnsuranceDBEntities())
{
user = context.Users.AsNoTracking()
.Where(u => u.UserName == login.UserName && u.Password == login.Password)
.Select(u => new AuthenticatedUser
{
Id = u.Id,
Name = u.Name,
LastName = u.LastName,
Username = u.UserName,
Token = ""
}).FirstOrDefault <AuthenticatedUser>();
}
return(user);
}
public List <ClientPolicyDTO> GetClientPolicyByClientId(int clientId)
{
List <ClientPolicyDTO> clientPolicyDTO = new List <ClientPolicyDTO>();
using (var context = new EnsuranceDBEntities())
{
clientPolicyDTO = context.ClientPolicies
.Where(cp => cp.ClientId == clientId)
.Select(cp => new ClientPolicyDTO
{
Id = cp.Id,
ClientId = clientId,
PolicyId = cp.PolicyId,
PolicyName = cp.Policy.Name,
StartDate = cp.StartDate
}).ToList <ClientPolicyDTO>();
}
return(clientPolicyDTO);
}
public ClientDTO GetClient(int id)
{
ClientDTO client;
using (var context = new EnsuranceDBEntities())
{
//var client = context.Clients.AsNoTracking()
// .Where(c => c.Id == id).FirstOrDefault();
client = context.Clients.AsNoTracking()
.Select(c => new ClientDTO
{
Id = c.Id,
FirstName = c.FirstName,
LastName = c.LastName,
PolicyIds = c.ClientPolicies.Select(p => p.PolicyId).ToList <int>()
}).FirstOrDefault();
}
return(client);
}
public List <PolicyDTO> GetPolicies()
{
List <PolicyDTO> policies = new List <PolicyDTO>();
using (var context = new EnsuranceDBEntities())
{
policies = context.Policies.AsNoTracking()
.Select(p => new PolicyDTO
{
Id = p.Id,
Name = p.Name,
Description = p.Description,
CoverageType = p.CoverageType,
CoveragePercentage = p.CoveragePercentage,
CoverageTime = p.CoverageTime,
Cost = p.Cost,
RiskType = p.RiskType
}).ToList();
}
return(policies);
}