public void UpdateRemittanceAdvanceTransaction(Guid txtID, FnRemittanceAdvance fnRemittanceAdvance) { this.ValidateRemittanceAdvance(fnRemittanceAdvance); FnRemittanceDataset fnRemittanceDS = (FnRemittanceDataset)TransactionService.GetDS(txtID); #region FnRemittanceAdvance FnRemittanceDataset.FnRemittanceAdvanceRow fnRemittanceAdvanceRow = fnRemittanceDS.FnRemittanceAdvance.FindByRemittanceAdvanceID(fnRemittanceAdvance.RemittanceAdvanceID); fnRemittanceAdvanceRow.BeginEdit(); if (fnRemittanceAdvance.Remittance != null) { fnRemittanceAdvanceRow.RemittanceID = fnRemittanceAdvance.Remittance.RemittanceID; } if (fnRemittanceAdvance.Advance != null) { fnRemittanceAdvanceRow.AdvanceID = fnRemittanceAdvance.Advance.AdvanceID; } fnRemittanceAdvanceRow.Active = fnRemittanceAdvance.Active; fnRemittanceAdvanceRow.CreBy = UserAccount.UserID; fnRemittanceAdvanceRow.CreDate = DateTime.Now; fnRemittanceAdvanceRow.UpdBy = UserAccount.UserID; fnRemittanceAdvanceRow.UpdDate = DateTime.Now; fnRemittanceAdvanceRow.UpdPgm = UserAccount.CurrentProgramCode; fnRemittanceAdvanceRow.EndEdit(); #endregion }
public void PrepareDataToDataset(FnRemittanceDataset remittanceDataset, long remittanceID) { IList <FnRemittanceAdvance> remittanceAdvanceList = ScgeAccountingQueryProvider.FnRemittanceAdvanceQuery.FindRemittanceAdvanceByRemittanceID(remittanceID); if (remittanceAdvanceList.Count > 0) { foreach (FnRemittanceAdvance remittanceAdvance in remittanceAdvanceList) { FnRemittanceDataset.FnRemittanceAdvanceRow remittanceAdvanceRow = remittanceDataset.FnRemittanceAdvance.NewFnRemittanceAdvanceRow(); remittanceAdvanceRow.RemittanceAdvanceID = remittanceAdvance.RemittanceAdvanceID; if (remittanceAdvance.Remittance != null) { remittanceAdvanceRow.RemittanceID = remittanceAdvance.Remittance.RemittanceID; } if (remittanceAdvance.Advance != null) { remittanceAdvanceRow.AdvanceID = remittanceAdvance.Advance.AdvanceID; } remittanceAdvanceRow.Active = remittanceAdvance.Active; remittanceAdvanceRow.CreBy = remittanceAdvance.CreBy; remittanceAdvanceRow.CreDate = remittanceAdvance.CreDate; remittanceAdvanceRow.UpdBy = remittanceAdvance.UpdBy; remittanceAdvanceRow.UpdDate = remittanceAdvance.UpdDate; remittanceAdvanceRow.UpdPgm = remittanceAdvance.UpdPgm; remittanceDataset.FnRemittanceAdvance.AddFnRemittanceAdvanceRow(remittanceAdvanceRow); } } }
public long AddFnRemittanceAdvanceTransaction(Guid txID, FnRemittanceAdvance fnRemittanceAdvance) { //Initial Data for another table. FnRemittanceDataset fnRemittanceDocumentDS = (FnRemittanceDataset)TransactionService.GetDS(txID); FnRemittanceDataset.FnRemittanceAdvanceRow fnRemittanceAdvanceRow = fnRemittanceDocumentDS.FnRemittanceAdvance.NewFnRemittanceAdvanceRow();; if (fnRemittanceAdvance.Remittance != null) { fnRemittanceAdvanceRow.RemittanceID = fnRemittanceAdvance.Remittance.RemittanceID; } if (fnRemittanceAdvance.Advance != null) { fnRemittanceAdvanceRow.AdvanceID = fnRemittanceAdvance.Advance.AdvanceID; } fnRemittanceAdvanceRow.Active = fnRemittanceAdvance.Active; fnRemittanceAdvanceRow.CreBy = UserAccount.UserID; fnRemittanceAdvanceRow.CreDate = DateTime.Now; fnRemittanceAdvanceRow.UpdBy = UserAccount.UserID; fnRemittanceAdvanceRow.UpdDate = DateTime.Now; fnRemittanceAdvanceRow.UpdPgm = UserAccount.CurrentProgramCode; fnRemittanceDocumentDS.FnRemittanceAdvance.AddFnRemittanceAdvanceRow(fnRemittanceAdvanceRow); return(fnRemittanceAdvanceRow.RemittanceAdvanceID); }
//public void InsertRemittanceAdvance(Guid txID, long tempfnRemittanceID) //{ // FnRemittanceDataset fnRemittanceDS = (FnRemittanceDataset)TransactionService.GetDS(txID); // FnRemittance fnRemittance = ScgeAccountingQueryProvider.FnRemittanceQuery.FindProxyByIdentity(tempfnRemittanceID); // FnRemittanceDataset.FnRemittanceAdvanceDataTable insertTable = (FnRemittanceDataset.FnRemittanceAdvanceDataTable)fnRemittanceDS.FnRemittanceAdvance.GetChanges(DataRowState.Added); // if (insertTable != null) // { // foreach (FnRemittanceDataset.FnRemittanceAdvanceRow row in insertTable.Rows) // { // FnRemittanceAdvance remittanceAdvance = new FnRemittanceAdvance(); // remittanceAdvance.Remittance = fnRemittance; // remittanceAdvance.Advance = new AvAdvanceDocument(row.AdvanceID); // remittanceAdvance.Active = row.Active; // remittanceAdvance.CreBy = row.CreBy; // remittanceAdvance.CreDate = row.CreDate; // remittanceAdvance.UpdBy = row.UpdBy; // remittanceAdvance.UpdDate = row.UpdDate; // remittanceAdvance.UpdPgm = row.UpdPgm; // // if row.BudgetCostElementID < 0 is new record that no data in database. // if (row.RemittanceAdvanceID < 0) // { // ScgeAccountingDaoProvider.FnRemittanceAdvanceDao.Save(remittanceAdvance); // } // } // } //} //public void UpdateRemittanceAdvance(Guid txID, long tempfnRemittanceID) //{ // FnRemittanceDataset fnRemittanceDS = (FnRemittanceDataset)TransactionService.GetDS(txID); // FnRemittance fnRemittance = ScgeAccountingQueryProvider.FnRemittanceQuery.FindProxyByIdentity(tempfnRemittanceID); // FnRemittanceDataset.FnRemittanceAdvanceDataTable updateTable = (FnRemittanceDataset.FnRemittanceAdvanceDataTable)fnRemittanceDS.FnRemittanceAdvance.GetChanges(DataRowState.Modified); // if (updateTable != null) // { // foreach (FnRemittanceDataset.FnRemittanceAdvanceRow row in updateTable.Rows) // { // FnRemittanceAdvance remittanceAdvance; // if (row.RemittanceAdvanceID < 0) // { // remittanceAdvance = new FnRemittanceAdvance(); // } // else // { // remittanceAdvance = ScgeAccountingQueryProvider.FnRemittanceAdvanceQuery.FindProxyByIdentity(row.RemittanceAdvanceID); // } // remittanceAdvance.Remittance = fnRemittance; // remittanceAdvance.Advance = new AvAdvanceDocument(row.AdvanceID); // remittanceAdvance.Active = row.Active; // remittanceAdvance.CreBy = row.CreBy; // remittanceAdvance.CreDate = row.CreDate; // remittanceAdvance.UpdBy = row.UpdBy; // remittanceAdvance.UpdDate = row.UpdDate; // remittanceAdvance.UpdPgm = row.UpdPgm; // // if row.BudgetCostElementID < 0 is new record that no data in database. // if (row.RemittanceAdvanceID < 0) // { // ScgeAccountingDaoProvider.FnRemittanceAdvanceDao.Save(remittanceAdvance); // } // else // { // ScgeAccountingDaoProvider.FnRemittanceAdvanceDao.SaveOrUpdate(remittanceAdvance); // } // } // } //} //public void DeleteRemittanceAdvance(Guid txID) //{ // FnRemittanceDataset fnRemittanceDS = (FnRemittanceDataset)TransactionService.GetDS(txID); // FnRemittanceDataset.FnRemittanceAdvanceDataTable deleteTable = (FnRemittanceDataset.FnRemittanceAdvanceDataTable)fnRemittanceDS.FnRemittanceAdvance.GetChanges(DataRowState.Deleted); // if (deleteTable != null) // { // foreach (FnRemittanceDataset.FnRemittanceItemRow row in deleteTable.Rows) // { // long remittanceItemID = Convert.ToInt64(row["RemittanceItemID", DataRowVersion.Original].ToString()); // if (remittanceItemID > 0) // { // FnRemittanceItem remittanceItem = ScgeAccountingQueryProvider.FnRemittanceItemQuery.FindProxyByIdentity(remittanceItemID); // if (remittanceItem != null) // { // ScgeAccountingDaoProvider.FnRemittanceItemDao.Delete(remittanceItem); // } // } // } // } //} public void SaveRemittanceAdvance(Guid txID, long remittanceID) { FnRemittanceDataset ds = (FnRemittanceDataset)TransactionService.GetDS(txID); FnRemittanceDataset.FnRemittanceAdvanceDataTable tempAdvance = new FnRemittanceDataset.FnRemittanceAdvanceDataTable(); foreach (FnRemittanceDataset.FnRemittanceAdvanceRow row in ds.FnRemittanceAdvance.Select()) { FnRemittanceDataset.FnRemittanceAdvanceRow tempRow = tempAdvance.NewFnRemittanceAdvanceRow(); tempRow.RemittanceID = row.RemittanceID; tempRow.AdvanceID = row.AdvanceID; tempRow.Active = row.Active; tempRow.CreBy = row.CreBy; tempRow.CreDate = row.CreDate; tempRow.UpdBy = row.UpdBy; tempRow.UpdDate = row.UpdDate; tempRow.UpdPgm = row.UpdPgm; tempAdvance.AddFnRemittanceAdvanceRow(tempRow); } //ScgeAccountingDaoProvider.FnRemittanceAdvanceDao.Persist(ds.FnRemittanceAdvance); ScgeAccountingDaoProvider.FnRemittanceAdvanceDao.Persist(tempAdvance); }