private int getCreatedId() { int createdID = 0; DataToQuerySelect queryData = new DataToQuerySelect(); try { queryData.tableName = "roulettes"; queryData.limit = "1"; List <string> fields = new List <string>(); fields.Add("id"); queryData.fields = fields; FieldsToOrder field = new FieldsToOrder(); List <FieldsToOrder> orderBy = new List <FieldsToOrder>(); field.filedName = "id"; field.orderType = "desc"; orderBy.Add(field); queryData.orderBy = orderBy; dataBaseConnect(); DataTable table = dataBaseSelect(queryData); dataBaseDesconnect(); if (table != null) { createdID = Int32.Parse(findAFieldValueInTable(table, "id", 0)); } } catch { errorInConsult = true; } return(createdID); }
public List <Dictionary <string, string> > ToList() { DataToQuerySelect queryData = new DataToQuerySelect(); List <Dictionary <string, string> > response = new List <Dictionary <string, string> >(); try { queryData.tableName = "roulettes"; List <string> fields = new List <string>(); fields.Add("id"); fields.Add("state_id"); queryData.fields = fields; FieldsToOrder field = new FieldsToOrder(); List <FieldsToOrder> orderBy = new List <FieldsToOrder>(); field.filedName = "id"; field.orderType = "asc"; orderBy.Add(field); queryData.orderBy = orderBy; dataBaseConnect(); DataTable table = dataBaseSelect(queryData); dataBaseDesconnect(); response = getRoulettes(table); } catch { response = null; } return(response); }