public Tabla GetTableName(String name)
{
GetTableInsert(name);
Tabla t = TableList.ElementAt(InsertTable);
return(t);
}
public void Multi_Elimination(List <Conditions> l, int contador)
{
Tabla temp_table = GetTableName(name_delete);
if (contador > 0)
{
}
else//NO HAY OR'S
{
if (l.Count == 1)
{
int temp = Verify_Conditions(l.Count(), l, temp_table);
if (temp > 0)
{
Delete_Row(position_D, temp_table);
position_D = 0;
}
}
else
{
int temp = Verify_Conditions(l.Count(), l, temp_table);
if (temp == l.Count())
{
Delete_Row(position_D, temp_table);//call's a delete Row method
position_D = 0;
}
else
{
Console.WriteLine("No cumplio todas las Y");
}
}
}
}
public String tx(Tabla t)
{
String Content = "";
try
{
Tabla temp = t;
Entity_Table columnas = temp.getList().ElementAt(0);
ArrayList lis = columnas.getDataArray();
String Values_list;
for (int lis_index = 0; lis_index < lis.Count; lis_index++)
{
Values_list = "";
for (int col_index = 0; col_index < temp.getList().Count; col_index++)
{
Entity_Table Entity_temp = temp.getList().ElementAt(col_index);
ArrayList ls = Entity_temp.getDataArray();
Values_list += "<td>" + ls[lis_index] + "</td>";
// Console.WriteLine(ls[lis_index]);
}
Content += "<tr>" + Values_list + "</tr>";
}
}
catch (NullReferenceException)
{
Console.WriteLine("entro al null");
}
return(Content);
}
public void insert_In_Table(int value, int column_value, String valueD)
{
if (Flag_Success != false)
{
try
{
Tabla t_insert = TableList.ElementAt(value);
Entity_Table tb = t_insert.getList().ElementAt(column_value);
if (tb.getDataArray() == null)
{
ArrayList ColumnData = new ArrayList();
ColumnData.Add(valueD);
tb.setDataArray(ColumnData);
}
else
{
ArrayList Column_Data = tb.getDataArray();
Column_Data.Add(valueD);
tb.setDataArray(Column_Data);
}
}
catch (ArgumentNullException)
{
Console.WriteLine("No se encontro la tabla a insertar");
}
}
}
public void Multi_Elimination(List <Conditions> l, int contador)
{
Tabla temp_table = GetTableName(name_delete);
if (condit.Count != 0)
{
if (contador > 0)
{
int contador_grupo = 0;
Console.WriteLine("ENTROOOOOO");
int v = 0;
while (v < contador)
{
for (int j = 0; j < l.Count; j++)
{
Conditions c_temp = l.ElementAt(v);
Conditions c_temp2 = l.ElementAt(j);
int group = c_temp.getGroup();
int grupo_actual = c_temp2.getGroup();
if (grupo_actual >= group)
{
//positions.Clear();
int temp = Verify_Conditions(v, j, l, temp_table);
contador_grupo += temp;
Console.WriteLine("EL GRUPO VALUADO ES" + temp);
List <Entity_Table> lists = temp_table.getList();
if (temp != 0)
{
Delete_rows(lists);
positions.Clear();
}
v++;
}
}
}
}
else//NO HAY OR'S
{
int temp = Verify_Conditions(0, l.Count(), l, temp_table);
if (temp == condit.Count)
{
List <Entity_Table> lists = temp_table.getList();
Delete_rows(lists);
positions.Clear();
}
else
{
Console.WriteLine("No cumplio todas las Y");
positions.Clear();
}
}
}
else
{
//NADA
}
}
public void Delete_Row(int D_positions, Tabla tmp_t)
{
List <Entity_Table> tb = tmp_t.getList();
for (int i = 0; i < tb.Count; i++)
{
Entity_Table entity = tb.ElementAt(i);
ArrayList a_temp = entity.getDataArray();
a_temp[D_positions] = null;
}
}
/*ELIMINATION METHDOS*/
public void Single_Elimination(String name)
{
if (Flag_Success == true)
{
GetTableInsert(name);
Tabla t = TableList.ElementAt(InsertTable);
for (int i = 0; i < t.getList().Count; i++)
{
Entity_Table entity_temp = t.getList().ElementAt(i);
entity_temp.setDataArray(null);
}
}
}
/*INSERT DATA IN TABLES METHODS*/
public void GetTableInsert(String tableName)
{
if (Flag_Success == true)
{
for (int i = 0; i < TableList.Count; i++)
{
Tabla t = TableList.ElementAt(i);
if (t.getName().ToUpper() == tableName.ToUpper())
{
InsertTable = i;
break;
}
}
}
}
/*CONDICIONCNOES*/
public int Verify_Conditions(int ind, int counter, List <Conditions> c, Tabla temp_table)
{
int temp_counter = 0;
bool Succes = false;
Tabla temp = temp_table;
BackUp = temp;
if (temp != null)
{
for (int index = ind; index < counter; index++)
{
Conditions c_temp = c.ElementAt(index);
Console.WriteLine("se envia" + c_temp.getValue());
String identificador = c_temp.getId();
int Condicion_valor = c_temp.getCondition();
String temp_value = c_temp.getValue();
if (Condicion_valor == 12)
{
temp_counter = Verify_Sub_Conditions_mMi(identificador, Condicion_valor, temp_value, temp, temp_counter);
}
else if (Condicion_valor == 10)//MENOR
{
temp_counter = Verify_Sub_Conditions_mMi(identificador, Condicion_valor, temp_value, temp, temp_counter);
}
else if (Condicion_valor == 11)//MAYOR
{
temp_counter = Verify_Sub_Conditions_mMi(identificador, Condicion_valor, temp_value, temp, temp_counter);
}
else if (Condicion_valor == 13)
{
temp_counter = Verify_Sub_Conditions_mMi(identificador, Condicion_valor, temp_value, temp, temp_counter);
}
else if (Condicion_valor == 14)
{
temp_counter = Verify_Sub_Conditions_mMi(identificador, Condicion_valor, temp_value, temp, temp_counter);
}
else if (Condicion_valor == 15)
{
temp_counter = Verify_Sub_Conditions_mMi(identificador, Condicion_valor, temp_value, temp, temp_counter);
}
}
}
return(temp_counter);
}
public int Verify_Conditions(int counter, List <Conditions> c, Tabla temp_table)
{
int temp_counter = 0;
bool Succes = false;
Tabla temp = temp_table;
BackUp = temp;
if (temp != null)
{
for (int i = 0; i < counter; i++)
{
Conditions c_temp = c.ElementAt(i);
Console.WriteLine("se envia" + c_temp.getValue());
String identificador = c_temp.getId();
int Condicion_valor = c_temp.getCondition();
String temp_value = c_temp.getValue();
if (Condicion_valor == 12)
{/*case "MENOR":
* return 10;
* case "MAYOR":
* return 11;
* case "IGUAL":
* return 12;
* case "MAYOR IGUAL":
* return 13;
* case "MENOR IGUAL":
* return 14;
* case "DISTINTO":
* return 15;*/
Succes = Verify_Sub_Conditions_Equals(identificador, Condicion_valor, temp_value, temp);
if (Succes == true)
{
temp_counter++;
}
}
else if (Condicion_valor == 13)
{
}
}
}
return(temp_counter);
}
public bool Verify_Sub_Conditions_Equals(String id, int c, String t, Tabla tmp_t)
{
bool temp = false;
List <Entity_Table> ls = tmp_t.getList();
for (int i = 0; i < ls.Count; i++)
{
Entity_Table entity_t = ls.ElementAt(i);
if (entity_t.getEntity().ToUpper() == id.ToUpper())
{
ArrayList ar = entity_t.getDataArray();
for (int j = 0; j < ar.Count; j++)
{
if (contadorVerify != 0)
{
if (t == ar[position_D].ToString())
{
return(temp = true);
}
else
{
return(temp = false);
}
}
else
{
if (c == 9)
{
if (t == ar[j].ToString())
{
position_D = j;
contadorVerify++;
return(temp = true);
}
}
}
}
break;
}
}
return(temp);
}
public void CreateColumns()
{
if (Flag_Success == true)
{
String Column = Token_List.ElementAt(Numb_post_analisis - 2).getLexl();
int Type = Token_List.ElementAt(Numb_post_analisis - 1).GetCorr();
Tabla t = TableList.ElementAt(contador - 1);
if (t.getList() == null)
{
List <Entity_Table> Columns = new List <Entity_Table>();
Columns.Add(new Entity_Table(Column, Type, null));
t.SetList(Columns);
}
else
{
List <Entity_Table> Columns = t.getList();
Columns.Add(new Entity_Table(Column, Type, null));
t.SetList(Columns);
}
//Entity_Table tb = TableList.ElementAt(contador).getList();
}
}
public void ImprimirTablas()
{
String html_Content;
String Cabezera_Html;
String Title_Table = "";
String Content_Celda = "";
String Content_Table = "";
Cabezera_Html = "<html>" +
"<link rel=\"stylesheet\" type=\"text/css\" href=\"bootstrap.css\">" +
"<body>";
for (int i = 0; i < TableList.Count; i++)
{
String Columns_Table = "";
Tabla t = TableList.ElementAt(i);
Title_Table = "</br>" + "<h2 align='center'>" + "Tabla" + " " + t.getName() + "</h2></br>" +
"<table cellpadding='10' border = '1' align='center'>";
for (int j = 0; j < t.getList().Count; j++)
{
Entity_Table ts = t.getList().ElementAt(j);
Columns_Table +=
"<td><strong>" + ts.getEntity() +
"</strong></td>";
}
if (t.getList() != null)
{
Content_Celda = tx(t);
}
Content_Table += Title_Table + Columns_Table + "</tr>" + Content_Celda
+ "</table>";
}
html_Content = Cabezera_Html + Content_Table + "</body>" +
"</html>";
File.WriteAllText("Tables.html", html_Content);
System.Diagnostics.Process.Start("Tables.html");
}
public int Verify_Sub_Conditions_mMi(String id, int c, String t, Tabla tmp_t, int con)
{
int contador = con;
if (positions.Count != 0)
{
Console.WriteLine("paso por aca prro");
List <Entity_Table> ls = tmp_t.getList();
for (int i = 0; i < ls.Count; i++)
{
Entity_Table entity_t = ls.ElementAt(i);
if (entity_t.getEntity().ToUpper() == id.ToUpper())
{
ArrayList ar = entity_t.getDataArray();
int postion = int.Parse(positions[0].ToString());
if (ar[postion].Equals(t))
{
Console.WriteLine("EL sdflkasdklajsdkl;R");
contador++;
break;
}
}
}
}
else
{
try
{
ArrayList ar = null;
List <Entity_Table> ls = tmp_t.getList();
for (int i = 0; i < ls.Count; i++)
{
Entity_Table entity_t = ls.ElementAt(i);
if (entity_t.getEntity().ToUpper() == id.ToUpper())
{
ar = entity_t.getDataArray();
break;
}
}
if (ar != null)
{
for (int j = 0; j < ar.Count; j++)
{
if (ar[j].ToString() != "")
{
if (c == 10)//MENOR
{
if (int.Parse(ar[j].ToString()) < int.Parse(t))
{
positions.Add(j);
contador++;
break;
}
}
else if (c == 11)
{//MAYOR
if (int.Parse(ar[j].ToString()) > int.Parse(t))
{
positions.Add(j);
contador++;
break;
}
}
else if (c == 12)//IGUAL
{
if (ar[j].ToString().ToUpper() == t.ToUpper())
{
Console.WriteLine("su cumplioi" + t);
positions.Add(j);
contador++;
break;
}
else
{
Console.WriteLine("su cumplioi" + t);
}
}
else if (c == 13)//MAYOR IGUAL
{
if (int.Parse(ar[j].ToString()) >= int.Parse(t))
{
positions.Add(j);
contador++;
break;
}
}
else if (c == 14)//MENOR IGUAL
{
if (int.Parse(ar[j].ToString()) <= int.Parse(t))
{
positions.Add(j);
contador++;
break;
}
}
else if (c == 15)//DISTINTO
{
if (int.Parse(ar[j].ToString()) != int.Parse(t))
{
positions.Add(j);
contador++;
break;
}
}
else
{
//NADA
}
}
}
}
}
catch (System.FormatException)
{
}
}
return(contador);
}
public void verifyUpdate()
{
Tabla temp_table = GetTableName(name_delete);
}
