private static object[] Take(BUPlanAdjustmentDetailEntity bUPlanAdjustmentDetailEntity)
{
return(new object[]
{
"@RefDetailID", bUPlanAdjustmentDetailEntity.RefDetailId,
"@RefID", bUPlanAdjustmentDetailEntity.RefId,
"@ItemName", bUPlanAdjustmentDetailEntity.ItemName,
"@BudgetSourceID", bUPlanAdjustmentDetailEntity.BudgetSourceId,
"@BudgetChapterCode", bUPlanAdjustmentDetailEntity.BudgetChapterCode,
"@BudgetKindItemCode", bUPlanAdjustmentDetailEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", bUPlanAdjustmentDetailEntity.BudgetSubKindItemCode,
"@BudgetGroupItemCode", bUPlanAdjustmentDetailEntity.BudgetGroupItemCode,
"@BudgetItemCode", bUPlanAdjustmentDetailEntity.BudgetItemCode,
"@BudgetSubItemCode", bUPlanAdjustmentDetailEntity.BudgetSubItemCode,
"@DebitAccount", bUPlanAdjustmentDetailEntity.DebitAccount,
"@AdjustmentAmount", bUPlanAdjustmentDetailEntity.AdjustmentAmount,
"@ProjectID", bUPlanAdjustmentDetailEntity.ProjectId,
"@ListItemID", bUPlanAdjustmentDetailEntity.ListItemId,
"@SortOrder", bUPlanAdjustmentDetailEntity.SortOrder,
"@TaskID", bUPlanAdjustmentDetailEntity.TaskId,
"@BudgetDetailItemCode", bUPlanAdjustmentDetailEntity.BudgetDetailItemCode,
"@FundStructureID", bUPlanAdjustmentDetailEntity.FundStructureId,
"@BankAccount", bUPlanAdjustmentDetailEntity.BankAccount,
"@ProjectExpenseEAID", bUPlanAdjustmentDetailEntity.ProjectExpenseEAID,
"@ProjectActivityEAID", bUPlanAdjustmentDetailEntity.ProjectActivityEAID,
"@BudgetProvideCode", bUPlanAdjustmentDetailEntity.BudgetProvideCode,
"@ContractID", bUPlanAdjustmentDetailEntity.ContractId,
"@CapitalPlanID", bUPlanAdjustmentDetailEntity.CapitalPlanId,
"@MethodDistributeId", bUPlanAdjustmentDetailEntity.MethodDistributeId,
"@ActivityID", bUPlanAdjustmentDetailEntity.ActivityId,
"@Amount", bUPlanAdjustmentDetailEntity.Amount
});
}
public List <BUPlanAdjustmentDetailEntity> BUPlanAdjustmentDetails(List <BUPlanAdjustmentDetail> details, string refid)
{
List <BUPlanAdjustmentDetailEntity> lstBuPlanReceiptDetailEntities = new List <BUPlanAdjustmentDetailEntity>();
foreach (var result in details)
{
var newresult = new BUPlanAdjustmentDetailEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.RefId = refid;
newresult.ItemName = result.ItemName;
newresult.BudgetSourceId = result.BudgetSource == null ? null : result.BudgetSource.BudgetSourceID.ToString();
newresult.BudgetChapterCode = result.BudgetChapterCode;
newresult.BudgetKindItemCode = result.BudgetKindItemCode;
newresult.BudgetSubKindItemCode = result.BudgetSubKindItemCode;
newresult.BudgetGroupItemCode = result.BudgetGroupItemCode;
newresult.BudgetItemCode = result.BudgetItemCode;
newresult.BudgetSubItemCode = result.BudgetSubItemCode;
newresult.DebitAccount = result.DebitAccount;
newresult.AdjustmentAmount = result.AdjustmentAmount;
newresult.ProjectId = result.Project == null ? null : result.Project.ProjectID.ToString();
//newresult.ActivityId = result.Project == null ? null : result.Project.CDCActivityType.ToString();
newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString();
newresult.SortOrder = result.SortOrder ?? 0;
newresult.TaskId = result.TaskID.ToString();
newresult.BudgetDetailItemCode = result.BudgetDetailItemCode;
newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString();
newresult.BankAccount = result.BankAccount;
newresult.ProjectExpenseEAID = result.ProjectExpense == null ? null : result.ProjectExpense.ProjectExpenseID.ToString();
newresult.ProjectActivityEAID = result.Project1 == null ? null : result.Project1.ProjectID.ToString();
newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode;
lstBuPlanReceiptDetailEntities.Add(newresult);
}
return(lstBuPlanReceiptDetailEntities);
}
/// <summary>
/// Inserts the account balance.
/// </summary>
/// <param name="buPlanReceipt">The bu plan receipt.</param>
/// <param name="buPlanReceiptDetail">The bu plan receipt detail.</param>
public void InsertAccountBalance(BUPlanAdjustmentEntity buPlanAdjustment, BUPlanAdjustmentDetailEntity buPlanAdjustmentDetail)
{
//insert AccountBalance for debit account
var accountBalanceForDebit = AddAccountBalanceForDebit(buPlanAdjustment, buPlanAdjustmentDetail);
var accountBalanceForDebitExit = AccountBalanceDao.GetExitsAccountBalance(accountBalanceForDebit);
if (accountBalanceForDebitExit != null)
{
UpdateAccountBalance(accountBalanceForDebitExit, accountBalanceForDebit.MovementDebitAmountOC,
accountBalanceForDebit.MovementDebitAmount, true, 1);
}
else
{
AccountBalanceDao.InsertAccountBalance(accountBalanceForDebit);
}
}
/// <summary>
/// Adds the account balance for debit.
/// </summary>
/// <param name="buPlanReceipt">The bu plan receipt.</param>
/// <param name="buPlanReceiptDetail">The bu plan receipt detail.</param>
/// <returns></returns>
public AccountBalanceEntity AddAccountBalanceForDebit(BUPlanAdjustmentEntity buPlanAdjustment, BUPlanAdjustmentDetailEntity buPlanAdjustmentDetail)
{
return(new AccountBalanceEntity
{
AccountBalanceId = Guid.NewGuid().ToString(),
AccountNumber = buPlanAdjustmentDetail.DebitAccount,
// CurrencyCode = buPlanAdjustment.CurrencyCode,
//ExchangeRate = buPlanAdjustment.ExchangeRate,
BalanceDate = buPlanAdjustment.PostedDate,
MovementDebitAmountOC = buPlanAdjustmentDetail.AdjustmentAmount,
//MovementDebitAmount = buPlanAdjustmentDetail.Amount,
MovementCreditAmountOC = 0,
MovementCreditAmount = 0,
BudgetSourceId = buPlanAdjustmentDetail.BudgetSourceId,
BudgetChapterCode = buPlanAdjustmentDetail.BudgetChapterCode,
BudgetKindItemCode = buPlanAdjustmentDetail.BudgetKindItemCode,
BudgetSubKindItemCode = buPlanAdjustmentDetail.BudgetSubKindItemCode,
BudgetItemCode = buPlanAdjustmentDetail.BudgetItemCode,
BudgetSubItemCode = buPlanAdjustmentDetail.BudgetSubItemCode,
ProjectId = buPlanAdjustmentDetail.ProjectId,
ActivityId = buPlanAdjustmentDetail.ActivityId,
BankAccount = buPlanAdjustmentDetail.BankAccount,
FundStructureId = buPlanAdjustmentDetail.FundStructureId,
BudgetDetailItemCode = buPlanAdjustmentDetail.BudgetDetailItemCode
});
}
public string InsertBUPlanAdjustmentDetail(BUPlanAdjustmentDetailEntity buPlanAdjustmentDetail)
{
const string procedures = @"uspInsert_BUPlanAdjustmentDetail";
return(Db.Insert(procedures, true, Take(buPlanAdjustmentDetail)));
}
