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 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 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; } }
public void Delete_rows(List <Entity_Table> ls) { for (int z = 0; z < positions.Count; z++) { for (int i = 0; i < ls.Count; i++) { Entity_Table entity_t = ls.ElementAt(i); ArrayList ar = entity_t.getDataArray(); for (int j = 0; j < ar.Count; j++) { if (positions[z].Equals(j)) { ar[j] = ""; } } } } }
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 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); }