public static int GetMaxId()
{
//Session session = new Session();
//session.ConnectionString = XpoDefault.ConnectionString;
// Obtain the persistent object class info required by the GetObjects method
XPClassInfo dstnClass = XpoDefault.Session.GetClassInfo(typeof(DataStore));
// Create criteria to get objects
CriteriaOperator criteria = null; // new BinaryOperator("Discontinued", true);
// Create a sort list if objects must be processed in a specific order
SortingCollection sortProps = null; // new SortingCollection(null);
// sortProps.Add(new SortProperty("Price", DevExpress.Xpo.DB.SortingDirection.Ascending));
// Create criteria patcher to filter out the objects marked as "deleted"
// and to support loading of inherited objects of a given base persistent class
CollectionCriteriaPatcher patcher = new DevExpress.Xpo.Generators.CollectionCriteriaPatcher(false, XpoDefault.Session.TypesManager);
// Call GetObjects
ICollection collection = XpoDefault.Session.GetObjects(dstnClass, criteria, sortProps, 0, patcher, true);
int max = int.MinValue;
// Do processing
foreach (DataStore dstn in collection)
{
max = Math.Max(max, dstn.Id);
}
return(max);
}
private void wizardControl1_FinishClick(object sender, CancelEventArgs e)
{
FinishClicked = true;
{
ParentName = this.parentTreeListLookUpEdit.Text;
{
//Session session = new Session();
//session.ConnectionString = XpoDefault.ConnectionString;
// Obtain the persistent object class info required by the GetObjects method
XPClassInfo dstnClass = XpoDefault.Session.GetClassInfo(typeof(DataStoreTreeNode));
// Create criteria to get objects
CriteriaOperator criteria;
criteria = null; // new BinaryOperator("Discontinued", true);
// Create a sort list if objects must be processed in a specific order
SortingCollection sortProps = null; // new SortingCollection(null);
// sortProps.Add(new SortProperty("Price", DevExpress.Xpo.DB.SortingDirection.Ascending));
// Create criteria patcher to filter out the objects marked as "deleted"
// and to support loading of inherited objects of a given base persistent class
CollectionCriteriaPatcher patcher = new DevExpress.Xpo.Generators.CollectionCriteriaPatcher(false, XpoDefault.Session.TypesManager);
// Call GetObjects
ICollection collection = XpoDefault.Session.GetObjects(dstnClass, criteria, sortProps, 0, patcher, true);
int max = int.MinValue;
// Do processing
foreach (DataStoreTreeNode dstn in collection)
{
max = Math.Max(max, dstn.Id);
}
NewDataStoreTreeNode = new DataStoreTreeNode();
{
NewDataStoreTreeNode.Id = max + 1;
NewDataStoreTreeNode.ParentId = (int)this.parentTreeListLookUpEdit.EditValue;
NewDataStoreTreeNode.IsFolder = isItFolderCheckEdit.Checked;
NewDataStoreTreeNode.Name = this.nameTextEdit.Text;
NewDataStoreTreeNode.SyntaxProvider = this.syntaxProviderComboBoxEdit.SelectedItem as string;
NewDataStoreTreeNode.ConnectionString = this.connectionStringMemoEdit.Text;
NewDataStoreTreeNode.Description = this.descriptionNodeMemoEdit.Text;
NewDataStoreTreeNode.Save();
}
}
}
this.Close();
}