private void BindData()
{
dtCustomers = taCustomers.SelectAllCustomers();
if (dtCustomers.Rows.Count > 0)
{
GridView1.DataSource = dtCustomers;
GridView1.DataBind();
}
else
{
GridView1.Visible = false;
lblMsg.Text = "No record found";
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
dtCustomers = taCustomers.SelectCutomerbyEmail(txtEmail.Text.Trim());
if (dtCustomers.Rows.Count > 0)
{
lblMsg.Text = "User with provided email address already exists";
return;
}
taCustomers.AddCustomer(txtName.Text.Trim(),
txtEmail.Text.Trim(),
txtAddress.Text.Trim(),
txtCity.Text.Trim(),
Convert.ToBoolean(rblNewsLetter.SelectedItem.Value),
txtPassword.Text.Trim(),
DateTime.Now,
true);
Response.Redirect("CustomerAdd.aspx?ID=True");
}
private void BindData()
{
if (Request.QueryString["CustomerId"] != null)
{
int customerId = Convert.ToInt32(Request.QueryString["CustomerId"]);
dtCustomers = taCustomers.SelectCustomerbyCustomerId(customerId);
if (dtCustomers.Rows.Count > 0)
{
DetailsView1.DataSource = dtCustomers;
DetailsView1.DataBind();
}
else
{
DetailsView1.Visible = false;
lblMsg.Text = "No record found";
}
}
else
{
DetailsView1.Visible = false;
lblMsg.Text = "No record found";
}
}
