public static bool InsertUser(UsuarioDTO usuario)
{
try
{
StringBuilder SQL = new StringBuilder();
SQL.Append(@"INSERT INTO Usuario (codigo,nome,login,cpf,senha");
SQL.Append(@"VALUES (NEXT VALUE FOR dbo.Sequence_User,@NOME,@LOGIN,@CPF,@SENHA)");
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Mendes_varejo"].ConnectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(SQL.ToString(), connection);
command.Parameters.AddWithValue("@NOME", usuario.nomeCompleto);
command.Parameters.AddWithValue("@LOGIN", usuario.login);
command.Parameters.AddWithValue("@CPF", usuario.cpf);
command.Parameters.AddWithValue("@SENHA", usuario.senha);
command.ExecuteNonQuery();
command.Dispose();
}
}
catch (Exception erro)
{
throw erro;
}
return true;
}
public static List<UsuarioDTO> GetAllUsers()
{
List<UsuarioDTO> retorno = new List<UsuarioDTO>();
StringBuilder SQL = new StringBuilder();
SQL.Append(@"SELECT nome,login, cpf FROM Usuario");
try
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Mendes_varejo"].ConnectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(SQL.ToString(), connection);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
UsuarioDTO usuario= new UsuarioDTO();
usuario.nomeCompleto = (Convert.ToString(reader["nome"]));
usuario.login = Convert.ToString(reader["login"]);
usuario.cpf = (Convert.ToString(reader["cpf"]));
retorno.Add(usuario);
}
}
}
}
catch (Exception Erro)
{
throw Erro;
}
return retorno;
}
public static bool InsertUser(UsuarioDTO usuario)
{
try
{
return UsuarioDAO.InsertUser(usuario);
}
catch (Exception e)
{
throw e;
}
}