private static UserInfo GetUserInfo(int id)
{
BaseDados bd = new BaseDados();
string sql = @"SELECT id, username, codigo, perfil, Nome, n_acessos, criacao_data FROM login WHERE id = @1;";
DataTable dt = bd.ExecQuery(sql, id);
UserInfo info = new UserInfo();
info.id = (String.IsNullOrEmpty(dt.Rows[0]["id"] + "") ? -1 : Convert.ToInt32(dt.Rows[0]["id"] + ""));
info.username = (String.IsNullOrEmpty(dt.Rows[0]["username"] + "") ? "" : dt.Rows[0]["username"] + "");
info.codigo = (String.IsNullOrEmpty(dt.Rows[0]["codigo"] + "") ? "" : dt.Rows[0]["codigo"] + "");
info.perfil = (String.IsNullOrEmpty(dt.Rows[0]["perfil"] + "") ? -1 : Convert.ToInt32(dt.Rows[0]["perfil"] + ""));
info.Nome = (String.IsNullOrEmpty(dt.Rows[0]["Nome"] + "") ? "" : dt.Rows[0]["Nome"] + "");
info.criacao_data = (String.IsNullOrEmpty(dt.Rows[0]["criacao_data"] + "") ? DateTime.Now : Convert.ToDateTime(dt.Rows[0]["criacao_data"] + ""));
info.n_acessos = (String.IsNullOrEmpty(dt.Rows[0]["n_acessos"] + "") ? -1 : Convert.ToInt32(dt.Rows[0]["n_acessos"] + ""));
return(info);
}
private static bool HasAtualizacaoInDB()
{
BaseDados bd = new BaseDados();
string sql = @"SELECT VersaoRelease, VersaoUpdate FROM atualizacao WHERE id = @1;";
DataTable dt = bd.ExecQuery(sql, ConfigAtualizacaoUsing);
if (dt == null || dt.Rows.Count == 0)
{
return(false);
}
if (((int)dt.Rows[0]["VersaoRelease"] <= 0) || ((int)dt.Rows[0]["VersaoUpdate"] <= 0))
{
return(false);
}
return(true);
}
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);
}
