void butQual_DoubleClick(object sender, EventArgs e)
{
int iRowid = gridView1.FocusedRowHandle;
DataView dv = new DataView(m_tQualifier);
dv.RowFilter = "RowId = " + iRowid;
DataTable dt = new DataTable();
if (dv.ToTable() != null)
{
dt = dv.ToTable();
}
Collection QualVBC = new Collection();
for (int i = 0; i < dt.Rows.Count; i++)
{
cRateQualR RAQual = new cRateQualR();
RAQual.Add_Less_Flag = CommFun.IsNullCheck(dt.Rows[i]["Add_Less_Flag"], CommFun.datatypes.vartypestring).ToString();
RAQual.Amount = 0;
RAQual.Expression = CommFun.IsNullCheck(dt.Rows[i]["Expression"], CommFun.datatypes.vartypestring).ToString();
RAQual.RateID = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[i]["QualifierId"], CommFun.datatypes.vartypenumeric));
RAQual.ExpPer = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[i]["ExpPer"], CommFun.datatypes.vartypenumeric));
RAQual.NetPer = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[i]["Net"], CommFun.datatypes.vartypenumeric));
RAQual.SurPer = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[i]["SurCharge"], CommFun.datatypes.vartypenumeric));
RAQual.EDPer = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[i]["EDCess"], CommFun.datatypes.vartypenumeric));
RAQual.HEDPer = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[i]["HEDCess"], CommFun.datatypes.vartypenumeric));
RAQual.TaxablePer = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[i]["Taxable"], CommFun.datatypes.vartypenumeric));
RAQual.TaxableValue = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[i]["TaxableValue"], CommFun.datatypes.vartypenumeric));
QualVBC.Add(RAQual, RAQual.RateID.ToString(), null, null);
}
Qualifier.frmQualifier qul = new Qualifier.frmQualifier();
decimal dAmt = 0;
decimal dNAmt = 0;
decimal dTaxAmt = 0;
decimal dVATAmt = 0;
if (qul.Execute("B", ref dAmt, ref QualVBC, ref dNAmt, true, "", true, ref dTaxAmt, DateTime.Now, ref dVATAmt) == true)
{
DataRow[] drow = m_tQualifier.Select("RowId=" + iRowid + "");
for (int i = 0; i <= drow.Length - 1; i++)
{
m_tQualifier.Rows.Remove(drow[i]);
}
foreach (Qualifier.cRateQualR d in QualVBC)
{
DataRow dr = m_tQualifier.NewRow();
dr["RowId"] = iRowid;
dr["QualifierId"] = d.RateID;
dr["Expression"] = d.Expression;
dr["ExpPer"] = d.ExpPer;
dr["Net"] = d.NetPer;
dr["Add_Less_Flag"] = d.Add_Less_Flag;
dr["SurCharge"] = d.SurPer;
dr["EDCess"] = d.EDPer;
dr["HEDCess"] = d.HEDPer;
dr["Taxable"] = d.TaxablePer;
dr["TaxableValue"] = d.TaxableValue;
m_tQualifier.Rows.Add(dr);
}
}
}
void txtGross_EditValueChanged(object sender, EventArgs e)
{
TextEdit editor = (TextEdit)sender;
DataTable dtQ = new DataTable();
DataTable dtTQ = new DataTable();
bool bService = false; int iQualId = 0;
decimal dGross = Convert.ToDecimal(CommFun.IsNullCheck(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "GrossAmount"), CommFun.datatypes.vartypenumeric));
decimal dAmt = dGross - Convert.ToDecimal(CommFun.IsNullCheck(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "PaidAmount"), CommFun.datatypes.vartypenumeric));
//decimal dNetAmt = Convert.ToDecimal(CommFun.IsNullCheck(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "NetAmount"), CommFun.datatypes.vartypenumeric)) - Convert.ToDecimal(CommFun.IsNullCheck(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "HPaidNetAmount"), CommFun.datatypes.vartypenumeric));
if (Convert.ToDecimal(CommFun.IsNullCheck(editor.EditValue, CommFun.datatypes.vartypenumeric)) > dAmt)
{
MessageBox.Show("Invalid Amount");
editor.EditValue = dAmt;
}
cRateQualR RAQual = new cRateQualR();
Collection QualVBC = new Collection();
//dtQualifier.Columns.Add("FlatId", typeof(int));
//dtQualifier.Columns.Add("PaymentSchId", typeof(int));
int iReceiptId = Convert.ToInt32(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "ReceiptTypeId"));
int iOthId = Convert.ToInt32(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "OtherCostId"));
DataView dv = new DataView(m_tQdT);
dv.RowFilter = "FlatId = " + m_iFlatId + " and PaymentSchId = " + m_iPayShId + " and ReceiptTypeId = " + iReceiptId + " and OtherCostId = " + iOthId;
dtQ = dv.ToTable();
if (dtQ.Rows.Count > 0)
{
dtTQ = dtQ.GetChanges().Copy();
}
else
{
dtTQ = dtQ.Clone();
}
for (int k = 0; k < dtQ.Rows.Count; k++)
{
DataTable dtTDS = new DataTable();
DataTable dtQ1 = new DataTable();
bService = Convert.ToBoolean(dtQ.Rows[k]["Service"]);
iQualId = Convert.ToInt32(dtQ.Rows[k]["QualifierId"]);
RAQual = new cRateQualR();
if (Convert.ToInt32(dtQ.Rows[k]["QualTypeId"]) == 2)
{
if (bService == true)
{
dtTDS = ReceiptDetailBL.GetSTSettings("G", m_dDate);
}
else
{
dtTDS = ReceiptDetailBL.GetSTSettings("F", m_dDate);
}
}
else
{
dtTDS = ReceiptDetailBL.GetQual(iQualId, m_dDate);
}
dtQ1 = ReceiptDetailBL.QualifierSelect(iQualId, "B", m_dDate);
if (dtTDS.Rows.Count > 0)
{
RAQual.RateID = iQualId;
RAQual.ExpPer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["ExpPer"], CommFun.datatypes.vartypenumeric));
RAQual.NetPer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["Net"], CommFun.datatypes.vartypenumeric));
RAQual.SurPer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["SurCharge"], CommFun.datatypes.vartypenumeric));
RAQual.EDPer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["EDCess"], CommFun.datatypes.vartypenumeric));
RAQual.HEDPer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["HEDCess"], CommFun.datatypes.vartypenumeric));
RAQual.HEDValue = 0;
RAQual.TaxablePer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["Taxable"], CommFun.datatypes.vartypenumeric));
}
if (dtQ1.Rows.Count > 0)
{
RAQual.Add_Less_Flag = dtQ1.Rows[0]["Add_Less_Flag"].ToString();
RAQual.Amount = 0;
RAQual.Expression = dtQ1.Rows[0]["Expression"].ToString();
}
//if (dtQ.Rows.Count > 0)
//{
// RAQual.Add_Less_Flag = dtQ.Rows[0]["Add_Less_Flag"].ToString();
// RAQual.Amount = 0;
// RAQual.Expression = dtQ.Rows[0]["Expression"].ToString();
// RAQual.RateID = Convert.ToInt32(dtQ.Rows[0]["QualifierId"].ToString());
// RAQual.ExpPer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[0]["ExpPer"], CommFun.datatypes.vartypenumeric));
// RAQual.NetPer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[0]["NetPer"], CommFun.datatypes.vartypenumeric));
// RAQual.SurPer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[0]["SurCharge"], CommFun.datatypes.vartypenumeric));
// RAQual.EDPer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[0]["EDCess"], CommFun.datatypes.vartypenumeric));
// RAQual.HEDPer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[0]["HEDPer"], CommFun.datatypes.vartypenumeric));
// RAQual.HEDValue = 0;
// RAQual.TaxablePer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[0]["TaxablePer"], CommFun.datatypes.vartypenumeric));
//}
QualVBC.Add(RAQual, RAQual.RateID.ToString(), null, null);
}
Qualifier.frmQualifier qul = new Qualifier.frmQualifier();
decimal dQNetAmt = 0;
decimal dTaxAmt = 0;
decimal dQBaseAmt = Convert.ToDecimal(CommFun.IsNullCheck(editor.EditValue, CommFun.datatypes.vartypenumeric));
DataRow dr1;
decimal dTax = 0;
decimal dVATAmt = 0;
if (qul.Execute("B", ref dQBaseAmt, ref QualVBC, ref dQNetAmt, false, "", true, ref dTaxAmt, m_dDate, ref dVATAmt) == true)
{
int i = 0;
DataRow dr;
while (i < m_tQdT.Rows.Count)
{
dr = m_tQdT.Rows[i];
if (Convert.ToInt32(dr["FlatId"]) == m_iFlatId && Convert.ToInt32(dr["PaymentSchId"]) == m_iPayShId && Convert.ToInt32(dr["ReceiptTypeId"]) == iReceiptId && Convert.ToInt32(dr["OtherCostId"]) == iOthId)
{
m_tQdT.Rows.Remove(dr);
}
else
{
i++;
}
}
foreach (Qualifier.cRateQualR d in QualVBC)
{
dr1 = m_tQdT.NewRow();
dr1["FlatId"] = m_iFlatId;
dr1["PaymentSchId"] = m_iPayShId;
dr1["QualifierId"] = d.RateID;
DataView dv1 = new DataView(dtTQ);
dv1.RowFilter = "QualifierId=" + d.RateID + "";
dr1["QualTypeId"] = dv1.ToTable().Rows[0]["QualTypeId"];
dr1["Service"] = dv1.ToTable().Rows[0]["Service"];
dr1["Expression"] = d.Expression;
dr1["ExpPer"] = d.ExpPer;
dr1["NetPer"] = d.NetPer; dTax = d.NetPer;
dr1["Add_Less_Flag"] = d.Add_Less_Flag;
dr1["SurCharge"] = d.SurPer;
dr1["EDCess"] = d.EDPer;
dr1["HEDPer"] = d.HEDPer;
dr1["ExpValue"] = d.ExpValue;
dr1["ExpPerValue"] = d.ExpPerValue;
dr1["SurValue"] = d.SurValue;
dr1["EDValue"] = d.EDValue;
dr1["Amount"] = d.Amount;
dr1["ReceiptTypeId"] = iReceiptId;
dr1["OtherCostId"] = iOthId;
dr1["TaxablePer"] = d.TaxablePer;
dr1["TaxableValue"] = d.TaxableValue;
m_tQdT.Rows.Add(dr1);
}
}
grdViewReceipt.SetRowCellValue(grdViewReceipt.FocusedRowHandle, "PaidTaxAmount", dTaxAmt);
grdViewReceipt.SetRowCellValue(grdViewReceipt.FocusedRowHandle, "PaidNetAmount", dQNetAmt);
}
void txtTax_DoubleClick(object sender, EventArgs e)
{
int iReceiptId = Convert.ToInt32(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "ReceiptTypeId"));
int iOthId = Convert.ToInt32(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "OtherCostId"));
DataView dv = new DataView(m_tQdT);
dv.RowFilter = "FlatId = " + m_iFlatId + " And PaymentSchId = " + m_iPayShId + " And ReceiptTypeId = " + iReceiptId + " And OtherCostId = " + iOthId;
DataTable dtQ = new DataTable();
dtQ = dv.ToTable();
DataTable dtTQ = new DataTable();
if (dtQ.Rows.Count > 0)
{
dtTQ = dtQ.GetChanges().Copy();
}
else
{
dtTQ = dtQ.Clone();
}
Collection QualVBC = new Collection();
if (dtQ.Rows.Count > 0)
{
for (int i = 0; i <= dtQ.Rows.Count - 1; i++)
{
cRateQualR RAQual = new cRateQualR();
RAQual.RateID = Convert.ToInt32(CommFun.IsNullCheck(dtQ.Rows[i]["QualifierId"], CommFun.datatypes.vartypenumeric));
RAQual.ExpPer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[i]["ExpPer"], CommFun.datatypes.vartypenumeric));
RAQual.NetPer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[i]["NetPer"], CommFun.datatypes.vartypenumeric));
RAQual.SurPer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[i]["SurCharge"], CommFun.datatypes.vartypenumeric));
RAQual.EDPer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[i]["EDCess"], CommFun.datatypes.vartypenumeric));
RAQual.HEDPer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[i]["HEDPer"], CommFun.datatypes.vartypenumeric));
RAQual.TaxablePer = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[i]["TaxablePer"], CommFun.datatypes.vartypenumeric));
RAQual.Add_Less_Flag = dtQ.Rows[i]["Add_Less_Flag"].ToString();
RAQual.Amount = Convert.ToDecimal(CommFun.IsNullCheck(dtQ.Rows[i]["Amount"], CommFun.datatypes.vartypenumeric));
RAQual.Expression = dtQ.Rows[i]["Expression"].ToString();
QualVBC.Add(RAQual, RAQual.RateID.ToString(), null, null);
}
}
else
{
for (int k = 0; k < dtQ.Rows.Count; k++)
{
bool bService = Convert.ToBoolean(CommFun.IsNullCheck(dtQ.Rows[k]["Service"], CommFun.datatypes.varTypeBoolean));
int iQualId = Convert.ToInt32(CommFun.IsNullCheck(dtQ.Rows[k]["QualifierId"], CommFun.datatypes.vartypenumeric));
DataTable dtTDS = new DataTable();
if (Convert.ToInt32(CommFun.IsNullCheck(dtQ.Rows[k]["QualTypeId"], CommFun.datatypes.vartypenumeric)) == 2)
{
if (bService == true)
{
dtTDS = ReceiptDetailBL.GetSTSettings("G", m_dDate);
}
else
{
dtTDS = ReceiptDetailBL.GetSTSettings("F", m_dDate);
}
}
else
{
dtTDS = ReceiptDetailBL.GetQual(iQualId, m_dDate);
}
cRateQualR RAQual = new cRateQualR();
if (dtTDS.Rows.Count > 0)
{
RAQual.RateID = iQualId;
RAQual.ExpPer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["ExpPer"], CommFun.datatypes.vartypenumeric));
RAQual.NetPer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["Net"], CommFun.datatypes.vartypenumeric));
RAQual.SurPer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["SurCharge"], CommFun.datatypes.vartypenumeric));
RAQual.EDPer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["EDCess"], CommFun.datatypes.vartypenumeric));
RAQual.HEDPer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["HEDCess"], CommFun.datatypes.vartypenumeric));
RAQual.TaxablePer = Convert.ToDecimal(CommFun.IsNullCheck(dtTDS.Rows[0]["Taxable"], CommFun.datatypes.vartypenumeric));
}
DataTable dtQ1 = new DataTable();
dtQ1 = CRM.DataLayer.PaymentScheduleDL.GetQual(Convert.ToInt32(iQualId), m_dDate, "B");
//dtQ1 = ReceiptDetailBL.QualifierSelect(iQualId, "B", m_dDate);
if (dtQ1.Rows.Count > 0)
{
RAQual.Add_Less_Flag = dtQ1.Rows[0]["Add_Less_Flag"].ToString();
RAQual.Amount = 0;
RAQual.Expression = dtQ1.Rows[0]["Expression"].ToString();
}
QualVBC.Add(RAQual, RAQual.RateID.ToString(), null, null);
}
}
decimal dQNetAmt = 0;
decimal dTaxAmt = 0;
decimal dVATAmt = 0;
decimal dQBaseAmt = Convert.ToDecimal(CommFun.IsNullCheck(grdViewReceipt.GetRowCellValue(grdViewReceipt.FocusedRowHandle, "PaidGrossAmount"), CommFun.datatypes.vartypenumeric));
Qualifier.frmQualifier qul = new Qualifier.frmQualifier();
if (qul.Execute("B", ref dQBaseAmt, ref QualVBC, ref dQNetAmt, true, "", true, ref dTaxAmt, m_dDate, ref dVATAmt) == true)
{
int i = 0;
while (i < m_tQdT.Rows.Count)
{
DataRow dr = m_tQdT.Rows[i];
if (Convert.ToInt32(dr["FlatId"]) == m_iFlatId && Convert.ToInt32(dr["PaymentSchId"]) == m_iPayShId && Convert.ToInt32(dr["ReceiptTypeId"]) == iReceiptId && Convert.ToInt32(dr["OtherCostId"]) == iOthId)
{
m_tQdT.Rows.Remove(dr);
}
else
{
i++;
}
}
foreach (Qualifier.cRateQualR d in QualVBC)
{
DataRow dr1 = m_tQdT.NewRow();
dr1["FlatId"] = m_iFlatId;
dr1["PaymentSchId"] = m_iPayShId;
dr1["QualifierId"] = d.RateID;
DataView dv1 = new DataView(dtTQ);
dv1.RowFilter = "QualifierId=" + d.RateID + "";
if (dv1.ToTable().Rows.Count > 0)
{
dr1["QualTypeId"] = dv1.ToTable().Rows[0]["QualTypeId"];
dr1["Service"] = dv1.ToTable().Rows[0]["Service"];
}
dr1["Expression"] = d.Expression;
dr1["ExpPer"] = d.ExpPer;
dr1["NetPer"] = d.NetPer;
dr1["Add_Less_Flag"] = d.Add_Less_Flag;
dr1["SurCharge"] = d.SurPer;
dr1["EDCess"] = d.EDPer;
dr1["HEDPer"] = d.HEDPer;
dr1["ExpValue"] = d.ExpValue;
dr1["ExpPerValue"] = d.ExpPerValue;
dr1["SurValue"] = d.SurValue;
dr1["EDValue"] = d.EDValue;
dr1["Amount"] = d.Amount;
dr1["ReceiptTypeId"] = iReceiptId;
dr1["OtherCostId"] = iOthId;
dr1["TaxablePer"] = d.TaxablePer;
dr1["TaxableValue"] = d.TaxableValue;
m_tQdT.Rows.Add(dr1);
}
grdViewReceipt.SetRowCellValue(grdViewReceipt.FocusedRowHandle, "PaidTaxAmount", dTaxAmt);
grdViewReceipt.SetRowCellValue(grdViewReceipt.FocusedRowHandle, "PaidNetAmount", dQNetAmt);
}
}
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);
}
}
