public void CopyProducts() { List<Product> products = new List<Product>(); Hashtable suppliers = new Hashtable(); Hashtable categories = new Hashtable(); //Processing Products LogMessage("Reading Products...", false); ProductsTableAdapter adapter1 = new ProductsTableAdapter(); NorthwindDb4o.NorthwindDataSet.ProductsDataTable table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (NorthwindDb4o.NorthwindDataSet.ProductsRow row in table1) { Product p = new Product(); p.ProductID = row.ProductID; p.ProductName = row.ProductName; if (!row.IsSupplierIDNull()) suppliers.Add(p.ProductID, row.SupplierID); if (!row.IsCategoryIDNull()) categories.Add(p.ProductID, row.CategoryID); p.QuantityPerUnit = row.IsQuantityPerUnitNull() ? null : row.QuantityPerUnit; p.UnitPrice = row.IsUnitPriceNull() ? 0 : Convert.ToDouble(row.UnitPrice); p.UnitsInStock = row.IsUnitsInStockNull() ? 0 : row.UnitsInStock; p.UnitsOnOrder = row.IsUnitsOnOrderNull() ? 0 : row.UnitsOnOrder; p.ReorderLevel = row.IsReorderLevelNull() ? 0 : row.ReorderLevel; p.Discontinued = row.Discontinued; products.Add(p); } foreach (Product p in products) { LogMessage("Product: " + p.ProductID.ToString() + " ...", false); if (suppliers.ContainsKey(p.ProductID)) { LogMessage("linking member...", false); long supplierID = Convert.ToInt64(suppliers[p.ProductID]); Supplier found = (Supplier)Db4oUtil.GetByNumericalID(container, typeof(Supplier), "supplierID", supplierID); p.SupplierID = found; } if (categories.ContainsKey(p.ProductID)) { LogMessage("linking member...", false); long categoryID = Convert.ToInt64(categories[p.ProductID]); Category found = (Category)Db4oUtil.GetByNumericalID(container, typeof(Category), "categoryID", categoryID); p.CategoryID = found; } container.Store(p); LogMessage("saved (" + p.ProductID.ToString() + ")", true); } container.Commit(); long objectCount = Db4oUtil.GetAllInstances(container, typeof(Product)).Count; if (table1.Count == objectCount) LogMessage(table1.Count + " objects saved", true); else LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true); LogMessage("Done with Products" + Environment.NewLine, true); }
private void printDocument1_BeginPrint(object sender, System.Drawing.Printing.PrintEventArgs e) { sayfaNo = 1; printLabel.Text = string.Empty; printLabel.Visible = true; printProgress.Value = int.Parse(sayfaNo.ToString()); printProgress.Maximum = int.Parse(toplamSayfa.ToString()); printProgress.Minimum = printProgress.Value; printProgress.Visible = true; //Veriler = new List<ProductClass>(); using (ProductsTableAdapter ta = new ProductsTableAdapter()) { var dt = ta.GetData(); //Veriler = dt.Select(x => new ProductClass() //{ // ProductID = x.ProductID.ToString(), // ProductName = x.ProductName, // UnitPrice = x.UnitPrice.ToString(), // UnitsInStock = x.UnitsInStock.ToString(), // TotalPrice = x.TotalPrice.ToString() //}).ToList(); Bitmap bm = new Bitmap(100, 100); Graphics g = Graphics.FromImage(bm); Veriler = (from x in dt select new ProductClass() { ProductID = x.ProductID.ToString(), ProductIDWidth = g.MeasureString(x.ProductID.ToString(), f).Width + 5, ProductName = x.ProductName, ProductNameWidth = g.MeasureString(x.ProductName, f).Width + 5, UnitPrice = x.UnitPrice.ToString("N2"), UnitPriceWidth = g.MeasureString(x.UnitPrice.ToString("N2"), f).Width + 5, UnitsInStock = x.UnitsInStock.ToString(), UnitsInStockWidth = g.MeasureString(x.UnitsInStock.ToString(), f).Width + 5, TotalPrice = x.TotalPrice.ToString("N2"), TotalPriceWidth = g.MeasureString(x.TotalPrice.ToString("N2"), f).Width + 5, }).ToList(); KolonGenislikleri.Clear(); KolonGenislikleri.Add("ProductID", g.MeasureString("Product ID ", f).Width + 5); KolonGenislikleri.Add("ProductName", g.MeasureString("Product Name ", f).Width + 5); KolonGenislikleri.Add("UnitPrice", g.MeasureString("Unit Price ", f).Width + 5); KolonGenislikleri.Add("UnitsInStock", g.MeasureString("Units In Stock ", f).Width + 5); KolonGenislikleri.Add("TotalPrice", g.MeasureString("Total Price ", f).Width + 5); float ff = Veriler.Max(x => x.ProductIDWidth); if (KolonGenislikleri["ProductID"] < ff) KolonGenislikleri["ProductID"] = ff; ff = Veriler.Max(x => x.ProductNameWidth); if (KolonGenislikleri["ProductName"] < ff) KolonGenislikleri["ProductName"] = ff; ff = Veriler.Max(x => x.UnitPriceWidth); if (KolonGenislikleri["UnitPrice"] < ff) KolonGenislikleri["UnitPrice"] = ff; ff = Veriler.Max(x => x.UnitsInStockWidth); if (KolonGenislikleri["UnitsInStock"] < ff) KolonGenislikleri["UnitsInStock"] = ff; ff = Veriler.Max(x => x.TotalPriceWidth); if (KolonGenislikleri["TotalPrice"] < ff) KolonGenislikleri["TotalPrice"] = ff; satirYuksekligi = g.MeasureString("ĞÖİ纪Çygğ", f).Height; } }
private void CopyProducts(IOdb odb) { var products = new List<Product>(); var suppliers = new Hashtable(); var categories = new Hashtable(); //Processing Products LogMessage("Reading Products...", false); var adapter1 = new ProductsTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { var p = new Product { ProductID = row.ProductID, ProductName = row.ProductName, QuantityPerUnit = row.IsQuantityPerUnitNull() ? null : row.QuantityPerUnit, UnitPrice = row.IsUnitPriceNull() ? 0 : Convert.ToDouble(row.UnitPrice), UnitsInStock = row.IsUnitsInStockNull() ? 0 : row.UnitsInStock, UnitsOnOrder = row.IsUnitsOnOrderNull() ? 0 : row.UnitsOnOrder, ReorderLevel = row.IsReorderLevelNull() ? 0 : row.ReorderLevel, Discontinued = row.Discontinued }; if (!row.IsSupplierIDNull()) suppliers.Add(p.ProductID, row.SupplierID); if (!row.IsCategoryIDNull()) categories.Add(p.ProductID, row.CategoryID); products.Add(p); } foreach (var p in products) { LogMessage("Product: " + p.ProductID.ToString() + " ...", false); if (suppliers.ContainsKey(p.ProductID)) { LogMessage("linking member...", false); var supplierID = Convert.ToInt64(suppliers[p.ProductID]); var found = NDbUtil.GetByNumericalID<Supplier>(odb, Supplier.PK, supplierID); p.Supplier = found; } if (categories.ContainsKey(p.ProductID)) { LogMessage("linking member...", false); var categoryID = Convert.ToInt64(categories[p.ProductID]); var found = NDbUtil.GetByNumericalID<Category>(odb, Category.PK, categoryID); p.Category = found; } odb.Store(p); LogMessage("saved (" + p.ProductID.ToString() + ")", true); } odb.Commit(); LogMessage("Commit done, starting create index ...", false); odb.IndexManagerFor<Product>().AddUniqueIndexOn("Product_ProductID_PK_index", Product.PK); odb.Commit(); LogMessage(" index created.", true); long objectCount = NDbUtil.GetAllInstances<Product>(odb).Count; if (table1.Count == objectCount) LogMessage(table1.Count + " objects saved", true); else LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true); LogMessage("Done with Products" + Environment.NewLine, true); }
private void CopyProducts(IOdb odb) { var products = new List <Product>(); var suppliers = new Hashtable(); var categories = new Hashtable(); //Processing Products LogMessage("Reading Products...", false); var adapter1 = new ProductsTableAdapter(); var table1 = adapter1.GetData(); LogMessage("processing " + table1.Count.ToString() + " rows", true); foreach (var row in table1) { var p = new Product { ProductID = row.ProductID, ProductName = row.ProductName, QuantityPerUnit = row.IsQuantityPerUnitNull() ? null : row.QuantityPerUnit, UnitPrice = row.IsUnitPriceNull() ? 0 : Convert.ToDouble(row.UnitPrice), UnitsInStock = row.IsUnitsInStockNull() ? 0 : row.UnitsInStock, UnitsOnOrder = row.IsUnitsOnOrderNull() ? 0 : row.UnitsOnOrder, ReorderLevel = row.IsReorderLevelNull() ? 0 : row.ReorderLevel, Discontinued = row.Discontinued }; if (!row.IsSupplierIDNull()) { suppliers.Add(p.ProductID, row.SupplierID); } if (!row.IsCategoryIDNull()) { categories.Add(p.ProductID, row.CategoryID); } products.Add(p); } foreach (var p in products) { LogMessage("Product: " + p.ProductID.ToString() + " ...", false); if (suppliers.ContainsKey(p.ProductID)) { LogMessage("linking member...", false); var supplierID = Convert.ToInt64(suppliers[p.ProductID]); var found = NDbUtil.GetByNumericalID <Supplier>(odb, Supplier.PK, supplierID); p.Supplier = found; } if (categories.ContainsKey(p.ProductID)) { LogMessage("linking member...", false); var categoryID = Convert.ToInt64(categories[p.ProductID]); var found = NDbUtil.GetByNumericalID <Category>(odb, Category.PK, categoryID); p.Category = found; } odb.Store(p); LogMessage("saved (" + p.ProductID.ToString() + ")", true); } odb.Commit(); LogMessage("Commit done, starting create index ...", false); odb.IndexManagerFor <Product>().AddUniqueIndexOn("Product_ProductID_PK_index", Product.PK); odb.Commit(); LogMessage(" index created.", true); long objectCount = NDbUtil.GetAllInstances <Product>(odb).Count; if (table1.Count == objectCount) { LogMessage(table1.Count + " objects saved", true); } else { LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true); } LogMessage("Done with Products" + Environment.NewLine, true); }