public long SaveRemittanceDocument(Guid txID, long remittanceID) { FnRemittanceDataset remittanceDS = (FnRemittanceDataset)TransactionService.GetDS(txID); FnRemittanceDataset.FnRemittanceRow remittanceRow = remittanceDS.FnRemittance.FindByRemittanceID(remittanceID); long documentID = remittanceRow.DocumentID; documentID = SCGDocumentService.SaveSCGDocument(txID, documentID); remittanceID = ScgeAccountingDaoProvider.FnRemittanceDao.Persist(remittanceDS.FnRemittance); ScgeAccountingDaoProvider.FnRemittanceDao.DeleteAllRemittanceItemAndRemittanceAdvance(remittanceRow.RemittanceID); FnRemittanceItemService.SaveRemittanceItem(txID, remittanceID); FnRemittanceAdvanceService.SaveRemittanceAdvance(txID, remittanceID); // Add code for update clearing advance by Anuwat S on 19/04/2009 AvAdvanceDocumentService.UpdateRemittanceAdvance(remittanceID, double.Parse("0" + remittanceDS.FnRemittance.Rows[0]["TotalAmount"].ToString()), false); if (!remittanceRow.IsIsRepOfficeNull() && remittanceRow.IsRepOffice) { AvAdvanceDocumentService.UpdateRemittanceAdvanceForRepOffice(remittanceID, double.Parse("0" + remittanceDS.FnRemittance.Rows[0]["MainCurrencyAmount"].ToString()), false); } return(remittanceID); }
public void SendEmailToOverDueDate() { IList <VOAdvanceOverDueReport> voList = ScgeAccountingQueryProvider.SCGDocumentQuery.GetAdvanceOverdueList(); foreach (VOAdvanceOverDueReport item in voList) { SCGDocument document = SCGDocumentService.FindByIdentity(item.DocumentID); SCGEmailService.SendEmailEM10(item.AdvanceID, document.RequesterID.Userid, document.ApproverID.Email, "This is e-mail for autoreminder advancedocument system.", true); } }
public long SaveFixedAdvance(Guid txid, long fixedadvanceId) { FixedAdvanceDataSet fixedadvanceDataset = (FixedAdvanceDataSet)TransactionService.GetDS(txid); FixedAdvanceDataSet.FixedAdvanceDocumentRow row = fixedadvanceDataset.FixedAdvanceDocument.FindByFixedAdvanceID(fixedadvanceId); long documentID = row.DocumentID; documentID = SCGDocumentService.SaveSCGDocument(txid, documentID); fixedadvanceId = ScgeAccountingDaoProvider.FixedAdvanceDocumentDao.Persist(fixedadvanceDataset.FixedAdvanceDocument); return(fixedadvanceId); }
public long SaveAvAdvance(Guid txid, long advanceId) { AdvanceDataSet advanceDataset = (AdvanceDataSet)TransactionService.GetDS(txid); AdvanceDataSet.AvAdvanceDocumentRow row = advanceDataset.AvAdvanceDocument.FindByAdvanceID(advanceId); long documentID = row.DocumentID; documentID = SCGDocumentService.SaveSCGDocument(txid, documentID); //insert update or delete AvAdvanveDocument advanceId = ScgeAccountingDaoProvider.AvAdvanceDocumentDao.Persist(advanceDataset.AvAdvanceDocument); //inset update or delete AvAdvanceItem AvAdvanceItemService.saveAdvanceItem(txid, advanceId); return(advanceId); }
public long SaveMPADocument(Guid txID, long mpaDocumentID) { MPADocumentDataSet mpaDocumentDS = (MPADocumentDataSet)TransactionService.GetDS(txID); MPADocumentDataSet.MPADocumentRow mpaDocumentRow = mpaDocumentDS.MPADocument.FindByMPADocumentID(mpaDocumentID); long documentID = mpaDocumentRow.DocumentID; // Insert, Update SCGDocument. // Insert, Update, Delete DocumentInitiator. // Insert, Delete DocumentAttachment. documentID = SCGDocumentService.SaveSCGDocument(txID, documentID); // Insert, Update, Delete MPADocument. mpaDocumentID = ScgeAccountingDaoProvider.MPADocumentDao.Persist(mpaDocumentDS.MPADocument); // Insert, Update, Delete MPAItem. MPAItemService.SaveMPAItem(txID, documentID); return(mpaDocumentID); }
public long SaveCADocument(Guid txID, long caDocumentID) { CADocumentDataSet caDocumentDS = (CADocumentDataSet)TransactionService.GetDS(txID); CADocumentDataSet.CADocumentRow caDocumentRow = caDocumentDS.CADocument.FindByCADocumentID(caDocumentID); long documentID = caDocumentRow.DocumentID; // Insert, Update SCGDocument. // Insert, Update, Delete DocumentInitiator. // Insert, Delete DocumentAttachment. documentID = SCGDocumentService.SaveSCGDocument(txID, documentID); // Insert, Update, Delete MPADocument. caDocumentID = ScgeAccountingDaoProvider.CADocumentDao.Persist(caDocumentDS.CADocument); // Insert, Update, Delete MPAItem. //MPAItemService.SaveMPADocumentItem(txID, mpaDocumentID); return(caDocumentID); }
public long SaveTADocument(Guid txID, long taDocumentID) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentRow taDocumentRow = taDocumentDS.TADocument.FindByTADocumentID(taDocumentID); long documentID = taDocumentRow.DocumentID; // Insert, Update SCGDocument. // Insert, Update, Delete DocumentInitiator. // Insert, Delete DocumentAttachment. documentID = SCGDocumentService.SaveSCGDocument(txID, documentID); // Insert, Update, Delete TADocument. taDocumentID = ScgeAccountingDaoProvider.TADocumentDao.Persist(taDocumentDS.TADocument); // Insert, Update, Delete TADocumentTraveller. TADocumentTravellerService.SaveTADocumentTraveller(txID, taDocumentID); // Insert, Update, Delete TADocumentSchedule. TADocumentScheduleService.SaveTADocumentSchedule(txID, taDocumentID); return(taDocumentID); }
public System.Data.DataSet PrepareDataToDataset(long documentID, bool isCopy) { MPADocumentDataSet mpaDocumentDS = new MPADocumentDataSet(); MPADocument mpaDocument = ScgeAccountingQueryProvider.MPADocumentQuery.GetMPADocumentByDocumentID(documentID); Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); if (mpaDocument == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("MPADocumentNotFound")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } // Prepare Data to Document datatable. if (!isCopy) { SCGDocumentService.PrepareDataToDataset(mpaDocumentDS, documentID); } else { SCGDocumentService.PrepareDataInternalToDataset(mpaDocumentDS, documentID, isCopy); } // Set data to Document row MPADocumentDataSet.MPADocumentRow mpaDocumentRow = mpaDocumentDS.MPADocument.NewMPADocumentRow(); mpaDocumentRow.MPADocumentID = mpaDocument.MPADocumentID; if (!isCopy) { if (mpaDocument.DocumentID != null) { mpaDocumentRow.DocumentID = mpaDocument.DocumentID.DocumentID; } } else { if (mpaDocumentDS.Document.Rows.Count > 0) { MPADocumentDataSet.DocumentRow docRow = (MPADocumentDataSet.DocumentRow)mpaDocumentDS.Document.Rows[0]; mpaDocumentRow.DocumentID = docRow.DocumentID; } } mpaDocumentRow.StartDate = mpaDocument.StartDate; mpaDocumentRow.EndDate = mpaDocument.EndDate; mpaDocumentRow.Active = mpaDocument.Active; mpaDocumentRow.CreBy = mpaDocument.CreBy; mpaDocumentRow.CreDate = mpaDocument.CreDate; mpaDocumentRow.UpdBy = mpaDocument.UpdBy; mpaDocumentRow.UpdDate = mpaDocument.UpdDate; mpaDocumentRow.UpdPgm = mpaDocument.UpdPgm; // Add ta document row to MPADocument. mpaDocumentDS.MPADocument.AddMPADocumentRow(mpaDocumentRow); // Prepare Data to MPAItemService Datatable. MPAItemService.PrepareDataToDataset(mpaDocumentDS, mpaDocument.MPADocumentID); return(mpaDocumentDS); }
public System.Data.DataSet PrepareDataToDataset(long documentID, bool isCopy) { CADocumentDataSet caDocumentDS = new CADocumentDataSet(); CADocument caDocument = ScgeAccountingQueryProvider.CADocumentQuery.GetCADocumentByDocumentID(documentID); Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); if (caDocument == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("CADocumentNotFound")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } // Prepare Data to Document datatable. if (!isCopy) { SCGDocumentService.PrepareDataToDataset(caDocumentDS, documentID); } else { SCGDocumentService.PrepareDataInternalToDataset(caDocumentDS, documentID, isCopy); } // Set data to Document row CADocumentDataSet.CADocumentRow caDocumentRow = caDocumentDS.CADocument.NewCADocumentRow(); caDocumentRow.CADocumentID = caDocument.CADocumentID; if (!isCopy) { if (caDocument.DocumentID != null) { caDocumentRow.DocumentID = caDocument.DocumentID.DocumentID; } } else { if (caDocumentDS.Document.Rows.Count > 0) { CADocumentDataSet.DocumentRow docRow = (CADocumentDataSet.DocumentRow)caDocumentDS.Document.Rows[0]; caDocumentRow.DocumentID = docRow.DocumentID; } } caDocumentRow.StartDate = caDocument.StartDate; caDocumentRow.EndDate = caDocument.EndDate; caDocumentRow.IsTemporary = caDocument.IsTemporary; if (caDocument.CarLicenseNo != null) { caDocumentRow.CarLicenseNo = caDocument.CarLicenseNo; } if (caDocument.CarLicenseNo != null) { caDocumentRow.Brand = caDocument.Brand; } if (caDocument.Model != null) { caDocumentRow.Model = caDocument.Model; } if (caDocument.IsWorkArea != null) { caDocumentRow.IsWorkArea = caDocument.IsWorkArea.Value; } if (caDocument.Remark != null) { caDocumentRow.Remark = caDocument.Remark; } caDocumentRow.CarType = caDocument.CarType; caDocumentRow.OwnerType = caDocument.OwnerType; caDocumentRow.Active = caDocument.Active; caDocumentRow.CreBy = caDocument.CreBy; caDocumentRow.CreDate = caDocument.CreDate; caDocumentRow.UpdBy = caDocument.UpdBy; caDocumentRow.UpdDate = caDocument.UpdDate; caDocumentRow.UpdPgm = caDocument.UpdPgm; // Add ta document row to MPADocument. caDocumentDS.CADocument.AddCADocumentRow(caDocumentRow); // Prepare Data to MPAItemService Datatable. //MPAItemService.PrepareDataToDataset(mpaDocumentDS, mpaDocument.MPADocumentID); return(caDocumentDS); }
public DataSet PrepareDataToDataset(long documentID, bool isCopy) { TADocumentDataSet taDocumentDS = new TADocumentDataSet(); TADocument taDocument = ScgeAccountingQueryProvider.TADocumentQuery.GetTADocumentByDocumentID(documentID); Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); if (taDocument == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("NoTADocumentFound")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } // Prepare Data to Document datatable. if (!isCopy) { SCGDocumentService.PrepareDataToDataset(taDocumentDS, documentID); } else { SCGDocumentService.PrepareDataInternalToDataset(taDocumentDS, documentID, isCopy); } // Set data to Budget Document row in budgetDocumentDS. TADocumentDataSet.TADocumentRow taDocumentRow = taDocumentDS.TADocument.NewTADocumentRow(); taDocumentRow.TADocumentID = taDocument.TADocumentID; if (!isCopy) { if (taDocument.DocumentID != null) { taDocumentRow.DocumentID = taDocument.DocumentID.DocumentID; } } else { if (taDocumentDS.Document.Rows.Count > 0) { TADocumentDataSet.DocumentRow docRow = (TADocumentDataSet.DocumentRow)taDocumentDS.Document.Rows[0]; taDocumentRow.DocumentID = docRow.DocumentID; } } taDocumentRow.FromDate = taDocument.FromDate; taDocumentRow.ToDate = taDocument.ToDate; taDocumentRow.IsBusinessPurpose = taDocument.IsBusinessPurpose; taDocumentRow.IsTrainningPurpose = taDocument.IsTrainningPurpose; taDocumentRow.IsOtherPurpose = taDocument.IsOtherPurpose; if (taDocument.OtherPurposeDescription != null) { taDocumentRow.OtherPurposeDescription = taDocument.OtherPurposeDescription; } taDocumentRow.TravelBy = taDocument.TravelBy; if (taDocument.Province != null) { taDocumentRow.Province = taDocument.Province; } if (taDocument.Country != null) { taDocumentRow.Country = taDocument.Country; } taDocumentRow.Ticketing = taDocument.Ticketing; //if (taDocument.CostCenterID != null) //{ // taDocumentRow.CostCenterID = taDocument.CostCenterID.CostCenterID; //} //if (taDocument.Account != null) //{ // taDocumentRow.AccountID = taDocument.Account.AccountID; //} //if (taDocument.IOID != null) //{ // taDocumentRow.IOID = taDocument.IOID.IOID; //} taDocumentRow.Active = taDocument.Active; taDocumentRow.CreBy = taDocument.CreBy; taDocumentRow.CreDate = taDocument.CreDate; taDocumentRow.UpdBy = taDocument.UpdBy; taDocumentRow.UpdDate = taDocument.UpdDate; taDocumentRow.UpdPgm = taDocument.UpdPgm; // Add ta document row to taDocument. taDocumentDS.TADocument.AddTADocumentRow(taDocumentRow); // Prepare Data to TADocumentTravellerService Datatable. TADocumentTravellerService.PrepareDataToDataset(taDocumentDS, taDocument.TADocumentID); // Prepare Data to TADocumentScheduleService Datatable. TADocumentScheduleService.PrepareDataToDataset(taDocumentDS, taDocument.TADocumentID); //Not Save to TADocumemtAdvance Table. // Prepare Data to TADocumentAdvanceService Datatable. ////TADocumentAdvanceService.PrepareDataToDataset(taDocumentDS, taDocument.TADocumentID); return(taDocumentDS); }
public FnRemittanceDataset PrepareDataToDataset(long documentID, bool isCopy) { FnRemittanceDataset remittanceDS = new FnRemittanceDataset(); FnRemittance remittance = ScgeAccountingQueryProvider.FnRemittanceQuery.GetFnRemittanceByDocumentID(documentID); Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); if (remittance == null) { errors.AddError("Remittance.Error", new Spring.Validation.ErrorMessage("NoRemittanceFound")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } // Prepare Data to Document datatable. if (!isCopy) { SCGDocumentService.PrepareDataToDataset(remittanceDS, documentID); } else { SCGDocumentService.PrepareDataInternalToDataset(remittanceDS, documentID, isCopy); } // Set data to Remittance Document row in FnremittanceDS. FnRemittanceDataset.FnRemittanceRow remittanceRow = remittanceDS.FnRemittance.NewFnRemittanceRow(); remittanceRow.RemittanceID = remittance.RemittanceID; //remittanceRow.SAPIONo = remittance.SAPIONo; if (!isCopy) { if (remittance.Document != null) { remittanceRow.DocumentID = remittance.Document.DocumentID; } //remittanceRow.PBID = remittance.PB.Pbid; remittanceRow.TotalAmount = remittance.TotalAmount; remittanceRow.isFullClearing = remittance.IsFullClearing; remittanceRow.TADocumentID = remittance.TADocumentID; } else { if (remittanceDS.Document.Rows.Count > 0) { FnRemittanceDataset.DocumentRow docRow = (FnRemittanceDataset.DocumentRow)remittanceDS.Document.Rows[0]; remittanceRow.DocumentID = docRow.DocumentID; } } remittanceRow.PBID = remittance.PB.Pbid; remittanceRow.MainCurrencyAmount = remittance.MainCurrencyAmount; remittanceRow.IsRepOffice = Convert.ToBoolean(remittance.IsRepOffice); remittanceRow.Active = remittance.Active; remittanceRow.CreBy = remittance.CreBy; remittanceRow.CreDate = remittance.CreDate; remittanceRow.UpdBy = remittance.UpdBy; remittanceRow.UpdDate = remittance.UpdDate; remittanceRow.UpdPgm = remittance.UpdPgm; // Add Remittance document row to FnremittanceDS. remittanceDS.FnRemittance.AddFnRemittanceRow(remittanceRow); // Prepare Data to RemittanceItem Datatable. FnRemittanceItemService.PrepareDataToDataset(remittanceDS, remittance.RemittanceID); // Prepare Data to RemittacneAdvance Datatable. FnRemittanceAdvanceService.PrepareDataToDataset(remittanceDS, remittance.RemittanceID); return(remittanceDS); }
public void UpdateHeaderAndFooterToTransaction(Guid txid, SCGDocument document, FnRemittance remittance) { SCGDocumentService.UpdateTransactionDocument(txid, document, false, false); this.UpdateRemittanceDocumentTransaction(txid, remittance, true); }
public AdvanceDataSet PrepareDataToDs(long documentId) { AdvanceDataSet advanceDs = new AdvanceDataSet(); //ดึงจาก base มาใส่ใน DataSet AvAdvanceDocument avDb = ScgeAccountingQueryProvider.AvAdvanceDocumentQuery.GetAvAdvanceByDocumentID(documentId); Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); if (avDb == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("NoAvAdvanceFound")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } // Prepare Data to Document datatable. SCGDocumentService.PrepareDataToDataset(advanceDs, documentId); // Set data to Advance Document row in advanceDs. AdvanceDataSet.AvAdvanceDocumentRow avRow = advanceDs.AvAdvanceDocument.NewAvAdvanceDocumentRow(); avRow.AdvanceID = avDb.AdvanceID; avRow.DocumentID = avDb.DocumentID.DocumentID; if (avDb.TADocumentID.HasValue) { avRow.TADocumentID = avDb.TADocumentID.Value; } else { avRow.SetTADocumentIDNull(); } avRow.AdvanceType = avDb.AdvanceType; if (avDb.PBID != null && avDb.PBID.Pbid > 0) { avRow.PBID = avDb.PBID.Pbid; } else { avRow.SetPBIDNull(); } if (avDb.ServiceTeamID != null && avDb.ServiceTeamID.ServiceTeamID > 0) { avRow.ServiceTeamID = avDb.ServiceTeamID.ServiceTeamID; } else { avRow.SetServiceTeamIDNull(); } avRow.RequestDateOfAdvance = avDb.RequestDateOfAdvance; avRow.DueDateOfRemittance = avDb.DueDateOfRemittance; avRow.RequestDateOfRemittance = avDb.RequestDateOfRemittance; if (avDb.AdvanceType == ZoneType.Foreign) { avRow.ArrivalDate = avDb.ArrivalDate.Value; } avRow.Reason = avDb.Reason; avRow.PerDiemExRateUSD = (decimal)avDb.PerDiemExRateUSD; avRow.Amount = (decimal)avDb.Amount; avRow.RemittanceAmount = (decimal)avDb.RemittanceAmount; avRow.ExpenseAmount = (decimal)avDb.ExpenseAmount; avRow.Active = avDb.Active; avRow.CreBy = UserAccount.UserID; avRow.CreDate = DateTime.Now; avRow.UpdBy = UserAccount.UserID; avRow.UpdDate = DateTime.Now; avRow.UpdPgm = UserAccount.CurrentProgramCode; if (avDb.MainCurrencyID.HasValue && avDb.MainCurrencyID.Value > 0) { avRow.MainCurrencyID = avDb.MainCurrencyID.Value; } else { avRow.SetMainCurrencyIDNull(); } if (avDb.MainCurrencyAmount.HasValue) { avRow.MainCurrencyAmount = (decimal)avDb.MainCurrencyAmount.Value; } else { avRow.SetMainCurrencyAmountNull(); } if (avDb.ExchangeRateForLocalCurrency.HasValue) { avRow.ExchangeRateForLocalCurrency = (decimal)avDb.ExchangeRateForLocalCurrency.Value; } else { avRow.SetExchangeRateForLocalCurrencyNull(); } if (avDb.ExchangeRateMainToTHBCurrency.HasValue) { avRow.ExchangeRateMainToTHBCurrency = (decimal)avDb.ExchangeRateMainToTHBCurrency.Value; } else { avRow.SetExchangeRateMainToTHBCurrencyNull(); } if (avDb.LocalCurrencyAmount.HasValue) { avRow.LocalCurrencyAmount = (decimal)avDb.LocalCurrencyAmount.Value; } else { avRow.SetLocalCurrencyAmountNull(); } if (avDb.IsRepOffice.HasValue) { avRow.IsRepOffice = avDb.IsRepOffice.Value; } else { avRow.SetIsRepOfficeNull(); } if (avDb.RequestDateOfAdvanceApproved.HasValue) { avRow.RequestDateOfAdvanceApproved = avDb.RequestDateOfAdvanceApproved.Value; } else { avRow.SetRequestDateOfAdvanceApprovedNull(); } advanceDs.AvAdvanceDocument.AddAvAdvanceDocumentRow(avRow); // Prepare Data to AvAdvanceItem Datatable. AvAdvanceItemService.PrepareDataToDataset(advanceDs, avRow.AdvanceID, false); advanceDs.AcceptChanges(); return(advanceDs); }
public DataSet PrepareInternalDataToDataset(long documentId, bool isCopy) { FixedAdvanceDataSet fixedadvanceDs = new FixedAdvanceDataSet(); //ดึงจาก base มาใส่ใน DataSet FixedAdvanceDocument favDb = ScgeAccountingQueryProvider.FixedAdvanceDocumentQuery.GetFixedAdvanceByDocumentID(documentId); Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); if (favDb == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("NoFixedAdvanceFound")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } // Prepare Data to Document datatable. if (!isCopy) { SCGDocumentService.PrepareDataToDataset(fixedadvanceDs, documentId); } else { SCGDocumentService.PrepareDataInternalToDataset(fixedadvanceDs, documentId, isCopy); } // Set data to Advance Document row in advanceDs. FixedAdvanceDataSet.FixedAdvanceDocumentRow favRow = fixedadvanceDs.FixedAdvanceDocument.NewFixedAdvanceDocumentRow(); if (!isCopy) { favRow.DocumentID = favDb.DocumentID.DocumentID; favRow.FixedAdvanceID = favDb.FixedAdvanceID; favRow.EffectiveFromDate = favDb.EffectiveFromDate; favRow.EffectiveToDate = favDb.EffectiveToDate; favRow.RequestDate = favDb.RequestDate; if (favDb.ReturnRequestDate != null) { favRow.ReturnRequestDate = (DateTime)favDb.ReturnRequestDate; } /*Check RefFixedAdvanceID is null*/ favRow.Objective = favDb.Objective; if (favDb.RefFixedAdvanceID != null) { favRow.RefFixedAdvanceID = (long)favDb.RefFixedAdvanceID; } favRow.FixedAdvanceType = favDb.FixedAdvanceType; favRow.Amount = (decimal)favDb.Amount; favRow.NetAmount = (decimal)favDb.NetAmount; } else { if (fixedadvanceDs.Document.Rows.Count > 0) { FixedAdvanceDataSet.DocumentRow docRow = (FixedAdvanceDataSet.DocumentRow)fixedadvanceDs.Document.Rows[0]; favRow.DocumentID = docRow.DocumentID; } favRow.EffectiveFromDate = favDb.EffectiveFromDate; favRow.EffectiveToDate = favDb.EffectiveToDate; favRow.RequestDate = favDb.RequestDate; if (favDb.ReturnRequestDate != null) { favRow.ReturnRequestDate = (DateTime)favDb.ReturnRequestDate; } favRow.Objective = favDb.Objective; if (favDb.RefFixedAdvanceID != null) { favRow.RefFixedAdvanceID = (long)favDb.RefFixedAdvanceID; } favRow.FixedAdvanceType = favDb.FixedAdvanceType; favRow.Amount = (decimal)favDb.Amount; favRow.NetAmount = (decimal)favDb.NetAmount; } favRow.PaymentType = favDb.PaymentType; favRow.ReturnPaymentType = favDb.ReturnPaymentType; if (favDb.PBID != null && favDb.PBID.Pbid > 0) { favRow.PBID = favDb.PBID.Pbid; } else { favRow.SetPBIDNull(); } if (favDb.ReturnPBID != null && favDb.ReturnPBID.Pbid > 0) { favRow.ReturnPBID = favDb.ReturnPBID.Pbid; } else { favRow.SetReturnPBIDNull(); } if (favDb.ReturnServiceTeamID != null && favDb.ReturnServiceTeamID.ServiceTeamID > 0) { favRow.ReturnServiceTeamID = favDb.ReturnServiceTeamID.ServiceTeamID; } else { favRow.SetReturnServiceTeamIDNull(); } favRow.PostingStatusReturn = favDb.PostingStatusReturn; favRow.BranchCodeReturn = favDb.BranchCodeReturn; favRow.FixedAdvanceBankAccount = favDb.FixedAdvanceBankAccount; if (favDb.PaymentMethodIDReturn != null) { favRow.PaymentMethodIDReturn = (long)favDb.PaymentMethodIDReturn; } if (favDb.PostingDateReturn != null) { favRow.PostingDateReturn = (DateTime)favDb.PostingDateReturn; } else { favRow.PostingDateReturn = DateTime.MinValue; } if (favDb.BaseLineDateReturn != null) { favRow.BaseLineDateReturn = (DateTime)favDb.BaseLineDateReturn; } else { favRow.BaseLineDateReturn = DateTime.MinValue; } favRow.Active = favDb.Active; favRow.CreBy = UserAccount.UserID; favRow.CreDate = DateTime.Now; favRow.UpdBy = UserAccount.UserID; favRow.UpdDate = DateTime.Now; favRow.UpdPgm = UserAccount.CurrentProgramCode; fixedadvanceDs.FixedAdvanceDocument.AddFixedAdvanceDocumentRow(favRow); return(fixedadvanceDs); }