private void addButton_Click(object sender, EventArgs e) { purchase.Date = sDateTimePicker.Text; purchase.BillNo = billTextBox.Text; purchase.Code = codeTextBox.Text; //purchase.ManufacturedDate = manufacturedDateTextBox.Text; purchase.ExpireDate = eDateTimePicker2.Value.ToString(); purchase.Remarks = remarksTextBox.Text; if (purchase.Date == "" || purchase.BillNo == "") { MessageBox.Show("Please Select Supplier Field.."); return; } if (!CheckIfNumeric(purchase.BillNo)) { MessageBox.Show("Please enter numeric Invoice Number."); billTextBox.Clear(); return; } else if (purchase.BillNo.Length < 4) { MessageBox.Show("Invoice No filed is required minimum 5 digit length"); billTextBox.Clear(); return; } else if (_purchaseManager.IsExistBillNo(billTextBox.Text)) { MessageBox.Show("Invoice No is already exist"); billTextBox.Clear(); return; } try { supplierCombo = supplierComboBox.SelectedValue.ToString(); if (Convert.ToInt32(supplierCombo) <= 0) { MessageBox.Show("Please,, Select any Supplier.."); return; } } catch (Exception excp) { //MessageBox.Show(excp.Message); MessageBox.Show("Please,, Select any Supplier.."); return; } try { categoryCombo = categoryComboBox.SelectedValue.ToString(); if (Convert.ToInt32(categoryCombo) <= 0) { MessageBox.Show("Please,, Select any Category.."); return; } } catch (Exception excp) { //MessageBox.Show(excp.Message); MessageBox.Show("Please,, Select any Category.."); return; } try { productCombo = productComboBox.SelectedValue.ToString(); if (Convert.ToInt32(productCombo) <= 0) { MessageBox.Show("Please,, Select any Product.."); return; } } catch (Exception) { //MessageBox.Show(excp.Message); MessageBox.Show("Please,, Select any Product.."); return; } if (aQuantityTextBox.Text == "" || purchase.ManufacturedDate == "" || purchase.ExpireDate == "" || purchase.Remarks == "" || quantityTextBox.Text == "" || unitPriceTextBox.Text == "" || totalPriceTextBox.Text == "" || MRPTextBox.Text == "") { MessageBox.Show("Please Product field is required.."); return; } if (!CheckIfNumeric(quantityTextBox.Text)) { MessageBox.Show("Please enter numeric Quantity."); codeTextBox.Clear(); return; } if (!CheckIfNumeric(unitPriceTextBox.Text)) { MessageBox.Show("Please enter numeric UnitPrice."); codeTextBox.Clear(); return; } //if (!CheckIfNumeric(MRPTextBox.Text)) //{ // MessageBox.Show("Please enter numeric MRP."); // codeTextBox.Clear(); // return; //} purchase.SupplierId = Convert.ToInt32(supplierComboBox.SelectedValue.ToString()); purchase.CategoryId = Convert.ToInt32(categoryComboBox.SelectedValue.ToString()); purchase.ProductId = Convert.ToInt32(productComboBox.SelectedValue.ToString()); purchase.AvailableQuantity = Convert.ToDouble(aQuantityTextBox.Text); purchase.Quantity = Convert.ToDouble(quantityTextBox.Text); purchase.UnitPrice = Convert.ToDouble(unitPriceTextBox.Text); purchase.TotalPrice = Convert.ToDouble(totalPriceTextBox.Text); //purchase.PreviousUnitPrice = Convert.ToDouble(pUnitPriceTextBox.Text); //purchase.PreviousMRP = Convert.ToDouble(pMRPTextBox.Text); purchase.MRP = Convert.ToDouble(MRPTextBox.Text); purchaseDetails.BillNo = billTextBox.Text; purchaseDetails.CategoryId = Convert.ToInt32(categoryComboBox.SelectedValue.ToString()); purchaseDetails.ProductId = purchase.ProductId = Convert.ToInt32(productComboBox.SelectedValue.ToString()); purchaseDetails.Code = codeTextBox.Text; purchaseDetails.Category = categoryComboBox.Text; purchaseDetails.Product = productComboBox.Text; purchaseDetails.ManufacturedDate = menufactureDateTimePicker1.Value.ToString(); purchaseDetails.ExpireDate = eDateTimePicker2.Value.ToString(); purchaseDetails.Quantity = Convert.ToDouble(quantityTextBox.Text); purchaseDetails.UnitPrice = Convert.ToDouble(unitPriceTextBox.Text); purchaseDetails.TotalPrice = Convert.ToDouble(totalPriceTextBox.Text); purchaseDetails.MRP = Convert.ToDouble(MRPTextBox.Text); purchaseDetails.Remarks = remarksTextBox.Text; if (addButton.Text == "Update") { FalsePurchaseDataGridView(); TrueShowDataGridView(); if (_purchaseManager.UpdatePurchaseItem(purchaseDetails, id)) { MessageBox.Show("Purchase Product Updated Successfully"); //Edit(); List <PurchaseDetails> purchaseViews = _purchaseManager.DisplayPurchaeItem(); showPurchaseDataGridView.DataSource = purchaseViews; SL(); addButton.Text = "Save"; Clear(); return; } else { MessageBox.Show("Purchase Product Not Updated, Check details"); return; } } //if (Convert.ToDouble(aQuantityTextBox.Text) < Convert.ToDouble(quantityTextBox.Text)) //{ // MessageBox.Show("Sorry, there is no more available quantity.."); // return; //} if (_purchaseManager.SavePurchaseItem(purchase)) { FalseShowDataGridView(); TruePurchaseDataGridView(); MessageBox.Show("Successfully Added .."); //List<PurchaseView> purchaseViews = _purchaseManager.DisplayPurchaeItem(); //purchaseDataGridView.DataSource = purchaseViews; //SL(); //Clear(); DataRow dr = dataTable.NewRow(); dr["Product"] = productComboBox.Text; dr["ManufacturedDate"] = menufactureDateTimePicker1.Value.ToString(); dr["ExpireDate"] = eDateTimePicker2.Value.ToString(); dr["Quantity"] = quantityTextBox.Text; dr["UnitPrice"] = unitPriceTextBox.Text; dr["TotalPrice"] = totalPriceTextBox.Text; dr["MRP"] = MRPTextBox.Text; dr["Remarks"] = remarksTextBox.Text; dataTable.Rows.Add(dr); purchaseDataGridView.DataSource = dataTable; total = total + Convert.ToDouble(totalPriceTextBox.Text); //totalLabel.Text = total.ToString(); //for (int i = 0; i < Convert.ToDouble(quantityTextBox.Text); i++) //{ // _purchaseManager.DeletePurchaseProduct(purchase.ProductId); //} string productName = productComboBox.Text; DataTable dtbl = _purchaseManager.CodeSelect(productName); foreach (DataRow dataRow in dtbl.Rows) { double profit = Convert.ToDouble(MRPTextBox.Text) - Convert.ToDouble(unitPriceTextBox.Text); stock.Code = codeTextBox.Text; stock.Product = productComboBox.Text; stock.Category = categoryComboBox.Text; stock.ManufacturedDate = menufactureDateTimePicker1.Value.ToString(); stock.Quantity = Convert.ToDouble(quantityTextBox.Text); stock.UnitPrice = Convert.ToDouble(unitPriceTextBox.Text); stock.MRP = Convert.ToDouble(MRPTextBox.Text); stock.Profit = profit; if (!_purchaseManager.IsStockProductName(productComboBox.Text)) { _purchaseManager.AddStock(stock); } else { _purchaseManager.UpdateStock(stock); } } } else { MessageBox.Show("No purchased,Check purchasing Details.."); } }