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 }