/// <summary> /// Function to Update values in RejectionInMaster Table /// </summary> /// <param name="rejectioninmasterinfo"></param> public void RejectionInMasterEdit(RejectionInMasterInfo rejectioninmasterinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("RejectionInMasterEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@rejectionInMasterId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.RejectionInMasterId; sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.VoucherNo; sprmparam = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.InvoiceNo; sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.VoucherTypeId; sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.SuffixPrefixId; sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime); sprmparam.Value = rejectioninmasterinfo.Date; sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.LedgerId; sprmparam = sccmd.Parameters.Add("@deliveryNoteMasterId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.DeliveryNoteMasterId; sprmparam = sccmd.Parameters.Add("@pricinglevelId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.PricinglevelId; sprmparam = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.EmployeeId; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.Narration; sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.ExchangeRateId; sprmparam = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.TotalAmount; sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.UserId; sprmparam = sccmd.Parameters.Add("@lrNo", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.LrNo; sprmparam = sccmd.Parameters.Add("@transportationCompany", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.TransportationCompany; sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.FinancialYearId; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function to insert values to RejectionInMaster Table /// </summary> /// <param name="rejectioninmasterinfo"></param> /// <returns></returns> public decimal RejectionInMasterAdd(RejectionInMasterInfo rejectioninmasterinfo) { decimal decIdentity = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("RejectionInMasterAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.VoucherNo; sprmparam = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.InvoiceNo; sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.VoucherTypeId; sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.SuffixPrefixId; sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime); sprmparam.Value = rejectioninmasterinfo.Date; sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.LedgerId; sprmparam = sccmd.Parameters.Add("@deliveryNoteMasterId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.DeliveryNoteMasterId; sprmparam = sccmd.Parameters.Add("@pricinglevelId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.PricinglevelId; sprmparam = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.EmployeeId; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.Narration; sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.ExchangeRateId; sprmparam = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.TotalAmount; sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.UserId; sprmparam = sccmd.Parameters.Add("@lrNo", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.LrNo; sprmparam = sccmd.Parameters.Add("@transportationCompany", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.TransportationCompany; sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam.Value = rejectioninmasterinfo.FinancialYearId; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = rejectioninmasterinfo.Extra2; decIdentity = Convert.ToDecimal(sccmd.ExecuteScalar().ToString()); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return decIdentity; }
/// <summary> /// Function to get particular values from RejectionInMaster table based on the parameter /// </summary> /// <param name="rejectionInMasterId"></param> /// <returns></returns> public RejectionInMasterInfo RejectionInMasterView(decimal rejectionInMasterId) { RejectionInMasterInfo rejectioninmasterinfo = new RejectionInMasterInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("RejectionInMasterView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@rejectionInMasterId", SqlDbType.Decimal); sprmparam.Value = rejectionInMasterId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { rejectioninmasterinfo.RejectionInMasterId = decimal.Parse(sdrreader[0].ToString()); rejectioninmasterinfo.VoucherNo = sdrreader[1].ToString(); rejectioninmasterinfo.InvoiceNo = sdrreader[2].ToString(); rejectioninmasterinfo.VoucherTypeId = decimal.Parse(sdrreader[3].ToString()); rejectioninmasterinfo.SuffixPrefixId = decimal.Parse(sdrreader[4].ToString()); rejectioninmasterinfo.Date = DateTime.Parse(sdrreader[5].ToString()); rejectioninmasterinfo.LedgerId = decimal.Parse(sdrreader[6].ToString()); rejectioninmasterinfo.PricinglevelId = decimal.Parse(sdrreader[7].ToString()); rejectioninmasterinfo.EmployeeId = decimal.Parse(sdrreader[8].ToString()); rejectioninmasterinfo.Narration = sdrreader[9].ToString(); rejectioninmasterinfo.ExchangeRateId = decimal.Parse(sdrreader[10].ToString()); rejectioninmasterinfo.TotalAmount = decimal.Parse(sdrreader[11].ToString()); rejectioninmasterinfo.UserId = decimal.Parse(sdrreader[12].ToString()); rejectioninmasterinfo.LrNo = sdrreader[13].ToString(); rejectioninmasterinfo.TransportationCompany = sdrreader[14].ToString(); rejectioninmasterinfo.FinancialYearId = decimal.Parse(sdrreader[15].ToString()); rejectioninmasterinfo.ExtraDate = DateTime.Parse(sdrreader[16].ToString()); rejectioninmasterinfo.Extra1 = sdrreader[17].ToString(); rejectioninmasterinfo.Extra2 = sdrreader[18].ToString(); rejectioninmasterinfo.DeliveryNoteMasterId = decimal.Parse(sdrreader[19].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return(rejectioninmasterinfo); }
/// <summary> /// Function to get particular values from RejectionInMaster table based on the parameter /// </summary> /// <param name="rejectionInMasterId"></param> /// <returns></returns> public RejectionInMasterInfo RejectionInMasterView(decimal rejectionInMasterId) { RejectionInMasterInfo rejectioninmasterinfo = new RejectionInMasterInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("RejectionInMasterView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@rejectionInMasterId", SqlDbType.Decimal); sprmparam.Value = rejectionInMasterId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { rejectioninmasterinfo.RejectionInMasterId = decimal.Parse(sdrreader[0].ToString()); rejectioninmasterinfo.VoucherNo = sdrreader[1].ToString(); rejectioninmasterinfo.InvoiceNo = sdrreader[2].ToString(); rejectioninmasterinfo.VoucherTypeId = decimal.Parse(sdrreader[3].ToString()); rejectioninmasterinfo.SuffixPrefixId = decimal.Parse(sdrreader[4].ToString()); rejectioninmasterinfo.Date = DateTime.Parse(sdrreader[5].ToString()); rejectioninmasterinfo.LedgerId = decimal.Parse(sdrreader[6].ToString()); rejectioninmasterinfo.PricinglevelId = decimal.Parse(sdrreader[7].ToString()); rejectioninmasterinfo.EmployeeId = decimal.Parse(sdrreader[8].ToString()); rejectioninmasterinfo.Narration = sdrreader[9].ToString(); rejectioninmasterinfo.ExchangeRateId = decimal.Parse(sdrreader[10].ToString()); rejectioninmasterinfo.TotalAmount = decimal.Parse(sdrreader[11].ToString()); rejectioninmasterinfo.UserId = decimal.Parse(sdrreader[12].ToString()); rejectioninmasterinfo.LrNo = sdrreader[13].ToString(); rejectioninmasterinfo.TransportationCompany = sdrreader[14].ToString(); rejectioninmasterinfo.FinancialYearId = decimal.Parse(sdrreader[15].ToString()); rejectioninmasterinfo.ExtraDate = DateTime.Parse(sdrreader[16].ToString()); rejectioninmasterinfo.Extra1 = sdrreader[17].ToString(); rejectioninmasterinfo.Extra2 = sdrreader[18].ToString(); rejectioninmasterinfo.DeliveryNoteMasterId = decimal.Parse(sdrreader[19].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return rejectioninmasterinfo; }
/// <summary> /// Save or edit function /// </summary> public void SaveOrEdit() { SettingsSP spSetting = new SettingsSP(); try { decimal decIdentity = 0; DeliveryNoteMasterSP SpDeliveryNoteMaster = new DeliveryNoteMasterSP(); DeliveryNoteMasterInfo InfoDeliveryNoteMaster = new DeliveryNoteMasterInfo(); InfoDeliveryNoteMaster = SpDeliveryNoteMaster.DeliveryNoteMasterView(Convert.ToDecimal(cmbDeliveryNoteNo.SelectedValue)); RejectionInMasterInfo InfoRejectionInMaster = new RejectionInMasterInfo(); RejectionInDetailsInfo InfoRejectionInDetails = new RejectionInDetailsInfo(); RejectionInDetailsSP SpRejectionInDetails = new RejectionInDetailsSP(); StockPostingInfo InfoStockPosting = new StockPostingInfo(); StockPostingSP SpStockPosting = new StockPostingSP(); if (isAutomatic) { InfoRejectionInMaster.VoucherNo = strVoucherNo; InfoRejectionInMaster.InvoiceNo = txtRejectionInNo.Text; } else { InfoRejectionInMaster.VoucherNo = txtRejectionInNo.Text; InfoRejectionInMaster.InvoiceNo = txtRejectionInNo.Text; } InfoRejectionInMaster.VoucherTypeId = decRejectionInVoucherTypeId; InfoRejectionInMaster.SuffixPrefixId = decRejectionInSuffixPrefixId; InfoRejectionInMaster.Date = DateTime.Parse(txtDate.Text); InfoRejectionInMaster.LedgerId = Convert.ToDecimal(cmbCashorParty.SelectedValue.ToString()); InfoRejectionInMaster.PricinglevelId = cmbPricingLevel.SelectedValue == null ? 0 : Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString()); InfoRejectionInMaster.EmployeeId = cmbSalesMan.SelectedValue == null ? 1 : Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString()); InfoRejectionInMaster.Narration = txtNarration.Text.Trim(); InfoRejectionInMaster.ExchangeRateId = cmbCurrency.SelectedValue == null ? 0 : Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()); InfoRejectionInMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text); InfoRejectionInMaster.UserId = PublicVariables._decCurrentUserId; InfoRejectionInMaster.LrNo = txtLRNo.Text.Trim(); InfoRejectionInMaster.TransportationCompany = txtTransportationCompany.Text.Trim(); InfoRejectionInMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId; InfoRejectionInMaster.Extra1 = string.Empty; InfoRejectionInMaster.Extra2 = string.Empty; InfoRejectionInMaster.DeliveryNoteMasterId = Convert.ToDecimal(cmbDeliveryNoteNo.SelectedValue == null ? "" : cmbDeliveryNoteNo.SelectedValue.ToString()); if (decRejectionInIdToEdit == 0) { decIdentity = spRejectionInMaster.RejectionInMasterAdd(InfoRejectionInMaster); } else { InfoRejectionInMaster.RejectionInMasterId = decRejectionInIdToEdit; spRejectionInMaster.RejectionInMasterEdit(InfoRejectionInMaster); } if (decRejectionInIdToEdit == 0) { InfoRejectionInDetails.RejectionInMasterId = decIdentity; } else { SpRejectionInDetails.DeleteRejectionInDetailsByRejectionInMasterId(decRejectionInIdToEdit); SpStockPosting.DeleteStockPostingByAgnstVouTypeIdAndAgnstVouNo(decRejectionInVoucherTypeId, strVoucherNo); InfoRejectionInDetails.RejectionInMasterId = decRejectionInIdToEdit; } foreach (DataGridViewRow dgvrow in dgvProduct.Rows) { InfoRejectionInDetails.DeliveryNoteDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxDeliveryNoteDetailsId"].Value.ToString()); InfoRejectionInDetails.ProductId = Convert.ToDecimal(dgvrow.Cells["dgvtxtProductId"].Value.ToString()); InfoRejectionInDetails.Qty = Convert.ToDecimal(dgvrow.Cells["dgvtxtQuantity"].Value.ToString()); InfoRejectionInDetails.Rate = Convert.ToDecimal(dgvrow.Cells["dgvtxtRate"].Value.ToString()); InfoRejectionInDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString()); InfoRejectionInDetails.UnitConversionId = Convert.ToDecimal(dgvrow.Cells["dgvtxtUnitConversionId"].Value.ToString());//0;//check InfoRejectionInDetails.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value.ToString()); InfoRejectionInDetails.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value.ToString()); InfoRejectionInDetails.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value.ToString()); InfoRejectionInDetails.Amount = Convert.ToDecimal(dgvrow.Cells["dgvtxtAmount"].Value.ToString()); InfoRejectionInDetails.SlNo = Convert.ToInt32(dgvrow.Cells["dgvtxtSlNo"].Value.ToString()); InfoRejectionInDetails.Extra1 = string.Empty; InfoRejectionInDetails.Extra2 = string.Empty; SpRejectionInDetails.RejectionInDetailsAdd(InfoRejectionInDetails); InfoStockPosting.Date = Convert.ToDateTime(txtDate.Text); InfoStockPosting.VoucherTypeId = InfoDeliveryNoteMaster.VoucherTypeId; InfoStockPosting.VoucherNo = InfoDeliveryNoteMaster.VoucherNo; InfoStockPosting.InvoiceNo = InfoDeliveryNoteMaster.InvoiceNo; InfoStockPosting.ProductId = Convert.ToDecimal(dgvrow.Cells["dgvtxtProductId"].Value.ToString()); InfoStockPosting.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value.ToString()); InfoStockPosting.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString()); InfoStockPosting.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value.ToString()); InfoStockPosting.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value.ToString()); InfoStockPosting.AgainstVoucherTypeId = decRejectionInVoucherTypeId; if (isAutomatic) { InfoStockPosting.AgainstInvoiceNo = txtRejectionInNo.Text; InfoStockPosting.AgainstVoucherNo = strVoucherNo; } else { InfoStockPosting.AgainstInvoiceNo = txtRejectionInNo.Text; InfoStockPosting.AgainstVoucherNo = txtRejectionInNo.Text; } InfoStockPosting.InwardQty = Convert.ToDecimal(dgvrow.Cells["dgvtxtQuantity"].Value.ToString()); InfoStockPosting.OutwardQty = 0; InfoStockPosting.Rate = Convert.ToDecimal(dgvrow.Cells["dgvtxtRate"].Value.ToString()); InfoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId; InfoStockPosting.Extra1 = string.Empty; InfoStockPosting.Extra2 = string.Empty; SpStockPosting.StockPostingAdd(InfoStockPosting); } if (decRejectionInIdToEdit == 0) { Messages.SavedMessage(); if (cbxPrintAfterSave.Checked) { if (spSetting.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decIdentity); } else { Print(decIdentity); } } } else { Messages.UpdatedMessage(); if (cbxPrintAfterSave.Checked) { if (spSetting.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decRejectionInIdToEdit); } else { Print(decRejectionInIdToEdit); } } this.Close(); } } catch (Exception ex) { MessageBox.Show("RI:23" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// function to Rejection In updation /// </summary> public void RejectionInview() { decimal decRejectioInMasterId = 0; try { btnSave.Text = "Update"; btnDelete.Enabled = true; isFromRejectionInRegister = true; RejectionInMasterSP SpRejectionInMaster = new RejectionInMasterSP(); RejectionInMasterInfo InfoRejectionInMaster = new RejectionInMasterInfo(); InfoRejectionInMaster = SpRejectionInMaster.RejectionInMasterView(decRejectionInIdToEdit); DeliveryNoteMasterSP SpDeliveryNoteMaster = new DeliveryNoteMasterSP(); DeliveryNoteMasterInfo InfoDeliveryNoteMaster = new DeliveryNoteMasterInfo(); InfoDeliveryNoteMaster = SpDeliveryNoteMaster.DeliveryNoteMasterView(InfoRejectionInMaster.DeliveryNoteMasterId); strRejectionInVoucherNo = SpRejectionInMaster.GetRejectionInVoucherNo(InfoRejectionInMaster.RejectionInMasterId); decRejectionInVoucherTypeId = InfoRejectionInMaster.VoucherTypeId; decRejectionInSuffixPrefixId = InfoRejectionInMaster.SuffixPrefixId; strVoucherNo = InfoRejectionInMaster.VoucherNo; VoucherTypeSP spVoucherType = new VoucherTypeSP(); isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(decRejectionInVoucherTypeId); if (!isAutomatic) { txtRejectionInNo.ReadOnly = false; txtRejectionInNo.Focus(); } else { txtRejectionInNo.ReadOnly = true; txtDate.Focus(); } txtRejectionInNo.Text = InfoRejectionInMaster.InvoiceNo; txtDate.Text = InfoRejectionInMaster.Date.ToString("dd-MMM-yyyy"); dtpDate.Value = Convert.ToDateTime(txtDate.Text); cmbCashorParty.SelectedValue = InfoRejectionInMaster.LedgerId; cmbVoucherType.SelectedValue = InfoDeliveryNoteMaster.VoucherTypeId; cmbPricingLevel.SelectedValue = InfoRejectionInMaster.PricinglevelId; cmbDeliveryNoteNo.SelectedValue = InfoRejectionInMaster.DeliveryNoteMasterId; cmbSalesMan.SelectedValue = InfoRejectionInMaster.EmployeeId; cmbCurrency.SelectedValue = InfoRejectionInMaster.ExchangeRateId; txtTransportationCompany.Text = InfoRejectionInMaster.TransportationCompany; txtNarration.Text = InfoRejectionInMaster.Narration; txtLRNo.Text = InfoRejectionInMaster.LrNo; txtTotalAmount.Text = Convert.ToString(InfoRejectionInMaster.TotalAmount); RejectionInDetailsSP SpRejectionInDetails = new RejectionInDetailsSP(); DataTable dtblRejectionInDetails = SpRejectionInDetails.RejectionInDetailsViewByRejectionInMasterId(decRejectionInIdToEdit); decRejectioInMasterId = Convert.ToDecimal(dtblRejectionInDetails.Rows[0]["voucherTypeId"].ToString()); VoucherTypeInfo infoVoucherType = new VoucherTypeInfo(); infoVoucherType = spVoucherType.VoucherTypeView(decRejectioInMasterId); this.Text = infoVoucherType.VoucherTypeName; foreach (DataRow drRejectionInDetails in dtblRejectionInDetails.Rows) { isDoCellValueChange = false; DGVGodownComboFill(); dgvProduct.Rows.Add(); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtProductId"].Value = drRejectionInDetails["productId"].ToString(); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxDeliveryNoteDetailsId"].Value = drRejectionInDetails.ItemArray[2].ToString(); AssignProductDefaultValues(dgvProduct.Rows.Count - 1, Convert.ToDecimal(drRejectionInDetails.ItemArray[3].ToString())); DGVBatchComboFill(dgvProduct.Rows.Count - 1, Convert.ToDecimal(drRejectionInDetails.ItemArray[3].ToString())); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtQuantity"].Value = drRejectionInDetails["qty"].ToString(); isDoCellValueChange = true; dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(drRejectionInDetails["unitId"].ToString()); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drRejectionInDetails["unitconversionId"].ToString()); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbGodown"].Value = Convert.ToDecimal(drRejectionInDetails["godownId"].ToString()); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbRack"].Value = Convert.ToDecimal(drRejectionInDetails["rackId"].ToString()); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(drRejectionInDetails["batchId"].ToString()); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtRate"].Value = drRejectionInDetails["rate"].ToString(); dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtAmount"].Value = drRejectionInDetails["amount"].ToString(); dgvProduct.CurrentCell = null; } SerialNo(); CalcTotalAmt(); isDoCellValueChange = true; isDoAfterGridFill = true; isFromRejectionInRegister = false; } catch (Exception ex) { MessageBox.Show("RI:35" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }