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);
}
}
