void AutoReconcile(string strFilePath1)
{
HRAReconSOFO sobj = new HRAReconSOFO();
string _yrmo = ddlYrmo1.SelectedItem.Text;
Decimal begBal, endBal, totContr, totDiv, termPay, withdraw, manAdjAmt;
DataSet ds = new DataSet(); ds.Clear();
int[] cols = { 6, 7, 11, 21, 25, 36 };
String _tableName = "SOFOTable";
String manAdjAmtStr, manAdjNotesStr;
manAdjAmtStr = tbx_adjAmt1.Text;
manAdjNotesStr = tbx_adjNotes1.Text;
if (manAdjAmtStr == null || manAdjAmtStr == String.Empty)
{
manAdjAmt = 0;
}
else
{
if (manAdjNotesStr == null || manAdjNotesStr == String.Empty)
{
throw new Exception("There is a Manual Adjustment Amount - " + manAdjAmtStr + " but Notes for it are not entered!");
}
manAdjAmt = Decimal.Parse(manAdjAmtStr, NumberStyles.Currency);
}
ds = HRATextImport.getTextFileData(strFilePath1, _tableName, ',');
begBal = Convert.ToDecimal(ds.Tables[_tableName].Rows[0][cols[0]]);
totContr = Convert.ToDecimal(ds.Tables[_tableName].Rows[0][cols[1]]);
totDiv = Convert.ToDecimal(ds.Tables[_tableName].Rows[0][cols[2]]);
termPay = Convert.ToDecimal(ds.Tables[_tableName].Rows[0][cols[3]]);
withdraw = Convert.ToDecimal(ds.Tables[_tableName].Rows[0][cols[4]]);
endBal = Convert.ToDecimal(ds.Tables[_tableName].Rows[0][cols[5]]);
sobj.ReconcileSOFO(_yrmo, begBal, endBal, totContr, totDiv, termPay, withdraw, manAdjAmt, manAdjNotesStr);
}
void ManualReconcile()
{
Decimal begBal, endBal, totContr, totDiv, termPay, withdraw, manAdjAmt;
String begBalStr, endBalStr, totContrStr, totDivStr, termPayStr, withdrawStr, manAdjAmtStr, manAdjNotesStr;
HRAReconSOFO sobj = new HRAReconSOFO();
string yrmo = ddlYrmo2.SelectedItem.Text;
begBalStr = txtBegBal.Text;
endBalStr = txtEndBal.Text;
totContrStr = txtTotContr.Text;
totDivStr = txtTotDiv.Text;
termPayStr = txtTermPay.Text;
withdrawStr = txtWithDraw.Text;
manAdjAmtStr = tbx_manAdjAmt.Text;
manAdjNotesStr = tbx_manAdjNotes.Text;
if (manAdjAmtStr == null || manAdjAmtStr == String.Empty || manAdjAmtStr.Equals("0.00"))
{
manAdjAmt = 0;
}
else
{
if (manAdjNotesStr == null || manAdjNotesStr == String.Empty)
{
throw new Exception("There is a Manual Adjustment Amount - " + manAdjAmtStr + " but Notes for it are not entered!");
}
manAdjAmt = Convert.ToDecimal(manAdjAmtStr);
}
if (begBalStr == null || begBalStr == String.Empty)
{
begBal = 0;
}
else
{
begBal = Decimal.Parse(begBalStr, NumberStyles.Currency);
}
if (endBalStr == null || endBalStr == String.Empty)
{
endBal = 0;
}
else
{
endBal = Decimal.Parse(endBalStr, NumberStyles.Currency);
}
if (totContrStr == null || totContrStr == String.Empty)
{
totContr = 0;
}
else
{
totContr = Decimal.Parse(totContrStr, NumberStyles.Currency);
}
if (totDivStr == null || totDivStr == String.Empty)
{
totDiv = 0;
}
else
{
totDiv = Decimal.Parse(totDivStr, NumberStyles.Currency);
}
if (termPayStr == null || termPayStr == String.Empty)
{
termPay = 0;
}
else
{
termPay = Decimal.Parse(termPayStr, NumberStyles.Currency);
}
if (withdrawStr == null || withdrawStr == String.Empty)
{
withdraw = 0;
}
else
{
withdraw = Decimal.Parse(withdrawStr, NumberStyles.Currency);
}
sobj.ReconcileSOFO(yrmo, begBal, endBal, totContr, totDiv, termPay, withdraw, manAdjAmt, manAdjNotesStr);
}