private void btnSave_Click(object sender, EventArgs e) { itemRow.itemID = txtItemID.Text; itemRow.name = txtItemName.Text; itemRow.limitQuantity = Int32.Parse(txtLimit.Text); itemRow.unitOfMeasurement = txtUnitOfMesasure.Text; //######### double purchasePrice; bool res1 = Double.TryParse(txtPurchacePrice.Text, out purchasePrice); if (res1 == false) { MessageBox.Show("please Fill the purchase price"); } else { itemRow.purchase_price = (float)purchasePrice; } itemRow.suppliedBy = "ss"; itemRow.unitOfMeasurement = txtUnitOfMesasure.Text; //setting category id String cid = Util.getCategoryID("ItemCategory", comboItemcategories.Text); MessageBox.Show(cid); itemRow.categoryID = cid; itemRow.image = Util.convertImageToBinary(picBocitempic.Image); using (DBEntities db = new DBEntities()) { if (operation == "insert") { db.Items.Add(itemRow); MessageBox.Show("Item Added Successfully"); } else if (operation == "update") { db.Entry(itemRow).State = EntityState.Modified; MessageBox.Show("Item details Updated Successfully"); } db.SaveChanges(); } StockManagement sm = StockManagement.getInstance(); sm.clearItemList(); sm.loadKitchenItems(); this.Hide(); sm.Show(); }//end of save method
//Adding Item to the Data Base ----------------------- private void btnSaveFoodItem_Click(object sender, EventArgs e) { if (status == "food") //adding meal/food details { //getting the user entered value food.foodCode = txtID.Text; food.name = txtName.Text; food.description = txtDescription.Text; //setting selling price double sellingPrice; bool result1 = Double.TryParse(txtSellingPrice.Text, out sellingPrice); if (result1 == false) { MessageBox.Show("Please enter Selling price"); } else { food.sellingPrice = (float)sellingPrice; } //setting discount rate double discountRate; bool result2 = Double.TryParse(txtDiscountRate.Text, out discountRate); if (result2 == false) { MessageBox.Show("Please enter Discount Rate"); } else { food.disountRate = (float)discountRate; } //setting category id String cid = Util.getCategoryID("FoodCategory", comboCategory.Text); food.categoryID = cid; //setting Image food.foodImage = Util.convertImageToBinary(picBoxImage.Image); //****** saving informations to the database using (DBEntities db = new DBEntities()) { if (operation == "save") { db.Foods.Add(food); MessageBox.Show("Meal/Food Item Added Successfully!!!"); } else if (operation == "update") { //updating the database db.Entry(food).State = EntityState.Modified; MessageBox.Show("Food details Updated Successfully"); } db.SaveChanges(); clear(); } } else if (status == "readyMade") //addimng a readymade product details { //setting values to the row object itemModel.itemID = txtID.Text; itemModel.name = txtName.Text; //setting purchase price double purchaseprice; bool result3 = Double.TryParse(txtFoodPurchasePrice.Text, out purchaseprice); if (result3 == false) { MessageBox.Show("Please enter Purchase price"); } else { itemModel.purchase_price = (float)purchaseprice; } itemModel.suppliedBy = null; //this shold be implemented After adding supplier table itemModel.limitQuantity = Int32.Parse(textReadymadeLimitQuantity.Text); //setting category id String cid = Util.getCategoryID("ItemCategory", comboCategory.Text); itemModel.categoryID = cid; //setting Image itemModel.image = Util.convertImageToBinary(picBoxImage.Image); //************* details adding to readyMAde product table * readymaddModel.productID = txtID.Text; //setting selling price of the product double productSellPrice; bool result4 = Double.TryParse(txtReadyMadeSellingPrice.Text, out productSellPrice); if (result4 == false) { MessageBox.Show("Please enter Selling price of the product"); } else { readymaddModel.sellingPrice = (float)productSellPrice; } //************* using (DBEntities db = new DBEntities()) { db.Items.Add(itemModel); db.ReadyMadeProducts.Add(readymaddModel); db.SaveChanges(); MessageBox.Show("Ready Made product Added Successfully"); clear(); } } else { MessageBox.Show("Cannot identify !!! (rm or Food) "); } FoodManagement fm = FoodManagement.getInstance(); fm.clearFoodcardpanel(); fm.loadFoodItemCards(); this.Hide(); fm.Show(); } // --------------------------------------------------------------------------------------------