public LowerNode Lower()
{
var lowerNode = new LowerNode();
Match(TokenType.LOWER);
return(lowerNode);
}
public int GetOffset(int target)
{
if (!Divider.HasValue)
{
return(Offset);
}
if (target < Divider.Value)
{
return(Offset + (LowerNode?.GetOffset(target) ?? 0));
}
return(Offset + (UpperNode?.GetOffset(target) ?? 0));
}
public LowerNode FillData(LowerNode lowerNode, string storedProcedure)
{
Connection connection = new Connection();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = storedProcedure;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = connection.connectionString;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
SqlParameter paramIdUsuario = new SqlParameter();
paramIdUsuario.SqlDbType = SqlDbType.NVarChar;
paramIdUsuario.ParameterName = "@NodoSuperior";
paramIdUsuario.Value = lowerNode.NodoSuperior;
sqlCommand.Parameters.Add(paramIdUsuario);
SqlParameter paramNodoInferior = new SqlParameter();
paramNodoInferior.SqlDbType = SqlDbType.NVarChar;
paramNodoInferior.ParameterName = "@NodoInferior";
paramNodoInferior.Value = lowerNode.NodoInferior;
sqlCommand.Parameters.Add(paramNodoInferior);
SqlParameter paramIdCategoria = new SqlParameter();
paramIdCategoria.SqlDbType = SqlDbType.SmallInt;
paramIdCategoria.ParameterName = "@IdCategoria";
paramIdCategoria.Value = lowerNode.IdCategoria;
sqlCommand.Parameters.Add(paramIdCategoria);
connection.Connect();
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
while (reader.Read())
{
lowerNode.Nombres = reader["Nombres"].ToString();
lowerNode.Cantidad = Convert.ToInt16(reader["Cantidad"].ToString());
lowerNode.NombreNivel = reader["NombreNivel"].ToString();
lowerNode.RecaudadoNivel1 = Convert.ToDecimal(reader["RecaudadoNivel1"].ToString());
lowerNode.RecaudadoNivel2 = Convert.ToDecimal(reader["RecaudadoNivel2"].ToString());
lowerNode.RecaudadoNivel3 = Convert.ToDecimal(reader["RecaudadoNivel3"].ToString());
}
}
connection.Disconnect();
return(lowerNode);
}
private void UpdateLower(int divider, int offset, IntegerMapOffsetType type)
{
if (LowerNode == null)
{
LowerNode = new IntegerMapNode();
}
LowerNode.Update(divider, offset, type);
if (type == IntegerMapOffsetType.GreaterThanOrEqualToDivider)
{
AddToUpper(offset);
}
}
public void Fill_List_LowerNodes()
{
principalIdsUsers = Get_List_LowerNodes();
LowerNode lowerNode;
if (principalIdsUsers.Count >= 1)
{
for (int i = 0; i < principalIdsUsers.Count; i++)
{
lowerNode = new LowerNode();
lowerNodes.Add(lowerNode);
lowerNodes[i] = FillLowerNodes(principalIdsUsers[i]);
}
}
}
public LowerNode FillLowerNodes(string idNodoInferior)
{
LowerNode lowerNode = new LowerNode()
{
NodoSuperior = idUsuario,
NodoInferior = idNodoInferior,
IdCategoria = idCategoria
};
LowerNodeData lowerNodeData = new LowerNodeData();
lowerNode = lowerNodeData.FillData(lowerNode, "Negocio_Read_Node");
return(lowerNode);
}
private void AddToLower(int offset)
{
if (LowerNode == null)
{
LowerNode = new IntegerMapNode()
{
Offset = offset
}
}
;
else
{
LowerNode.Offset += offset;
LowerNode = LowerNode.Reduce();
}
}
public override ASTN VisitComparer([NotNull] ComparerContext context)
{
ExprNode left = VisitExpr(context.left) as ExprNode;
ExprNode right = VisitExpr(context.right) as ExprNode;
ComparerNode node;
switch (context.op.Type)
{
case EQU:
node = new EqualNode(context);
break;
case LOW:
node = new LowerNode(context);
break;
default:
node = new LowerOrEqualNode(context);
break;
}
node.Leftexpr = left;
node.Rigthexpr = right;
return(node);
}
public void FillData_PrincipalUser()
{
try
{
#region Principal User
PrincipalUser user = new PrincipalUser()
{
IdUsuario = idUsuario,
IdCategoria = idCategoria
};
PrincipalUserData principalUser = new PrincipalUserData();
user = principalUser.FillData(user);
PUlblNombres.Text = user.Nombres;
PUCategoria.Text = user.NombreCategoria;
PUlblNivel.Text = user.NombreNivel;
conteoNodosinferiores = user.Cantidad;
#endregion Principal User
#region Principal User Status
ReadGeneralData readGeneralData = new ReadGeneralData();
int valueNextlevel; // Variable temporal para asignar el nivel
if (Convert.ToInt32(user.IdNivel) <= 2)
{
valueNextlevel = Convert.ToInt32(user.IdNivel) + 1;
}
else
{
valueNextlevel = Convert.ToInt32(user.IdNivel);
}
PUlblSiguienteNivel.Text = readGeneralData.GetSingleValueSTRINGById("Negocio_GetData_Level_Name", "@IdNivel", Convert.ToInt16(valueNextlevel));
PUlblCantidadColaboradores.Text = conteoNodosinferiores.ToString(); // idUsuario obtenido previamente
PUlblCantidadColaboradores2.Text = conteoNodosinferiores.ToString();
GrlLblNombreNivel1.Text = readGeneralData.GetSingleValueSTRINGById("Negocio_GetData_Level_Name", "@IdNivel", 1);
GrlLblNombreNivel2.Text = readGeneralData.GetSingleValueSTRINGById("Negocio_GetData_Level_Name", "@IdNivel", 2);
GrlLblNombreNivel3.Text = readGeneralData.GetSingleValueSTRINGById("Negocio_GetData_Level_Name", "@IdNivel", 3);
LowerNode lowerNode = new LowerNode()
{
NodoSuperior = idUsuario,
NodoInferior = idUsuario,
IdCategoria = idCategoria
};
LowerNodeData lowerNodeData = new LowerNodeData();
lowerNode = lowerNodeData.FillData(lowerNode, "Negocio_Read_Principal_Node");
PULblGananciaNivel1.Text = lowerNode.RecaudadoNivel1.ToString();
PULblGananciaNivel2.Text = lowerNode.RecaudadoNivel2.ToString();
PULblGananciaNivel3.Text = lowerNode.RecaudadoNivel3.ToString();
//PULblGananciaNivel1.Text = Convert.ToString(readGeneralData.GetSingleValueDECIMAL_3Ids("Negocio_GetData_Achievements_ByIdUser", "@NodoSuperior", idUsuario, "@IdNivel", 1, "@IdCategoria", idCategoria));
//PULblGananciaNivel2.Text = Convert.ToString(readGeneralData.GetSingleValueDECIMAL_3Ids("Negocio_GetData_Achievements_ByIdUser", "@NodoSuperior", idUsuario, "@IdNivel", 2, "@IdCategoria", idCategoria));
//PULblGananciaNivel3.Text = Convert.ToString(readGeneralData.GetSingleValueDECIMAL_3Ids("Negocio_GetData_Achievements_ByIdUser", "@NodoSuperior", idUsuario, "@IdNivel", 3, "@IdCategoria", idCategoria));
#endregion Principal User Status
}
catch (Exception ex)
{
throw;
}
}