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);
}
