public void DeleteAttachmentFromTransaction(Guid TxID, DocumentAttachment documentAttachment) { DataSet documentDataset = TransactionService.GetDS(TxID); DataRow row = documentDataset.Tables["DocumentAttachment"].Rows.Find(documentAttachment.AttachmentID); row.Delete(); }
public void UpdateTADocumentAdvanceTransaction(Guid txID, TADocumentAdvance taDocumentAdvance) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentAdvanceRow taDocumentAdvanceRow = taDocumentDS.TADocumentAdvance.FindByTADocumentAdvanceID(taDocumentAdvance.TADocumentAdvanceID); taDocumentAdvanceRow.BeginEdit(); if (taDocumentAdvance.TADocument != null) { taDocumentAdvanceRow.TADocumentID = taDocumentAdvance.TADocument.TADocumentID; } if (taDocumentAdvance.Advance != null) { taDocumentAdvanceRow.AdvanceID = taDocumentAdvance.Advance.AdvanceID; } taDocumentAdvanceRow.Active = taDocumentAdvance.Active; taDocumentAdvanceRow.CreBy = UserAccount.UserID; taDocumentAdvanceRow.CreDate = DateTime.Now; taDocumentAdvanceRow.UpdBy = UserAccount.UserID; taDocumentAdvanceRow.UpdDate = DateTime.Now; taDocumentAdvanceRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentAdvanceRow.EndEdit(); }
public void SaveTADocumentTraveller(Guid txID, long taDocumentID) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); // Insert, Delete TADocumentTraveller. ScgeAccountingDaoProvider.TADocumentTravellerDao.Persist(taDocumentDS.TADocumentTraveller); }
public void SaveRemittanceItem(Guid txID, long remittanceID) { FnRemittanceDataset ds = (FnRemittanceDataset)TransactionService.GetDS(txID); FnRemittanceDataset.FnRemittanceItemDataTable itemDt = new FnRemittanceDataset.FnRemittanceItemDataTable(); foreach (FnRemittanceDataset.FnRemittanceItemRow row in ds.FnRemittanceItem.Select()) { FnRemittanceDataset.FnRemittanceItemRow tempRow = itemDt.NewFnRemittanceItemRow(); tempRow.RemittanceID = row.RemittanceID; tempRow.PaymentType = row.PaymentType; tempRow.CurrencyID = row.CurrencyID; tempRow.ForeignCurrencyAdvanced = (double)Math.Round((decimal)row.ForeignCurrencyAdvanced, 2, MidpointRounding.AwayFromZero); tempRow.ExchangeRate = (double)Math.Round((decimal)row.ExchangeRate, 5, MidpointRounding.AwayFromZero); tempRow.ForeignCurrencyRemitted = (double)Math.Round((decimal)row.ForeignCurrencyRemitted, 2, MidpointRounding.AwayFromZero); tempRow.ForeignAmountTHBAdvanced = (double)Math.Round((decimal)row.ForeignAmountTHBAdvanced, 2, MidpointRounding.AwayFromZero); tempRow.AmountTHB = (double)Math.Round((decimal)row.AmountTHB, 2, MidpointRounding.AwayFromZero); tempRow.ExchangeRateTHB = (double)Math.Round((decimal)row.ExchangeRateTHB, 5, MidpointRounding.AwayFromZero); tempRow.ForeignAmountMainCurrencyAdvanced = (double)Math.Round((decimal)row.ForeignAmountMainCurrencyAdvanced, 2, MidpointRounding.AwayFromZero); tempRow.MainCurrencyAmount = (double)Math.Round((decimal)row.MainCurrencyAmount, 2, MidpointRounding.AwayFromZero); tempRow.IsImportFromAdvance = row.IsImportFromAdvance; tempRow.Active = row.Active; tempRow.CreBy = row.CreBy; tempRow.CreDate = row.CreDate; tempRow.UpdBy = row.UpdBy; tempRow.UpdDate = row.UpdDate; tempRow.UpdPgm = row.UpdPgm; itemDt.AddFnRemittanceItemRow(tempRow); } //ScgeAccountingDaoProvider.FnRemittanceItemDao.Persist(ds.FnRemittanceItem); ScgeAccountingDaoProvider.FnRemittanceItemDao.Persist(itemDt); }
public void SaveMPAItem(Guid txID, long documentID) { MPADocumentDataSet mpaItemDS = (MPADocumentDataSet)TransactionService.GetDS(txID); // Insert, Delete TADocumentTraveller. ScgeAccountingDaoProvider.MPAItemDao.Persist(mpaItemDS.MPAItem); }
//[Transaction] public void SaveExpenseMileage(Guid txID, long expenseId) { ExpenseDataSet expDS = (ExpenseDataSet)TransactionService.GetDS(txID); ScgeAccountingDaoProvider.FnExpenseMileageDao.Persist(expDS.FnExpenseMileage); ScgeAccountingDaoProvider.FnExpenseMileageItemDao.Persist(expDS.FnExpenseMileageItem); }
public DataTable DeleteRemittanceItemFromTransaction(Guid txID, long fnremittrnceItemID, bool isFromAdvanceGrid) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); long remittanceId = 0; FnRemittanceDataset remittanceDS = (FnRemittanceDataset)TransactionService.GetDS(txID); FnRemittanceDataset.FnRemittanceItemRow remittanceItemRow = remittanceDS.FnRemittanceItem.FindByRemittanceItemID(fnremittrnceItemID); if (remittanceItemRow != null && !remittanceItemRow.IsNull("RemittanceID")) { remittanceId = remittanceItemRow.RemittanceID; } if (!isFromAdvanceGrid) { if (remittanceItemRow.IsImportFromAdvance) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("CanNotDeleteItemInsertFromAdvance")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } } remittanceItemRow.Delete(); FnRemittanceService.UpdateTotalRemittanceAmount(txID, remittanceId); return(remittanceDS.FnRemittanceItem); }
public void ChangeRequesterTraveller(Guid txID, TADocumentTraveller taDocumentTraveller) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentTravellerRow taDocumentTravellerRow = taDocumentDS.TADocumentTraveller.FindByTravellerID(taDocumentTraveller.TravellerID); taDocumentTravellerRow.BeginEdit(); taDocumentTravellerRow.TADocumentID = taDocumentTraveller.TADocumentID.TADocumentID; taDocumentTravellerRow.UserID = taDocumentTraveller.UserID.Userid; taDocumentTravellerRow.EmployeeNameEng = taDocumentTraveller.EmployeeNameEng; taDocumentTravellerRow.AirLineMember = taDocumentTraveller.AirLineMember; if (taDocumentTraveller.CostCenterID != null) { taDocumentTravellerRow.CostCenterID = taDocumentTraveller.CostCenterID.CostCenterID; } if (taDocumentTraveller.Account != null) { taDocumentTravellerRow.AccountID = taDocumentTraveller.Account.AccountID; } if (taDocumentTraveller.IOID != null) { taDocumentTravellerRow.IOID = taDocumentTraveller.IOID.IOID; } taDocumentTravellerRow.UpdBy = UserAccount.UserID; taDocumentTravellerRow.UpdDate = DateTime.Now; taDocumentTravellerRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentTravellerRow.EndEdit(); }
public void UpdateTotalRemittanceAmount(Guid txID, long remittanceId) { FnRemittanceDataset fnRemittanceDS = (FnRemittanceDataset)TransactionService.GetDS(txID); if (fnRemittanceDS != null) { double totalRemittanceAmount = 0; double totalRemittanceMainAmount = 0; FnRemittanceDataset.FnRemittanceItemRow[] items = (FnRemittanceDataset.FnRemittanceItemRow[])fnRemittanceDS.FnRemittanceItem.Select(); FnRemittanceDataset.FnRemittanceRow fnremittanceRow = fnRemittanceDS.FnRemittance.FindByRemittanceID(remittanceId); if (items.Length > 0) { totalRemittanceAmount = items.Sum(x => x.AmountTHB); if ((!fnremittanceRow.IsIsRepOfficeNull() && fnremittanceRow.IsRepOffice)) { totalRemittanceMainAmount = items.Sum(x => x.MainCurrencyAmount); } } fnremittanceRow.BeginEdit(); fnremittanceRow.TotalAmount = (double)Math.Round((decimal)totalRemittanceAmount, 2, MidpointRounding.AwayFromZero); fnremittanceRow.MainCurrencyAmount = (double)Math.Round((decimal)totalRemittanceMainAmount, 2, MidpointRounding.AwayFromZero); //fnremittanceRow.IsRepOffice = isRepOffice; fnremittanceRow.EndEdit(); } }
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 DeleteExpenseMileageItemOnTransaction(Guid txId, long expenseMileageItemId) { ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(txId); ExpenseDataSet.FnExpenseMileageItemRow row = expDs.FnExpenseMileageItem.FindByExpenseMileageItemID(expenseMileageItemId); row.Delete(); }
private string GetPerdiemType(FnExpensePerdiemItem item, Guid txId) { ExpenseDataSet ds = (ExpenseDataSet)TransactionService.GetDS(txId); ExpenseDataSet.FnExpensePerdiemRow perRow = ds.FnExpensePerdiem.FindByExpensePerdiemID(item.ExpensePerdiem.ExpensePerdiemID); return(FnExpenseDocumentService.GetExpenseType(perRow.ExpenseID, txId)); }
public void SaveExpenseMileageItem(Guid txId, long expenseId) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); ExpenseDataSet expDS = (ExpenseDataSet)TransactionService.GetDS(txId); ScgeAccountingDaoProvider.FnExpenseMileageItemDao.Persist(expDS.FnExpenseMileageItem); }
public void DeleteMileage(Guid txID, long mileageId) { ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(txID); ExpenseDataSet.FnExpenseMileageRow row = expDs.FnExpenseMileage.FindByExpenseMileageID(mileageId); row.Delete(); FnExpenseInvoiceService.DeleteMileageInvoice(txID); }
public int AddTADocumentScheduleTransaction(Guid txID, TADocumentSchedule taDocumentSchedule) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentScheduleRow taDocumentScheduleRow = taDocumentDS.TADocumentSchedule.NewTADocumentScheduleRow(); taDocumentScheduleRow.TADocumentID = taDocumentSchedule.TADocumentID.TADocumentID; if (taDocumentSchedule.Date == null) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("Travelling date is required.")); } else { taDocumentScheduleRow.Date = taDocumentSchedule.Date.Value; } if (string.IsNullOrEmpty(taDocumentSchedule.DepartureFrom)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("Departure From is required.")); } else { taDocumentScheduleRow.DepartureFrom = taDocumentSchedule.DepartureFrom; } if (string.IsNullOrEmpty(taDocumentSchedule.ArrivalAt)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("Arrival At is required.")); } else { taDocumentScheduleRow.ArrivalAt = taDocumentSchedule.ArrivalAt; } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } taDocumentScheduleRow.DepartureFrom = taDocumentSchedule.DepartureFrom; taDocumentScheduleRow.ArrivalAt = taDocumentSchedule.ArrivalAt; taDocumentScheduleRow.TravelBy = taDocumentSchedule.TravelBy; taDocumentScheduleRow.Time = taDocumentSchedule.Time; taDocumentScheduleRow.FlightNo = taDocumentSchedule.FlightNo; taDocumentScheduleRow.TravellingDetail = taDocumentSchedule.TravellingDetail; taDocumentScheduleRow.Active = taDocumentSchedule.Active; taDocumentScheduleRow.CreBy = UserAccount.UserID; taDocumentScheduleRow.CreDate = DateTime.Now; taDocumentScheduleRow.UpdBy = UserAccount.UserID; taDocumentScheduleRow.UpdDate = DateTime.Now; taDocumentScheduleRow.UpdPgm = UserAccount.CurrentProgramCode; taDocumentDS.TADocumentSchedule.AddTADocumentScheduleRow(taDocumentScheduleRow); return(taDocumentScheduleRow.ScheduleID); }
public DataTable DeleteTADocumentScheduleTransaction(Guid txID, int scheduleID) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentScheduleRow taDocumentScheduleRow = taDocumentDS.TADocumentSchedule.FindByScheduleID(scheduleID); taDocumentScheduleRow.Delete(); return(taDocumentDS.TADocumentSchedule); }
public DataTable DeleteMPAItemTransaction(Guid txID, long MPAItemID) { MPADocumentDataSet MPAItemDS = (MPADocumentDataSet)TransactionService.GetDS(txID); MPADocumentDataSet.MPAItemRow mpaItemRow = MPAItemDS.MPAItem.FindByMPAItemID(MPAItemID); mpaItemRow.Delete(); return(MPAItemDS.MPAItem); }
public DataTable DeleteTADocumentTravellerTransaction(Guid txID, int travellerID) { TADocumentDataSet taDocumentDS = (TADocumentDataSet)TransactionService.GetDS(txID); TADocumentDataSet.TADocumentTravellerRow taDocumentTravellerRow = taDocumentDS.TADocumentTraveller.FindByTravellerID(travellerID); taDocumentTravellerRow.Delete(); return(taDocumentDS.TADocumentTraveller); }
public void AddMileageInvoiceItem(FnExpenseInvoiceItem item, Guid txId) { ExpenseDataSet ds = (ExpenseDataSet)TransactionService.GetDS(txId); ExpenseDataSet.FnExpenseInvoiceItemRow row = ds.FnExpenseInvoiceItem.NewFnExpenseInvoiceItemRow(); if (item.Invoice != null) { row.InvoiceID = item.Invoice.InvoiceID; } if (item.CostCenter != null) { row.CostCenterID = item.CostCenter.CostCenterID; } if (item.Account != null) { row.AccountID = item.Account.AccountID; } if (item.IO != null) { row.IOID = item.IO.IOID; } if (item.CurrencyID.HasValue) { row.CurrencyID = item.CurrencyID.Value; } if (item.Amount.HasValue) { row.Amount = item.Amount.Value; } if (item.ExchangeRate.HasValue) { row.ExchangeRate = item.ExchangeRate.Value; } if (item.CurrencyAmount.HasValue) { row.CurrencyAmount = item.CurrencyAmount.Value; } row.SaleOrder = item.SaleOrder; row.SaleItem = item.SaleItem; row.Description = item.Description; row.ReferenceNo = item.ReferenceNo; row.Active = true; row.CreBy = UserAccount.UserID; row.CreDate = DateTime.Now; row.UpdBy = UserAccount.UserID; row.UpdDate = DateTime.Now; row.UpdPgm = UserAccount.CurrentProgramCode; ds.FnExpenseInvoiceItem.AddFnExpenseInvoiceItemRow(row); }
public void DeleteExpensePerdiemDetailTransaction(long perdiemDetailId, Guid txId) { ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(txId); ExpenseDataSet.FnExpensePerdiemDetailRow row = expDs.FnExpensePerdiemDetail.FindByExpensePerdiemDetailID(perdiemDetailId); long expensePerdiemId = row.ExpensePerdiemID; row.Delete(); FnExpensePerdiemService.UpdateExpensePerdiemCalculateTransaction(expensePerdiemId, txId); }
public void UpdateMPADocumentTransaction(Guid txID, MPADocument mpaDocument) { Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); MPADocumentDataSet mpaDocumentDS = (MPADocumentDataSet)TransactionService.GetDS(txID); MPADocumentDataSet.MPADocumentRow mpaDocumentRow = mpaDocumentDS.MPADocument.FindByMPADocumentID(mpaDocument.MPADocumentID); mpaDocumentRow.BeginEdit(); mpaDocumentRow.DocumentID = mpaDocument.DocumentID.DocumentID; //if (mpaDocument.StartDate < DateTime.Today) //{ // errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("StartDateMoreOrEqualToDay")); //} if (mpaDocument.StartDate > mpaDocument.EndDate) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("StartDateLessOrEqualEndDate")); } if (mpaDocument.StartDate.Equals(DateTime.MinValue)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("StartDateIsRequired")); } else { mpaDocumentRow.StartDate = mpaDocument.StartDate; } if (mpaDocument.EndDate.Equals(DateTime.MinValue)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("EndDateIsRequired")); } else { mpaDocumentRow.EndDate = mpaDocument.EndDate; } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } mpaDocumentRow.Active = mpaDocument.Active; mpaDocumentRow.CreBy = UserAccount.UserID; mpaDocumentRow.CreDate = DateTime.Now; mpaDocumentRow.UpdBy = UserAccount.UserID; mpaDocumentRow.UpdDate = DateTime.Now; mpaDocumentRow.UpdPgm = UserAccount.CurrentProgramCode; mpaDocumentRow.EndEdit(); }
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 void DeleteExpensePerdiemItemTransaction(long itemId, Guid txId) { ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(txId); ExpenseDataSet.FnExpensePerdiemItemRow row = expDs.FnExpensePerdiemItem.FindByPerdiemItemID(itemId); long expensePerdiemID = row.ExpensePerdiemID; row.Delete(); FnExpensePerdiemService.UpdateExpensePerdiemCalculateTransaction(expensePerdiemID, txId); }
public void ValidateVerifyDetail(Guid txId, ViewPostDocumentType docType, bool isRepOffice) { DataSet ds = TransactionService.GetDS(txId); DataTable documentTable = ds.Tables["Document"]; SCGDocument document = new SCGDocument(); if (documentTable.Rows.Count > 0) { document.LoadFromDataRow(documentTable.Rows[0]); } Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); if (string.IsNullOrEmpty(document.BranchCode)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("BranchCodeIsRequired")); } if (!document.PostingDate.HasValue) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("PostingDateIsRequired")); } if (!document.BaseLineDate.HasValue) { if (docType.Equals(ViewPostDocumentType.AdvanceForeign)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("ValueDateIsRequired")); } else { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("BaseLineDateIsRequired")); } //errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("BaseLineDate is Required.")); } if (docType.Equals(ViewPostDocumentType.AdvanceForeign)) { if (!isRepOffice && string.IsNullOrEmpty(document.BankAccount)) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("BankAccountIsRequired")); } } else if (!docType.Equals(ViewPostDocumentType.Remittance)) { if (!document.PaymentMethodID.HasValue) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("PaymentMethodIDIsRequired")); } } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } }
public long AddFixedAdvanceDocument(Guid txid, string fixedadvanceType) { FixedAdvanceDataSet ds = (FixedAdvanceDataSet)TransactionService.GetDS(txid); FixedAdvanceDataSet.DocumentRow docRow = ds.Document.NewDocumentRow();//create newRow to dataset ds.Document.AddDocumentRow(docRow); FixedAdvanceDataSet.FixedAdvanceDocumentRow fixedavRow = ds.FixedAdvanceDocument.NewFixedAdvanceDocumentRow(); fixedavRow.DocumentID = docRow.DocumentID; ds.FixedAdvanceDocument.AddFixedAdvanceDocumentRow(fixedavRow); return(fixedavRow.FixedAdvanceID); }
public long AddAdvanceDocument(Guid txid, string advanceType) { AdvanceDataSet ds = (AdvanceDataSet)TransactionService.GetDS(txid); AdvanceDataSet.DocumentRow docRow = ds.Document.NewDocumentRow();//create newRow to dataset ds.Document.AddDocumentRow(docRow); AdvanceDataSet.AvAdvanceDocumentRow avRow = ds.AvAdvanceDocument.NewAvAdvanceDocumentRow(); avRow.DocumentID = docRow.DocumentID; avRow.AdvanceType = advanceType; ds.AvAdvanceDocument.AddAvAdvanceDocumentRow(avRow); return(avRow.AdvanceID); }
public long AddFnRemittanceDocumentTransaction(Guid txID) { FnRemittanceDataset fnRemittanceDocumentDS = (FnRemittanceDataset)TransactionService.GetDS(txID); FnRemittanceDataset.DocumentRow documentRow = fnRemittanceDocumentDS.Document.NewDocumentRow(); //create new row to dataset. fnRemittanceDocumentDS.Document.AddDocumentRow(documentRow); //add new row to dataset. FnRemittanceDataset.FnRemittanceRow fnRemittanceDocumentRow = fnRemittanceDocumentDS.FnRemittance.NewFnRemittanceRow(); fnRemittanceDocumentRow.DocumentID = documentRow.DocumentID; fnRemittanceDocumentDS.FnRemittance.AddFnRemittanceRow(fnRemittanceDocumentRow); return(fnRemittanceDocumentRow.RemittanceID); }
public void UpdateNonDeductAmountInvoiceItem(Guid txID, long invoiceId, double rateNonDeduct) { ExpenseDataSet expenseDs = (ExpenseDataSet)TransactionService.GetDS(txID); DataRow[] drArr = expenseDs.FnExpenseInvoiceItem.Select(string.Format("{0} = '{1}'", expenseDs.FnExpenseInvoiceItem.InvoiceIDColumn, invoiceId)); foreach (ExpenseDataSet.FnExpenseInvoiceItemRow row in drArr) { double amount = Convert.ToDouble(row.Amount); double nonDeductAmount = ((amount * rateNonDeduct) / 100); row.NonDeductAmount = (double)Math.Round(Convert.ToDecimal(nonDeductAmount), 2, MidpointRounding.AwayFromZero); } }
public void SaveDocumentAttachment(Guid txID, long documentID) { DataSet ds = TransactionService.GetDS(txID); DataTable insertTable = ds.Tables["DocumentAttachment"].GetChanges(DataRowState.Added); string saveFilePath = ParameterServices.LocalAccessUploadFilePath + documentID.ToString(); string oldFilePath = string.Empty; string newFilePath = string.Empty; if (insertTable != null) { foreach (DataRow row in insertTable.Rows) { row.BeginEdit(); oldFilePath = row["AttachFilePath"].ToString(); newFilePath = row["AttachFilePath"].ToString().Replace(txID.ToString(), documentID.ToString()); row["AttachFilePath"] = saveFilePath; row.EndEdit(); } ds.Tables["DocumentAttachment"].Merge(insertTable); // Move file to new filepath. if (!string.IsNullOrEmpty(oldFilePath) && !string.IsNullOrEmpty(newFilePath) && !newFilePath.Equals(oldFilePath)) { if (Directory.Exists(oldFilePath)) { if (!Directory.Exists(newFilePath)) { // if Directory not Exist then create new Directory. Directory.CreateDirectory(newFilePath); } string[] files = Directory.GetFiles(oldFilePath); foreach (string file in files) { string newFile = file.Replace(oldFilePath, newFilePath); File.Copy(file, newFile, true); } // Call FileDelete for Delete file in the specific directory. Utilities.FilesDelete(oldFilePath); } } } // Insert, Delete DocumentAttachment. ScgeAccountingDaoProvider.DocumentAttachmentDao.Persist(ds.Tables["DocumentAttachment"]); }
public void UpdateRemittanceDocumentTransaction(Guid txtID, FnRemittance fnRemittance, bool IsHeaderAndFooter) { this.ValidateRemittance(fnRemittance, IsHeaderAndFooter); // function to validateion of remittance. Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors(); FnRemittanceDataset fnRemittanceDS = (FnRemittanceDataset)TransactionService.GetDS(txtID); #region FnRemittanceDocument FnRemittanceDataset.FnRemittanceRow fnremittanceRow = fnRemittanceDS.FnRemittance.FindByRemittanceID(fnRemittance.RemittanceID); if (!IsHeaderAndFooter && fnremittanceRow.TotalAmount == 0) { errors.AddError("Provider.Error", new Spring.Validation.ErrorMessage("CannotSaveRemittance_TotalRemittanceAmountMustMoreThanZero")); } if (!errors.IsEmpty) { throw new ServiceValidationException(errors); } fnremittanceRow.BeginEdit(); if (fnRemittance.Document != null) { fnremittanceRow.DocumentID = fnRemittance.Document.DocumentID; } if (fnRemittance.TADocumentID > 0) { fnremittanceRow.TADocumentID = fnRemittance.TADocumentID; } if (fnRemittance.PB != null) { fnremittanceRow.PBID = fnRemittance.PB.Pbid; } if (fnRemittance.MainCurrencyID != null) { fnremittanceRow.MainCurrencyID = fnRemittance.MainCurrencyID; } //fnremittanceRow.TotalAmount = (double)Math.Round((decimal)fnRemittance.TotalAmount, 2, MidpointRounding.AwayFromZero); fnremittanceRow.isFullClearing = fnRemittance.IsFullClearing; fnremittanceRow.IsRepOffice = Convert.ToBoolean(fnRemittance.IsRepOffice); fnremittanceRow.Active = fnRemittance.Active; fnremittanceRow.CreBy = UserAccount.UserID; fnremittanceRow.CreDate = DateTime.Now; fnremittanceRow.UpdBy = UserAccount.UserID; fnremittanceRow.UpdDate = DateTime.Now;; fnremittanceRow.UpdPgm = UserAccount.CurrentProgramCode; fnremittanceRow.EndEdit(); #endregion }