public ActionResult ShowPolicies()
{
InsuranceDBContext db = new InsuranceDBContext();
db.USP_ShowPolicies();
return(View());
}
public ActionResult DeleteParticipants(int participantno)
{
InsuranceDBContext db = new InsuranceDBContext();
db.USP_DeleteParticipants(participantno);
db.SaveChanges();
return(View());
}
public ActionResult UpdateParticipants(Participant participant)
{
InsuranceDBContext db = new InsuranceDBContext();
db.USP_UpdateParticipants(participant.ParticipantNo, participant.FirtsName, participant.LastName, participant.MiddleName, participant.DOB, participant.ParticipantTypeNo);
db.SaveChanges();
return(View());
}
public ActionResult DeletePolicy(int policyno)
{
InsuranceDBContext db = new InsuranceDBContext();
db.USP_DeletePolicies(policyno);
db.SaveChanges();
return(View());
}
public ActionResult UpdatePolicy(Policy policy)
{
InsuranceDBContext db = new InsuranceDBContext();
db.USP_UpdatePolicies(policy.PlanNumber, policy.InstallmentPremium, policy.Insured, policy.SumAssured, policy.PolicyStatus, policy.PremiumMode, policy.PremiumDueDate, policy.Beneficiary, policy.Owner, policy.PolicyTerm);
db.SaveChanges();
return(View());
}
public GenericRepository(InsuranceDBContext context)
{
this._DbContext = context;
this._DbSet = this._DbContext.Set <T>();
}
public DataRepository(InsuranceDBContext insuranceDBContext)
{
_insuranceDBContext = insuranceDBContext;
}
public PolicyRepository(InsuranceDBContext context)
{
_context = context;
}
public CustomerRepository(InsuranceDBContext context)
{
_context = context;
}
public PolicyRepository(InsuranceDBContext context) : base(context)
{
this._DbContext = context;
}
public UnitOfWork(InsuranceDBContext context)
{
this._DbContext = context;
this.PolicyRepository = new PolicyRepository(this._DbContext);
}
