private void BtnReject_Click(object sender, RoutedEventArgs e)
{
MessageBox.Show("Records Rejected");
Endorsement end = sq.Endorsements.Where(x => x.Policynumber == txtPolicyNumber.Text).OrderByDescending(x => x.TransactionId).First();
end.EndorsementStatus = "Changes Rejected";
sq.SaveChanges();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Endorsement end = new Endorsement();
try
{
DateTime dt = Convert.ToDateTime(txtDob.Text);
Customer customer = sq.Customers.Where(x => x.Dob == dt).Select(x => x).FirstOrDefault();
end.CustId = customer.CustId;
end.Policynumber = txtPolicyNumber.Text;
InsuranceProduct product = sq.InsuranceProducts.Where(x => x.Products == txtProductName.Text).Select(x => x).FirstOrDefault();
end.ProductId = product.ProductId;
end.InsuredName = txtInsuredName.Text;
end.InsuredAge = Convert.ToInt32(txtAge.Text);
end.Dob = Convert.ToDateTime(txtDob.Text);
end.Nominee = txtNominee.Text;
end.Relation = txtRelation.Text;
end.Address = txtAddress.Text;
end.Telephone = txtTelephone.Text;
end.PremiumPaymentFrequency = txtPaymentFrequency.Text;
if (btnMale.IsChecked == true)
{
end.Gender = "Male";
}
else
{
end.Gender = "Female";
}
if (btnSmoker.IsChecked == true)
{
end.Smoker = "Smoker";
}
else
{
end.Smoker = "NonSmoker";
}
sq.Endorsements.Add(end);
sq.SaveChanges();
}
catch (Exception)
{
throw;
}
MessageBox.Show("Request Sent");
}
private void BtnAccept_Click(object sender, RoutedEventArgs e)
{
try
{
Policy p1 = sq.Policys.Single(x => x.PolicyNumber == txtPolicyNumber.Text);
Policy p2 = sq1.Policys.Single(x => x.PolicyNumber == txtPolicyNumber.Text);
p2.InsuredName = txtInsuredName.Text;
p2.InsuredAge = Convert.ToInt32(txtAge.Text);
p2.Nominee = txtNominee.Text;
p2.Relation = txtRelation.Text;
p2.PremiumPaymentFrequency = txtPaymentFrequency.Text;
sq1.SaveChanges();
Customer c1 = sq.Customers.Single(x => x.CustId == p1.Customerno);
c1.Dob = Convert.ToDateTime(txtDob.Text);
if (btnMale.IsChecked == true)
{
c1.Gender = "Male";
}
else
{
c1.Gender = "Female";
}
c1.Address = txtAddress.Text;
c1.Telephone = txtTelephone.Text;
if (btnSmoker.IsChecked == true)
{
c1.Smoker = "Smoker";
}
else
{
c1.Smoker = "NonSmoker";
}
MessageBox.Show("Records Accepted");
sq.SaveChanges();
Endorsement end = sq.Endorsements.Where(x => x.Policynumber == txtPolicyNumber.Text).OrderByDescending(x => x.TransactionId).First();
end.EndorsementStatus = "Changes Accepted";
sq.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}