public static Group Save(Group group) { Connection c = conn; Group ret = (Group)c.Save((Org.Reddragonit.Dbpro.Structure.Table)group); c.Commit(); c.CloseConnection(); return ret; }
static void Main(string[] args) { Connection conn = ConnectionPoolManager.GetConnection(typeof(Group)); conn.SelectAll(typeof(Group)); _RunThreadTests(); IDbDataParameter[] pars = new IDbDataParameter[]{ conn.CreateParameter("@Name","Test2"), conn.CreateParameter("@Inherit",false), conn.CreateParameter("@Parent",null), conn.CreateParameter("@ID",(long?)null) }; pars[pars.Length - 1].Direction = ParameterDirection.ReturnValue; conn.ExecuteNonQuery("INSERT INTO RES_GROUP(NAME,INHERIT_PARENT_RIGHTS,PARENT_GROUP_ID) VALUES(@Name,@Inherit,@Parent) RETURNING ID", pars); Console.WriteLine(pars[pars.Length - 1].Value); Group grp = new Group(); grp.Name = "Testing"; grp.ParentGroup = null; grp.Rights = SecurityRight.LoadAll().ToArray(); grp.Save(); Console.WriteLine("Selecting from a Virtual Table..."); grp.Name = "test"; Group.Save(grp); User u = User.Instance(); u.Active=true; u.FirstName="Roger"; u.LastName="Castaldo"; u.Password="******"; u.Type=UserTypes.Normal; u.UserGroup=Group.LoadAllGroups()[0]; u.UserName="******"; u=User.Save(u); conn = ConnectionPoolManager.GetConnection(typeof(User)); foreach (UserGroupList ugl in conn.SelectClassView(typeof(UserGroupList))){ Console.WriteLine("FirstName: "+ugl.FirstName+"\tLastName: "+ugl.LastName+"\tGroup: "+ugl.GroupName); } /*ClassQuery cq =new ClassQuery("TestingApp.Structure","SELECT u.FirstName||' '||u.LastName AS PersonName,u.UserGroup FROM User u WHERE u.UserGroup IN @Groups"); cq.Execute(new IDbDataParameter[]{cq.CreateParameter("@Groups",Group.LoadAllGroups())}); while (cq.Read()){ grp = (Group)cq[1]; Console.WriteLine("Person: " + cq[0].ToString() + " in Group: " + grp.Name); }*/ //XmlDocument doc = new XmlDocument(); //string xml = ReadEmbeddedResource("TestingApp.CompressionTester.xml"); //System.Diagnostics.Debug.WriteLine("Uncompressed Size=" + xml.Length.ToString()); //doc.LoadXml(xml); //byte[] tmp = XMLCompressor.CompressXMLDocument(doc); //System.Diagnostics.Debug.WriteLine("Compressed size=" + tmp.Length.ToString()); //System.Diagnostics.Debug.WriteLine(System.Text.ASCIIEncoding.ASCII.GetString(tmp)); //doc = XMLCompressor.DecompressXMLDocument(new MemoryStream(tmp)); //XmlTextWriter xtw = new XmlTextWriter(new FileStream(".\\results.xml", FileMode.Create, FileAccess.Write, FileShare.None), System.Text.Encoding.ASCII); //doc.WriteContentTo(xtw); //xtw.Flush(); //xtw.Close(); //Thread t = new Thread(new ThreadStart(SecondaryThreadStart)); //t.Start(); /*ConnectionPool pool = ConnectionPoolManager.GetConnection("Security"); Console.WriteLine("Attempting to backup database..."); Stream fs= new FileStream(".\\backuptesting.zip", FileMode.Create, FileAccess.Write, FileShare.None); BackupManager.BackupDataToStream(pool, ref fs); Console.WriteLine("Backup attempt completed successfully..."); /*fs = new FileStream(".\\backuptesting.zip", FileMode.Open, FileAccess.Read, FileShare.None); Console.WriteLine("Attempting to restore database..."); BackupManager.RestoreDataFromStream(pool, ref fs);*/ //Console.WriteLine("Waiting on secondary thread to complete..."); //t.Join();*/ Console.WriteLine("Examine Diagnostics messages."); Console.ReadLine(); }