public Usuario ObterUsuario(int id) { var usuario = new Usuario(); var procedure = "sp_obter_usuario_id"; var parameters = new List <SqlParameter>() { new SqlParameter() { DbType = System.Data.DbType.Int32, ParameterName = "@id", Value = id } }; using (var dbHelper = new ProcTesteCommand()) { var command = dbHelper.CriarComando(procedure, parameters); var reader = command.ExecuteReader(); while (reader.Read()) { usuario.Id = Convert.ToInt32(reader["id"]); usuario.Nome = reader["@nome"].ToString(); usuario.Login = reader["@login"].ToString(); usuario.Senha = reader["@senha"].ToString(); usuario.Endereco = reader["@endereco"].ToString(); } return(usuario); } }
public bool AlterarUsuario(Usuario usuario) { var procedure = "sp_alterar_usuario"; var parameters = new List <SqlParameter>() { new SqlParameter() { SqlDbType = SqlDbType.Int, ParameterName = "@id", Value = usuario.Id }, new SqlParameter() { SqlDbType = SqlDbType.VarChar, ParameterName = "@nome", Value = usuario.Nome }, new SqlParameter() { SqlDbType = SqlDbType.VarChar, ParameterName = "@login", Value = usuario.Login }, new SqlParameter() { SqlDbType = SqlDbType.VarChar, ParameterName = "@senha", Value = usuario.Senha }, new SqlParameter() { SqlDbType = SqlDbType.VarChar, ParameterName = "@endereco", Value = usuario.Endereco } }; using (var dbHelper = new ProcTesteCommand()) { var command = dbHelper.CriarComando(procedure, parameters); var retorno = command.ExecuteNonQuery(); if (retorno > 0) { return(true); } return(false); } }
public bool InserirUsuario(Usuario usuario) { var procedure = "sp_inserir_cliente"; var parameter = new List <SqlParameter>() { new SqlParameter() { DbType = System.Data.DbType.String, ParameterName = "@nome", Value = usuario.Nome }, new SqlParameter() { DbType = System.Data.DbType.String, ParameterName = "@login", Value = usuario.Login }, new SqlParameter() { DbType = System.Data.DbType.String, ParameterName = "@senha", Value = usuario.Senha }, new SqlParameter() { DbType = System.Data.DbType.String, ParameterName = "@endereco", Value = usuario.Endereco } }; using (var dbHelper = new ProcTesteCommand()) { var command = dbHelper.CriarComando(procedure, parameter); var retornaLinhas = command.ExecuteNonQuery(); if (retornaLinhas > 0) { return(true); } return(false); } }
public List <Usuario> ListarUsuario() { var usuarios = new List <Usuario>(); var procedure = "sp_listar_usuario"; using (var dbHelper = new ProcTesteCommand()) { var command = dbHelper.CriarComando(procedure); var reader = command.ExecuteReader(); while (reader.Read()) { usuarios.Add(new Usuario { Nome = reader["nome"].ToString(), Login = reader["login"].ToString(), Senha = reader["senha"].ToString(), Endereco = reader["endereco"].ToString() }); } return(usuarios); } }
public bool ExcluirUsuario(int id) { var procedure = "sp_excluir_usuario"; var parameters = new List <SqlParameter>() { new SqlParameter() { SqlDbType = SqlDbType.Int, ParameterName = "@id", Value = id } }; using (var dbHelper = new ProcTesteCommand()) { var command = dbHelper.CriarComando(procedure, parameters); var retorno = command.ExecuteNonQuery(); if (retorno > 0) { return(true); } return(false); } }