public void CreatePolicyInfo
(
Guid id,
string policyNumber,
DateTime coverFrom,
DateTime coverTo,
string policyHolderFirstName, string policyHolderLastName,
string carPlateNumber, string carMake,
decimal totalPremium
)
{
using (var cn = new NpgsqlConnection(cnString))
{
var policyInfo = new PolicyInfo
{
PolicyId = id,
PolicyNumber = policyNumber,
CoverFrom = coverFrom,
CoverTo = coverTo,
PolicyHolder = $"{policyHolderLastName} {policyHolderFirstName}",
Vehicle = $"{carPlateNumber} {carMake}",
TotalPremiumAmount = totalPremium
};
cn.Open();
cn.Execute(
"INSERT INTO public.policy_info_view (policy_id,policy_number,cover_from,cover_to,vehicle,policy_holder,total_premium) " +
"VALUES (@PolicyId,@PolicyNumber,@CoverFrom,@CoverTo,@Vehicle,@PolicyHolder,@TotalPremiumAmount)",
policyInfo);
}
}
public void UpdatePolicyInfo
(
Guid id,
string policyNumber,
DateTime coverFrom,
DateTime coverTo,
string policyHolderFirstName, string policyHolderLastName,
string carPlateNumber, string carMake,
decimal totalPremium
)
{
using (var cn = new NpgsqlConnection(cnString))
{
var policyInfo = new PolicyInfo
{
PolicyId = id,
CoverFrom = coverFrom,
CoverTo = coverTo,
PolicyHolder = $"{policyHolderLastName} {policyHolderFirstName}",
Vehicle = $"{carPlateNumber} {carMake}",
TotalPremiumAmount = totalPremium
};
cn.Open();
cn.Execute(
"UPDATE public.policy_info_view " +
"SET " +
"cover_from = @CoverFrom, " +
"cover_to = @CoverTo, " +
"vehicle = @Vehicle, " +
"policy_holder = @PolicyHolder, " +
"total_premium = @TotalPremiumAmount " +
"WHERE policy_id = @PolicyId ",
policyInfo);
}
}