protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// Make the Message visible
pnlForm.Visible = false;
pnlThankYou.Visible = true;
// Add the data in the database
using (RegistrationsContext entities = new RegistrationsContext())
{
try
{
var customer = entities.Customers.Create();
customer.FirstName = txtFirstName.Text;
customer.LastName = txtLastName.Text;
customer.EmailAddress = txtEmail.Text;
if (chkIsMale.Checked)
{
customer.IsMale = true;
}
if (chkIsFemale.Checked)
{
customer.IsFemale = true;
}
customer.Street = txtStreet.Text;
customer.City = txtCity.Text;
customer.State = txtState.Text;
customer.ZipCode = txtZipCode.Text;
if (double.TryParse(txtIncome.Text, out var income))
{
customer.Income = income;
}
if (int.TryParse(drpListOfCreditScore.SelectedValue, out var score))
{
customer.CreditScore = score;
}
entities.Customers.Add(customer);
entities.SaveChanges();
lblStatus.Text = "Form Submited. Thank you!";
}
catch (Exception ex)
{
lblStatus.Text = "Error Occured. Error Info: " + ex.Message;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (RegistrationsContext entities = new RegistrationsContext())
{
// Get all the customers as the list
var customers = entities.Customers.ToList();
// Null Check
if (customers.Count != 0)
{
dtList.DataSource = customers;
dtList.DataBind();
}
else
{
lblMessage.Visible = true;
lblMessage.Text = "There are no Customers registred";
}
}
}
