/// <summary>This methods deletes a record in the dbo.Policies table based on it's id
/// <param name="id">The id of the record to be deleted from dbo.Policies table</param>
public void DeletePolicy(int policyNumber)
{
using (InsuranceDBEntities db = new InsuranceDBEntities())
{
db.usp_DeletePolicy(policyNumber);
}
}
public HttpResponseMessage Post([FromBody] Customers entity)
{
try
{
using (var db = new InsuranceDBEntities())
{
var customer = db.Customers.FirstOrDefault(cust => cust.CustomerID == entity.CustomerID);
if (customer == null)
{
db.Customers.Add(entity);
db.SaveChanges();
var response = Request.CreateResponse(HttpStatusCode.Created, entity);
response.Headers.Location = new Uri(Url.Link("GetCustomerByID", new { id = entity.CustomerID }));
return(response);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "The customer name is already exist"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
/// <summary>This methods adds a new policy details to the database
/// <param name="policy">The policy object of class Policy which is to be added to the db</param>
public void AddPolicy(Policy policy)
{
policy.InstallmentPremium = CalculatePremium(policy.PlanNumber, policy.SumAssured, policy.PolicyTerm, policy.PremiumMode);
using (InsuranceDBEntities db = new InsuranceDBEntities())
{
db.usp_InsertPolicy(policy.PlanNumber, policy.InstallmentPremium, policy.InsuredId, policy.SumAssured, policy.PolicyStatus, policy.PremiumMode, policy.PremiumDueDate, policy.BeneficiaryId, policy.OwnerId, policy.PolicyTerm);
}
}
public HttpResponseMessage Update([FromBody] Customers entity)
{
try
{
using (var db = new InsuranceDBEntities())
{
var customer = db.Customers.FirstOrDefault(c => c.CustomerID == entity.CustomerID);
var auto = db.Autos.FirstOrDefault(c => c.AutoID == entity.AutoID);
var address = db.Addresses.FirstOrDefault(c => c.AddressID == entity.AddressID);
var contact = db.Contacts.FirstOrDefault(c => c.ContactID == entity.ContactID);
customer.Autos = auto;
customer.Addresses = address;
customer.Contacts = contact;
if (customer != null)
{
customer.First_Name = entity.First_Name;
customer.Last_Name = entity.Last_Name;
customer.Civility = entity.Civility;
customer.Birthdate = entity.Birthdate;
customer.Sexe = entity.Sexe;
customer.Autos.Year = entity.Autos.Year;
customer.Autos.Marque = entity.Autos.Marque;
customer.Autos.Model = entity.Autos.Model;
customer.Autos.Vehicle_Nbre = entity.Autos.Vehicle_Nbre;
customer.Autos.IsLeqsedOrFinanced = entity.Autos.IsLeqsedOrFinanced;
customer.Autos.Vehicle_Use = entity.Autos.Vehicle_Use;
customer.Autos.KilometersPerYear = entity.Autos.KilometersPerYear;
customer.Autos.Infraction_Nbre = entity.Autos.Infraction_Nbre;
customer.Autos.Accident_Nbre = entity.Autos.Accident_Nbre;
customer.Autos.Claim_Type = entity.Autos.Claim_Type;
customer.Autos.Date_Of_Claim = entity.Autos.Date_Of_Claim;
customer.Autos.Estimation_Per_Month = BusinessAuto.CalculAutoSoumission(entity.Autos);
//Address
customer.Addresses.AddressLine = entity.Addresses.AddressLine;
customer.Addresses.PostalCode = entity.Addresses.PostalCode;
customer.Addresses.City = entity.Addresses.City;
customer.Addresses.Country = entity.Addresses.Country;
//Contact
customer.Contacts.Home_Phone = entity.Contacts.Home_Phone;
customer.Contacts.Mobile_Phone = entity.Contacts.Mobile_Phone;
customer.Contacts.Email_Address = entity.Contacts.Email_Address;
customer.Contacts.Contact_Preferences = entity.Contacts.Contact_Preferences;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "The customer name is already exist"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
/// <summary>This methods retrieves all the rows from the PoliciesType table
public List <PolicyType> GetPolicyTypes()
{
List <PolicyType> policyTypes;
using (InsuranceDBEntities db = new InsuranceDBEntities())
{
policyTypes = db.usp_GetPolicyTypes().ToList();
return(policyTypes);
}
}
public UserAuth AuthenticateUser(string userName, string password)
{
UserAuth user;
using (InsuranceDBEntities db = new InsuranceDBEntities())
{
user = db.USP_USERAUTHENTICATION(userName, password).Select(u => new UserAuth
{
UserName = u.userName,
Role = u.role
}).FirstOrDefault();
}
return(user);
}
public HttpResponseMessage GetCustomers()
{
try
{
using (var db = new InsuranceDBEntities())
{
var response = Request.CreateResponse(HttpStatusCode.OK, db.Customers.ToList());
return(response);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage GetAutoPolicy()
{
try
{
using (var db = new InsuranceDBEntities())
{
var response = Request.CreateResponse(HttpStatusCode.OK,
db.Customers.Where(policy => policy.Type_Of_insurance == "Auto").ToList());
return(response);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
/// <summary>This methods retrieves the participants in a policy based on their type
/// <param name="participantType">The participantType can be either owner or insured or beneficiary
public List <Participant> GetParticipantsByType(string participantType)
{
List <Participant> participants;
using (InsuranceDBEntities db = new InsuranceDBEntities())
{
participants = db.usp_GetParticipantsByType(participantType).Select
(
participant => new Participant
{
ParticipantNo = participant.ParticipantNo,
FullName = participant.FullName
}
).ToList();
}
return(participants);
}
public HttpResponseMessage GetCustomers(int?id)
{
using (var db = new InsuranceDBEntities())
{
var entity = db.Customers.FirstOrDefault(ev => ev.CustomerID == id);
db.Entry(entity).Reference(policy => policy.Autos).Load();
db.Entry(entity).Reference(policy => policy.Addresses).Load();
db.Entry(entity).Reference(policy => policy.Contacts).Load();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "The customer with id = " + id + " is not found"));
}
}
}
/// <summary>This methods searches for a record in the dbo.Policies table based on it's id
/// <param name="id">The id of the record to be searched for in dbo.Policies table</param>
public Policy SearchPolicy(int policyNumber)
{
Policy searchedPolicy;
using (InsuranceDBEntities db = new InsuranceDBEntities())
{
searchedPolicy = db.usp_SearchPolicy(policyNumber).Select(policy => new Policy
{
PlanNumber = policy.PlanNumber,
InstallmentPremium = policy.InstallmentPremium,
InsuredId = policy.Insured,
SumAssured = policy.SumAssured,
PolicyStatus = policy.PolicyStatus,
PremiumMode = policy.PremiumMode,
PremiumDueDate = policy.PremiumDueDate,
BeneficiaryId = policy.Beneficiary,
OwnerId = policy.Owner,
PolicyTerm = policy.PolicyTerm
}).FirstOrDefault();
return(searchedPolicy);
}
}
/// <summary>This methods retrieves all the rows from the db
public List <Policy> GetAllPolicies()
{
List <Policy> policies;
using (InsuranceDBEntities db = new InsuranceDBEntities())
{
policies = db.vw_Policies.Select(policy => new Policy
{
PolicyNumber = policy.PolicyNumber,
PolicyName = policy.PolicyName,
InstallmentPremium = policy.InstallmentPremium,
InsuredName = policy.Insured,
SumAssured = policy.SumAssured,
PolicyStatus = policy.PolicyStatus,
PremiumMode = policy.PremiumMode,
PremiumDueDate = policy.PremiumDueDate,
BeneficiaryName = policy.Beneficiary,
OwnerName = policy.Owner,
PolicyTerm = policy.PolicyTerm
}).ToList();
}
return(policies);
}
public HttpResponseMessage Delete(int?id)
{
using (var db = new InsuranceDBEntities())
{
var customer = db.Customers.FirstOrDefault(c => c.CustomerID == id);
var auto = db.Autos.FirstOrDefault(c => c.AutoID == customer.AutoID);
var address = db.Addresses.FirstOrDefault(c => c.AddressID == customer.AddressID);
var contact = db.Contacts.FirstOrDefault(c => c.ContactID == customer.ContactID);
customer.Autos = auto;
customer.Addresses = address;
customer.Contacts = contact;
if (customer != null)
{
db.Entry(customer).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, customer));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "The customer with id = " + id + " is not found"));
}
}
}
