private void addCategoryToItem(int itemID, int categoryID) { //categories DataTable dtcategories = xmlData.Select("categoryID = " + categoryID + " and inventoryItemID = " + itemID, "", "data\\" + XmlData.Tables.L_inventoryItemsToCategories.ToString()); if (dtcategories == null) //these values are not in the db { //create new record VoodooPOS.objects.L_inventoryItemsToCategories categoryForItem = new VoodooPOS.objects.L_inventoryItemsToCategories(); categoryForItem.CategoryID = (int)ddCategories.SelectedValue; categoryForItem.InventoryItemID = itemID; xmlData.Insert(categoryForItem, "data\\" + XmlData.Tables.L_inventoryItemsToCategories.ToString()); } }
private void btnSave_Click(object sender, EventArgs e) { try { int quantity = 0; double price = 0; double wholesalePrice = 0; double salePrice = 0; //CashRegister register = (CashRegister)this.ParentForm; newItem = new Voodoo.Objects.InventoryItem(); newItem.ID = 999999; newItem.UPC = txtUpc.Text; newItem.Name = txtName.Text; newItem.Description = txtDescription.Text; newItem.Manufacturer = txtManufacturer.Text; newItem.Color = txtColor.Text; newItem.Model = txtModel.Text; newItem.Status = ddStatus.SelectedText; newItem.OnSale = chbOnSale.Checked; newItem.Active = chbActive.Checked; newItem.DisplayOnWeb = chbDisplayOnWeb.Checked; double.TryParse(txtPrice.Text.Trim(), out price); newItem.Price = price; double.TryParse(txtSalePrice.Text.Trim(), out salePrice); newItem.SalePrice = salePrice; double.TryParse(txtWholesalePrice.Text.Trim(), out wholesalePrice); newItem.WholesalePrice = wholesalePrice; int.TryParse(txtQuantity.Text.Trim(), out quantity); newItem.Quantity = quantity; newItem.Size = txtSize.Text; if (System.IO.File.Exists(txtPicturePath.Text.Trim())) { System.IO.FileInfo picturePath = new System.IO.FileInfo(txtPicturePath.Text.Trim()); string newPicturePath = Application.StartupPath + "\\data\\inventoryImages\\" + picturePath.Name; if (!System.IO.File.Exists(newPicturePath)) { newItem.PicturePath = txtPicturePath.Text.Trim(); if (newItem.PicturePath.Length > 0 && !newItem.PicturePath.ToLower().Contains(Application.StartupPath.ToLower() + "\\data\\inventoryimages"))//copy picture to application path { newItem.PicturePath = Application.StartupPath + "\\data\\inventoryImages\\" + picturePath.Name; if (!System.IO.File.Exists(newItem.PicturePath)) { System.IO.File.Copy(picturePath.FullName, newItem.PicturePath); } } } } newItem.ID = common.AddItemToInventory(newItem); foreach (DataRowView dr in lbCategories.Items) { int categoryID = -1; categoryID = int.Parse(dr["id"].ToString()); //categories DataTable dtcategories = xmlData.Select("categoryID = " + categoryID + " and inventoryItemID = " + newItem.ID, "", "data\\" + XmlData.Tables.L_inventoryItemsToCategories.ToString()); if (dtcategories == null) //these values are not in the db { //create new record VoodooPOS.objects.L_inventoryItemsToCategories categoryForItem = new VoodooPOS.objects.L_inventoryItemsToCategories(); categoryForItem.CategoryID = categoryID; categoryForItem.InventoryItemID = newItem.ID; xmlData.Insert(categoryForItem, "data\\" + XmlData.Tables.L_inventoryItemsToCategories.ToString()); } } this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { Common.WriteToFile(ex); //MessageBox.Show(ex.Message + Environment.NewLine + ex.StackTrace); } }