protected void selecionaNacionalidade(object sender, EventArgs e)
{
if (dropNacionalidade.SelectedValue == "01")
{
//pnlLocal.Enabled = true;
//pnlLocal.Visible = true;
pnlPais.Enabled = true;
estadoTableAdapter estadoAdapter = new estadoTableAdapter();
DataSet.estadoDataTable DT = estadoAdapter.GetData();
dropEstado.Items.Clear();
dropEstado.Items.Add("-");
foreach (DataSet.estadoRow estado in DT)
{
dropEstado.Items.Add(new ListItem(estado.nome, estado.id.ToString()));
}
}
else if (dropNacionalidade.SelectedValue == "02")
{
paisTableAdapter paisAdapter = new paisTableAdapter();
DataSet.paisDataTable DT = paisAdapter.GetData();
dropPais.Items.Clear();
dropPais.Items.Add("-");
foreach (DataSet.paisRow pais in DT)
{
dropPais.Items.Add(new ListItem(pais.nome, pais.id.ToString()));
}
dropPais.Items.Add("Outro");
pnlPais.Enabled = true;
pnlPais.Visible = true;
}
}
protected void btnEnvioClick(object sender, EventArgs e)
{
if (dropNacionalidade.SelectedValue == "02")
{
int idPais = 1;
if (dropPais.SelectedValue == "Outro")
{
paisTableAdapter paisAdapter = new paisTableAdapter();
int query = paisAdapter.InsertTeste(txtPais.Text);
idPais = int.Parse(paisAdapter.GetIdbyNome(txtPais.Text).ToString());
}
else if (dropPais.SelectedValue == "-")
{
Response.Write("Selecione um país");
}
else
{
idPais = int.Parse(dropPais.SelectedValue);
}
inscricaoTableAdapter inscricaoAdapter = new inscricaoTableAdapter();
int outputInsert = inscricaoAdapter.InsertQueryExtrangeiro(
txtNome.Text,
txtPassaporte.Text,
txtEmail.Text,
txtTelefone.Text,
txtCelular.Text,
dropSexo.SelectedValue,
idPais);
}
else
{
inscricaoTableAdapter inscricaoAdapter = new inscricaoTableAdapter();
int outputInsert = inscricaoAdapter.InsertQueryBrasileiro(
txtNome.Text,
txtCPF.Text,
txtEmail.Text,
txtTelefone.Text,
txtCelular.Text,
dropSexo.SelectedValue,
int.Parse(dropEstado.SelectedValue.ToString()),
int.Parse(dropCidade.SelectedValue.ToString()),
txtRua.Text,
txtNumero.Text,
txtBairro.Text);
}
Response.Redirect("/inscritos.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
inscricaoTableAdapter inscricaoAdapter = new inscricaoTableAdapter();
txtInscritos.Text = inscricaoAdapter.Count().ToString();
paisTableAdapter paisAdapter = new paisTableAdapter();
estadoTableAdapter estadoAdapter = new estadoTableAdapter();
cidadeTableAdapter cidadeAdapter = new cidadeTableAdapter();
DataSet.inscricaoDataTable dt = inscricaoAdapter.GetData();
//Building an HTML string.
StringBuilder html = new StringBuilder();
//Table start.
html.Append("<table class='mdl-data-table mdl-js-data-table mdl-shadow--2dp'>");
//Building the Header row.
html.Append("<tr>" +
"<th class='mdl-data-table__cell--non-numeric'> Nome</th>" +
"<th class='mdl-data-table__cell--non-numeric'>cpf </th>" +
"<th class='mdl-data-table__cell--non-numeric'>passaporte </th>" +
"<th class='mdl-data-table__cell--non-numeric'>email </th>" +
"<th class='mdl-data-table__cell--non-numeric'>telefone </th>" +
"<th class='mdl-data-table__cell--non-numeric'>celular </th>" +
"<th class='mdl-data-table__cell--non-numeric'>sexo </th>" +
"<th class='mdl-data-table__cell--non-numeric'>rua </th>" +
"<th class='mdl-data-table__cell--non-numeric'>numero </th>" +
"<th class='mdl-data-table__cell--non-numeric'>bairro </th>" +
"<th class='mdl-data-table__cell--non-numeric'>cidade </th>" +
"<th class='mdl-data-table__cell--non-numeric'>estado </th>" +
"<th class='mdl-data-table__cell--non-numeric'>pais </th>" +
"</tr>");
//Building the Data rows.
foreach (DataSet.inscricaoRow inscricao in dt)
{
if (inscricao.pais == 1)
{
html.Append("<tr>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.nome + " </td>");
html.Append("<td >" + inscricao.cpf + "</td>");
html.Append("<td> </td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.email + "</td>");
html.Append("<td >" + inscricao.telefone + " </td>");
html.Append("<td >" + inscricao.celular + " </td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.sexo + "</td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.rua + "</td>");
html.Append("<td >" + inscricao.numero + "</td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.bairro + "</td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + cidadeAdapter.GetNomeById(inscricao.cidade).ToString() + "</td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + estadoAdapter.GetNomeById(inscricao.estado).ToString() + "</td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + paisAdapter.GetNomeById(inscricao.pais).ToString() + "</td>");
html.Append("</tr>");
}
else
{
html.Append("<tr>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.nome + " </td>");
html.Append("<td> </td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.passaporte + "</td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.email + "</td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.telefone + " </td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.celular + " </td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + inscricao.sexo + "</td>");
html.Append("<td> </td>");
html.Append("<td> </td>");
html.Append("<td> </td>");
html.Append("<td> </td>");
html.Append("<td> </td>");
html.Append("<td class='mdl-data-table__cell--non-numeric'>" + paisAdapter.GetNomeById(inscricao.pais).ToString() + "</td>");
html.Append("</tr>");
}
}
//Table end.
html.Append("</table>");
string strText = html.ToString();
////Append the HTML string to Placeholder.
placeholder.Controls.Add(new Literal {
Text = html.ToString()
});
}
