List <MetaEV> getValues(DbConnection connection, string sql)
{
var result = new List <MetaEV>();
if (!string.IsNullOrEmpty(sql))
{
DataTable table = Helper.GetDataTable(connection, sql);
if (table.Columns.Count > 0)
{
foreach (DataRow row in table.Rows)
{
if (!row.IsNull(0))
{
MetaEV value = new MetaEV();
value.Id = row[0].ToString();
value.Val = table.Columns.Count > 1 ? (row.IsNull(1) ? null : row[1].ToString()) : null;
value.ValR = table.Columns.Count > 2 ? (row.IsNull(2) ? null : row[2].ToString()) : null;
value.Css = table.Columns.Count > 3 ? (row.IsNull(3) ? null : row[3].ToString()) : null;
value.Class = table.Columns.Count > 4 ? (row.IsNull(4) ? null : row[4].ToString()) : null;
result.Add(value);
}
}
}
}
return(result);
}
/// <summary>
/// Get the sort value for an enumerated list
/// </summary>
public string GetEnumSortValue(string enumValue, bool useDisplayValue)
{
string result = enumValue;
MetaEnum en = EnumEL;
bool elementSortPosition = (IsSorted && en.UsePosition);
MetaEV value = null;
if (useDisplayValue)
{
value = en.Values.FirstOrDefault(i => i.DisplayValue == enumValue);
}
else
{
value = en.Values.FirstOrDefault(i => i.Id == enumValue);
}
if (value != null)
{
string sortPrefix = elementSortPosition ? string.Format("{0:000000}", en.Values.LastIndexOf(value)) : "";
result = sortPrefix + Report.EnumDisplayValue(en, value.Id);
}
else
{
string sortPrefix = elementSortPosition ? "000000" : "";
result = sortPrefix + result;
}
return(result);
}
/// <summary>
/// Return the display value from the identifer
/// </summary>
public string GetDisplayValue(string id, MetaConnection connection, bool forRestriction = false)
{
var values = ValuesPerConnection ? GetValues(connection) : Values;
MetaEV value = values.FirstOrDefault(i => i.Id == id);
return(value == null ? id : (forRestriction ? value.DisplayRestriction : value.DisplayValue));
}
void updateFinalCssStyle()
{
if (string.IsNullOrEmpty(FinalCssClass) && Element != null && Value != null && Element.IsEnum)
{
MetaEV value = Element.EnumEL.Values.FirstOrDefault(i => i.DisplayValue == Value.ToString());
if (value != null && !string.IsNullOrEmpty(value.Css))
{
FinalCssStyle = value.Css;
}
}
}
public void RefreshEnum(bool checkOnly = false)
{
if (_source == null || !IsDynamic)
{
return;
}
try
{
_error = "";
_information = "";
DbConnection connection = _source.GetOpenConnection();
DataTable table = Helper.GetDataTable(connection, RazorHelper.CompileExecute(Sql, this));
connection.Close();
if (checkOnly)
{
return;
}
Values.Clear();
foreach (DataRow row in table.Rows)
{
if (table.Columns.Count > 0)
{
if (!row.IsNull(0))
{
MetaEV value = new MetaEV();
value.Id = row[0].ToString();
value.Val = table.Columns.Count > 1 ? (row.IsNull(1) ? null : row[1].ToString()) : null;
value.ValR = table.Columns.Count > 2 ? (row.IsNull(2) ? null : row[2].ToString()) : null;
value.Css = table.Columns.Count > 3 ? (row.IsNull(3) ? null : row[3].ToString()) : null;
value.Class = table.Columns.Count > 4 ? (row.IsNull(4) ? null : row[4].ToString()) : null;
Values.Add(value);
}
}
}
_information = string.Format("List refreshed with {0} value(s).", Values.Count);
}
catch (Exception ex)
{
_error = ex.Message;
_information = "Error got when refreshing the values.";
}
_information = Helper.FormatMessage(_information);
UpdateEditorAttributes();
}
public string GetEnumSortValue(string enumValue, bool useDisplayValue)
{
string result = enumValue;
bool elementSortPosition = (IsSorted && MetaColumn.Enum.UsePosition);
MetaEV value = null;
if (useDisplayValue)
{
value = MetaColumn.Enum.Values.FirstOrDefault(i => i.Val == enumValue);
}
else
{
value = MetaColumn.Enum.Values.FirstOrDefault(i => i.Id == enumValue);
}
if (value != null)
{
string sortPrefix = elementSortPosition ? string.Format("{0:000000}", MetaColumn.Enum.Values.LastIndexOf(value)) : "";
result = sortPrefix + value.Val;
}
return(result);
}
public string GetDisplayValue(string id, bool forRestriction = false)
{
MetaEV value = Values.FirstOrDefault(i => i.Id == id);
return(value == null ? id : (forRestriction ? value.DisplayRestriction : value.DisplayValue));
}
public void RefreshEnum(bool checkOnly = false)
{
if (_source == null || !IsDynamic) return;
try
{
_error = "";
_information = "";
DbConnection connection = _source.GetOpenConnection();
DataTable table = Helper.GetDataTable(connection, Sql);
connection.Close();
if (checkOnly) return;
Values.Clear();
foreach (DataRow row in table.Rows)
{
if (table.Columns.Count > 0)
{
if (!row.IsNull(0))
{
MetaEV value = new MetaEV();
value.Id = row[0].ToString();
value.Val = table.Columns.Count > 1 ? (row.IsNull(1) ? "" : row[1].ToString()) : value.Id;
Values.Add(value);
}
}
}
_information = string.Format("List refreshed with {0} value(s).", Values.Count);
}
catch (Exception ex)
{
_error = ex.Message;
_information = "Error got when refreshing the values.";
}
_information = Helper.FormatMessage(_information);
UpdateEditorAttributes();
}
public string GetDisplayValue(string id)
{
MetaEV value = Values.FirstOrDefault(i => i.Id == id);
return(value == null ? id : value.Val);
}