private void CreateMastHist() { IACDataSetTableAdapters.ACCOUNTTableAdapter ACCOUNTTableAdapter = new IACDataSetTableAdapters.ACCOUNTTableAdapter(); IACDataSetTableAdapters.MASTERTableAdapter MASTERTableAdapter = new IACDataSetTableAdapters.MASTERTableAdapter(); IACDataSetTableAdapters.MASTHISTTableAdapter MASTHISTTableAdapter = new IACDataSetTableAdapters.MASTHISTTableAdapter(); BindingSource MASTHISTBindingSource = new BindingSource(); MASTHISTBindingSource.DataSource = AddOniacDataSet.MASTHIST; Object loMasterKey = ACCOUNTTableAdapter.AccountNumber("OS_LOANS"), loMasterHistSeq = null; String lsMasterKey = (String)loMasterKey; Int32 lnSeq = 0; MASTERTableAdapter.Fill(AddOniacDataSet.MASTER, lsMasterKey); if (AddOniacDataSet.MASTER.Rows.Count != 0) { if (AddOniacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_OLOAN") != 0) { MASTHISTBindingSource.AddNew(); MASTHISTBindingSource.EndEdit(); AddOniacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_ACC_NO", AddOniacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO")); AddOniacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <DateTime>("MASTHIST_POST_DATE", AddOniacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); loMasterHistSeq = MASTHISTTableAdapter.SeqNoQuery(AddOniacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO"), AddOniacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); if (loMasterHistSeq != null) { lnSeq = (int)loMasterHistSeq + 1; } else { lnSeq = 1; } AddOniacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Int32>("MASTHIST_SEQ_NO", lnSeq); AddOniacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_NAME", AddOniacDataSet.MASTER.Rows[0].Field <String>("MASTER_NAME")); AddOniacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_CUR_OLOAN", AddOniacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_OLOAN")); AddOniacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_YTD_OLOAN", AddOniacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_OLOAN")); AddOniacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_YTD_NOTES", AddOniacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_NOTES")); AddOniacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_IAC_TYPE", "O"); MASTHISTBindingSource.EndEdit(); MASTHISTTableAdapter.Update(AddOniacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position]); AddOniacDataSet.MASTHIST.AcceptChanges(); } } }
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(); } }
public void CreateMastHist() { IACDataSetTableAdapters.ACCOUNTTableAdapter ACCOUNTTableAdapter = new IACDataSetTableAdapters.ACCOUNTTableAdapter(); IACDataSetTableAdapters.MASTERTableAdapter MASTERTableAdapter = new IACDataSetTableAdapters.MASTERTableAdapter(); IACDataSetTableAdapters.MASTHISTTableAdapter MASTHISTTableAdapter = new IACDataSetTableAdapters.MASTHISTTableAdapter(); BindingSource MASTHISTBindingSource = new BindingSource(); MASTHISTBindingSource.DataSource = ContingiacDataSet.MASTHIST; Object loMasterKey = ACCOUNTTableAdapter.AccountNumber("OS_LOANS"), loMasterHistSeq = null; String lsMasterKey = (String)loMasterKey; Int32 lnSeq = 0; MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey); if (ContingiacDataSet.MASTER.Rows.Count != 0) { if (ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_OLOAN") != 0 || ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_NOTES") != 0) { MASTHISTBindingSource.AddNew(); MASTHISTBindingSource.EndEdit(); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_ACC_NO", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <DateTime>("MASTHIST_POST_DATE", ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); loMasterHistSeq = MASTHISTTableAdapter.SeqNoQuery(ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO"), ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); if (loMasterHistSeq != null) { lnSeq = (int)loMasterHistSeq + 1; } else { lnSeq = 1; } ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Int32>("MASTHIST_SEQ_NO", lnSeq); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_NAME", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_NAME")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_CUR_OLOAN", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_OLOAN")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_YTD_OLOAN", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_OLOAN")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_CUR_NOTES", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_NOTES")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_YTD_NOTES", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_NOTES")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_IAC_TYPE", "C"); MASTHISTBindingSource.EndEdit(); MASTHISTTableAdapter.Update(ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position]); ContingiacDataSet.MASTHIST.AcceptChanges(); } } loMasterKey = ACCOUNTTableAdapter.AccountNumber("CONTING"); loMasterHistSeq = null; lsMasterKey = (String)loMasterKey; lnSeq = 0; MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey); if (ContingiacDataSet.MASTER.Rows.Count != 0) { if (ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_CONT") != 0) { MASTHISTBindingSource.AddNew(); MASTHISTBindingSource.EndEdit(); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_ACC_NO", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <DateTime>("MASTHIST_POST_DATE", ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); loMasterHistSeq = MASTHISTTableAdapter.SeqNoQuery(ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO"), ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); if (loMasterHistSeq != null) { lnSeq = (int)loMasterHistSeq + 1; } else { lnSeq = 1; } ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Int32>("MASTHIST_SEQ_NO", lnSeq); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_NAME", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_NAME")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_CUR_CONT", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_CONT")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_YTD_CONT", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_CONT")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_IAC_TYPE", "C"); MASTHISTBindingSource.EndEdit(); MASTHISTTableAdapter.Update(ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position]); ContingiacDataSet.MASTHIST.AcceptChanges(); } } loMasterKey = ACCOUNTTableAdapter.AccountNumber("ADJUST"); loMasterHistSeq = null; lsMasterKey = (String)loMasterKey; lnSeq = 0; MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey); if (ContingiacDataSet.MASTER.Rows.Count != 0) { if (ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_ADJ") != 0) { MASTHISTBindingSource.AddNew(); MASTHISTBindingSource.EndEdit(); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_ACC_NO", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <DateTime>("MASTHIST_POST_DATE", ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); loMasterHistSeq = MASTHISTTableAdapter.SeqNoQuery(ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO"), ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); if (loMasterHistSeq != null) { lnSeq = (int)loMasterHistSeq + 1; } else { lnSeq = 1; } ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Int32>("MASTHIST_SEQ_NO", lnSeq); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_NAME", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_NAME")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_CUR_ADJ", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_ADJ")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_YTD_ADJ", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_ADJ")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_IAC_TYPE", "C"); MASTHISTBindingSource.EndEdit(); MASTHISTTableAdapter.Update(ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position]); ContingiacDataSet.MASTHIST.AcceptChanges(); } } loMasterKey = ACCOUNTTableAdapter.AccountNumber("LOSS_RES"); loMasterHistSeq = null; lsMasterKey = (String)loMasterKey; lnSeq = 0; MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey); if (ContingiacDataSet.MASTER.Rows.Count != 0) { if (ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_LOSS") != 0) { MASTHISTBindingSource.AddNew(); MASTHISTBindingSource.EndEdit(); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_ACC_NO", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <DateTime>("MASTHIST_POST_DATE", ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); loMasterHistSeq = MASTHISTTableAdapter.SeqNoQuery(ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO"), ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); if (loMasterHistSeq != null) { lnSeq = (int)loMasterHistSeq + 1; } else { lnSeq = 1; } ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Int32>("MASTHIST_SEQ_NO", lnSeq); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_NAME", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_NAME")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_CUR_LOSS", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_LOSS")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_YTD_LOSS", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_LOSS")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_IAC_TYPE", "C"); MASTHISTBindingSource.EndEdit(); MASTHISTTableAdapter.Update(ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position]); ContingiacDataSet.MASTHIST.AcceptChanges(); } } loMasterKey = ACCOUNTTableAdapter.AccountNumber("RES_LOSS"); loMasterHistSeq = null; lsMasterKey = (String)loMasterKey; lnSeq = 0; MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey); if (ContingiacDataSet.MASTER.Rows.Count != 0) { if (ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_RSV") != 0) { MASTHISTBindingSource.AddNew(); MASTHISTBindingSource.EndEdit(); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_ACC_NO", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <DateTime>("MASTHIST_POST_DATE", ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); loMasterHistSeq = MASTHISTTableAdapter.SeqNoQuery(ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO"), ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); if (loMasterHistSeq != null) { lnSeq = (int)loMasterHistSeq + 1; } else { lnSeq = 1; } ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Int32>("MASTHIST_SEQ_NO", lnSeq); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_NAME", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_NAME")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_CUR_RSV", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_RSV")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_YTD_RSV", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_RSV")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_IAC_TYPE", "C"); MASTHISTBindingSource.EndEdit(); MASTHISTTableAdapter.Update(ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position]); ContingiacDataSet.MASTHIST.AcceptChanges(); } } loMasterKey = ACCOUNTTableAdapter.AccountNumber("BAD_DEBTS"); loMasterHistSeq = null; lsMasterKey = (String)loMasterKey; lnSeq = 0; MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey); if (ContingiacDataSet.MASTER.Rows.Count != 0) { if (ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_BAD") != 0) { MASTHISTBindingSource.AddNew(); MASTHISTBindingSource.EndEdit(); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_ACC_NO", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <DateTime>("MASTHIST_POST_DATE", ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); loMasterHistSeq = MASTHISTTableAdapter.SeqNoQuery(ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO"), ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); if (loMasterHistSeq != null) { lnSeq = (int)loMasterHistSeq + 1; } else { lnSeq = 1; } ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Int32>("MASTHIST_SEQ_NO", lnSeq); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_NAME", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_NAME")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_CUR_BAD", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_CUR_BAD")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_YTD_BAD", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_YTD_BAD")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_IAC_TYPE", "C"); MASTHISTBindingSource.EndEdit(); MASTHISTTableAdapter.Update(ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position]); ContingiacDataSet.MASTHIST.AcceptChanges(); } } loMasterKey = ACCOUNTTableAdapter.AccountNumber("AMORT_INT"); loMasterHistSeq = null; lsMasterKey = (String)loMasterKey; lnSeq = 0; MASTERTableAdapter.Fill(ContingiacDataSet.MASTER, lsMasterKey); if (ContingiacDataSet.MASTER.Rows.Count != 0) { if (ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_AMORT_CUR_INT") != 0) { MASTHISTBindingSource.AddNew(); MASTHISTBindingSource.EndEdit(); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_ACC_NO", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <DateTime>("MASTHIST_POST_DATE", ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); loMasterHistSeq = MASTHISTTableAdapter.SeqNoQuery(ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_ACC_NO"), ContingiacDataSet.MASTER.Rows[0].Field <DateTime>("MASTER_POST_DATE")); if (loMasterHistSeq != null) { lnSeq = (int)loMasterHistSeq + 1; } else { lnSeq = 1; } ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Int32>("MASTHIST_SEQ_NO", lnSeq); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_NAME", ContingiacDataSet.MASTER.Rows[0].Field <String>("MASTER_NAME")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_AMORT_CUR_INT", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_AMORT_CUR_INT")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <Decimal>("MASTHIST_AMORT_YTD_INT", ContingiacDataSet.MASTER.Rows[0].Field <Decimal>("MASTER_AMORT_YTD_INT")); ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position].SetField <String>("MASTHIST_IAC_TYPE", "C"); MASTHISTBindingSource.EndEdit(); MASTHISTTableAdapter.Update(ContingiacDataSet.MASTHIST.Rows[MASTHISTBindingSource.Position]); ContingiacDataSet.MASTHIST.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(); } }