private void grdList_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex < 0) { return; } if (e.ColumnIndex == 5) { captureChange = false; int rowID = e.RowIndex; btnSave.Text = "Update"; cmbProduct.SelectedIndex = cmbProduct.FindStringExact(grdList.Rows[e.RowIndex].Cells[0].Value.ToString()); txtDetails.Text = grdList.Rows[e.RowIndex].Cells[2].Value.ToString(); txtCost.Text = grdList.Rows[e.RowIndex].Cells[3].Value.ToString(); cmbStatus.SelectedIndex = cmbStatus.FindStringExact(grdList.Rows[e.RowIndex].Cells[4].Value.ToString()); DataGridViewRow row = grdList.Rows[rowID]; //get customer bank details BOMDB bomdb = new BOMDB(); List <bomdetail> bomdetails = bomdb.getBOMDetail(grdList.Rows[e.RowIndex].Cells[0].Value.ToString()); grdBOMDetail.Rows.Clear(); int i = 0; foreach (bomdetail bd in bomdetails) { AddBOMDetailRow(); grdBOMDetail.Rows[i].Cells[0].Value = i + 1; //DataGridViewComboBoxCell ComboColumn1 = new DataGridViewComboBoxCell(); //StockItemDB.fillTaxItemGridViewCombo(ComboColumn1,""); //grdBOMDetail.Rows[i].Cells[1] = ComboColumn1; //grdBOMDetail.Rows[i].Cells[1].Value = bd.Name; DataGridViewComboBoxCell ComboColumn1 = new DataGridViewComboBoxCell(); StockItemDB.fillStockItemGridViewCombo(ComboColumn1, ""); grdBOMDetail.Rows[i].Cells[1].Value = bd.StockItemID + "-" + bd.Name; grdBOMDetail.Rows[i].Cells[2].Value = bd.Quantity; grdBOMDetail.Rows[i].Cells[3].Value = bd.PurchasePrice; grdBOMDetail.Rows[i].Cells[4].Value = bd.CustomPrice; i++; } cmbProduct.SelectedIndex = cmbProduct.FindString(grdList.Rows[e.RowIndex].Cells[0].Value.ToString()); cmbProduct.Enabled = false; verifyAndReworkBOMDetailGridRows(); btnSave.Text = "Update"; pnlBOMDetails.Visible = true; pnlBottomActions.Visible = false; captureChange = true; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void addGridListRows() { try { BOMDB bomdb = new BOMDB(); string[] ProductStrArr = prod.Split('-'); string ProdID = ProductStrArr[0]; string ProdName = ProductStrArr[1]; lblProductCode.Text = ProdID; lblProductname.Text = ProdName; bomList = bomdb.getBOMDetail(ProdID); txtProdQuantity.Text = prodQuant.ToString(); int QuantTOPrepare = Convert.ToInt32(txtProdQuantity.Text); lblModelNo.Text = ModelNo; foreach (bomdetail bom in bomList) { string stockID = bom.StockItemID; double totalStock = StockDB.getTotalItemWiseStock(stockID, lblModelNo.Text); grdList.Rows.Add(); grdList.Rows[grdList.Rows.Count - 1].Cells["SINO"].Value = grdList.Rows.Count; grdList.Rows[grdList.Rows.Count - 1].Cells["StockItemID"].Value = bom.StockItemID; grdList.Rows[grdList.Rows.Count - 1].Cells["StockItemName"].Value = bom.Name; grdList.Rows[grdList.Rows.Count - 1].Cells["gModelNo"].Value = "NA"; grdList.Rows[grdList.Rows.Count - 1].Cells["RequiredQuantity"].Value = bom.Quantity * QuantTOPrepare; grdList.Rows[grdList.Rows.Count - 1].Cells["StockQunatity"].Value = totalStock; if ((bom.Quantity * QuantTOPrepare) > totalStock) { grdList.Rows[grdList.Rows.Count - 1].Cells["IssueQuantity"].Value = totalStock; } else { grdList.Rows[grdList.Rows.Count - 1].Cells["IssueQuantity"].Value = bom.Quantity * QuantTOPrepare; } } } catch (Exception ex) { } }