public IList <int> ClassExist(string codigoSala)
{
string query = "select * from tb_salas where codigo_sala = '" + codigoSala + "'";
IList <int> consulta = _dbOracleConnection.Dbconnection().Query <int>(query).AsList();
return(consulta);
}
public IList <int> ValidateCreateAcout(string email)
{
try
{
IList <int> conferencia = _dbOracleConnection.Dbconnection().Query <int>("select * from tb_usuario where email_usuario = '" + email + "'").AsList();
return(conferencia);
}
catch (Exception ex)
{
throw ex;
}
}
public void Presenca(string codigoSala)
{
try
{
_dbOracleConnection.Dbconnection().Query("begin sp_presenca_sala('" + codigoSala + "'); end;");
}
catch (Exception ex)
{
throw ex;
}
}
public IList <int> Login(string email, string senha)
{
try
{
IList <int> consulta = _dbConnection.Dbconnection().Query <int>("SELECT fn_verifica_login ('" + email + "'" + ",'" + senha + "') FROM dual").AsList();
return(consulta);
}
catch (Exception ex)
{
throw ex;
}
}