public long Persist(FixedAdvanceDataSet.FixedAdvanceDocumentDataTable dtFixedAdvanceDocument)
{
NHibernateAdapter <FixedAdvanceDocument, long> adapter = new NHibernateAdapter <FixedAdvanceDocument, long>();
adapter.UpdateChange(dtFixedAdvanceDocument, ScgeAccountingDaoProvider.FixedAdvanceDocumentDao);
return(dtFixedAdvanceDocument.Rows[0].Field <long>(dtFixedAdvanceDocument.Columns["FixedAdvanceID"]));
}
public long Persist(MPADocumentDataSet.MPADocumentDataTable dtMPADocument)
{
NHibernateAdapter <MPADocument, long> adapter = new NHibernateAdapter <MPADocument, long>();
adapter.UpdateChange(dtMPADocument, ScgeAccountingDaoProvider.MPADocumentDao);
return(dtMPADocument.Rows[0].Field <long>(dtMPADocument.Columns["MPADocumentID"]));
}
public void Persist(DataTable dtExpensePerdiemItem)
{
NHibernateAdapter <FnExpensePerdiemItem, long> adapter = new NHibernateAdapter <FnExpensePerdiemItem, long>();
adapter.UpdateChange(dtExpensePerdiemItem, ScgeAccountingDaoProvider.FnExpensePerdiemItemDao);
//return dtExpenseDocument.Rows[0].Field<long>(dtExpenseDocument.Columns["ExpenseID"]);
}
public long Persist(DataTable dtExpenseDocument)
{
NHibernateAdapter <FnExpenseDocument, long> adapter = new NHibernateAdapter <FnExpenseDocument, long>();
adapter.UpdateChange(dtExpenseDocument, ScgeAccountingDaoProvider.FnExpenseDocumentDao);
return(dtExpenseDocument.Rows[0].Field <long>(dtExpenseDocument.Columns["ExpenseID"]));
}
public void Persist(DataTable dtPbCurrency)
{
NHibernateAdapter <DbPBCurrency, long> adapter = new NHibernateAdapter <DbPBCurrency, long>();
adapter.UpdateChange(dtPbCurrency, ScgDbDaoProvider.DbPBCurrencyDao);
//return dtPbCurrency.Rows[0].Field<long>(dtPbCurrency.Columns["ID"]);
}
public long Persist(DataTable dtExpenseMPA)
{
NHibernateAdapter <FnExpenseMPA, long> adapter = new NHibernateAdapter <FnExpenseMPA, long>();
adapter.UpdateChange(dtExpenseMPA, ScgeAccountingDaoProvider.ExpensesMPADao);
//return dtExpenseAdvance.Rows[0].Field<long>(dtExpenseAdvance.Columns["FnExpenseAdvanceID"]);
return(0);
}
public long Persist(AdvanceDataSet.AvAdvanceDocumentDataTable dtAvDocument)
{
#region comment
//AdvanceDataSet.AvAdvanceDocumentDataTable deleteTable =
// (AdvanceDataSet.AvAdvanceDocumentDataTable)dtAvDocument.GetChanges(DataRowState.Deleted);
//AdvanceDataSet.AvAdvanceDocumentDataTable updateTable =
// (AdvanceDataSet.AvAdvanceDocumentDataTable)dtAvDocument.GetChanges(DataRowState.Modified);
//AdvanceDataSet.AvAdvanceDocumentDataTable insertTable =
// (AdvanceDataSet.AvAdvanceDocumentDataTable)dtAvDocument.GetChanges(DataRowState.Added);
//long avDocumentID = 0;
//// Delete AvAdvanceDocument.
//if (deleteTable != null)
//{
// foreach (AdvanceDataSet.AvAdvanceDocumentRow avRow in deleteTable)
// {
// long avID = Convert.ToInt64(((DataRow)avRow)["AdvanceID", DataRowVersion.Original].ToString());
// AvAdvanceDocument avDocument = new AvAdvanceDocument(avID);
// this.Delete(avDocument);
// }
//}
//// Update AvAdvanceDocument.
//if (updateTable != null)
//{
// AvAdvanceDocument avDocument = new AvAdvanceDocument((AdvanceDataSet.AvAdvanceDocumentRow)updateTable.Rows[0]);
// avDocumentID = avDocument.AdvanceID;
// this.SaveOrUpdate(avDocument);
//}
//// Insert AvAdvanceDocument.
//if (insertTable != null)
//{
// AvAdvanceDocument avDocument = new AvAdvanceDocument((AdvanceDataSet.AvAdvanceDocumentRow)insertTable.Rows[0]);
// avDocumentID = this.Save(avDocument);
// #region Update New avDocumentID to Dataset
// dtAvDocument.AdvanceIDColumn.ReadOnly = false;
// dtAvDocument.Rows[0].BeginEdit();
// dtAvDocument.Rows[0][dtAvDocument.AdvanceIDColumn.ColumnName] = avDocumentID;
// dtAvDocument.Rows[0].EndEdit();
// dtAvDocument.AdvanceIDColumn.ReadOnly = true;
// #endregion
//}
//return avDocumentID;
#endregion
NHibernateAdapter <AvAdvanceDocument, long> adapter = new NHibernateAdapter <AvAdvanceDocument, long>();
adapter.UpdateChange(dtAvDocument, ScgeAccountingDaoProvider.AvAdvanceDocumentDao);
return(dtAvDocument.Rows[0].Field <long>(dtAvDocument.Columns["AdvanceID"]));
}
public long Persist(TADocumentDataSet.TADocumentDataTable taDocumentDT)
{
#region 25/03/2009
//TADocumentDataSet.TADocumentDataTable deleteTable =
// (TADocumentDataSet.TADocumentDataTable)taDocumentDT.GetChanges(DataRowState.Deleted);
//TADocumentDataSet.TADocumentDataTable updateTable =
// (TADocumentDataSet.TADocumentDataTable)taDocumentDT.GetChanges(DataRowState.Modified);
//TADocumentDataSet.TADocumentDataTable insertTable =
// (TADocumentDataSet.TADocumentDataTable)taDocumentDT.GetChanges(DataRowState.Added);
//long taDocumentID = 0;
//if (deleteTable != null)
//{
// foreach (TADocumentDataSet.TADocumentRow taDocumentRow in deleteTable)
// {
// taDocumentID = Convert.ToInt64(((DataRow)taDocumentRow)["TADocumentID", DataRowVersion.Original].ToString());
// TADocument taDocument = new TADocument(taDocumentID);
// this.Delete(taDocument);
// }
//}
//if (updateTable != null)
//{
// TADocument taDocument = new TADocument((TADocumentDataSet.TADocumentRow)updateTable.Rows[0]);
// taDocumentID = taDocument.TADocumentID;
// this.SaveOrUpdate(taDocument);
//}
//if (insertTable != null)
//{
// TADocument taDocument = new TADocument((TADocumentDataSet.TADocumentRow)insertTable.Rows[0]);
// taDocumentID = this.Save(taDocument);
// #region Update New TADocumentID to Dataset
// taDocumentDT.TADocumentIDColumn.ReadOnly = false;
// taDocumentDT.Rows[0].BeginEdit();
// taDocumentDT.Rows[0][taDocumentDT.TADocumentIDColumn.ColumnName] = taDocumentID;
// taDocumentDT.Rows[0].EndEdit();
// taDocumentDT.TADocumentIDColumn.ReadOnly = true;
// #endregion
//}
//return taDocumentID;
#endregion
NHibernateAdapter <TADocument, long> adapter = new NHibernateAdapter <TADocument, long>();
adapter.UpdateChange(taDocumentDT, ScgeAccountingDaoProvider.TADocumentDao);
return(taDocumentDT.Rows[0].Field <long>(taDocumentDT.Columns["TADocumentID"]));
}
public long Persist(FnRemittanceDataset.FnRemittanceDataTable dtRemittanceDocument)
{
NHibernateAdapter <FnRemittance, long> adapter = new NHibernateAdapter <FnRemittance, long>();
adapter.UpdateChange(dtRemittanceDocument, ScgeAccountingDaoProvider.FnRemittanceDao);
#region Old 24-March-2009
//FnRemittanceDataset.FnRemittanceDataTable updateTable =
// (FnRemittanceDataset.FnRemittanceDataTable)dtRemittanceDocument.GetChanges(DataRowState.Modified);
//FnRemittanceDataset.FnRemittanceDataTable insertTable =
// (FnRemittanceDataset.FnRemittanceDataTable)dtRemittanceDocument.GetChanges(DataRowState.Added);
//FnRemittanceDataset.FnRemittanceAdvanceDataTable deleteTable =
// (FnRemittanceDataset.FnRemittanceAdvanceDataTable)dtRemittanceDocument.GetChanges(DataRowState.Deleted);
//long remittanceDocumentID = 0;
//// Update BgBudgetDocument.
//if (updateTable != null)
//{
// FnRemittanceDataset.FnRemittanceRow row = (FnRemittanceDataset.FnRemittanceRow)updateTable.Rows[0];
// FnRemittance remittance = this.FindByIdentity(row.RemittanceID);//new FnRemittance((FnRemittanceDataset.FnRemittanceRow)updateTable.Rows[0]);
// remittanceDocumentID = remittance.RemittanceID;
// this.SaveOrUpdate(remittance);
//}
//if (insertTable != null)
//{
// FnRemittanceDataset.FnRemittanceRow row = (FnRemittanceDataset.FnRemittanceRow)insertTable.Rows[0];
// FnRemittance remittanceDocument = new FnRemittance(row);
// remittanceDocumentID = this.Save(remittanceDocument);
// dtRemittanceDocument.RemittanceIDColumn.ReadOnly = false;
// dtRemittanceDocument.Rows[0].BeginEdit();
// dtRemittanceDocument.Rows[0][dtRemittanceDocument.RemittanceIDColumn.ColumnName] = remittanceDocumentID;
// dtRemittanceDocument.Rows[0].EndEdit();
// dtRemittanceDocument.RemittanceIDColumn.ReadOnly = true;
//}
//if (deleteTable != null)
//{
// long remittanceID = Convert.ToInt64((deleteTable.Rows[0])["RemittanceID", DataRowVersion.Original].ToString());
// FnRemittance remittanceDocument = new FnRemittance(remittanceID);
// this.Delete(remittanceDocument);
//}
#endregion
return(dtRemittanceDocument.Rows[0].Field <long>(dtRemittanceDocument.Columns["RemittanceID"]));
}
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 Persist(TADocumentDataSet.TADocumentScheduleDataTable taDocumentScheduleDT)
{
#region 25/03/2009
//TADocumentDataSet.TADocumentScheduleDataTable deleteTable =
// (TADocumentDataSet.TADocumentScheduleDataTable)taDocumentScheduleDT.GetChanges(DataRowState.Deleted);
//TADocumentDataSet.TADocumentScheduleDataTable updateTable =
// (TADocumentDataSet.TADocumentScheduleDataTable)taDocumentScheduleDT.GetChanges(DataRowState.Modified);
//TADocumentDataSet.TADocumentScheduleDataTable insertTable =
// (TADocumentDataSet.TADocumentScheduleDataTable)taDocumentScheduleDT.GetChanges(DataRowState.Added);
//int scheduleID = 0;
//if (deleteTable != null)
//{
// foreach (TADocumentDataSet.TADocumentScheduleRow taDocumentScheduleRow in deleteTable)
// {
// scheduleID = Convert.ToInt32(((DataRow)taDocumentScheduleRow)["ScheduleID", DataRowVersion.Original].ToString());
// TADocumentSchedule taDocumentSchedule = new TADocumentSchedule(scheduleID);
// this.Delete(taDocumentSchedule);
// }
//}
//if (updateTable != null)
//{
// foreach (TADocumentDataSet.TADocumentScheduleRow taDocumentScheduleRow in updateTable)
// {
// TADocumentSchedule taDocumentSchedule = new TADocumentSchedule(taDocumentScheduleRow);
// this.SaveOrUpdate(taDocumentSchedule);
// }
//}
//if (insertTable != null)
//{
// foreach (TADocumentDataSet.TADocumentScheduleRow taDocumentScheduleRow in insertTable)
// {
// TADocumentSchedule taDocumentSchedule = new TADocumentSchedule(taDocumentScheduleRow);
// this.Save(taDocumentSchedule);
// }
//}
#endregion
NHibernateAdapter <TADocumentSchedule, int> adapter = new NHibernateAdapter <TADocumentSchedule, int>();
adapter.UpdateChange(taDocumentScheduleDT, ScgeAccountingDaoProvider.TADocumentScheduleDao);
}
public void Persist(MPADocumentDataSet.MPAItemDataTable mpaItemDT)
{
#region 25/03/2009
//TADocumentDataSet.TADocumentTravellerDataTable deleteTable =
// (TADocumentDataSet.TADocumentTravellerDataTable)taDocumentTravellerDT.GetChanges(DataRowState.Deleted);
//TADocumentDataSet.TADocumentTravellerDataTable updateTable =
// (TADocumentDataSet.TADocumentTravellerDataTable)taDocumentTravellerDT.GetChanges(DataRowState.Modified);
//TADocumentDataSet.TADocumentTravellerDataTable insertTable =
// (TADocumentDataSet.TADocumentTravellerDataTable)taDocumentTravellerDT.GetChanges(DataRowState.Added);
//int travellerID = 0;
//if (deleteTable != null)
//{
// foreach (TADocumentDataSet.TADocumentTravellerRow taDocumentTravellerRow in deleteTable)
// {
// travellerID = Convert.ToInt32(((DataRow)taDocumentTravellerRow)["TravellerID", DataRowVersion.Original].ToString());
// TADocumentTraveller taDocumentTraveller = new TADocumentTraveller(travellerID);
// this.Delete(taDocumentTraveller);
// }
//}
//if (updateTable != null)
//{
// foreach (TADocumentDataSet.TADocumentTravellerRow taDocumentTravellerRow in updateTable)
// {
// TADocumentTraveller taDocumentTraveller = new TADocumentTraveller(taDocumentTravellerRow);
// this.SaveOrUpdate(taDocumentTraveller);
// }
//}
//if (insertTable != null)
//{
// foreach (TADocumentDataSet.TADocumentTravellerRow taDocumentTravellerRow in insertTable)
// {
// TADocumentTraveller taDocumentTraveller = new TADocumentTraveller(taDocumentTravellerRow);
// this.Save(taDocumentTraveller);
// }
//}
#endregion
NHibernateAdapter <MPAItem, long> adapter = new NHibernateAdapter <MPAItem, long>();
adapter.UpdateChange(mpaItemDT, ScgeAccountingDaoProvider.MPAItemDao);
}
public void Persist(FnRemittanceDataset.FnRemittanceItemDataTable dtRemittanceItem)
{
NHibernateAdapter <FnRemittanceItem, long> adapter = new NHibernateAdapter <FnRemittanceItem, long>();
adapter.UpdateChange(dtRemittanceItem, ScgeAccountingDaoProvider.FnRemittanceItemDao);
#region Old 24-March-2009
//FnRemittanceDataset.FnRemittanceItemDataTable insertTable = (FnRemittanceDataset.FnRemittanceItemDataTable)dtRemittanceItem.GetChanges(DataRowState.Added);
//FnRemittanceDataset.FnRemittanceItemDataTable updateTable = (FnRemittanceDataset.FnRemittanceItemDataTable)dtRemittanceItem.GetChanges(DataRowState.Modified);
//FnRemittanceDataset.FnRemittanceItemDataTable deleteTable = (FnRemittanceDataset.FnRemittanceItemDataTable)dtRemittanceItem.GetChanges(DataRowState.Deleted);
//if (insertTable != null)
//{
// foreach (FnRemittanceDataset.FnRemittanceItemRow row in insertTable)
// {
// FnRemittanceItem remittanceItem = new FnRemittanceItem(row);
// this.Save(remittanceItem);
// }
//}
//if (updateTable != null)
//{
// foreach (FnRemittanceDataset.FnRemittanceItemRow row in insertTable)
// {
// FnRemittanceItem remittanceItem = new FnRemittanceItem(row);
// this.SaveOrUpdate(remittanceItem);
// }
//}
//if (deleteTable != null)
//{
// foreach (FnRemittanceDataset.FnRemittanceItemRow row in insertTable)
// {
// long remittanceID = Convert.ToInt64(((DataRow)row)["RemittanceItemID", DataRowVersion.Original].ToString());
// FnRemittanceItem remittanceItem = new FnRemittanceItem(row);
// this.Delete(remittanceItem);
// }
//}
#endregion
}
public void Persist(DataTable dtDocumentInitiator)
{
NHibernateAdapter <DocumentInitiator, long> adapter = new NHibernateAdapter <DocumentInitiator, long>();
adapter.UpdateChange(dtDocumentInitiator, ScgeAccountingDaoProvider.DocumentInitiatorDao);
}
public long Persist(DataTable dtDocument)
{
NHibernateAdapter <SCGDocument, long> adapter = new NHibernateAdapter <SCGDocument, long>();
adapter.UpdateChange(dtDocument, ScgeAccountingDaoProvider.SCGDocumentDao);
#region Old 24-March-2009
//Old 24-March-2009
//DataTable updateTable = dtDocument.GetChanges(DataRowState.Modified);
//DataTable insertTable = dtDocument.GetChanges(DataRowState.Added);
//long documentID = 0;
//#region Update
//if (updateTable != null)
//{
// #region Remittance
// if (updateTable is FnRemittanceDataset.FnRemittanceDataTable)
// {
// if (updateTable.Rows[0] is FnRemittanceDataset.DocumentRow)
// {
// FnRemittanceDataset.DocumentRow row = (FnRemittanceDataset.DocumentRow)updateTable.Rows[0];
// SCGDocument document = this.FindByIdentity(row.DocumentID);
// document.CompanyID = new SCG.DB.DTO.DbCompany(row.CompanyID);
// document.CreatorID = new SS.SU.DTO.SuUser(row.CreatorID);
// document.RequesterID = new SS.SU.DTO.SuUser(row.RequesterID);
// if (row.ApproverID != null)
// {
// document.ApproverID = new SS.SU.DTO.SuUser(row.ApproverID);
// }
// else
// {
// document.ApproverID = null;
// }
// document.DocumentNo = row.DocumentNo;
// document.DocumentDate = row.DocumentDate;
// document.DocumentType = new SS.Standard.WorkFlow.DTO.DocumentType(row.DocumentTypeID);
// document.Subject = row.Subject;
// document.Memo = row.Memo;
// if (row.ReceiverID != null)
// {
// document.ReceiverID = new SS.SU.DTO.SuUser(row.ReceiverID);
// }
// else
// {
// document.ReceiverID = null;
// }
// document.Active = row.Active;
// document.CreBy = row.CreBy;
// document.CreDate = row.CreDate;
// document.UpdBy = row.UpdBy;
// document.UpdDate = row.UpdDate;
// document.UpdPgm = row.UpdPgm;
// this.SaveOrUpdate(document);
// documentID = document.DocumentID;
// }
// }
// #endregion
// #region TADocument
// if (updateTable is TADocumentDataSet.TADocumentDataTable)
// {
// if (updateTable.Rows[0] is TADocumentDataSet.DocumentRow)
// {
// TADocumentDataSet.DocumentRow row = (TADocumentDataSet.DocumentRow)updateTable.Rows[0];
// SCGDocument document = this.FindByIdentity(row.DocumentID);
// document.CompanyID = new SCG.DB.DTO.DbCompany(row.CompanyID);
// document.CreatorID = new SS.SU.DTO.SuUser(row.CreatorID);
// document.RequesterID = new SS.SU.DTO.SuUser(row.RequesterID);
// if (row.ApproverID != null)
// {
// document.ApproverID = new SS.SU.DTO.SuUser(row.ApproverID);
// }
// else
// {
// document.ApproverID = null;
// }
// document.DocumentNo = row.DocumentNo;
// document.DocumentDate = row.DocumentDate;
// document.DocumentType = new SS.Standard.WorkFlow.DTO.DocumentType(row.DocumentTypeID);
// document.Subject = row.Subject;
// document.Memo = row.Memo;
// if (row.ReceiverID != null)
// {
// document.ReceiverID = new SS.SU.DTO.SuUser(row.ReceiverID);
// }
// else
// {
// document.ReceiverID = null;
// }
// document.Active = row.Active;
// document.CreBy = row.CreBy;
// document.CreDate = row.CreDate;
// document.UpdBy = row.UpdBy;
// document.UpdDate = row.UpdDate;
// document.UpdPgm = row.UpdPgm;
// this.SaveOrUpdate(document);
// documentID = document.DocumentID;
// }
// }
// #endregion
// #region AdvanceDocument
// if (updateTable is AdvanceDataSet.AvAdvanceDocumentDataTable)
// {
// if (updateTable.Rows[0] is AdvanceDataSet.DocumentRow)
// {
// AdvanceDataSet.DocumentRow row = (AdvanceDataSet.DocumentRow)updateTable.Rows[0];
// SCGDocument document = this.FindByIdentity(row.DocumentID);
// document.CompanyID = new SCG.DB.DTO.DbCompany(row.CompanyID);
// document.CreatorID = new SS.SU.DTO.SuUser(row.CreatorID);
// document.RequesterID = new SS.SU.DTO.SuUser(row.RequesterID);
// if (row.ApproverID != null)
// {
// document.ApproverID = new SS.SU.DTO.SuUser(row.ApproverID);
// }
// else
// {
// document.ApproverID = null;
// }
// document.DocumentNo = row.DocumentNo;
// document.DocumentDate = row.DocumentDate;
// document.DocumentType = new SS.Standard.WorkFlow.DTO.DocumentType(row.DocumentTypeID);
// document.Subject = row.Subject;
// document.Memo = row.Memo;
// if (row.ReceiverID != null)
// {
// document.ReceiverID = new SS.SU.DTO.SuUser(row.ReceiverID);
// }
// else
// {
// document.ReceiverID = null;
// }
// document.Active = row.Active;
// document.CreBy = row.CreBy;
// document.CreDate = row.CreDate;
// document.UpdBy = row.UpdBy;
// document.UpdDate = row.UpdDate;
// document.UpdPgm = row.UpdPgm;
// this.SaveOrUpdate(document);
// documentID = document.DocumentID;
// }
// }
// #endregion
// #region ExpenseDataset Wait from Meaw
// if (updateTable is ExpenseDataSet.FnExpenseDocumentDataTable)
// {
// if (updateTable.Rows[0] is ExpenseDataSet.DocumentRow)
// {
// ExpenseDataSet.DocumentRow row = (ExpenseDataSet.DocumentRow)updateTable.Rows[0];
// SCGDocument document = this.FindByIdentity(row.DocumentID);
// document.CompanyID = new SCG.DB.DTO.DbCompany(row.CompanyID);
// document.CreatorID = new SS.SU.DTO.SuUser(row.CreatorID);
// document.RequesterID = new SS.SU.DTO.SuUser(row.RequesterID);
// if (row.ApproverID != null)
// {
// document.ApproverID = new SS.SU.DTO.SuUser(row.ApproverID);
// }
// else
// {
// document.ApproverID = null;
// }
// document.DocumentNo = row.DocumentNo;
// document.DocumentDate = row.DocumentDate;
// document.DocumentType = new SS.Standard.WorkFlow.DTO.DocumentType(row.DocumentTypeID);
// document.Subject = row.Subject;
// document.Memo = row.Memo;
// if (row.ReceiverID != null)
// {
// document.ReceiverID = new SS.SU.DTO.SuUser(row.ReceiverID);
// }
// else
// {
// document.ReceiverID = null;
// }
// document.Active = row.Active;
// document.CreBy = row.CreBy;
// document.CreDate = row.CreDate;
// document.UpdBy = row.UpdBy;
// document.UpdDate = row.UpdDate;
// document.UpdPgm = row.UpdPgm;
// this.SaveOrUpdate(document);
// documentID = document.DocumentID;
// }
// }
// #endregion
//}
//#endregion
//#region Insert
//if (insertTable != null)
//{
// #region Remittance
// if (insertTable is FnRemittanceDataset.FnRemittanceDataTable)
// {
// if (insertTable.Rows[0] is FnRemittanceDataset.DocumentRow)
// {
// FnRemittanceDataset.DocumentRow documentRow = (FnRemittanceDataset.DocumentRow)insertTable.Rows[0];
// SCGDocument document = new SCGDocument(documentRow);
// documentID = this.Save(document);
// }
// #region Update New DocumentID to Dataset
// dtDocument.Columns["DocumentID"].ReadOnly = false;
// dtDocument.Rows[0].BeginEdit();
// dtDocument.Rows[0]["DocumentID"] = documentID;
// dtDocument.Rows[0].EndEdit();
// dtDocument.Columns["DocumentID"].ReadOnly = true;
// #endregion
// }
// #endregion
// #region TADocument
// if (insertTable is TADocumentDataSet.TADocumentDataTable)
// {
// if (insertTable.Rows[0] is TADocumentDataSet.DocumentRow)
// {
// TADocumentDataSet.DocumentRow documentRow = (TADocumentDataSet.DocumentRow)insertTable.Rows[0];
// SCGDocument document = new SCGDocument(documentRow);
// documentID = this.Save(document);
// }
// #region Update New DocumentID to Dataset
// dtDocument.Columns["DocumentID"].ReadOnly = false;
// dtDocument.Rows[0].BeginEdit();
// dtDocument.Rows[0]["DocumentID"] = documentID;
// dtDocument.Rows[0].EndEdit();
// dtDocument.Columns["DocumentID"].ReadOnly = true;
// #endregion
// }
// #endregion
// #region Advance
// if (insertTable is AdvanceDataSet.AvAdvanceDocumentDataTable)
// {
// if (insertTable.Rows[0] is AdvanceDataSet.DocumentRow)
// {
// AdvanceDataSet.DocumentRow documentRow = (AdvanceDataSet.DocumentRow)insertTable.Rows[0];
// SCGDocument document = new SCGDocument(documentRow);
// documentID = this.Save(document);
// }
// #region Update New DocumentID to Dataset
// dtDocument.Columns["DocumentID"].ReadOnly = false;
// dtDocument.Rows[0].BeginEdit();
// dtDocument.Rows[0]["DocumentID"] = documentID;
// dtDocument.Rows[0].EndEdit();
// dtDocument.Columns["DocumentID"].ReadOnly = true;
// #endregion
// }
// #endregion
// #region Expense
// if (insertTable is ExpenseDataSet.FnExpenseDocumentDataTable)
// {
// if (insertTable.Rows[0] is ExpenseDataSet.DocumentRow)
// {
// ExpenseDataSet.DocumentRow documentRow = (ExpenseDataSet.DocumentRow)insertTable.Rows[0];
// SCGDocument document = new SCGDocument(documentRow);
// documentID = this.Save(document);
// }
// #region Update New DocumentID to Dataset
// dtDocument.Columns["DocumentID"].ReadOnly = false;
// dtDocument.Rows[0].BeginEdit();
// dtDocument.Rows[0]["DocumentID"] = documentID;
// dtDocument.Rows[0].EndEdit();
// dtDocument.Columns["DocumentID"].ReadOnly = true;
// }
// #endregion
// #endregion
//}
//return documentID;
//#endregion
#endregion
return(dtDocument.Rows[0].Field <long>(dtDocument.Columns["DocumentID"]));
}
public void Persist(DataTable dtExpenseMileageInvoice)
{
NHibernateAdapter <FnExpenseMileageInvoice, long> adapter = new NHibernateAdapter <FnExpenseMileageInvoice, long>();
adapter.UpdateChange(dtExpenseMileageInvoice, ScgeAccountingDaoProvider.FnExpenseMileageInvoiceDao);
}
public void Persist(TADocumentDataSet.TADocumentAdvanceDataTable taDocumentAdvanceDT)
{
NHibernateAdapter <TADocumentAdvance, int> adapter = new NHibernateAdapter <TADocumentAdvance, int>();
adapter.UpdateChange(taDocumentAdvanceDT, ScgeAccountingDaoProvider.TADocumentAdvanceDao);
}
public void Persist(DataTable dtExpensePerdiem)
{
NHibernateAdapter <FnExpensePerdiem, long> adapter = new NHibernateAdapter <FnExpensePerdiem, long>();
adapter.UpdateChange(dtExpensePerdiem, ScgeAccountingDaoProvider.FnExpensePerdiemDao);
}
public void Persist(DataTable dtDocumentAttachment)
{
NHibernateAdapter <DocumentAttachment, long> adapter = new NHibernateAdapter <DocumentAttachment, long>();
adapter.UpdateChange(dtDocumentAttachment, ScgeAccountingDaoProvider.DocumentAttachmentDao);
#region Old Comment By AO 07/04/2009
//DataTable insertTable = dtDocumentAttachment.GetChanges(DataRowState.Added);
//DataTable updateTable = dtDocumentAttachment.GetChanges(DataRowState.Modified);
//DataTable deleteTable = dtDocumentAttachment.GetChanges(DataRowState.Deleted);
//#region Persist
//// Delete DocumentAttachment.
//if (deleteTable != null)
//{
// foreach (DataRow documentAttachmentRow in deleteTable.Rows)
// {
// long attachmentID = Convert.ToInt64(documentAttachmentRow["AttachmentID", DataRowVersion.Original].ToString());
// DocumentAttachment documentAttachment = new DocumentAttachment(attachmentID);
// this.Delete(documentAttachment);
// }
//}
//#region Update DocumentAttachment.
//#region Update TA
//if (updateTable != null)
//{
// if (updateTable is TADocumentDataSet.DocumentAttachmentDataTable)
// {
// foreach (TADocumentDataSet.DocumentAttachmentRow documentAttachmentRow in (TADocumentDataSet.DocumentAttachmentDataTable)updateTable)
// {
// DocumentAttachment documentAttachment = new DocumentAttachment(documentAttachmentRow.AttachmentID);
// this.SaveOrUpdate(documentAttachment);
// }
// }
//}
//#endregion
//#region Update Advance
//if (updateTable != null)
//{
// if (updateTable is AdvanceDataSet.DocumentAttachmentDataTable)
// {
// foreach (AdvanceDataSet.DocumentAttachmentRow documentAttachmentRow in (AdvanceDataSet.DocumentAttachmentDataTable)updateTable)
// {
// DocumentAttachment documentAttachment = new DocumentAttachment(documentAttachmentRow.AttachmentID);
// this.SaveOrUpdate(documentAttachment);
// }
// }
//}
//#endregion
//#region Update Remittance
//if (updateTable != null)
//{
// if (updateTable is FnRemittanceDataset.DocumentAttachmentDataTable)
// {
// foreach (FnRemittanceDataset.DocumentAttachmentRow documentAttachmentRow in (FnRemittanceDataset.DocumentAttachmentDataTable)updateTable)
// {
// DocumentAttachment documentAttachment = new DocumentAttachment(documentAttachmentRow.AttachmentID);
// this.SaveOrUpdate(documentAttachment);
// }
// }
//}
//#endregion
//#region Update Expense
//if (updateTable != null)
//{
// if (updateTable is ExpenseDataSet.DocumentAttachmentDataTable)
// {
// foreach (ExpenseDataSet.DocumentAttachmentRow documentAttachmentRow in (ExpenseDataSet.DocumentAttachmentDataTable)updateTable)
// {
// DocumentAttachment documentAttachment = new DocumentAttachment(documentAttachmentRow.AttachmentID);
// this.SaveOrUpdate(documentAttachment);
// }
// }
//}
//#endregion
//#endregion
//#region Insert DocumentAttachment.
//#region Insert TA
//if (insertTable != null)
//{
// if (insertTable is TADocumentDataSet.DocumentAttachmentDataTable)
// {
// foreach (TADocumentDataSet.DocumentAttachmentRow documentAttachmentRow in (TADocumentDataSet.DocumentAttachmentDataTable)insertTable)
// {
// DocumentAttachment documentAttachement = new DocumentAttachment(documentAttachmentRow.AttachmentID);
// this.Save(documentAttachement);
// }
// }
//}
//#endregion
//#region Insert Advance
//if (insertTable != null)
//{
// if (insertTable is AdvanceDataSet.DocumentAttachmentDataTable)
// {
// foreach (AdvanceDataSet.DocumentAttachmentRow documentAttachmentRow in (AdvanceDataSet.DocumentAttachmentDataTable)insertTable)
// {
// DocumentAttachment documentAttachement = new DocumentAttachment(documentAttachmentRow.AttachmentID);
// this.Save(documentAttachement);
// }
// }
//}
//#endregion
//#region Insert Remittance
//if (insertTable != null)
//{
// if (insertTable is FnRemittanceDataset.DocumentAttachmentDataTable)
// {
// foreach (FnRemittanceDataset.DocumentAttachmentRow documentAttachmentRow in (FnRemittanceDataset.DocumentAttachmentDataTable)insertTable)
// {
// DocumentAttachment documentAttachement = new DocumentAttachment(documentAttachmentRow.AttachmentID);
// this.Save(documentAttachement);
// }
// }
//}
//#endregion
//#region Insert Expense
//if (insertTable != null)
//{
// if (insertTable is ExpenseDataSet.DocumentAttachmentDataTable)
// {
// foreach (ExpenseDataSet.DocumentAttachmentRow documentAttachmentRow in (ExpenseDataSet.DocumentAttachmentDataTable)insertTable)
// {
// DocumentAttachment documentAttachement = new DocumentAttachment(documentAttachmentRow.AttachmentID);
// this.Save(documentAttachement);
// }
// }
//}
//#endregion
//#endregion
//#endregion
#endregion
}
