/// <summary> /// Function to fill the details while calling from register or report /// </summary> public void FillRegisterOrReport() { StockJournalMasterSP spStockJournalMaster = new StockJournalMasterSP(); StockJournalDetailsSP spStockJournalDetails = new StockJournalDetailsSP(); StockJournalMasterInfo infoStockJournalMaster = new StockJournalMasterInfo(); StockJournalDetailsInfo infoStockJournalDetails = new StockJournalDetailsInfo(); AdditionalCostSP spAdditionalCost = new AdditionalCostSP(); VoucherTypeSP spVoucherType = new VoucherTypeSP(); try { isFillMode = true; btnSave.Text = "Update"; cmbFinishedGoods.Enabled = false; txtQty.Enabled = false; btnAdd.Enabled = false; dgvConsumption.Rows.Clear(); dgvProduction.Rows.Clear(); dgvAdditionalCost.Rows.Clear(); DataTable dtblMaster = spStockJournalMaster.StockJournalMasterFillForRegisterOrReport(decStockJournalMasterIdForEdit); StockJournalVoucherTypeId = Convert.ToDecimal(dtblMaster.Rows[0]["voucherTypeId"].ToString()); VoucherTypeInfo infoVoucherType = new VoucherTypeInfo(); infoVoucherType = spVoucherType.VoucherTypeView(StockJournalVoucherTypeId); this.Text = infoVoucherType.VoucherTypeName; txtDate.Text = dtblMaster.Rows[0]["date"].ToString(); strVoucherNo = dtblMaster.Rows[0]["voucherNo"].ToString(); decSuffixPrefixId = Convert.ToDecimal(dtblMaster.Rows[0]["suffixPrefixId"].ToString()); decVoucherTypeId = Convert.ToDecimal(dtblMaster.Rows[0]["voucherTypeId"].ToString()); isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(StockJournalVoucherTypeId); dtpDate.Value = Convert.ToDateTime(txtDate.Text); txtNarration.Text = dtblMaster.Rows[0]["narration"].ToString(); cmbCurrency.SelectedValue = Convert.ToDecimal(dtblMaster.Rows[0]["exchangeRateId"].ToString()); if (dtblMaster.Rows[0]["extra1"].ToString() == "Manufacturing") { rbtnManufacturing.Checked = true; } if (dtblMaster.Rows[0]["extra1"].ToString() == "Transfer") { rbtnTransfer.Checked = true; } if (dtblMaster.Rows[0]["extra1"].ToString() == "Stock Out") { rbtnStockOut.Checked = true; } txtVoucherNo.Text = dtblMaster.Rows[0]["invoiceNo"].ToString(); DataSet dsDetails = spStockJournalDetails.StockJournalDetailsForRegisterOrReport(decStockJournalMasterIdForEdit); DataTable dtblConsumption = dsDetails.Tables[0]; if (dsDetails.Tables[0].Rows.Count > 0) { for (int i = 0; i < dtblConsumption.Rows.Count; i++) { dgvConsumption.Rows.Add(); dgvConsumption.Rows[i].HeaderCell.Value = string.Empty; dgvConsumption.Rows[i].Cells["dgvtxtConsumptionStockJournalDetailsId"].Value = Convert.ToDecimal(dtblConsumption.Rows[i]["stockJournalDetailsId"].ToString()); dgvConsumption.Rows[i].Cells["dgvtxtConsumptionSlNo"].Value = dtblConsumption.Rows[i]["slno"].ToString(); dgvConsumption.Rows[i].Cells["dgvtxtConsumptionBarcode"].Value = dtblConsumption.Rows[i]["barcode"].ToString(); dgvConsumption.Rows[i].Cells["dgvtxtConsumptionProductCode"].Value = dtblConsumption.Rows[i]["productCode"].ToString(); dgvConsumption.Rows[i].Cells["dgvtxtConsumptionProductName"].Value = dtblConsumption.Rows[i]["productName"].ToString(); dgvConsumption.Rows[i].Cells["dgvtxtConsumptionProductId"].Value = dtblConsumption.Rows[i]["productId"].ToString(); IsSetGridValueChange = true; dgvConsumption.Rows[i].Cells["dgvtxtConsumptionQty"].Value = dtblConsumption.Rows[i]["qty"].ToString(); IsSetGridValueChange = false; dgvConsumption.Rows[i].Cells["dgvcmbConsumptionGodown"].Value = Convert.ToDecimal(dtblConsumption.Rows[i]["godownId"].ToString()); dgvConsumption.Rows[i].Cells["dgvcmbConsumptionRack"].Value = Convert.ToDecimal(dtblConsumption.Rows[i]["rackId"].ToString()); if (dtblConsumption.Rows[i]["batchId"] != null && dtblConsumption.Rows[i]["batchId"].ToString() != "0") { dgvConsumption.Rows[i].Cells["dgvcmbConsumptionBatch"].Value = Convert.ToDecimal(dtblConsumption.Rows[i]["batchId"].ToString()); } else { dgvConsumption.Rows[i].Cells["dgvcmbConsumptionBatch"].Value = string.Empty; } IsSetGridValueChange = true; dgvConsumption.Rows[i].Cells["dgvcmbConsumptionunitId"].Value = Convert.ToDecimal(dtblConsumption.Rows[i]["unitId"].ToString()); IsSetGridValueChange = false; dgvConsumption.Rows[i].Cells["dgvtxtConsumptionUnitConversionId"].Value = dtblConsumption.Rows[i]["unitConversionId"].ToString(); dgvConsumption.Rows[i].Cells["dgvtxtConsumptionBarcode"].ReadOnly = true; dgvConsumption.Rows[i].Cells["dgvtxtConsumptionProductCode"].ReadOnly = true; dgvConsumption.Rows[i].Cells["dgvtxtConsumptionProductName"].ReadOnly = true; dgvConsumption.Rows[i].Cells["dgvtxtConsumptionRate"].Value = dtblConsumption.Rows[i]["rate"].ToString(); dgvConsumption.Rows[i].Cells["dgvtxtConsumptionAmount"].Value = dtblConsumption.Rows[i]["amount"].ToString(); dgvConsumption.Rows[i].HeaderCell.Value = ""; } } DataTable dtblProduction = dsDetails.Tables[1]; for (int i = 0; i < dtblProduction.Rows.Count; i++) { dgvProduction.Rows.Add(); dgvProduction.Rows[i].HeaderCell.Value = string.Empty; dgvProduction.Rows[i].Cells["dgvtxtProductionStockJournalDetailsId"].Value = Convert.ToDecimal(dtblProduction.Rows[i]["stockJournalDetailsId"].ToString()); dgvProduction.Rows[i].Cells["dgvtxtProductionSlNo"].Value = dtblProduction.Rows[i]["slno"].ToString(); dgvProduction.Rows[i].Cells["dgvtxtProductionBarcode"].Value = dtblProduction.Rows[i]["barcode"].ToString(); dgvProduction.Rows[i].Cells["dgvtxtProductionProductCode"].Value = dtblProduction.Rows[i]["productCode"].ToString(); dgvProduction.Rows[i].Cells["dgvtxtProductionProductName"].Value = dtblProduction.Rows[i]["productName"].ToString(); dgvProduction.Rows[i].Cells["dgvtxtProductionProductId"].Value = dtblProduction.Rows[i]["productId"].ToString(); IsSetGridValueChange = true; dgvProduction.Rows[i].Cells["dgvtxtProductionQty"].Value = dtblProduction.Rows[i]["qty"].ToString(); IsSetGridValueChange = false; if (rbtnManufacturing.Checked) { cmbFinishedGoods.SelectedValue = dgvProduction.Rows[i].Cells["dgvtxtProductionProductId"].Value; if (cmbFinishedGoods.SelectedValue != null) { cmbFinishedGoods.Enabled = true; txtQty.Enabled = true; btnAdd.Enabled = true; txtQty.Text = dtblProduction.Rows[i]["qty"].ToString(); } } dgvProduction.Rows[i].Cells["dgvcmbProductionGodown"].Value = Convert.ToDecimal(dtblProduction.Rows[i]["godownId"].ToString()); dgvProduction.Rows[i].Cells["dgvcmbProductionRack"].Value = Convert.ToDecimal(dtblProduction.Rows[i]["rackId"].ToString()); if (dtblProduction.Rows[i]["batchId"] != null && dtblProduction.Rows[i]["batchId"].ToString() != string.Empty) { dgvProduction.Rows[i].Cells["dgvcmbProductionBatch"].Value = Convert.ToDecimal(dtblProduction.Rows[i]["batchId"].ToString()); } else { dgvProduction.Rows[i].Cells["dgvcmbProductionBatch"].Value = string.Empty; } IsSetGridValueChange = true; dgvProduction.Rows[i].Cells["dgvcmbProductionunitId"].Value = Convert.ToDecimal(dtblProduction.Rows[i]["unitId"].ToString()); IsSetGridValueChange = false; dgvProduction.Rows[i].Cells["dgvtxtProductionUnitConversionId"].Value = dtblProduction.Rows[i]["unitConversionId"].ToString(); dgvProduction.Rows[i].Cells["dgvtxtProductionBarcode"].ReadOnly = true; dgvProduction.Rows[i].Cells["dgvtxtProductionProductCode"].ReadOnly = true; dgvProduction.Rows[i].Cells["dgvtxtProductionProductName"].ReadOnly = true; dgvProduction.Rows[i].Cells["dgvtxtProductionRate"].Value = dtblProduction.Rows[i]["rate"].ToString(); dgvProduction.Rows[i].Cells["dgvtxtProductionAmount"].Value = dtblProduction.Rows[i]["amount"].ToString(); } DataSet dsAdditionalCost = spAdditionalCost.StockJournalAdditionalCostForRegisteOrReport(strVoucherNo, decVoucherTypeId); if (dsAdditionalCost.Tables[0].Rows.Count > 0) { DataTable dtblCashOrBank = dsAdditionalCost.Tables[0]; cmbCashOrBank.SelectedValue = Convert.ToDecimal(dtblCashOrBank.Rows[0]["ledgerId"]); } if (dsAdditionalCost.Tables[1].Rows.Count > 0) { DataTable dtblIndirectExpenses = dsAdditionalCost.Tables[1]; int inRowIndexAdditional = 0; for (int i = 0; i < dtblIndirectExpenses.Rows.Count; i++) { dgvAdditionalCost.Rows.Add(); dgvAdditionalCost.Rows[i].HeaderCell.Value = string.Empty; dgvAdditionalCost.Rows[i].Cells["dgvtxtAdditionalCostSlNo"].Value = ++inRowIndexAdditional; dgvAdditionalCost.Rows[i].Cells["dgvcmbAdditionalCostLedger"].Value = Convert.ToDecimal(dtblIndirectExpenses.Rows[i]["ledgerId"].ToString()); dgvAdditionalCost.Rows[i].Cells["dgvtxtAdditionalCostAmount"].Value = dtblIndirectExpenses.Rows[i]["debit"].ToString(); } } grandTotalAmountCalculationConsumption(); grandTotalAmountCalculationProduction(); TotalAdditionalCostAmount(); btnDelete.Enabled = true; if (isAutomatic) { txtVoucherNo.ReadOnly = true; } else { txtVoucherNo.ReadOnly = false; } gbxTransactionType.Enabled = false; isFillMode = false; } catch (Exception ex) { MessageBox.Show("SJ:50" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }