public static AssetInformation getAsset(String assetId)
{
String idColumn = ColumnData.GetName(Net7.Table_assets._base_id);
String query = "SELECT "
+ ColumnData.GetName(Net7.Table_assets._base_id) + ", "
+ ColumnData.GetName(Net7.Table_assets._descr) + ", "
+ ColumnData.GetName(Net7.Table_assets._filename)
+ " FROM "
+ Net7.Tables.assets.ToString()
+ " WHERE "
+ idColumn
+ " = "
+ DB.QueryParameterCharacter + idColumn;
DataTable dataTable = DB.Instance.executeQuery(query, new String[] { idColumn }, new String[] { assetId });
AssetInformation assetInformation = null;
if (dataTable.Rows.Count == 1)
{
DataRow dataRow = dataTable.Rows[0];
assetInformation = new AssetInformation();
assetInformation.base_id = ColumnData.GetInt32(dataRow, Net7.Table_assets._base_id);
assetInformation.descr = ColumnData.GetString(dataRow, Net7.Table_assets._descr);
assetInformation.filename = ColumnData.GetString(dataRow, Net7.Table_assets._filename);
}
return assetInformation;
}
public static AssetInformation getAsset(String assetId)
{
String idColumn = ColumnData.GetName(Net7.Table_assets._base_id);
String query = "SELECT "
+ ColumnData.GetName(Net7.Table_assets._base_id) + ", "
+ ColumnData.GetName(Net7.Table_assets._descr) + ", "
+ ColumnData.GetName(Net7.Table_assets._filename)
+ " FROM "
+ Net7.Tables.assets.ToString()
+ " WHERE "
+ idColumn
+ " = "
+ DB.QueryParameterCharacter + idColumn;
DataTable dataTable = DB.Instance.executeQuery(query, new String[] { idColumn }, new String[] { assetId });
AssetInformation assetInformation = null;
if (dataTable.Rows.Count == 1)
{
DataRow dataRow = dataTable.Rows[0];
assetInformation = new AssetInformation();
assetInformation.base_id = ColumnData.GetInt32(dataRow, Net7.Table_assets._base_id);
assetInformation.descr = ColumnData.GetString(dataRow, Net7.Table_assets._descr);
assetInformation.filename = ColumnData.GetString(dataRow, Net7.Table_assets._filename);
}
return(assetInformation);
}
public static AssetInformation[] getAssetItems(String categoryValue, String subCategoryValue)
{
String categoryColumn = ColumnData.GetName(Net7.Table_assets._main_cat);
String subCategoryColumn = ColumnData.GetName(Net7.Table_assets._sub_cat);
String[] parameters;
String[] values;
List <AssetInformation> valueList = new List <AssetInformation>();
String query = "SELECT "
+ ColumnData.GetName(Net7.Table_assets._base_id) + ", "
+ ColumnData.GetName(Net7.Table_assets._descr) + ", "
+ ColumnData.GetName(Net7.Table_assets._filename)
+ " FROM "
+ Net7.Tables.assets.ToString()
+ " WHERE "
+ categoryColumn
+ " = "
+ DB.QueryParameterCharacter + categoryColumn;
if (subCategoryValue == null)
{
parameters = new String[] { categoryColumn };
values = new String[] { categoryValue };
}
else
{
query += " AND "
+ subCategoryColumn
+ " = "
+ DB.QueryParameterCharacter + subCategoryColumn;
parameters = new String[] { categoryColumn, subCategoryColumn };
values = new String[] { categoryValue, subCategoryValue };
}
query += " ORDER BY "
+ ColumnData.GetName(Net7.Table_assets._filename);
DataTable dataTable = DB.Instance.executeQuery(query, parameters, values);
AssetInformation assetInformation;
foreach (DataRow dataRow in dataTable.Rows)
{
assetInformation = new AssetInformation();
assetInformation.base_id = ColumnData.GetInt32(dataRow, Net7.Table_assets._base_id);
assetInformation.descr = ColumnData.GetString(dataRow, Net7.Table_assets._descr);
assetInformation.filename = ColumnData.GetString(dataRow, Net7.Table_assets._filename);
valueList.Add(assetInformation);
}
return(valueList.ToArray());
}
public static AssetInformation[] getAssetItems(String categoryValue, String subCategoryValue)
{
String categoryColumn = ColumnData.GetName(Net7.Table_assets._main_cat);
String subCategoryColumn = ColumnData.GetName(Net7.Table_assets._sub_cat);
String[] parameters;
String[] values;
List<AssetInformation> valueList = new List<AssetInformation>();
String query = "SELECT "
+ ColumnData.GetName(Net7.Table_assets._base_id) + ", "
+ ColumnData.GetName(Net7.Table_assets._descr) + ", "
+ ColumnData.GetName(Net7.Table_assets._filename)
+ " FROM "
+ Net7.Tables.assets.ToString()
+ " WHERE "
+ categoryColumn
+ " = "
+ DB.QueryParameterCharacter + categoryColumn;
if (subCategoryValue == null)
{
parameters = new String[] { categoryColumn };
values = new String[] { categoryValue };
}
else
{
query += " AND "
+ subCategoryColumn
+ " = "
+ DB.QueryParameterCharacter + subCategoryColumn;
parameters = new String[] { categoryColumn, subCategoryColumn };
values = new String[] { categoryValue, subCategoryValue };
}
query += " ORDER BY "
+ ColumnData.GetName(Net7.Table_assets._filename);
DataTable dataTable = DB.Instance.executeQuery(query, parameters, values);
AssetInformation assetInformation;
foreach (DataRow dataRow in dataTable.Rows)
{
assetInformation = new AssetInformation();
assetInformation.base_id = ColumnData.GetInt32(dataRow, Net7.Table_assets._base_id);
assetInformation.descr = ColumnData.GetString(dataRow, Net7.Table_assets._descr);
assetInformation.filename = ColumnData.GetString(dataRow, Net7.Table_assets._filename);
valueList.Add(assetInformation);
}
return valueList.ToArray();
}