public string Delete(long id)
{
List <UsuarioEnt> us = new List <UsuarioEnt>();
XmlSerializer xs = new XmlSerializer(typeof(List <UsuarioEnt>));
StreamReader sr = new StreamReader(caminho);
try
{
us = (List <UsuarioEnt>)xs.Deserialize(sr);
sr.Close();
UsuarioEnt u = us.Where(x => x.Matricula == id.ToString()).FirstOrDefault();
us.Remove(u);
StreamWriter sw = new StreamWriter(caminho);
xs.Serialize(sw, us);
sw.Close();
return("ok");
}
catch (Exception ex)
{
throw ex;
}
}
public List <UsuarioEnt> Lista()
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * FROM usuarios ORDER BY nome ASC";
cn.Connection = con;
SqlDataReader dr;
List <UsuarioEnt> Lista = new List <UsuarioEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
UsuarioEnt dado = new UsuarioEnt();
dado.Id = Convert.ToInt32(dr["id"]);
dado.Nome = Convert.ToString(dr["nome"]);
dado.Usuario = Convert.ToString(dr["usuario"]);
dado.Senha = Convert.ToString(dr["senha"]);
Lista.Add(dado);
}
}
return(Lista);
}
}
void ReadData(string prmUSER_LOGIN)
{
try
{
UsuarioEnt oUsuario = new UsuarioEnt();
UsuarioBus oUsuarioBus = new UsuarioBus();
string img;
oUsuario = oUsuarioBus.ObtieneUsuario(prmUSER_LOGIN);
txtUSER_LOGIN.Text = prmUSER_LOGIN;
txtUSER_PASSWORD.Text = oUsuario.psPassword;
txtNOMBRE.Text = oUsuario.psNombreUsuario;
chkACTIVO.Checked = Convert.ToBoolean(oUsuario.psActivo);
chkADMINISTRACION.Checked = Convert.ToBoolean(oUsuario.psAdministracion);
chkALUMNOS.Checked = Convert.ToBoolean(oUsuario.psAlumnos);
// chkPROFESORES.Checked = Convert.ToBoolean(oUsuario.psProfesores);
chkCOBRANZA.Checked = Convert.ToBoolean(oUsuario.psCobranza);
// chkBLOG.Checked = Convert.ToBoolean(oUsuario.psBlog);
chkPAGO.Checked = Convert.ToBoolean(oUsuario.psPago);
//Image1.ImageUrl = "~/Images/Users/" + oUsuario.psImagen.ToString();
img = oUsuario.psImagen.ToString();
img = img.Substring(15, img.Length - 15);
//ddlImage.SelectedValue = img;
}
catch (Exception E)
{ }
}
public List <UsuarioEnt> Consulta(UsuarioEnt objtabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.Banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
//con conversa/instansia com bd cn estancia/recebendo a função da sqlcommand
cn.CommandText = " SELECT * FROM CADTELEFONE WHERE nome LIKE @nome";
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objtabela.Nome + "%";
cn.Connection = con;
SqlDataReader dr;
List <UsuarioEnt> lista = new List <UsuarioEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
UsuarioEnt dado = new UsuarioEnt();
dado.Id = Convert.ToInt32(dr["id"]);
dado.Nome = Convert.ToString(dr["Nome"]);
dado.Telefone = Convert.ToString(dr["Telefone"]);
lista.Add(dado);
}
}
return(lista);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textUsuario.Text == "" || textSenha.Text == "")
{
MessageBox.Show("Preencha o campo vazio!");
textUsuario.Focus();
return;
}
UsuarioEnt obj = new UsuarioEnt();
obj.Usuario = textUsuario.Text;
obj.Senha = textSenha.Text;
obj = new UsuarioModel().Login(obj);
if (obj.Usuario == null)
{
lblMesagem.Text = "Usuário ou Senha não encontrado!";
lblMesagem.ForeColor = Color.Red;
return;
}
frmCadUsuario formCad = new frmCadUsuario();
this.Hide();
formCad.Show();
}
catch (Exception ex)
{
MessageBox.Show("Error ao Logar: " + ex.Message);
}
}
internal List <UsuarioEnt> Lista()
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * FROM cadtelefone";
cn.Connection = con;
SqlDataReader dr;
List <UsuarioEnt> lista = new List <UsuarioEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
UsuarioEnt dado = new UsuarioEnt();
dado.Id = Convert.ToInt32(dr["id"]);
dado.Nome = Convert.ToString(dr["nome"]);
dado.Telefone = Convert.ToString(dr["telefone"]);
lista.Add(dado);
}
}
return(lista);
}
}
public UsuarioEnt Login(UsuarioEnt obj)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * FROM usuario WHERE email = @email AND senha = @senha";
cn.Connection = con;
cn.Parameters.Add("email", SqlDbType.VarChar).Value = obj.Email;
cn.Parameters.Add("senha", SqlDbType.VarChar).Value = obj.Senha;
SqlDataReader dr;
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
UsuarioEnt dado = new UsuarioEnt();
dado.Email = Convert.ToString(dr["email"]);
dado.Senha = Convert.ToString(dr["senha"]);
}
}
else
{
obj.Email = null;
obj.Senha = null;
}
return(obj);
}
}
protected void btnGrabar_Click(object sender, EventArgs e)
{
try
{
UsuarioEnt UsuarioItem = new UsuarioEnt();
UsuarioBus oUsuarioItemBus = new UsuarioBus();
UsuarioItem.psIDUsuario = txtUSER_LOGIN.Text;
UsuarioItem.psNombreUsuario = txtNOMBRE.Text;
UsuarioItem.psPassword = txtUSER_PASSWORD.Text;
UsuarioItem.psActivo = Convert.ToInt32(chkACTIVO.Checked).ToString();
UsuarioItem.psAdministracion = Convert.ToInt32(chkADMINISTRACION.Checked).ToString();
UsuarioItem.psAlumnos = Convert.ToInt32(chkALUMNOS.Checked).ToString();
// UsuarioItem.psProfesores = Convert.ToInt32(chkPROFESORES.Checked).ToString();
UsuarioItem.psCobranza = Convert.ToInt32(chkCOBRANZA.Checked).ToString();
UsuarioItem.psPago = Convert.ToInt32(chkPAGO.Checked).ToString();
// UsuarioItem.psBlog = Convert.ToInt32(chkBLOG.Checked).ToString();
// UsuarioItem.psAyuda = Convert.ToInt32(chkAYUDA.Checked).ToString();
// UsuarioItem.psImagen = ddlImage.SelectedValue.ToString();
if (oUsuarioItemBus.fnRegistroBus(UsuarioItem))
{
Response.Redirect("UsuariosLista.aspx");
}
}
catch (Exception ex)
{
lblMensaje.Text = ex.Message;
}
}
public string Post([FromForm] UsuarioEnt usu)
{
try
{
List <UsuarioEnt> us = new List <UsuarioEnt>();
XmlSerializer xs = new XmlSerializer(typeof(List <UsuarioEnt>));
usu.Matricula = DateTime.Now.ToString("yyyyMMddHms");
StreamReader sr = new StreamReader(caminho);
us = (List <UsuarioEnt>)xs.Deserialize(sr);
sr.Close();
sr.Dispose();
us.Add(usu);
StreamWriter sw = new StreamWriter(caminho);
xs.Serialize(sw, us);
sw.Close();
}
catch (Exception ex)
{
return(ex.Message);
}
return("ok");
}
public int Inserir(UsuarioEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
try
{
con.ConnectionString = DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "INSERT INTO Usuario ([nome], [email], [senha], [id_funcao]) VALUES (@nome, @email, @senha, @id_funcao)";
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome;
cn.Parameters.Add("email", SqlDbType.VarChar).Value = objTabela.Email;
cn.Parameters.Add("senha", SqlDbType.VarChar).Value = objTabela.Senha;
cn.Parameters.Add("id_funcao", SqlDbType.Int).Value = objTabela.Id_funcao;
cn.Connection = con;
qtd = cn.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine("Error DAO: " + ex.Message);
}
return(qtd);
}
}
public List <UsuarioEnt> Consulta(UsuarioEnt objTabela)
{
using (SqlConnection con = new SqlConnection()) //Instanciar = Apelidar e passar as propiedades para o nome definido
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand(); //apelidando o sqlcommand para cn
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * FROM cadTelefone WHERE nome like @nome";
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome + "%";
cn.Connection = con;
SqlDataReader dr;
List <UsuarioEnt> lista = new List <UsuarioEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
UsuarioEnt dado = new UsuarioEnt();
dado.Id = Convert.ToInt32(dr["Id"]);
dado.Nome = Convert.ToString(dr["Nome"]);
dado.Telefone = Convert.ToString(dr["Telefone"]);
lista.Add(dado);
}
}
return(lista);
}
}
public List <UsuarioEnt> Buscar(UsuarioEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * FROM Usuario WHERE nome like @nome";
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome + "%";
cn.Connection = con;
SqlDataReader dr;
List <UsuarioEnt> lista = new List <UsuarioEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
UsuarioEnt dado = new UsuarioEnt();
dado.Id = Convert.ToInt32(dr["id"]);
dado.Nome = Convert.ToString(dr["nome"]);
dado.Email = Convert.ToString(dr["email"]);
dado.Senha = Convert.ToString(dr["senha"]);
dado.Id_funcao = Convert.ToInt32(dr["id_funcao"]);
lista.Add(dado);
}
}
return(lista);
}
}
public int Exluir(UsuarioEnt objetoTabela)
{
using (SqlConnection conexao = new SqlConnection())
{
//objeto do tipo conexao, sendo atribuido para ele valores retirado do XML app.config, INDISPENSAVEL para conexão
conexao.ConnectionString = Properties.Settings.Default.banco;
//para usar os SQL COMAND
SqlCommand comand = new SqlCommand();
comand.CommandType = CommandType.Text;
comand.CommandText = "DELETE from usuarios where id= @id";
//inicializa conexão
conexao.Open();
//referencias para inserção
comand.Parameters.Add("id", SqlDbType.Int).Value = objetoTabela.Id;
//associar o comand a uma conexão
comand.Connection = conexao;
int qtd = comand.ExecuteNonQuery(); //retorno de validação recebimento de valor 0 = NÃO e 1 = SIM
Console.Write("qtd");
return(qtd); //retorna a função para ser validado na camada VIEW
}
}
public int Excluir(UsuarioEnt objTabela)
{
int qtd = 0;
try
{
using (MySqlConnection con = new MySqlConnection("server=127.0.0.1; port=3306; user id=root;password=278701;database=ProjetoMVC"))
{
con.ConnectionString = Properties.Settings.Default.banco;
con.Open();
MySqlCommand cn = new MySqlCommand("DELETE FROM tb_usuario WHERE id = ?", con);
cn.Parameters.Add("@?", MySqlDbType.Int16).Value = objTabela.Id;
//cn.Connection = con;
qtd = cn.ExecuteNonQuery(); //executar o comando
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("Erro: " + ex);
}
return(qtd);
}
public int Editar(UsuarioEnt objetoTabela)
{
using (SqlConnection conexao = new SqlConnection())
{
//objeto do tipo conexao, sendo atribuido para ele valores retirado do XML app.config, INDISPENSAVEL para conexão
conexao.ConnectionString = Properties.Settings.Default.banco;
//para usar os SQL COMAND
SqlCommand comand = new SqlCommand();
comand.CommandType = CommandType.Text;
comand.CommandText = "UPDATE usuarios SET nome = @nome,usuario = @usuario where id = @id";
//inicializa conexão
conexao.Open();
//referencias para inserção
comand.Parameters.Add("nome", SqlDbType.VarChar).Value = objetoTabela.Nome;//OBJETO que foi inseido na VIEW levando para MODEL e depois CONTROLLER
comand.Parameters.Add("usuario", SqlDbType.VarChar).Value = objetoTabela.Usuario;
comand.Parameters.Add("id", SqlDbType.Int).Value = objetoTabela.Id;
//associar o comand a uma conexão
comand.Connection = conexao;
int qtd = comand.ExecuteNonQuery(); //retorno de validação recebimento de valor 0 = NÃO e 1 = SIM
Console.Write("qtd");
return(qtd); //retorna a função para ser validado na camada VIEW
}
}
public string Put(long id, [FromForm] UsuarioEnt usu)
{
List <UsuarioEnt> us = new List <UsuarioEnt>();
XmlSerializer xs = new XmlSerializer(typeof(List <UsuarioEnt>));
usu.Matricula = DateTime.Now.ToString("yyyyMMddHms");
StreamReader sr = new StreamReader(caminho);
us = (List <UsuarioEnt>)xs.Deserialize(sr);
sr.Close();
UsuarioEnt u = us.Where(x => x.Matricula == id.ToString()).FirstOrDefault();
us.Remove(u);
us.Add(usu);
StreamWriter sw = new StreamWriter(caminho);
xs.Serialize(sw, us);
sw.Close();
return("ok");
}
internal List <UsuarioEnt> Lista()
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.Banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
//con conversa/instansia com bd cn estancia/recebendo a função da sqlcommand
cn.CommandText = " SELECT * FROM CADTELEFONE";
cn.Connection = con;
SqlDataReader dr;
List <UsuarioEnt> lista = new List <UsuarioEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
UsuarioEnt dado = new UsuarioEnt();
dado.Id = Convert.ToInt32(dr["id"]);
dado.Nome = Convert.ToString(dr["Nome"]);
dado.Telefone = Convert.ToString(dr["Telefone"]);
lista.Add(dado);
}
}
return(lista);
}
}
private void btnLogar_KeyPress(object sender, KeyPressEventArgs e)
{
try
{
if (textEmail.Text == "" || textSenha.Text == "")
{
sound2();
MessageBox.Show("Preencha o campo vazio!", "Aviso!", MessageBoxButtons.OK);
textEmail.Focus();
return;
}
UsuarioEnt obj = new UsuarioEnt();
obj.Email = textEmail.Text;
obj.Senha = textSenha.Text;
obj = new UsuarioModel().Login(obj);
if (obj.Email == null || obj.Senha == null)
{
sound2();
MessageBox.Show("Usuário ou Senha inválidos!", "Aviso!", MessageBoxButtons.OK);
return;
}
frmPrincipal frmP = new frmPrincipal();
this.Hide();
frmP.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show("Erro messagem: " + ex.Message);
}
}
public UsuarioEnt Login(UsuarioEnt obj)
{
using (SqlConnection conexao = new SqlConnection())
{
//objeto do tipo conexao, sendo atribuido para ele valores retirado do XML app.config, INDISPENSAVEL para conexão
conexao.ConnectionString = Properties.Settings.Default.banco;
//para usar os SQL COMAND
SqlCommand comand = new SqlCommand();
comand.CommandType = CommandType.Text;
comand.CommandText = "SELECT * from usuarios where usuario = @usuario AND senha = @senha";
//inicializa conexão
conexao.Open();
//PRECISA DE PARAMETROS PARA WHERE
//referencias para inserção
comand.Parameters.Add("usuario", SqlDbType.VarChar).Value = obj.Usuario;
comand.Parameters.Add("senha", SqlDbType.VarChar).Value = obj.Senha;
comand.Connection = conexao;
SqlDataReader dr;
//NAO PRECISA EXIBIR EM NENHUM LOCAL
//List<UsuarioEnt> lista = new List<UsuarioEnt>();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
UsuarioEnt dado = new UsuarioEnt();
dado.Usuario = Convert.ToString(dr["usuario"]);
dado.Senha = Convert.ToString(dr["senha"]);
}
}
else
{
obj.Usuario = null;
obj.Senha = null;
}
return(obj);
}
}
public List <UsuarioEnt> Lista()
{
List <UsuarioEnt> lista = new List <UsuarioEnt>();
try
{
using (MySqlConnection con = new MySqlConnection("server=127.0.0.1; port=3306; user id=root;password=278701;database=ProjetoMVC"))
{
con.ConnectionString = Properties.Settings.Default.banco;
con.Open();
MySqlCommand cn = new MySqlCommand("SELECT *FROM tb_usuario ORDER BY nome DESC", con);
//cn.CommandType = CommandType.Text;
//cn.CommandText = "INSERT INTO tb_usuario (nome, usuario, cpf, senha) VALUES (?, ?, ?, ?)";
//cn.Connection = con;
MySqlDataReader dr;
dr = cn.ExecuteReader();//executar o comando
if (dr.HasRows)
{
while (dr.Read())
{
UsuarioEnt dado = new UsuarioEnt();
dado.Id = Convert.ToInt32(dr["id"]);
dado.Nome = Convert.ToString(dr["nome"]);
dado.Usuario = Convert.ToString(dr["usuario"]);
dado.CPF = Convert.ToString(dr["cpf"]);
dado.Senha = Convert.ToString(dr["senha"]);
lista.Add(dado);
}
}
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("Erro: " + ex);
}
return(lista);
}
public UsuarioEnt Get(long id)
{
XmlSerializer xs = new XmlSerializer(typeof(List <UsuarioEnt>));
StreamReader s = new StreamReader(caminho);
List <UsuarioEnt> us = (List <UsuarioEnt>)xs.Deserialize(s);
UsuarioEnt u = us.Where(x => x.Matricula == id.ToString()).FirstOrDefault();
s.Close();
return(u);
}
public int Excluir(UsuarioEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "DELETE FROM usuario WHERE id = @id";
cn.Parameters.Add("id", SqlDbType.Int).Value = objTabela.Id;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
return(qtd);
}
}
public List <UsuarioEnt> Buscar(UsuarioEnt objTabela)
{
List <UsuarioEnt> lista = new List <UsuarioEnt>();
try
{
using (MySqlConnection con = new MySqlConnection("server=127.0.0.1; port=3306; user id=root;password=278701;database=ProjetoMVC"))
{
con.ConnectionString = Properties.Settings.Default.banco;
con.Open();
MySqlCommand cn = new MySqlCommand("SELECT *FROM tb_usuario WHERE nome LIKE ? ORDER BY nome DESC", con);
cn.Parameters.Add("@?", MySqlDbType.VarChar, 40).Value = objTabela.Nome + "%";
MySqlDataReader dr;
dr = cn.ExecuteReader();//executar o comando
if (dr.HasRows)
{
while (dr.Read())
{
UsuarioEnt dado = new UsuarioEnt();
dado.Id = Convert.ToInt32(dr["id"]);
dado.Nome = Convert.ToString(dr["nome"]);
dado.Usuario = Convert.ToString(dr["usuario"]);
dado.CPF = Convert.ToString(dr["cpf"]);
dado.Senha = Convert.ToString(dr["senha"]);
lista.Add(dado);
}
}
con.Close();
}
}
catch (Exception ex)
{
Console.WriteLine("Erro: " + ex);
}
return(lista);
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
if (textUsuario.Text == "")
{
MessageBox.Show(" Preencha o campo usuário! ");
textUsuario.Focus();
return;
}
else if (textSenha.Text == "")
{
MessageBox.Show(" Preencha o campo senha! ");
textSenha.Focus();
return;
}
UsuarioEnt obj = new UsuarioEnt();
obj.Usuario = textUsuario.Text;
obj.Senha = textSenha.Text;
obj = new UsuarioModel().Login(obj);
if (obj.Usuario == null)
{
lbl_mensagem.Text = " Usuario ou senha não encontrado ";
lbl_mensagem.ForeColor = Color.Red;
return;
}
FrmCadUsuario form = new FrmCadUsuario();
this.Hide();
form.Show();//MOSTRA O FORMULARIO DE CADASTRO DE USUÁRIO
//this.Close();
}
catch (Exception ex)
{
MessageBox.Show("Erro ao Logar " + ex);
}
FrmCadUsuario frmCadUsuario = new FrmCadUsuario();
frmCadUsuario.Show();
}
public int Inserir(UsuarioEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Sistema.DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "INSERT INTO usuarios ([nome], [usuario], [senha]) VALUES (@nome, @usuario, @senha)";
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome;
cn.Parameters.Add("usuario", SqlDbType.VarChar).Value = objTabela.Usuario;
cn.Parameters.Add("senha", SqlDbType.VarChar).Value = objTabela.Senha;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
Console.Write(qtd);
return(qtd);
}
}
internal int Inserir(UsuarioEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "INSERT INTO cadtelefone ([nome] , [telefone] ) VALUES (@nome , @telefone) ";
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome;
cn.Parameters.Add("telefone", SqlDbType.VarChar).Value = objTabela.Telefone;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
return(qtd);
}
}
internal int Inserir(UsuarioEnt objTabela)
{
using (SqlConnection con = new SqlConnection()) //Instanciar = Apelidar e passar as propiedades para o nome definido
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand(); //apelidando o sqlcommand para cn
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "INSERT INTO cadTelefone ([nome], [telefone]) VALUES (@nome, @telefone)";
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome;
cn.Parameters.Add("telefone", SqlDbType.VarChar).Value = objTabela.Telefone;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
return(qtd);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
if (txtUsuario.Text == "")
{
MessageBox.Show("Preencha o campo usuário!");
txtUsuario.Focus();
return;
}
if (txtSenha.Text == "")
{
MessageBox.Show("Preencha o campo Senha!");
txtSenha.Focus();
return;
}
UsuarioEnt obj = new UsuarioEnt();
obj.Usuario = txtUsuario.Text;
obj.Senha = txtSenha.Text;
obj = new UsuarioModel().Login(obj);
if (obj.Usuario == null)
{
lblMensagem.Text = "Usuário ou senha não encontrado!";
lblMensagem.ForeColor = Color.Red;
return;
}
frmCadUsuario form = new frmCadUsuario()
{
telaprincipal = this
};
this.Hide();
form.Show();
// this.Close();
}
catch (Exception ex)
{
MessageBox.Show("Erro ao Logar" + ex.Message);
}
}
public int Editar(UsuarioEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = DAO.Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "UPDATE Usuario SET nome = @nome, email = @email, senha = @senha, id_funcao = @id_funcao WHERE id = @id";
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome;
cn.Parameters.Add("email", SqlDbType.VarChar).Value = objTabela.Email;
cn.Parameters.Add("senha", SqlDbType.VarChar).Value = objTabela.Senha;
cn.Parameters.Add("id_funcao", SqlDbType.Int).Value = Convert.ToInt32(objTabela.Id_funcao);
cn.Parameters.Add("id", SqlDbType.Int).Value = Convert.ToInt32(objTabela.Id);
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
return(qtd);
}
}
internal int Alterar(UsuarioEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "UPDATE cadtelefone SET nome=@nome, telefone=@telefone WHERE id=@id";
cn.Parameters.Add("id", SqlDbType.Int).Value = objTabela.Id;
cn.Parameters.Add("nome", SqlDbType.VarChar).Value = objTabela.Nome;
cn.Parameters.Add("telefone", SqlDbType.VarChar).Value = objTabela.Telefone;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
return(qtd);
}
}