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
}