private void CreateCD(DumpingProperty dumpingProperty)
        {
            CollectionDescription collectionDescription = new CollectionDescription();
            Guid g = Guid.NewGuid();

            collectionDescription.Id      = g.ToString();
            collectionDescription.Dataset = dataset;
            DumpingPropertyCollection propertyCollection = new DumpingPropertyCollection();

            collectionDescription.PropertyCollection = propertyCollection;
            collectionDescription.PropertyCollection.DumpingProperties.Add(dumpingProperty);
            collectionDescriptions.Add(collectionDescription);
        }
 public CollectionDescription()
 {
     this.id                 = Id;
     this.dataset            = Dataset;
     this.propertyCollection = PropertyCollection;
 }
        public void SetDataToDumpingBuffer()
        {
            databaseDB.Create();
            databaseDB.Connect();
            using (sw)
            {
                propertyCollection    = new DumpingPropertyCollection();
                collectionDescription = new CollectionDescription();

                while (count < 10)
                {
                    sw.WriteLine("******************************************");


                    code  = writer.WriteToDumpinBuffer().code;
                    value = writer.WriteToDumpinBuffer().value;

                    sw.WriteLine("CODE: " + code);
                    sw.WriteLine("VALUE:" + value);

                    Console.WriteLine("******************");
                    Console.WriteLine("DumpingBuffer code: " + code);
                    Console.WriteLine("DumpingBuffer value:" + value);
                    DumpingProperty dumpingProperty = new DumpingProperty();
                    dumpingProperty.Code         = code;
                    dumpingProperty.DumpingValue = value;

                    dataset = GetDataset(code);
                    //ako ne postoji nijedan cd
                    if (collectionDescriptions.Count == 0)
                    {
                        CreateCD(dumpingProperty);//kreiramo
                        databaseDB.WriteToDatabase();
                    }
                    else
                    {
                        foreach (CollectionDescription cd in collectionDescriptions.ToList())
                        {
                            //da li u CDs postoji CD sa tim dataset-om
                            if (cd.Dataset == dataset)//ako postoji
                            {
                                isDatasetExist = true;
                                foreach (DumpingProperty dp in cd.PropertyCollection.DumpingProperties.ToList())
                                {
                                    if (dp.Code == code)//provera da li postoji taj code
                                    {
                                        isEqualsCode    = true;
                                        dp.DumpingValue = value;//ako postoji, azuruiranje vrednosti
                                        databaseDB.WriteToDatabase();
                                    }
                                }
                                if (!isEqualsCode)
                                {
                                    cd.PropertyCollection.DumpingProperties.Add(dumpingProperty);//ako ne, dodajemo
                                    databaseDB.WriteToDatabase();
                                    if (deltaCDs.Count() == 0)
                                    {
                                        DeltaCD deltaCD = new DeltaCD();
                                        deltaCD.TranscationID            = ++trId;
                                        deltaCD.CollectionDescriptionAdd = cd;
                                        collectionDescriptions.Remove(cd);
                                        deltaCDs.Add(deltaCD);
                                    }
                                }
                            }
                        }
                        //ako ne postoji CD, napravimo ga
                        if (!isDatasetExist)
                        {
                            CreateCD(dumpingProperty);
                            databaseDB.WriteToDatabase();
                        }
                        isDatasetExist = false;
                        isEqualsCode   = false;
                    }
                    count++;

                    Read();

                    if (count == 10)
                    {
                        if (deltaCDs.Count == 0)
                        {
                            count = 0;
                        }
                    }
                    Thread.Sleep(2000);
                }

                count = 0;
            }

            databaseDB.sqlConnection.Close();
        }