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; }
}
