private void dataTable()
{
conexao a = new conexao();
dt.AutoGenerateEditButton = true;
dt.AutoGenerateDeleteButton = true;
dt.DataSource = a.myDataTable();
dt.DataBind();
}
protected void dt_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int index = e.RowIndex;
id = dt.Rows[index].Cells[1].Text;
string query = "delete Endereco where id = " + id + "; " +
" delete Telefone where id=" + id + ";" +
" delete clientes where id=" + id;
conexao con = new conexao();
bool ok = con.myComandoRetornoLogico(query);
Response.Redirect(Request.RawUrl);
}
protected void dt_RowEditing(object sender, GridViewEditEventArgs e)
{
int index = e.NewEditIndex;
id = dt.Rows[index].Cells[1].Text;
ConfigurationManager.AppSettings["idCliente"] = id;
string tDoc, nDoc;
conexao a = new conexao();
string query = "select c.nome, c.documento, c.tipodoc, t.numero, t.tipo, e.endereco, e.tipo from clientes c" +
" inner join Telefone t on t.id = c.id" +
" inner join Endereco e on e.id = c.id where c.id = " + id;
SqlDataReader dr = a.myDataReader(query);
if (dr.HasRows)
{
while (dr.Read())
{
nome.Value = dr[0].ToString();
tDoc = dr[2].ToString();
nDoc = dr[1].ToString();
if (tDoc == "CPF")
{
cpf.Value = nDoc; radio1.Checked = true;
}
else
{
cnpj.Value = nDoc; radio2.Checked = true;
}
tipotel.Value = dr[4].ToString();
tel.Value = dr[3].ToString();
end.Value = dr[5].ToString();
tipoend.Value = dr[6].ToString();
}
}
//foreach (Control c in dt.Rows[e.NewEditIndex].Controls)
//{
// if (c is DataControlFieldCell)
// (c as DataControlFieldCell).Enabled = false;
//}
btnCancel.Visible = true;
//Response.Redirect(Request.RawUrl);
dt.Enabled = false;
}
protected void Save(object sender, EventArgs e)
{
Cliente c = new Cliente();
c.nome = nome.Value.ToString();
c.tipoDoc = radio1.Checked ? "CPF" : "CNPJ";
c.doc = radio1.Checked ? cpf.Value.ToString() : cnpj.Value.ToString();
c.tipoTel = tipotel.Value.ToString();
c.tel = tel.Value.ToString();
c.tipoEnd = tipoend.Value.ToString();
c.end = end.Value.ToString();
if (string.IsNullOrEmpty(ConfigurationManager.AppSettings["idCliente"]))
{
string query = "insert into clientes values ('" + c.nome + "', '" + c.doc + "', '" + c.tipoDoc + "'); declare @a int; set @a = scope_identity(); " +
" insert into Endereco values (@a, '" + c.end + "', '" + c.tipoEnd + "');" +
" insert into Telefone values (@a, '" + c.tel + "', '" + c.tipoTel + "')";
conexao con = new conexao();
bool ok = con.myComandoRetornoLogico(query);
}
else
{
id = ConfigurationManager.AppSettings["idCliente"];
string query = "update clientes set nome ='" + c.nome + "', documento = '" + c.doc + "', tipodoc = '" + c.tipoDoc + "' where id = " + id + "; " +
" update Endereco set endereco ='" + c.end + "', tipo='" + c.tipoEnd + "' where id=" + id + ";" +
" update Telefone set numero ='" + c.tel + "', tipo='" + c.tipoTel + "' where id=" + id;
conexao con = new conexao();
bool ok = con.myComandoRetornoLogico(query);
}
ConfigurationManager.AppSettings["idCliente"] = "";
btnCancel.Visible = false;
Response.Redirect(Request.RawUrl);
}