public bool GetExistsUser(NovaContaModel nc) { try { string sql = "SELECT * FROM Usuarios WHERE Usuario = @Usuario"; SQLiteCommand cmd = new SQLiteCommand(sql); cmd.Connection = AbreConexao(); cmd.Parameters.Add(new SQLiteParameter("@Usuario", nc.usuario)); SQLiteDataReader dr = cmd.ExecuteReader(); int rows = 0; while (dr.Read()) { rows++; } if (rows > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } finally { FecharConexao(); } }
public bool Add(NovaContaModel nc) { try { string sql = "INSERT INTO Usuarios(Usuario, Senha) VALUES (@Usuario, @Senha)"; SQLiteCommand cmd = new SQLiteCommand(sql); cmd.Connection = AbreConexao(); cmd.Parameters.Add(new SQLiteParameter("@Usuario", nc.usuario)); cmd.Parameters.Add(new SQLiteParameter("@Senha", nc.senha)); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } finally { FecharConexao(); } }