private void cboQuote_EditValueChanged(object sender, EventArgs e) { DataTable dtBuyer; txtBuyer.Text = ""; txtFlat.Text = ""; if (cboQuote.ItemIndex != 0) { dtBuyer = new DataTable(); dtBuyer = ServiceOrderBillBL.PopulateFlatQuote(Convert.ToInt32(cboQuote.EditValue)); if (dtBuyer.Rows.Count > 0) { txtFlat.Text = dtBuyer.Rows[0]["FlatNo"].ToString(); txtFlat.Tag = dtBuyer.Rows[0]["FlatID"].ToString(); txtFlat.Properties.ReadOnly = true; txtBuyer.Text = dtBuyer.Rows[0]["LeadName"].ToString(); txtBuyer.Tag = dtBuyer.Rows[0]["LeadId"].ToString(); txtBuyer.Properties.ReadOnly = true; txtTotal.Text = dtBuyer.Rows[0]["GrossAmt"].ToString(); txtNAmt.Text = dtBuyer.Rows[0]["NetAmt"].ToString(); dtBuyer.Dispose(); } if (m_iRegBillId != 0) { return; } m_dtGrid = new DataTable(); m_dtGrid = ServiceOrderBillBL.PopulateServiceQ(Convert.ToInt32(cboQuote.EditValue)); if (m_dtComPList.Rows.Count > 0) { m_dtComPList.Rows.Clear(); } AddNewEntry(); DataRow dr; for (int st = 0; st < m_dtGrid.Rows.Count; st++) { dr = m_dtComPList.NewRow(); dr["ServiceId"] = Convert.ToInt32(m_dtGrid.Rows[st]["ServiceId"].ToString()); dr["Description"] = m_dtGrid.Rows[st]["Description"]; dr["Amount"] = m_dtGrid.Rows[st]["Amount"];; m_dtComPList.Rows.Add(dr); } } }
private void cboProject_EditValueChanged(object sender, EventArgs e) { if (cboProject.ItemIndex != 0) { DataTable dtQu = new DataTable(); dtQu = ServiceOrderBillBL.PopulateQuote(Convert.ToInt32(cboProject.EditValue)); cboQuote.Properties.DataSource = CommFun.AddSelectToDataTable(dtQu); cboQuote.Properties.PopulateColumns(); cboQuote.Properties.DisplayMember = "RefNo"; cboQuote.Properties.ValueMember = "RegisterId"; cboQuote.Properties.Columns["RegisterId"].Visible = false; cboQuote.Properties.ShowFooter = false; cboQuote.Properties.ShowHeader = false; cboQuote.ItemIndex = 0; } }
public void GetData() { try { DataTable dtPpro = new DataTable(); dtPpro = ServiceOrderBillBL.PopulateProject(BsfGlobal.g_lUserId); cboProject.Properties.DataSource = CommFun.AddSelectToDataTable(dtPpro); cboProject.Properties.PopulateColumns(); cboProject.Properties.DisplayMember = "CostCentreName"; cboProject.Properties.ValueMember = "CostCentreId"; cboProject.Properties.Columns["CostCentreId"].Visible = false; cboProject.Properties.ShowHeader = false; cboProject.Properties.ShowFooter = false; cboProject.ItemIndex = 0; } catch (Exception ex) { BsfGlobal.CustomException(ex.Message, ex.StackTrace); } }
private void ChangeGridValue(int argEntryId) { DataTable dt = new DataTable(); dt = ServiceOrderBillBL.Populate_SerOrderBillRegisterChange(argEntryId); int iRowId = frmServiceOrderBillReg.m_oGridMasterView.FocusedRowHandle; if (dt.Rows.Count > 0) { //A.Billdate,A.BillRefNo,A.CostcentreID,B.CostCentreName,S.RefNo QuoteNo,C.FlatNo,E.LeadName BuyerName,A.NetAmt,A.Approve frmServiceOrderBillReg.m_oGridMasterView.SetRowCellValue(iRowId, "Billdate", Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["Billdate"], CommFun.datatypes.VarTypeDate)).ToString("dd/MM/yyyy")); frmServiceOrderBillReg.m_oGridMasterView.SetRowCellValue(iRowId, "BillRefNo", CommFun.IsNullCheck(dt.Rows[0]["BillRefNo"], CommFun.datatypes.vartypestring).ToString()); frmServiceOrderBillReg.m_oGridMasterView.SetRowCellValue(iRowId, "CostCentreName", CommFun.IsNullCheck(dt.Rows[0]["CostCentreName"], CommFun.datatypes.vartypestring).ToString()); frmServiceOrderBillReg.m_oGridMasterView.SetRowCellValue(iRowId, "QuoteNo", CommFun.IsNullCheck(dt.Rows[0]["QuoteNo"], CommFun.datatypes.vartypestring).ToString()); frmServiceOrderBillReg.m_oGridMasterView.SetRowCellValue(iRowId, "FlatNo", CommFun.IsNullCheck(dt.Rows[0]["FlatNo"], CommFun.datatypes.vartypestring).ToString()); frmServiceOrderBillReg.m_oGridMasterView.SetRowCellValue(iRowId, "BuyerName", CommFun.IsNullCheck(dt.Rows[0]["BuyerName"], CommFun.datatypes.vartypestring).ToString()); frmServiceOrderBillReg.m_oGridMasterView.SetRowCellValue(iRowId, "NetAmt", CommFun.IsNullCheck(dt.Rows[0]["NetAmt"], CommFun.datatypes.vartypestring).ToString()); frmServiceOrderBillReg.m_oGridMasterView.SetRowCellValue(iRowId, "Approve", CommFun.IsNullCheck(dt.Rows[0]["Approve"], CommFun.datatypes.vartypestring).ToString()); } dt.Dispose(); }
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e) { if (DGvTransView.FocusedRowHandle < 0) { return; } if (BsfGlobal.FindPermission("CRM-ServiceBill-Delete") == false) { MessageBox.Show("You don't have Rights to Service Quote Bill-Delete", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } try { int i_RegId = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "RegBillId"), CommFun.datatypes.vartypenumeric)); string m_sIssNo = ""; int m_iCCId1 = 0; string Apv = ""; m_iCCId1 = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "CostcentreID"), CommFun.datatypes.vartypenumeric)); m_sIssNo = Convert.ToString(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "BillRefNo"), CommFun.datatypes.vartypestring)); Apv = Convert.ToString(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "Approve"), CommFun.datatypes.vartypestring)); if (Apv == "Y") { MessageBox.Show("Already Approved, Do Not Delete", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } if (MessageBox.Show("Do you want to delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (ServiceOrderBillBL.DeleteSerOrderBillRegister(i_RegId, m_iCCId1, m_sIssNo) == true) { DGvTransView.DeleteRow(DGvTransView.FocusedRowHandle); } //CommFun.InsertLog(DateTime.Now, "Service Quote Bill-Delete", "D", "Delete Service Quote Bill Reg", BsfGlobal.g_lUserId, 0, 0, 0, BsfGlobal.g_sCRMDBName); } } catch (Exception ex) { BsfGlobal.CustomException(ex.Message, ex.StackTrace); } }
public void FillData() { try { m_dt = new DataTable(); m_dt = ServiceOrderBillBL.Populate_SerOrderBillRegister(Convert.ToDateTime(dtpFrmDate.EditValue), Convert.ToDateTime(dtpToDate.EditValue)); DGvTrans.DataSource = m_dt; RepositoryItemTextEdit txtEditAmt = new RepositoryItemTextEdit(); txtEditAmt.LookAndFeel.UseDefaultLookAndFeel = false; txtEditAmt.Mask.EditMask = BsfGlobal.g_sDigitFormat; txtEditAmt.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtEditAmt.Mask.UseMaskAsDisplayFormat = true; DGvTransView.Columns["NetAmt"].ColumnEdit = txtEditAmt; DGvTransView.Columns["RegBillId"].Visible = false; DGvTransView.Columns["CostcentreID"].Visible = false; DGvTransView.Columns["Billdate"].Width = 80; DGvTransView.Columns["BillRefNo"].Width = 80; DGvTransView.Columns["CostCentreName"].Width = 200; DGvTransView.Columns["QuoteNo"].Width = 100; DGvTransView.Columns["FlatNo"].Width = 100; DGvTransView.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No"; DGvTransView.Columns["BuyerName"].Width = 150; DGvTransView.Columns["NetAmt"].Caption = "NetAmount"; DGvTransView.Columns["NetAmt"].Width = 100; DGvTransView.Columns["Billdate"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False; DGvTransView.Columns["Approve"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False; DGvTransView.Columns["BillRefNo"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; DGvTransView.Columns["BillRefNo"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; DGvTransView.Columns["QuoteNo"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; DGvTransView.Columns["QuoteNo"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; DGvTransView.Columns["FlatNo"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; DGvTransView.Columns["FlatNo"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; DGvTransView.Columns["Billdate"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; DGvTransView.Columns["Billdate"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; DGvTransView.Columns["Approve"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; DGvTransView.Columns["Approve"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; DGvTransView.OptionsCustomization.AllowFilter = true; DGvTransView.OptionsBehavior.AllowIncrementalSearch = true; DGvTransView.OptionsView.ShowAutoFilterRow = true; DGvTransView.OptionsView.ShowViewCaption = false; DGvTransView.OptionsView.ShowFooter = false; DGvTransView.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect; DGvTransView.OptionsSelection.InvertSelection = false; DGvTransView.OptionsView.ColumnAutoWidth = true; DGvTransView.Appearance.HeaderPanel.Font = new Font(DGvTransView.Appearance.HeaderPanel.Font, FontStyle.Bold); DGvTransView.FocusedRowHandle = 0; DGvTransView.FocusedColumn = DGvTransView.VisibleColumns[0]; DGvTransView.Appearance.FocusedCell.BackColor = Color.Teal; DGvTransView.Appearance.FocusedCell.ForeColor = Color.White; DGvTransView.Appearance.FocusedRow.ForeColor = Color.Black; DGvTransView.Appearance.FocusedRow.BackColor = Color.White; DGvTransView.OptionsSelection.EnableAppearanceHideSelection = false; } catch (Exception ex) { BsfGlobal.CustomException(ex.Message, ex.StackTrace); } }
private void barButtonItemOk_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (txtRefNo.Text.Trim() == "") { MessageBox.Show("Provide ReferenceNo", "PMS", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); txtRefNo.Focus(); return; } else if (Convert.ToInt32(cboProject.EditValue) == -1 || Convert.ToInt32(cboProject.EditValue) == 0) { MessageBox.Show("Select Project Type", "PMS", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); cboProject.Focus(); return; } else if (Convert.ToInt32(cboQuote.EditValue) == -1 || Convert.ToInt32(cboQuote.EditValue) == 0) { MessageBox.Show("Select Ref Quote Type", "PMS", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); cboQuote.Focus(); return; } else if (txtFlat.Text.Trim() == "") { MessageBox.Show("Provide Flat", "PMS", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); txtFlat.Focus(); return; } else if (txtBuyer.Text.Trim() == "") { MessageBox.Show("Provide Buyer", "PMS", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); txtBuyer.Focus(); return; } grdViewService.FocusedRowHandle = grdViewService.FocusedRowHandle + 1; if (grdViewService.RowCount <= 0) { MessageBox.Show("Blank Posting Zero", "ASSET", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else { if (grdViewService.RowCount > 0) { for (int t = 0; t < grdViewService.RowCount; t++) { decimal dQA = Convert.ToDecimal(CommFun.IsNullCheck(grdViewService.GetRowCellValue(t, "Amount").ToString(), CommFun.datatypes.vartypenumeric)); if (dQA == 0) { MessageBox.Show("Amount Check", "ASSET", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } } } } if (m_iRegBillId == 0) { if (oVType.GenType == true) { oVType = new BsfGlobal.VoucherType(); oVType = BsfGlobal.GetVoucherNo(29, Convert.ToDateTime(dtpRefDate.EditValue), 0, 0); txtRefNo.Text = oVType.VoucherNo; } } else { if (oVType.PeriodWise == true) { oVType = new BsfGlobal.VoucherType(); if (BsfGlobal.CheckPeriodChange(m_dOldDate, Convert.ToDateTime(dtpRefDate.EditValue)) == true) { oVType = BsfGlobal.GetVoucherNo(29, Convert.ToDateTime(dtpRefDate.EditValue), 0, 0); } } } if (m_iRegBillId == 0) { oSoBO = new ServiceOrderBillBO(); ServiceOrderBillBO.RegBillId = m_iRegBillId; ServiceOrderBillBO.Billdate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtpRefDate.EditValue, CommFun.datatypes.VarTypeDate)); ServiceOrderBillBO.BillRefNo = CommFun.IsNullCheck(txtRefNo.Text, CommFun.datatypes.vartypestring).ToString(); ServiceOrderBillBO.CostcentreID = Convert.ToInt32(CommFun.IsNullCheck(cboProject.EditValue, CommFun.datatypes.vartypenumeric)); ServiceOrderBillBO.FlatID = Convert.ToInt32(CommFun.IsNullCheck(txtFlat.Tag, CommFun.datatypes.vartypenumeric)); ServiceOrderBillBO.GrossAmt = Convert.ToDecimal(CommFun.IsNullCheck(txtTotal.Text, CommFun.datatypes.vartypenumeric)); ServiceOrderBillBO.QualifierAmt = Convert.ToDecimal(CommFun.IsNullCheck(txtQTotal.Text, CommFun.datatypes.vartypenumeric)); ServiceOrderBillBO.NetAmt = Convert.ToDecimal(CommFun.IsNullCheck(txtNAmt.Text, CommFun.datatypes.vartypenumeric)); ServiceOrderBillBO.Narration = CommFun.IsNullCheck(txtNarration.Text, CommFun.datatypes.vartypestring).ToString(); ServiceOrderBillBO.QuoteRegId = Convert.ToInt32(CommFun.IsNullCheck(cboQuote.EditValue, CommFun.datatypes.vartypenumeric)); bSuccess = ServiceOrderBillBL.InsertSerOrderBill(m_dtComPList, QualTrans); //CommFun.InsertLog(DateTime.Now, "Service Order Details-Add", "N", "Service Order Details", BsfGlobal.g_lUserId, 0, m_iCCId, 0, BsfGlobal.g_sCRMDBName); BsfGlobal.UpdateMaxNo(29, oVType, 0, 0); } else { oSoBO = new ServiceOrderBillBO(); ServiceOrderBillBO.RegBillId = m_iRegBillId; ServiceOrderBillBO.Billdate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dtpRefDate.EditValue, CommFun.datatypes.VarTypeDate)); ServiceOrderBillBO.BillRefNo = CommFun.IsNullCheck(txtRefNo.Text, CommFun.datatypes.vartypestring).ToString(); ServiceOrderBillBO.CostcentreID = Convert.ToInt32(CommFun.IsNullCheck(cboProject.EditValue, CommFun.datatypes.vartypenumeric)); ServiceOrderBillBO.FlatID = Convert.ToInt32(CommFun.IsNullCheck(txtFlat.Tag, CommFun.datatypes.vartypenumeric)); ServiceOrderBillBO.GrossAmt = Convert.ToDecimal(CommFun.IsNullCheck(txtTotal.Text, CommFun.datatypes.vartypenumeric)); ServiceOrderBillBO.QualifierAmt = Convert.ToDecimal(CommFun.IsNullCheck(txtQTotal.Text, CommFun.datatypes.vartypenumeric)); ServiceOrderBillBO.NetAmt = Convert.ToDecimal(CommFun.IsNullCheck(txtNAmt.Text, CommFun.datatypes.vartypenumeric)); ServiceOrderBillBO.Narration = CommFun.IsNullCheck(txtNarration.Text, CommFun.datatypes.vartypestring).ToString(); ServiceOrderBillBO.QuoteRegId = Convert.ToInt32(CommFun.IsNullCheck(cboQuote.EditValue, CommFun.datatypes.vartypenumeric)); if (Convert.ToDateTime(ServiceOrderBillBO.Billdate) != Convert.ToDateTime(dtpRefDate.EditValue)) { oVType = new BsfGlobal.VoucherType(); if (oVType.PeriodWise == true) { if (BsfGlobal.CheckPeriodChange(Convert.ToDateTime(ServiceOrderBillBO.Billdate), Convert.ToDateTime(dtpRefDate.EditValue)) == true) { oVType = BsfGlobal.GetVoucherNo(29, Convert.ToDateTime(dtpRefDate.EditValue), 0, 0); txtRefNo.Text = oVType.VoucherNo; BsfGlobal.UpdateMaxNo(29, oVType, 0, 0); } } } bSuccess = ServiceOrderBillBL.UpdateSerOrderBill(m_dtComPList, QualTrans); //CommFun.InsertLog(DateTime.Now, "Service Order Bill Details-Add", "N", "Add Service Order Bill Details", BsfGlobal.g_lUserId, 0, m_iCCId, 0, BsfGlobal.g_sCRMDBName); } if (bSuccess == true) { if (m_iRegBillId == 0) { ClearEntries(); } else { //if (BsfGlobal.g_bWorkFlow == true) //{ // Close(); // Cursor.Current = Cursors.WaitCursor; // frmServiceOrderBillReg frmProg = new frmServiceOrderBillReg(); // frmProg.TopLevel = false; // frmProg.FormBorderStyle = FormBorderStyle.None; // frmProg.Dock = DockStyle.Fill; // frmServiceOrderBillReg.m_oDW.Show(); // frmServiceOrderBillReg.t_panel.Controls.Clear(); // frmServiceOrderBillReg.t_panel.Controls.Add(frmProg); // frmProg.Show(); // Cursor.Current = Cursors.Default; //} //else //{ // Close(); //} Close(); } } }
public void FillData() { try { m_dtComp = new DataTable(); m_dtComp = ServiceOrderBillBL.Fill_SerOrderRegister(m_iRegBillId); if (m_dtComp.Rows.Count > 0) { dtpRefDate.EditValue = Convert.ToDateTime(m_dtComp.Rows[0]["Billdate"].ToString()); m_dOldDate = Convert.ToDateTime(dtpRefDate.EditValue); txtRefNo.Text = m_dtComp.Rows[0]["BillRefNo"].ToString(); txtRefNo.Properties.ReadOnly = true; cboProject.EditValue = Convert.ToInt32(m_dtComp.Rows[0]["CostcentreID"].ToString()); cboQuote.EditValue = Convert.ToInt32(m_dtComp.Rows[0]["QuoteRegId"].ToString()); cboProject.Enabled = false; cboQuote.Enabled = false; m_dtGrid = new DataTable(); m_dtGrid = ServiceOrderBillBL.Fill_SerOrderTrans(m_iRegBillId); AddNewEntry(); DataRow dr; for (int st = 0; st < m_dtGrid.Rows.Count; st++) { dr = m_dtComPList.NewRow(); dr["ServiceId"] = Convert.ToInt32(m_dtGrid.Rows[st]["ServiceId"].ToString()); dr["Description"] = m_dtGrid.Rows[st]["Description"]; dr["Amount"] = m_dtGrid.Rows[st]["Amount"];; m_dtComPList.Rows.Add(dr); } txtTotal.Text = m_dtComp.Rows[0]["GrossAmt"].ToString(); txtQTotal.Text = m_dtComp.Rows[0]["QualifierAmt"].ToString(); txtNAmt.Text = m_dtComp.Rows[0]["NetAmt"].ToString(); txtNarration.Text = m_dtComp.Rows[0]["Narration"].ToString(); if (m_dtComp.Rows[0]["Approve"].ToString() == "Y") { barButtonItemOk.Enabled = false; } DataTable dt = new DataTable(); dt = ServiceOrderBillBL.Fill_SerOrderTransQu(m_iRegBillId); if (dt.Rows.Count > 0) { QualTrans.Rows.Clear(); for (int q = 0; q < dt.Rows.Count; q++) { dr = QualTrans.NewRow(); dr["BillRegId"] = m_iRegBillId; dr["QualifierId"] = Convert.ToInt32(dt.Rows[q]["QualifierId"].ToString()); dr["Expression"] = dt.Rows[q]["Expression"].ToString(); dr["ExpPer"] = Convert.ToDecimal(dt.Rows[q]["ExpPer"].ToString()); dr["Add_Less_Flag"] = dt.Rows[q]["Add_Less_Flag"].ToString();; dr["SurCharge"] = Convert.ToDecimal(dt.Rows[q]["SurCharge"].ToString()); dr["EDCess"] = Convert.ToDecimal(dt.Rows[q]["EDCess"].ToString()); dr["ExpValue"] = Convert.ToDecimal(dt.Rows[q]["ExpValue"].ToString()); dr["ExpPerValue"] = dt.Rows[q]["ExpPerValue"].ToString(); dr["EDValue"] = dt.Rows[q]["EDValue"].ToString(); dr["SurValue"] = dt.Rows[q]["SurValue"].ToString(); dr["Amount"] = Convert.ToDecimal(dt.Rows[q]["Amount"].ToString()); QualTrans.Rows.Add(dr); } } cRateQualR RAQual; for (int i = 0; i < QualTrans.Rows.Count; i++) { RAQual = new cRateQualR(); RAQual.Add_Less_Flag = QualTrans.Rows[i]["Add_Less_Flag"].ToString(); RAQual.Amount = Convert.ToDecimal(QualTrans.Rows[i]["Amount"].ToString()); RAQual.Expression = QualTrans.Rows[i]["Expression"].ToString(); RAQual.RateID = Convert.ToInt32(QualTrans.Rows[i]["QualifierId"]); RAQual.ExpPer = Convert.ToDecimal(QualTrans.Rows[i]["ExpPer"].ToString()); RAQual.SurPer = Convert.ToDecimal(QualTrans.Rows[i]["SurCharge"].ToString()); RAQual.EDPer = Convert.ToDecimal(QualTrans.Rows[i]["EDCess"].ToString()); RAQual.ExpPerValue = Convert.ToDecimal(QualTrans.Rows[i]["ExpPerValue"].ToString()); RAQual.ExpValue = Convert.ToDecimal(QualTrans.Rows[i]["ExpValue"].ToString()); RAQual.SurValue = Convert.ToDecimal(QualTrans.Rows[i]["SurValue"].ToString()); RAQual.EDValue = Convert.ToDecimal(QualTrans.Rows[i]["EDValue"].ToString()); QualVBC.Add(RAQual, RAQual.RateID.ToString(), null, null); } } } catch (Exception ex) { BsfGlobal.CustomException(ex.Message, ex.StackTrace); } }