private void PostOloans()
{
IACDataSetTableAdapters.ACCOUNTTableAdapter ACCOUNTTableAdapter = new IACDataSetTableAdapters.ACCOUNTTableAdapter();
IACDataSetTableAdapters.MASTERTableAdapter MASTERTableAdapter = new IACDataSetTableAdapters.MASTERTableAdapter();
BindingSource MASTERBindingSource = new BindingSource();
Object loMasterKey = null;
String lsMasterKey = "";
MASTERBindingSource.DataSource = AddOniacDataSet.MASTER;
loMasterKey = ACCOUNTTableAdapter.AccountNumber("OS_LOANS");
lsMasterKey = (String)loMasterKey;
MASTERTableAdapter.Fill(AddOniacDataSet.MASTER, lsMasterKey);
if (AddOniacDataSet.MASTER.Rows.Count != 0)
{
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_RSV", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_CONT", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_OLOAN", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_ADJ", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_BAD", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_LOSS", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_INT", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_NOTES", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_OLOAN", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_NOTES", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_INT", 0);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_OLOAN", lnMASTER_OS_LOANS);
AddOniacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_YTD_OLOAN", AddOniacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_OLOAN") + lnMASTER_OS_LOANS);
AddOniacDataSet.MASTER.Rows[0].SetField <DateTime>("MASTER_POST_DATE", DateTime.Now.Date);
MASTERBindingSource.EndEdit();
MASTERTableAdapter.Update(AddOniacDataSet.MASTER.Rows[0]);
AddOniacDataSet.MASTER.AcceptChanges();
}
}
private void UpdateMaster()
{
IACDataSetTableAdapters.ACCOUNTTableAdapter ACCOUNTTableAdapter = new IACDataSetTableAdapters.ACCOUNTTableAdapter();
IACDataSetTableAdapters.MASTERTableAdapter MASTERTableAdapter = new IACDataSetTableAdapters.MASTERTableAdapter();
BindingSource MASTERBindingSource = new BindingSource();
MASTERBindingSource.DataSource = ContingiacDataSet.MASTER;
Object loMasterKey = ACCOUNTTableAdapter.AccountNumber("BAD_DEBTS");
String lsMasterKey = (String)loMasterKey;
MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey);
if (ContingiacDataSet.MASTER.Rows.Count != 0)
{
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_RSV", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_CONT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_ADJ", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_BAD", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_LOSS", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_BAD", lnMASTER_BAD);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_YTD_BAD", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_BAD") + lnMASTER_BAD);
ContingiacDataSet.MASTER.Rows[0].SetField <DateTime>("MASTER_POST_DATE", DateTime.Now.Date);
MASTERBindingSource.EndEdit();
MASTERTableAdapter.Update(ContingiacDataSet.MASTER.Rows[0]);
ContingiacDataSet.MASTER.AcceptChanges();
}
loMasterKey = ACCOUNTTableAdapter.AccountNumber("RES_LOSS");
lsMasterKey = (String)loMasterKey;
MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey);
if (ContingiacDataSet.MASTER.Rows.Count != 0)
{
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_RSV", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_CONT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_ADJ", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_BAD", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_LOSS", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_RSV", lnMASTER_RSV);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_YTD_RSV", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_RSV") + lnMASTER_RSV);
ContingiacDataSet.MASTER.Rows[0].SetField <DateTime>("MASTER_POST_DATE", DateTime.Now.Date);
MASTERBindingSource.EndEdit();
MASTERTableAdapter.Update(ContingiacDataSet.MASTER.Rows[0]);
ContingiacDataSet.MASTER.AcceptChanges();
}
loMasterKey = ACCOUNTTableAdapter.AccountNumber("LOSS_RES");
lsMasterKey = (String)loMasterKey;
MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey);
if (ContingiacDataSet.MASTER.Rows.Count != 0)
{
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_RSV", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_CONT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_ADJ", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_BAD", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_LOSS", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_LOSS", lnMASTER_LOSS);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_YTD_LOSS", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_LOSS") + lnMASTER_LOSS);
ContingiacDataSet.MASTER.Rows[0].SetField <DateTime>("MASTER_POST_DATE", DateTime.Now.Date);
MASTERBindingSource.EndEdit();
MASTERTableAdapter.Update(ContingiacDataSet.MASTER.Rows[0]);
ContingiacDataSet.MASTER.AcceptChanges();
}
loMasterKey = ACCOUNTTableAdapter.AccountNumber("ADJUST");
lsMasterKey = (String)loMasterKey;
MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey);
if (ContingiacDataSet.MASTER.Rows.Count != 0)
{
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_RSV", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_CONT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_ADJ", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_BAD", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_LOSS", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_ADJ", lnMASTER_ADJ);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_YTD_ADJ", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_ADJ") + lnMASTER_ADJ);
ContingiacDataSet.MASTER.Rows[0].SetField <DateTime>("MASTER_POST_DATE", DateTime.Now.Date);
MASTERBindingSource.EndEdit();
MASTERTableAdapter.Update(ContingiacDataSet.MASTER.Rows[0]);
ContingiacDataSet.MASTER.AcceptChanges();
}
loMasterKey = ACCOUNTTableAdapter.AccountNumber("CONTING");
lsMasterKey = (String)loMasterKey;
MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey);
if (ContingiacDataSet.MASTER.Rows.Count != 0)
{
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_RSV", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_CONT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_ADJ", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_BAD", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_LOSS", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_CONT", lnMASTER_CONT);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_YTD_CONT", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_CONT") + lnMASTER_CONT);
ContingiacDataSet.MASTER.Rows[0].SetField <DateTime>("MASTER_POST_DATE", DateTime.Now.Date);
MASTERBindingSource.EndEdit();
MASTERTableAdapter.Update(ContingiacDataSet.MASTER.Rows[0]);
ContingiacDataSet.MASTER.AcceptChanges();
}
loMasterKey = ACCOUNTTableAdapter.AccountNumber("OS_LOANS");
lsMasterKey = (String)loMasterKey;
MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey);
if (ContingiacDataSet.MASTER.Rows.Count != 0)
{
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_RSV", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_CONT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_ADJ", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_BAD", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_LOSS", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_NOTES", lnMASTER_NOTES);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_YTD_NOTES", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_NOTES") + lnMASTER_NOTES);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_OLOAN", lnMASTER_OS_LOANS);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_YTD_OLOAN", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_OLOAN") + lnMASTER_OS_LOANS);
ContingiacDataSet.MASTER.Rows[0].SetField <DateTime>("MASTER_POST_DATE", DateTime.Now.Date);
MASTERBindingSource.EndEdit();
MASTERTableAdapter.Update(ContingiacDataSet.MASTER.Rows[0]);
ContingiacDataSet.MASTER.AcceptChanges();
}
loMasterKey = ACCOUNTTableAdapter.AccountNumber("AMORT_INT");
lsMasterKey = (String)loMasterKey;
MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey);
if (ContingiacDataSet.MASTER.Rows.Count != 0)
{
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_RSV", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_CONT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_ADJ", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_BAD", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_LOSS", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_OLOAN", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_NOTES", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_INT", 0);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_CUR_INT", lnMASTER_AMORT_INT);
ContingiacDataSet.MASTER.Rows[0].SetField <Decimal>("MASTER_AMORT_YTD_INT", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_AMORT_YTD_INT") + lnMASTER_AMORT_INT);
ContingiacDataSet.MASTER.Rows[0].SetField <DateTime>("MASTER_POST_DATE", DateTime.Now.Date);
MASTERBindingSource.EndEdit();
MASTERTableAdapter.Update(ContingiacDataSet.MASTER.Rows[0]);
ContingiacDataSet.MASTER.AcceptChanges();
}
}
