private static bool HasUpdates(out int VersaoRelease)
{
BaseDados bd = new BaseDados();
string sql = @"SELECT VersaoRelease FROM atualizacao WHERE id = @1;";
VersaoRelease = bd.ExecNumberQuery(sql, ConfigAtualizacaoUsing);
return(VersaoUpdate > VersaoRelease && VersaoRelease > 0);
}
private static void IncrementNumAcessos(int id)
{
BaseDados bd = new BaseDados();
string sql = @"SELECT n_acessos FROM login WHERE id = @1;";
int n_acess = bd.ExecNumberQuery(sql, id) + 1;
sql = @"UPDATE login SET n_acessos = @2 WHERE id = @1;";
bd.ExecNonQuery(sql, id, n_acess);
}
public static UserInfo VerificarLogin(string username, string password)
{
BaseDados bd = new BaseDados();
UserInfo userInfo = new UserInfo();
string sql = @"SELECT IFNULL(id, -1) FROM login WHERE username = @1 AND password = @2;";
int id;
try { id = bd.ExecNumberQuery(sql, username, password); }
catch { id = -1; }
if (id < 1)
{
throw new Exception("Dados de Login Incorretos!");
}
sql = @"SELECT bloqueado FROM login WHERE id = @1;";
int bloqueado = bd.ExecNumberQuery(sql, id);
if (bloqueado != 0)
{
sql = @"SELECT bloqueio_data as data, bloqueio_motivo as motivo FROM login WHERE id = @1;";
DataTable dt = bd.ExecQuery(sql, id);
string exp = "<b>Utilizador bloqueado</b> em: " + (String.IsNullOrEmpty(dt.Rows[0]["data"] + "") ? "---" : dt.Rows[0]["data"].ToString()) + "<br />" +
"<b>Motivo: </b>" + (String.IsNullOrEmpty(dt.Rows[0]["motivo"] + "") ? "---" : dt.Rows[0]["motivo"].ToString());
throw new Exception(exp);
}
else
{
IncrementNumAcessos(id);
userInfo = GetUserInfo(id);
}
return(userInfo);
}
