public int GetMaxOrder()
{
MenuCommandBuilder menuCommandBuilder = new MenuCommandBuilder();
string query = menuCommandBuilder.GetMaxOrder();
return(DBManager.ExecuteScalar <int>(base.ConnectionHandler, query));
}
public IEnumerable <Menu> GetChildMenu(Guid parentMenuId)
{
MenuCommandBuilder menuCommandBuilder = new MenuCommandBuilder();
SqlCommand query = menuCommandBuilder.GetChildMenu(parentMenuId);
return(DBManager.GetCollection <Menu>(ConnectionHandler, query));
}
public IEnumerable <Menu> GetParentsAndChilds(Guid?congressId)
{
MenuCommandBuilder menuCommandBuilder = new MenuCommandBuilder();
string query = menuCommandBuilder.GetParentsChilds(congressId);
return(DBManager.GetCollection <Menu>(base.ConnectionHandler, query));
}