public void InsertAvAdvanceItem(Guid txID, long advanceID)
{
Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors();
AdvanceDataSet advanceDS = (AdvanceDataSet)TransactionService.GetDS(txID);
AvAdvanceDocument avDocument = ScgeAccountingQueryProvider.AvAdvanceDocumentQuery.FindProxyByIdentity(advanceID);
AdvanceDataSet.AvAdvanceItemDataTable insertTable =
(AdvanceDataSet.AvAdvanceItemDataTable)advanceDS.AvAdvanceItem.GetChanges(DataRowState.Added);
if (insertTable != null)
{
foreach (AdvanceDataSet.AvAdvanceItemRow row in insertTable.Rows)
{
AvAdvanceItem advanceItem = new AvAdvanceItem();
advanceItem.AdvanceID = avDocument;
if (!row.IsNull(advanceDS.AvAdvanceItem.PaymentTypeColumn.ColumnName))
{
advanceItem.PaymentType = row.PaymentType;
}
if (!row.IsNull(advanceDS.AvAdvanceItem.CurrencyIDColumn.ColumnName))
{
advanceItem.CurrencyID = new SS.DB.DTO.DbCurrency(row.CurrencyID);
}
if (!row.IsNull(advanceDS.AvAdvanceItem.AmountColumn.ColumnName))
{
advanceItem.Amount = (double)Math.Round(row.Amount, 2, MidpointRounding.AwayFromZero);
}
if (!row.IsNull(advanceDS.AvAdvanceItem.ExchangeRateColumn.ColumnName))
{
advanceItem.ExchangeRate = (double)Math.Round(row.ExchangeRate, 5, MidpointRounding.AwayFromZero);
}
if (!row.IsNull(advanceDS.AvAdvanceItem.AmountTHBColumn.ColumnName))
{
advanceItem.AmountTHB = (double)Math.Round(row.AmountTHB, 2, MidpointRounding.AwayFromZero);
}
advanceItem.Active = row.Active;
advanceItem.CreBy = UserAccount.UserID;
advanceItem.CreDate = DateTime.Now;
advanceItem.UpdBy = UserAccount.UserID;
advanceItem.UpdDate = DateTime.Now;
advanceItem.UpdPgm = UserAccount.CurrentProgramCode;
// if row.ScheduleID < 0 is new record that no data in database.
if (row.AdvanceItemID < 0)
{
ScgeAccountingDaoProvider.AvAdvanceItemDao.Save(advanceItem);
}
}
}
}
public void Persist(AdvanceDataSet.AvAdvanceItemDataTable dtAvDocument)
{
#region comment
//AdvanceDataSet.AvAdvanceItemDataTable deleteTable =
// (AdvanceDataSet.AvAdvanceItemDataTable)dtAvDocument.GetChanges(DataRowState.Deleted);
//AdvanceDataSet.AvAdvanceItemDataTable updateTable =
// (AdvanceDataSet.AvAdvanceItemDataTable)dtAvDocument.GetChanges(DataRowState.Modified);
//AdvanceDataSet.AvAdvanceItemDataTable insertTable =
// (AdvanceDataSet.AvAdvanceItemDataTable)dtAvDocument.GetChanges(DataRowState.Added);
//long avItemID = 0;
//// Delete AvAdvanceItem.
//if (deleteTable != null)
//{
// foreach (AdvanceDataSet.AvAdvanceItemRow avRow in deleteTable)
// {
// long avID = Convert.ToInt64(((DataRow)avRow)["AdvanceID", DataRowVersion.Original].ToString());
// AvAdvanceItem avDocument = new AvAdvanceItem(avID);
// this.Delete(avDocument);
// }
//}
//// Update AvAdvanceItem.
//if (updateTable != null)
//{
// foreach (AdvanceDataSet.AvAdvanceItemRow avRow in updateTable)
// {
// AvAdvanceItem avDocument = new AvAdvanceItem(avRow);
// this.SaveOrUpdate(avDocument);
// }
//}
//// Insert AvAdvanceItem.
//if (insertTable != null)
//{
// foreach (AdvanceDataSet.AvAdvanceItemRow avRow in insertTable)
// {
// AvAdvanceItem avDocument = new AvAdvanceItem(avRow);
// this.Save(avDocument);
// }
//}
#endregion
NHibernateAdapter <AvAdvanceItem, long> adapter = new NHibernateAdapter <AvAdvanceItem, long>();
adapter.UpdateChange(dtAvDocument, ScgeAccountingDaoProvider.AvAdvanceItemDao);
}
public void DeleteAdvanceDocument(Guid txID)
{
AdvanceDataSet advanceDS = (AdvanceDataSet)TransactionService.GetDS(txID);
AdvanceDataSet.AvAdvanceItemDataTable deleteTable =
(AdvanceDataSet.AvAdvanceItemDataTable)advanceDS.AvAdvanceItem.GetChanges(DataRowState.Deleted);
if (deleteTable != null)
{
foreach (AdvanceDataSet.AvAdvanceItemRow row in deleteTable.Rows)
{
long advanceItemID = Convert.ToInt64(row["AdvanceItemID", DataRowVersion.Original].ToString());
if (advanceItemID > 0)
{
AvAdvanceItem advanceItem = ScgeAccountingDaoProvider.AvAdvanceItemDao.FindProxyByIdentity(advanceItemID);
if (advanceItem != null)
{
ScgeAccountingDaoProvider.AvAdvanceItemDao.Delete(advanceItem);
}
}
}
}
}
