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(); }