Форум программистов [Powered by Invision Power Board]

Код


        public List<Storage> GetAllStorages()
        {
            if (this.archiveDataSet == null)
                return null;
            DataRowCollection searchedRow = this.archiveDataSet.storage.Rows;

            return this.GetRestPartsOfStorage(searchedRow);
        }

        List<Storage> GetRestPartsOfStorage(DataRowCollection searchedRows)
        {
            if (searchedRows == null || searchedRows.Count == 0)
                return null;

            List<Storage> storages = new List<Storage>();

            foreach (archivefundDataSet.storageRow storRow in searchedRows)
            {
                Storage storage = new Storage();
                storage.ID_Storage = storRow.ID_Storage;
                storage.RegistDate = storRow.RegistDate;
                storage.NoteStorage = storRow.Note;

                if (storRow.laboratoryRow != null)
                {
                    storage.NumberLaboratory = storRow.laboratoryRow.NumberLaboratory;
                }
                else
                {
                    throw new Exception("Cannot find corresponding Laboratory");
                }

                if (storRow.applicantcompanyRow != null)
                {
                    storage.NameCompany = storRow.applicantcompanyRow.NameCompany;
                }
                else
                {
                    throw new Exception("Cannot find corresponding Company");
                }

                DataRow[] testobjectRows = archiveDataSet.testobject.Select("Storage_ID = " + storRow.ID_Storage);                
                
                if (testobjectRows != null && testobjectRows.Length != 0)
                {
                    foreach (archivefundDataSet.testobjectRow testobRow in testobjectRows)
                    {
                        storage.NameTestObject = new List<string>();
                        storage.NameDesign = new List<string>();

                        storage.NameTestObject.Add(testobRow.NameTestObject);
                        storage.NameDesign.Add(testobRow.NameDesign);
                    }
                }
                else
                {
                    throw new Exception("Cannot find corresponding TestObject");
                }

                if (storRow.workcontractRow != null)
                {
                    storage.NumberContract = storRow.workcontractRow.NumberContract;
                    storage.DateContract = storRow.workcontractRow.DateContract;
                }
                else
                {
                    throw new Exception("Cannot find corresponding Contract");
                }
                storages.Add(storage);                
            }
            return storages;