private void PopulaGrid() { try { var autenticacao = (autenticacaoViewModel)Session["autentica"]; var aut = new autenticacaoViewModel(); DataSet ds = new DataSet(); var cnn = string.Format("Data Source=LAPTOP-6BM5FJHM\\SQLEXPRESS; Initial Catalog=ListaDeContatosDB; Integrated Security=True;"); string strStringcnn = cnn; var comando = string.Format("select * from tblContatos where nmUsuario like '{0}%' and (dsStatus = 'Ativo' or dsStatus = 'ATIVO') order by nmUsuario", Txtb_Procura.Text); string strStringComando = comando; string strNome = Txtb_Procura.Text.ToLower(); SqlConnection objSqlcnn = new SqlConnection(strStringcnn); SqlCommand objSqlComando = new SqlCommand(strStringComando, objSqlcnn); objSqlcnn.Open(); if (objSqlcnn.State == ConnectionState.Open) { DataTable dt = new DataTable(); SqlConnection con = new SqlConnection(cnn); SqlDataAdapter adapt = new SqlDataAdapter(comando, con); con.Open(); adapt.Fill(dt); aut.table = dt; Session.Add("autentica", aut); if (dt.Rows.Count > 0) { grdShow.DataSource = dt; grdShow.DataBind(); } else { Response.Write("<script> alert('Não encontrado!')</script>"); } } objSqlcnn.Close(); Txtb_Procura.Text = ""; } catch (Exception ex) { Response.Write("<script> alert('Erro')</script>"); } }
protected void grdShow_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { try { if (e.CommandName == "Editar") { var autenticacao = (autenticacaoViewModel)Session["autentica"]; autenticacao.editar_campo = true; Txtb_nmUsuario.Visible = true; Txtb_dsEmail.Visible = true; Txtb_dsCelular.Visible = true; Txtb_dsStatus.Visible = true; Txtb_dsPrioridade.Visible = true; Label_Usuario.Visible = true; Label_Email.Visible = true; Label_Celular.Visible = true; Label_Status.Visible = true; Label_Prioridade.Visible = true; Btn_Salvar.Visible = true; DataSet ds = new DataSet(); var cnn = string.Format("Data Source=LAPTOP-6BM5FJHM\\SQLEXPRESS; Initial Catalog=ListaDeContatosDB; Integrated Security=True;"); SqlConnection conectar = new SqlConnection(cnn); string strStringcnn = cnn; SqlConnection objSqlcnn = new SqlConnection(strStringcnn); conectar.Open(); if (conectar.State == ConnectionState.Open) { Txtb_nmUsuario.Text = ""; Txtb_dsEmail.Text = ""; Txtb_dsCelular.Text = ""; Txtb_dsStatus.Text = ""; Txtb_dsPrioridade.Text = ""; SqlCommand cmd = conectar.CreateCommand(); cmd.CommandType = System.Data.CommandType.Text; int index = Convert.ToInt32(((System.Web.UI.WebControls.GridViewRow)((System.Web.UI.Control)e.CommandSource).DataItemContainer).RowIndex); GridViewRow row = grdShow.Rows[index]; string linhaIndex = grdShow.Rows[index].Cells[0].Text; autenticacao.idUsuario = linhaIndex; var procura_por_id = string.Format("select * from tblContatos where Id = '{0}'", linhaIndex); cmd.CommandText = procura_por_id; SqlDataReader dr = (cmd.ExecuteReader()); while (dr.Read()) { Txtb_nmUsuario.Text = Convert.ToString(dr["nmUsuario"]); Txtb_dsCelular.Text = Convert.ToString(dr["dsCelular"]); Txtb_dsEmail.Text = Convert.ToString(dr["dsEmail"]); Txtb_dsStatus.Text = Convert.ToString(dr["dsStatus"]); Txtb_dsPrioridade.Text = Convert.ToString(dr["dsPrioridade"]); } conectar.Close(); } autenticacao.editar_campo = true; } if (e.CommandName == "Deletar") { var autenticacao = (autenticacaoViewModel)Session["autentica"]; var aut = new autenticacaoViewModel(); DataSet ds = new DataSet(); var cnn = string.Format("Data Source=LAPTOP-6BM5FJHM\\SQLEXPRESS; Initial Catalog=ListaDeContatosDB; Integrated Security=True;"); SqlConnection conectar = new SqlConnection(cnn); int index = Convert.ToInt32(((System.Web.UI.WebControls.GridViewRow)((System.Web.UI.Control)e.CommandSource).DataItemContainer).RowIndex); GridViewRow row = grdShow.Rows[index]; string linhaIndex = grdShow.Rows[index].Cells[0].Text; aut.idUsuario = linhaIndex; string strStringcnn = cnn; SqlConnection objSqlcnn = new SqlConnection(strStringcnn); conectar.Open(); if (conectar.State == ConnectionState.Open) { SqlCommand cmd = conectar.CreateCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "UPDATE [tblContatos] SET dsStatus = @Status WHERE Id = @Index"; cmd.Parameters.Add(new SqlParameter("@Index", linhaIndex)); cmd.Parameters.Add(new SqlParameter("@Status", "Cancelado")); cmd.ExecuteNonQuery(); conectar.Close(); objSqlcnn.Close(); PopulaGrid(); } } } catch (Exception ex) { throw ex; } }