/// <summary>
/// Loads the data and data bind.
/// </summary>
private void LoadDataAndDataBind()
{
MyListView.CurrentListView.PrimaryKeyId = EcfListView.MakePrimaryKeyIdString("MenuItemId", "MenuId", "IsRoot");
DataTable dtSource = null;
if (MenuItemId == 0)
{
IDataReader reader = mc.MenuItem.LoadAllRoot(SiteId);
dtSource = ManagementHelper.ConvertToTable(reader);
reader.Close();
}
else
{
DataTable menuTable = mc.MenuItem.LoadSubMenuDT(MenuItemId);
foreach (DataRow row in menuTable.Rows)
{
int itemId = (int)row["MenuItemId"];
using (IDataReader reader = mc.MenuItem.LoadById(itemId, LanguageId))
{
if (reader.Read())
{
row["Text"] = reader["Text"];
}
else
{
row["Text"] = "<span style='color:red;'>no localized version</span>";
}
reader.Close();
}
}
menuTable.Columns.Add(new DataColumn("IsDirectory", typeof(bool)));
using (IDataReader par = mc.MenuItem.LoadParent(MenuItemId))
{
if (par.Read())
{
DataRow newRow = menuTable.NewRow();
newRow["Text"] = "[..]";
newRow["MenuItemId"] = (int)par["MenuItemId"];
newRow["Order"] = -1;
newRow["IsDirectory"] = true;
menuTable.Rows.InsertAt(newRow, 0);
}
par.Close();
}
dtSource = menuTable;
}
if (dtSource != null)
{
MyListView.DataSource = dtSource;
}
DataBind();
}
/// <summary>
/// Loads the data and data bind.
/// </summary>
/// <param name="sortExpression">The sort expression.</param>
private void LoadDataAndDataBind(string sortExpression)
{
IDataReader reader = mc.WorkflowStatus.LoadByWorkflowId(WorkflowId);
DataTable table = ManagementHelper.ConvertToTable(reader);
reader.Close();
MyListView.DataSource = table.DefaultView;
if (table != null)
{
DataView view = table.DefaultView;
view.Sort = sortExpression;
MyListView.DataSource = view;
}
MyListView.CurrentListView.PrimaryKeyId = EcfListView.MakePrimaryKeyIdString("StatusId");
MyListView.DataBind();
}