jvanhoesen

<Sql TableName="Table1" TableSchemaXml="#CDATA">
        <CDATA name="TableSchemaXml"><![CDATA[<table name="Table1">
  <col name="Field1" type="Int" default="Zero" />
  <col name="Field2" type="NVarChar(10)" />
  <index name="PK_Table1" clustered="true" primary="true" unique="true">
    <col name="Field1" />
    <col name="Field2" />
  </index>
</table>]]></CDATA>
    </Sql>

jvanhoesen

public static IEnumerable<TNode> SelectRecords(params PXDataField[] restricts)
		{
			//Retrieves table structure for specified TNode
			TableHeader tableStructure = PXDatabase.GetTableStructure(typeof(TNode).Name);

			//Should be null if there's no Table, IE if you're using a Synthetic DAC
			if (tableStructure != null)
			{
				List<PXDataField> parameters = new List<PXDataField>();
				IEnumerable<PXDataRecord> selectDel = null;

jvanhoesen

		public static PXCacheExtension[] GetExtensions(TNode row)
		{
			object pxCacheExtensionCollection = AAReflectionHelper.InvokeMethod(PXCacheExtensionCollectionType, null, "GetSlot", PXCacheExtensionCollectionType, new Type[0], new object[] { true });
			object syncRoot = ((ICollection)pxCacheExtensionCollection).SyncRoot;

			PXCacheExtension[] extensions;
			IDictionary<IBqlTable, PXCacheExtension[]> dict = pxCacheExtensionCollection as IDictionary<IBqlTable, PXCacheExtension[]>;

			lock (syncRoot)
			{

jvanhoesen

internal sealed class AAInventoryItemCache : IPrefetchable
    {
        private Dictionary<int, InventoryItem> _InventoryItems = new Dictionary<int, InventoryItem>();

        public void Prefetch()
        {
            _InventoryItems.Clear();

            foreach (InventoryItem item in AACache<InventoryItem>.SelectRecords())
            {

jvanhoesen

		private static CacheStaticInfo _staticInfo;

		private static Type _pXCacheExtensionCollectionType;

		protected static CacheStaticInfo StaticInfo
		{
			get
			{
				if (_staticInfo == null)
				{

jvanhoesen

        //Default implementation
        public void Prefetch()
        {
            _InventoryItems.Clear();

            foreach (InventoryItem item in PXDatabase.SelectRecords<InventoryItem>())
            {
                _InventoryItems[item.InventoryID.Value] = item;
            }
        }

jvanhoesen

			using (MemoryStream zipStream = new MemoryStream())
			{
				zipStream.Seek(0, SeekOrigin.Begin);
        
        //2nd Parameter determines if .Zip is read only
				using (ZipArchive zip = ZipArchive.CreateFrom(zipStream, false))
				{
          //Read or write data 
				}
			}

jvanhoesen

				using (ZipArchive zip = ZipArchive.CreateFrom(zipStream, false))
				{
					using (MemoryStream fileStream = new MemoryStream())
					{
						fileStream.Seek(0, SeekOrigin.Begin);

						file.Write(fileStream);

						fileStream.Seek(0, SeekOrigin.Begin);

jvanhoesen

                    //Retrieving .ZIP file attached to Acumatica document
                    PX.SM.FileInfo fileInfo = uploadFileMaint.GetFile(zipFile);
                    if(fileInfo != null)
                    {
                        //Create a new memory stream from .ZIP file data
                        using (MemoryStream stream = new MemoryStream(fileInfo.BinData))
                        {
                            //Create new instance of ZipArchive to interact with .ZIP file
                            using (ZipArchive zip = ZipArchive.CreateFrom(stream, true))
                            {

jvanhoesen

                                //Iterate through all files and retrieve each files ItemInfo containing it's name 
                                foreach (ZipArchive.ItemInfo info in zip.GetFiles())
                                {
                                    //Use file name to retrieve file from .Zip Archive
                                }