public bool chkLog(string Login, string psw)
{
cnn.Open();
string query = "SELECT Persona.Identificacion FROM Usuario INNER JOIN Persona ON Persona.idPersona = Usuario.idUsuario WHERE Usuario.Login = "******"Usuario");
string validate = "SELECT idUsuario,idPerfil FROM Usuario WHERE esActivo = 1 AND Login = "******" AND eClave = " + fun.gsql(fun.Sha256(fun.Sha256(psw) + fun.Sha256(id))) + " AND Clave = " + fun.gsql(fun.Sha256(psw));
cnn.dtFill(dtU, validate);
bool rt = fun.TryBool(dtU);
if (rt)
{
DataRow drU = dtU.Rows[0];
Variables.idUsuarioActual = fun.TryInt(drU["idUsuario"]);
Variables.idPerfilUsuarioActual = fun.TryInt(drU["idPerfil"]);
}
cnn.Close();
return(rt);
}
public static string getMaxString(string nomTable, string column, string filter = ";")
{
DataTable dt = new DataTable();
int max = 0, num = 0;
afgCon cn = new afgCon(Variables.strCon);
cn.Open();
string cmd = "SELECT " + column + " FROM " + nomTable + " " + filter;
cn.dtFill(dt, cmd);
foreach (DataRow dr in dt.Rows)
{
num = TryInt(dr[column]);
if (num > max)
{
max = num;
}
}
max++;
return(max.ToString());
}
public void dtFill(DataTable dt, string query)
{
cnn.Open();
cnn.dtFill(dt, query);
cnn.Close();
}