private void TelaCadastroPessoa_Load(object sender, EventArgs e) { string sql = "SELECT CET_DESCRIPTION FROM ROS_CERTIFICATE_TYPE"; try { using (DatabaseROS db = new DatabaseROS()) { SQLiteDataReader reader = db.executeReader(sql); while (reader.Read()) { cbCertificates.Items.Add(reader.GetString(0)); } } } catch (Exception ex) { MessageBox.Show("Erro :" + ex.Message); } }
public static bool loginUser(string login, string password, out string profile) { bool senhaOK = false; profile = ""; string sql = "SELECT USR_PASSWORD, PRO_DESCRIPTION " + "FROM ROS_USER US " + "INNER JOIN ROS_PROFILE PRO ON USR_PRO_ID = PRO_ID " + "WHERE USR_LOGIN = \"" + login + "\""; using (DatabaseROS db = new DatabaseROS()) { SQLiteDataReader reader = db.executeReader(sql); while (reader.Read()) { senhaOK = CustomMD5.CompareMD5(password, reader.GetString(0)); profile = reader.GetString(1); } } return(senhaOK); }