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);
}