//[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 Guid BeginExpenseTransaction()
{
ExpenseDataSet ds = (ExpenseDataSet)PrepareExpenseDS();
Guid txId = TransactionService.Begin(ds);
return(txId);
}
public void DeleteExpenseMileageItemOnTransaction(Guid txId, long expenseMileageItemId)
{
ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(txId);
ExpenseDataSet.FnExpenseMileageItemRow row = expDs.FnExpenseMileageItem.FindByExpenseMileageItemID(expenseMileageItemId);
row.Delete();
}
public void PrepareDataToDataset(ExpenseDataSet ds, long mileageId)
{
IList <FnExpenseMileageInvoice> mileageInvoiceList = ScgeAccountingQueryProvider.FnExpenseMileageInvoiceQuery.GetMileageInvoiceByMileageID(mileageId);
foreach (FnExpenseMileageInvoice mileageInvoice in mileageInvoiceList)
{
// Set data to invoice row in Dataset.
ExpenseDataSet.FnExpenseMileageInvoiceRow row = ds.FnExpenseMileageInvoice.NewFnExpenseMileageInvoiceRow();
row.MileageInvoiceID = mileageInvoice.MileageInvoiceID;
if (mileageInvoice.ExpenseMileage != null)
{
row.ExpenseMileageID = mileageInvoice.ExpenseMileage.ExpenseMileageID;
}
if (mileageInvoice.Invoice != null)
{
row.MileageInvoiceID = mileageInvoice.Invoice.InvoiceID;
}
row.Active = mileageInvoice.Active;
row.CreBy = mileageInvoice.CreBy;
row.CreDate = mileageInvoice.CreDate;
row.UpdBy = mileageInvoice.UpdBy;
row.UpdDate = mileageInvoice.UpdDate;
row.UpdPgm = mileageInvoice.UpdPgm;
// Add mileage invoice row to documentDataset.
ds.FnExpenseMileageInvoice.AddFnExpenseMileageInvoiceRow(row);
}
}
public void DeleteInvoiceOnTransaction(FnExpenseInvoice invoice, Guid txId)
{
ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(txId);
ExpenseDataSet.FnExpenseInvoiceRow row = expDs.FnExpenseInvoice.FindByInvoiceID(invoice.InvoiceID);
expDs.FnExpenseInvoice.RemoveFnExpenseInvoiceRow(row);
}
public DataSet PrepareExpenseDS(long documentId)
{
ExpenseDataSet expDs = (ExpenseDataSet)this.PrepareExpenseDS();
return(expDs);
}
public void PrepareDataToDataset(ExpenseDataSet ds, long expenseId)
{
IList <FnExpenseAdvance> advList = ScgeAccountingQueryProvider.FnExpenseAdvanceQuery.FindByExpenseDocumentID(expenseId);
foreach (FnExpenseAdvance adv in advList)
{
// Set data to invoice row in Dataset.
ExpenseDataSet.FnExpenseAdvanceRow expAdvRow = ds.FnExpenseAdvance.NewFnExpenseAdvanceRow();
expAdvRow.FnExpenseAdvanceID = adv.FnExpenseAdvanceID;
if (adv.Expense != null)
{
expAdvRow.ExpenseID = adv.Expense.ExpenseID;
}
if (adv.Advance != null)
{
expAdvRow.AdvanceID = adv.Advance.AdvanceID;
}
expAdvRow.Active = adv.Active;
expAdvRow.CreBy = adv.CreBy;
expAdvRow.CreDate = adv.CreDate;
expAdvRow.UpdBy = adv.UpdBy;
expAdvRow.UpdDate = adv.UpdDate;
expAdvRow.UpdPgm = adv.UpdPgm;
// Add expense remittance row to documentDataset.
ds.FnExpenseAdvance.AddFnExpenseAdvanceRow(expAdvRow);
}
}
private string ShowPerdiemPopup(string mode, long?invoiceId)
{
ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(this.TransactionId);
long? perdiemId = null;
string url = String.Format(perdiemURL, this.TransactionId, this.ExpDocumentID, this.DocumentType, this.DocumentID, Request.QueryString["cp"]);
string filter = string.Format(" ExpenseID = {0} ", this.ExpDocumentID);
if (invoiceId.HasValue)
{
filter += string.Format(" and InvoiceID = {0} ", invoiceId.Value);
}
DataRow[] perdiemRows = expDs.FnExpensePerdiem.Select(filter);
if (perdiemRows.Length > 0)
{
perdiemId = perdiemRows[0].Field <long>("ExpensePerdiemID");
if (mode.Equals(FlagEnum.NewFlag))
{
mode = FlagEnum.EditFlag;
}
}
else
{
if (mode.Equals(FlagEnum.EditFlag))
{
mode = FlagEnum.NewFlag;
}
}
if (perdiemId.HasValue)
{
url += String.Format("&perdiemId={0}", perdiemId);
}
return(url.Replace("[mode]", mode));
}
public void DeleteExpensePerdiemItemOnTransaction(Guid txId, long itemId)
{
ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(txId);
ExpenseDataSet.FnExpensePerdiemItemRow row = expDs.FnExpensePerdiemItem.FindByPerdiemItemID(itemId);
expDs.FnExpensePerdiemItem.RemoveFnExpensePerdiemItemRow(row);
}
public void PrepareDataToDataset(ExpenseDataSet ds, long expenseId)
{
IList <FnExpenseRemittance> remittedList = ScgeAccountingQueryProvider.FnExpenseRemittanceQuery.GetExpenseRemittanceByExpenseID(expenseId);
foreach (FnExpenseRemittance remitted in remittedList)
{
// Set data to invoice row in Dataset.
ExpenseDataSet.FnExpenseRemittanceRow expRemittedRow = ds.FnExpenseRemittance.NewFnExpenseRemittanceRow();
expRemittedRow.ExpenseRemittanceID = remitted.ExpenseRemittanceID;
if (remitted.Expense != null)
{
expRemittedRow.ExpenseID = remitted.Expense.ExpenseID;
}
if (remitted.Remittance != null)
{
expRemittedRow.RemittanceID = remitted.Remittance.RemittanceID;
}
expRemittedRow.Active = remitted.Active;
expRemittedRow.CreBy = remitted.CreBy;
expRemittedRow.CreDate = remitted.CreDate;
expRemittedRow.UpdBy = remitted.UpdBy;
expRemittedRow.UpdDate = remitted.UpdDate;
expRemittedRow.UpdPgm = remitted.UpdPgm;
// Add expense remittance row to documentDataset.
ds.FnExpenseRemittance.AddFnExpenseRemittanceRow(expRemittedRow);
}
}
public void BindExpenseMPAGridView()
{
ExpenseDataSet expenseDS = (ExpenseDataSet)TransactionService.GetDS(this.TransactionId);
ExpenseDataSet.FnExpenseMPARow[] rows = (ExpenseDataSet.FnExpenseMPARow[])expenseDS.FnExpenseMPA.Select();
List <long> expenseMPAIdList = new List <long>();
foreach (ExpenseDataSet.FnExpenseMPARow row in rows)
{
// Prepare list of advance id for query
expenseMPAIdList.Add(row.MPADocumentID);
}
if (expenseMPAIdList.Count > 0)
{
ctlExpeseMPAGridView.DataSource = ScgeAccountingQueryProvider.MPADocumentQuery.FindByExpenseMPAID(expenseMPAIdList);
ctlExpeseMPAGridView.DataBind();
}
else
{
ctlExpeseMPAGridView.DataSource = null;
ctlExpeseMPAGridView.DataBind();
}
ctlUpdatePanelExpenseGeneral.Update();
}
public void PrepareDataToDataset(ExpenseDataSet ds, long perdiemId)
{
IList <FnExpensePerdiemDetail> perdiemDetailList = ScgeAccountingQueryProvider.FnExpensePerdiemDetailQuery.GetPerdiemDetailByPerdiemID(perdiemId);
foreach (FnExpensePerdiemDetail detail in perdiemDetailList)
{
// Set data to perdiem item row in Dataset.
ExpenseDataSet.FnExpensePerdiemDetailRow itemRow = ds.FnExpensePerdiemDetail.NewFnExpensePerdiemDetailRow();
itemRow.ExpensePerdiemDetailID = detail.ExpensePerdiemDetailID;
if (detail.ExpensePerdiem != null)
{
itemRow.ExpensePerdiemID = detail.ExpensePerdiem.ExpensePerdiemID;
}
itemRow.Description = detail.Description;
itemRow.CurrencyID = detail.CurrencyID;
itemRow.Amount = detail.Amount;
itemRow.ExchangeRate = detail.ExchangeRate;
// Add perdiem detail row to documentDataset.
ds.FnExpensePerdiemDetail.AddFnExpensePerdiemDetailRow(itemRow);
}
}
private string ShowMileagePopup(string mode)
{
ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(this.TransactionId);
DataRow[] drs = expDs.FnExpenseMileage.Select(string.Format(" ExpenseID = {0}", this.ExpDocumentID));
ExpenseDataSet.FnExpenseDocumentRow row = expDs.FnExpenseDocument.FindByExpenseID(this.ExpDocumentID);
string url = string.Empty;
if ((expDs.FnExpenseMileage != null) && (expDs.FnExpenseMileage.Rows.Count > 0))
{
if (drs.Length > 0)
{
url = String.Format(string.Concat(MileageURL, "&mileageId={3}&docId={4}&cp={5}"), this.TransactionId, this.ExpDocumentID, this.DocumentType, drs[0]["ExpenseMileageID"], row.DocumentID, Request.QueryString["cp"]);
}
else
{
url = String.Format(string.Concat(MileageURL, "&docId={3}&cp={4}"), this.TransactionId, this.ExpDocumentID, this.DocumentType, row.DocumentID, Request.QueryString["cp"]).Replace("[mode]", FlagEnum.NewFlag);
}
}
else
{
url = String.Format(string.Concat(MileageURL, "&docId={3}&cp={4}"), this.TransactionId, this.ExpDocumentID, this.DocumentType, row.DocumentID, Request.QueryString["cp"]).Replace("[mode]", FlagEnum.NewFlag);
}
return(url.Replace("[mode]", mode));
}
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 PrepareDataToDataset(ExpenseDataSet ds, long expenseId)
{
IList <FnExpenseMPA> ExpMPAList = ScgeAccountingQueryProvider.FnExpensMPAQuery.FindByExpenseDocumentID(expenseId);
foreach (FnExpenseMPA expMPA in ExpMPAList)
{
// Set data to invoice row in Dataset.
ExpenseDataSet.FnExpenseMPARow expAdvRow = ds.FnExpenseMPA.NewFnExpenseMPARow();
expAdvRow.FnExpenseMPAID = expAdvRow.FnExpenseMPAID;
if (expMPA.ExpenseID != null)
{
expAdvRow.ExpenseID = expMPA.ExpenseID.ExpenseID;
}
if (expMPA.MPADocumentID != null)
{
expAdvRow.MPADocumentID = (long)expMPA.MPADocumentID;
}
expAdvRow.Active = expMPA.Active;
expAdvRow.CreBy = expMPA.CreBy;
expAdvRow.CreDate = expMPA.CreDate;
expAdvRow.UpdBy = expMPA.UpdBy;
expAdvRow.UpdDate = expMPA.UpdDate;
expAdvRow.UpdPgm = expMPA.UpdPgm;
// Add expense remittance row to documentDataset.
ds.FnExpenseMPA.AddFnExpenseMPARow(expAdvRow);
}
}
public long UpdateBeginRowExpensePerdiemOnTransaction(FnExpensePerdiem expensePerdiem, Guid txId)
{
Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors();
if (expensePerdiem.CostCenterID == null)
{
errors.AddError("Perdiem.Error", new Spring.Validation.ErrorMessage("RequiredCostCenter"));
}
if (expensePerdiem.AccountID == null)
{
errors.AddError("Perdiem.Error", new Spring.Validation.ErrorMessage("RequiredAccountID"));
}
if (expensePerdiem.Description == null)
{
errors.AddError("Perdiem.Error", new Spring.Validation.ErrorMessage("RequiredDescription"));
}
if (!expensePerdiem.PerdiemRate.HasValue)
{
errors.AddError("Perdiem.Error", new Spring.Validation.ErrorMessage("RequiredPerdiemRate"));
}
if (expensePerdiem.PerdiemRate.Equals((decimal)0))
{
errors.AddError("Perdiem.Error", new Spring.Validation.ErrorMessage("RequiredPerdiemRateOverZero"));
}
if (!errors.IsEmpty)
{
throw new ServiceValidationException(errors);
}
ExpenseDataSet ds = (ExpenseDataSet)TransactionService.GetDS(txId);
ExpenseDataSet.FnExpensePerdiemRow row = ds.FnExpensePerdiem.FindByExpensePerdiemID(expensePerdiem.ExpensePerdiemID);
row.BeginEdit();
row.InvoiceID = expensePerdiem.InvoiceID.InvoiceID;
row.CostCenterID = expensePerdiem.CostCenterID.CostCenterID;
row.AccountID = expensePerdiem.AccountID.AccountID;
if (expensePerdiem.IOID != null)
{
row.IOID = expensePerdiem.IOID.IOID;
}
row.Description = expensePerdiem.Description;
row.PerdiemRate = expensePerdiem.PerdiemRate.Value;
row.ReferenceNo = expensePerdiem.ReferenceNo;
row.CreBy = expensePerdiem.CreBy;
row.CreDate = expensePerdiem.CreDate;
row.UpdBy = expensePerdiem.UpdBy;
row.UpdDate = expensePerdiem.UpdDate;
row.UpdPgm = expensePerdiem.UpdPgm;
row.Active = true;
row.EndEdit();
row.AcceptChanges();
return(row.ExpensePerdiemID);
}
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 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 ClearRemittanceGridview()
//{
// ExpenseDataSet expenseDS = (ExpenseDataSet)TransactionService.GetDS(this.TransactionId);
// if (expenseDS != null)
// {
// ExpenseDataSet.FnExpenseRemittanceRow[] rows = (ExpenseDataSet.FnExpenseRemittanceRow[])expenseDS.FnExpenseRemittance.Select();
// foreach (ExpenseDataSet.FnExpenseRemittanceRow row in rows)
// {
// row.Delete();
// }
// this.BindRemittanceGridview();
// }
//}
public void DeleteTAFromExpense()
{
ExpenseDataSet expenseDS = (ExpenseDataSet)TransactionService.GetDS(this.TransactionId);
if (expenseDS.FnExpenseDocument.Rows.Count > 0)
{
expenseDS.FnExpenseDocument[0].SetTADocumentIDNull();
}
}
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 long AddBeginRowExpensePerdiemOnTransaction(FnExpensePerdiem expensePerdiem, Guid txId)
{
ExpenseDataSet ds = (ExpenseDataSet)TransactionService.GetDS(txId);
ExpenseDataSet.FnExpensePerdiemRow row = ds.FnExpensePerdiem.NewFnExpensePerdiemRow();
ds.FnExpensePerdiem.AddFnExpensePerdiemRow(row);
return(row.ExpensePerdiemID);
}
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 long AddInvoiceOnTransaction(FnExpenseInvoice invoice, Guid txId)
{
ExpenseDataSet ds = (ExpenseDataSet)TransactionService.GetDS(txId);
ExpenseDataSet.FnExpenseInvoiceRow row = ds.FnExpenseInvoice.NewFnExpenseInvoiceRow();
ds.FnExpenseInvoice.AddFnExpenseInvoiceRow(row);
return(row.InvoiceID);
}
public DataSet PrepareExpenseDS()
{
ExpenseDataSet ds = new ExpenseDataSet();
ds.EnforceConstraints = false;
ds.Document.DocumentIDColumn.AutoIncrement = true;
ds.Document.DocumentIDColumn.AutoIncrementSeed = -1;
ds.Document.DocumentIDColumn.AutoIncrementStep = -1;
ds.FnExpenseDocument.ExpenseIDColumn.AutoIncrement = true;
ds.FnExpenseDocument.ExpenseIDColumn.AutoIncrementSeed = -1;
ds.FnExpenseDocument.ExpenseIDColumn.AutoIncrementStep = -1;
ds.FnExpenseAdvance.AdvanceIDColumn.AutoIncrement = true;
ds.FnExpenseAdvance.AdvanceIDColumn.AutoIncrementSeed = -1;
ds.FnExpenseAdvance.AdvanceIDColumn.AutoIncrementStep = -1;
ds.FnExpenseInvoice.InvoiceIDColumn.AutoIncrement = true;
ds.FnExpenseInvoice.InvoiceIDColumn.AutoIncrementSeed = -1;
ds.FnExpenseInvoice.InvoiceIDColumn.AutoIncrementStep = -1;
ds.FnExpenseInvoiceItem.InvoiceItemIDColumn.AutoIncrement = true;
ds.FnExpenseInvoiceItem.InvoiceItemIDColumn.AutoIncrementSeed = -1;
ds.FnExpenseInvoiceItem.InvoiceItemIDColumn.AutoIncrementStep = -1;
ds.FnExpenseMileage.ExpenseMileageIDColumn.AutoIncrement = true;
ds.FnExpenseMileage.ExpenseMileageIDColumn.AutoIncrementSeed = -1;
ds.FnExpenseMileage.ExpenseMileageIDColumn.AutoIncrementStep = -1;
ds.FnExpenseMileageItem.ExpenseMileageItemIDColumn.AutoIncrement = true;
ds.FnExpenseMileageItem.ExpenseMileageItemIDColumn.AutoIncrementSeed = -1;
ds.FnExpenseMileageItem.ExpenseMileageItemIDColumn.AutoIncrementStep = -1;
ds.FnExpensePerdiem.ExpensePerdiemIDColumn.AutoIncrement = true;
ds.FnExpensePerdiem.ExpensePerdiemIDColumn.AutoIncrementSeed = -1;
ds.FnExpensePerdiem.ExpensePerdiemIDColumn.AutoIncrementStep = -1;
ds.FnExpensePerdiemItem.PerdiemItemIDColumn.AutoIncrement = true;
ds.FnExpensePerdiemItem.PerdiemItemIDColumn.AutoIncrementSeed = -1;
ds.FnExpensePerdiemItem.PerdiemItemIDColumn.AutoIncrementStep = -1;
ds.DocumentAttachment.AttachmentIDColumn.AutoIncrement = true;
ds.DocumentAttachment.AttachmentIDColumn.AutoIncrementSeed = -1;
ds.DocumentAttachment.AttachmentIDColumn.AutoIncrementStep = -1;
ds.DocumentInitiator.InitiatorIDColumn.AutoIncrement = true;
ds.DocumentInitiator.InitiatorIDColumn.AutoIncrementSeed = -1;
ds.DocumentInitiator.InitiatorIDColumn.AutoIncrementStep = -1;
ds.WorkFlow.WorkFlowIDColumn.AutoIncrement = true;
ds.WorkFlow.WorkFlowIDColumn.AutoIncrementSeed = -1;
ds.WorkFlow.WorkFlowIDColumn.AutoIncrementStep = -1;
return(ds.Clone());
}
public void BindExpenseGrid()
{
ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(TransactionId);
string filter = String.Format("ExpenseID = {0}", this.ExpDocumentID);
ctlRepeater.DataSource = expDs.FnExpenseInvoice.Select(filter, "CreDate asc");
ctlRepeater.DataBind();
ctlSimpleExpense.Visible = false;
ctlUpdatePanelExpenseInvoice.Update();
ctlUpdatePanelExpenseGeneral.Update();
}
public void BindRemittanceGridview()
{
ExpenseDataSet expenseDS = (ExpenseDataSet)TransactionService.GetDS(this.TransactionId);
ExpenseDataSet.FnExpenseAdvanceRow[] rows = (ExpenseDataSet.FnExpenseAdvanceRow[])expenseDS.FnExpenseAdvance.Select();
List <long> advanceIdList = new List <long>();
foreach (ExpenseDataSet.FnExpenseAdvanceRow row in rows)
{
// Prepare list of advance id for query
advanceIdList.Add(row.AdvanceID);
}
if (!advanceIdList.Count.Equals(0))
{
IList <SCG.eAccounting.DTO.ValueObject.Advance> advDtoList = ScgeAccountingQueryProvider.FnRemittanceAdvanceQuery.FindRemittanceAdvanceAndItemsByAdvanceIDs(advanceIdList);
IList <long> remittanceIdList = new List <long>();
foreach (SCG.eAccounting.DTO.ValueObject.Advance advDto in advDtoList)
{
remittanceIdList.Add(advDto.RemittanceID);
}
if (remittanceIdList.Count > 0)
{
if (ScgeAccountingQueryProvider.FnRemittanceItemQuery.FindRemittanceItemByRemittanceIds(remittanceIdList, UserAccount.CurrentLanguageID).Count > 0)
{
IsEmptyRemittance = false;
}
else
{
IsEmptyRemittance = true;
}
ctlRemittanceGridview.DataSource = ScgeAccountingQueryProvider.FnRemittanceItemQuery.FindRemittanceItemByRemittanceIds(remittanceIdList, UserAccount.CurrentLanguageID);
ctlRemittanceGridview.DataBind();
}
else
{
IsEmptyRemittance = true;
ctlRemittanceGridview.DataSource = null;
ctlRemittanceGridview.DataBind();
}
}
else
{
IsEmptyRemittance = true;
ctlRemittanceGridview.DataSource = null;
ctlRemittanceGridview.DataBind();
}
ctlRemittanceGridview.DataBind();
ctlUpdatePanelExpenseGeneral.Update();
}
public void UpdateDomesticInvoiceItemOnTransaction(FnExpenseInvoiceItem item, Guid txId)
{
Spring.Validation.ValidationErrors errors = new Spring.Validation.ValidationErrors();
if (item.CostCenter == null)
{
errors.AddError("InvoiceItem.Error", new Spring.Validation.ErrorMessage("RequiredCostCenter"));
}
if (item.Account == null)
{
errors.AddError("InvoiceItem.Error", new Spring.Validation.ErrorMessage("RequiredAccountCode"));
}
if (item.IO == null)
{
errors.AddError("InvoiceItem.Error", new Spring.Validation.ErrorMessage("RequiredIO"));
}
if (!item.Amount.HasValue)
{
errors.AddError("InvoiceItem.Error", new Spring.Validation.ErrorMessage("RequiredAmount"));
}
if (!errors.IsEmpty)
{
throw new ServiceValidationException(errors);
}
ExpenseDataSet ds = (ExpenseDataSet)TransactionService.GetDS(txId);
ExpenseDataSet.FnExpenseInvoiceItemRow row = ds.FnExpenseInvoiceItem.FindByInvoiceItemID(item.InvoiceItemID);
//row.ExpenseID = item.Expense.ExpenseID;
//row.InvoiceID = item.Invoice.InvoiceID;
row.CostCenterID = item.CostCenter.CostCenterID;
row.AccountID = item.Account.AccountID;
row.IOID = item.IO.IOID;
if (item.Amount.HasValue)
{
row.Amount = (decimal)item.Amount.Value;
}
//if (item.ExchangeRate.HasValue)
// row.ExchangeRate = (decimal)item.ExchangeRate;
row.Description = item.Description;
row.ReferenceNo = item.ReferenceNo;
row.CreBy = item.CreBy;
row.CreDate = item.CreDate;
row.UpdBy = item.UpdBy;
row.UpdDate = item.UpdDate;
row.UpdPgm = item.UpdPgm;
row.Active = true;
ds.FnExpenseInvoiceItem.AddFnExpenseInvoiceItemRow(row);
}
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 Initialize(Guid txID, long documentID, string initFlag)
{
this.TransactionId = txID;
this.ExpDocumentID = documentID;
this.InitialFlag = initFlag;
ExpenseDataSet expDs = (ExpenseDataSet)TransactionService.GetDS(this.TransactionId);
ExpenseDataSet.FnExpenseDocumentRow expenseDocumentRow = expDs.FnExpenseDocument.FindByExpenseID(this.ExpDocumentID);
this.DocumentID = expenseDocumentRow.DocumentID;
this.InitialControl();
//this.BindControl();
}
public long AddNewExpenseDocumentOnTransaction(FnExpenseDocument exp, Guid txId)
{
ExpenseDataSet ds = (ExpenseDataSet)TransactionService.GetDS(txId);
ExpenseDataSet.DocumentRow docRow = ds.Document.NewDocumentRow();
ExpenseDataSet.FnExpenseDocumentRow expRow = ds.FnExpenseDocument.NewFnExpenseDocumentRow();
expRow.DocumentID = docRow.DocumentID;
ds.FnExpenseDocument.AddFnExpenseDocumentRow(expRow);
return(expRow.ExpenseID);
}
