/// <summary> /// Function to use to fill details to updation when comes register or report /// </summary> public void FillRegisterOrReport() { try { SalesQuotationMasterInfo infoSalesQuotationMaster = new SalesQuotationMasterInfo(); SalesOrderMasterInfo infoSalesOrderMaster = new SalesOrderMasterInfo(); SalesOrderBll bllSalesOrder = new SalesOrderBll(); isValueChange = false; btnSave.Text = "Update"; btnDelete.Enabled = true; txtOrderNo.ReadOnly = true; infoSalesOrderMaster = bllSalesOrder.SalesOrderMasterView(decSalesOrderMasterId); txtOrderNo.Text = infoSalesOrderMaster.InvoiceNo; strVoucherNo = infoSalesOrderMaster.VoucherNo.ToString(); decSalesSuffixPrefixId = Convert.ToDecimal(infoSalesOrderMaster.SuffixPrefixId); decSalesVoucherId = Convert.ToDecimal(infoSalesOrderMaster.VoucherTypeId); isAutomatic = new VoucherTypeBll().CheckMethodOfVoucherNumbering(decSalesVoucherId); decSalesOrderTypeId = decSalesVoucherId; txtDate.Text = infoSalesOrderMaster.Date.ToString("dd-MMM-yyyy"); cmbCashOrParty.SelectedValue = infoSalesOrderMaster.LedgerId; decSalesOrderVoucherTypeId = infoSalesOrderMaster.VoucherTypeId; VoucherTypeInfo infoVoucherType = new VoucherTypeInfo(); VoucherTypeBll BllVoucherType = new VoucherTypeBll(); infoVoucherType = BllVoucherType.VoucherTypeView(decSalesOrderVoucherTypeId); string strVoucherTypeName = infoVoucherType.VoucherTypeName; this.Text = strVoucherTypeName; if (infoSalesOrderMaster.QuotationMasterId == 0) { cmbType.SelectedItem = "NA"; } else if (infoSalesOrderMaster.QuotationMasterId != 0) { infoSalesQuotationMaster = new SalesQuotationBll().SalesQuotationMasterView(infoSalesOrderMaster.QuotationMasterId); cmbType.SelectedValue = infoSalesQuotationMaster.VoucherTypeId; AgainstQuotationComboFill(); cmbQuotationNo.SelectedValue = infoSalesOrderMaster.QuotationMasterId; } txtDueDate.Text = infoSalesOrderMaster.DueDate.ToString("dd-MMM-yyyy"); TimeSpan objTs = Convert.ToDateTime(txtDueDate.Text).Subtract(Convert.ToDateTime(txtDate.Text)); txtDueDays.Text = objTs.Days.ToString(); txtNarration.Text = infoSalesOrderMaster.Narration; cmbCurrency.SelectedValue = infoSalesOrderMaster.ExchangeRateId; cmbPricingLevel.SelectedValue = infoSalesOrderMaster.PricinglevelId; SalesManComboFill(); cmbSalesMan.SelectedValue = infoSalesOrderMaster.EmployeeId; txtTotalAmount.Text = infoSalesOrderMaster.TotalAmount.ToString(); List<DataTable> ListObj = new List<DataTable>(); ListObj = bllSalesOrder.SalesOrderDetailsViewByMasterId(decSalesOrderMasterId); if (CheckCancelStatus(decSalesOrderMasterId)) { isCheck = true; cbxCancelled.Checked = true; cbxCancelled.Enabled = false; btnSave.Enabled = false; isCheck = false; } else { isCheck = true; cbxCancelled.Enabled = true; cbxCancelled.Checked = false; isCheck = false; } if (isAutomatic) { txtOrderNo.ReadOnly = true; txtDate.Focus(); } else { txtOrderNo.ReadOnly = false; txtOrderNo.Focus(); } for (int i = 0; i < ListObj[0].Rows.Count; i++) { isAmountcalc = false; isValueChange = false; dgvSalesOrder.Rows.Add(); dgvSalesOrder.Rows[i].HeaderCell.Value = string.Empty; dgvSalesOrder.Rows[i].Cells["dgvtxtSalesOrderDetailsId"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["salesOrderDetailsId"].ToString()); dgvSalesOrder.Rows[i].Cells["dgvtxtProductId"].Value = ListObj[0].Rows[i]["productId"].ToString(); dgvSalesOrder.Rows[i].Cells["dgvtxtProductCode"].Value = ListObj[0].Rows[i]["productCode"].ToString(); dgvSalesOrder.Rows[i].Cells["dgvtxtProductName"].Value = ListObj[0].Rows[i]["productName"].ToString(); dgvSalesOrder.Rows[i].Cells["dgvtxtQty"].Value = ListObj[0].Rows[i]["qty"].ToString(); UnitComboFill(Convert.ToDecimal(dgvSalesOrder.Rows[i].Cells["dgvtxtProductId"].Value.ToString()), i, dgvSalesOrder.Rows[i].Cells["dgvcmbUnit"].ColumnIndex); dgvSalesOrder.Rows[i].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["unitId"].ToString()); dgvSalesOrder.Rows[i].Cells["dgvtxtRate"].Value = ListObj[0].Rows[i]["rate"].ToString(); BatchComboFill(Convert.ToDecimal(dgvSalesOrder.Rows[i].Cells["dgvtxtProductId"].Value.ToString()), i, dgvSalesOrder.Rows[i].Cells["dgvcmbBatch"].ColumnIndex); dgvSalesOrder.Rows[i].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(ListObj[0].Rows[i]["batchId"].ToString()); dgvSalesOrder.Rows[i].Cells["dgvtxtBarcode"].Value = ListObj[0].Rows[i]["barcode"].ToString(); dgvSalesOrder.Rows[i].Cells["dgvtxtAmount"].Value = ListObj[0].Rows[i]["amount"].ToString(); dgvSalesOrder.Rows[i].Cells["dgvtxtUnitConversionId"].Value = ListObj[0].Rows[i]["unitConversionId"].ToString(); dgvSalesOrder.Rows[i].Cells["dgvtxtConversionRate"].Value = ListObj[0].Rows[i]["conversionRate"].ToString(); dgvSalesOrder.Rows[i].Cells["dgvtxtSalesQuotationDetailsId"].Value = ListObj[0].Rows[i]["quotationDetailsId"].ToString(); if (Convert.ToDecimal(ListObj[0].Rows[i]["quotationDetailsId"].ToString()) != 0) { dgvSalesOrder.Rows[i].Cells["dgvtxtProductCode"].ReadOnly = true; dgvSalesOrder.Rows[i].Cells["dgvtxtProductName"].ReadOnly = true; dgvSalesOrder.Rows[i].Cells["dgvtxtBarcode"].ReadOnly = true; } if (cmbQuotationNo.Visible == true) { dgvSalesOrder.Rows[i].Cells["dgvcmbUnit"].ReadOnly = true; } } isAmountcalc = true; isEditFill = false; isValueChange = true; isDoAfterGridFill = true; } catch (Exception ex) { MessageBox.Show("SO30:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }