//BATransfers
public List <GLVoucherDetailEntity> GLVoucherDetailFromBATransfers(List <BATransferDetail> details, string refid)
{
List <GLVoucherDetailEntity> lstDetailEntities = new List <GLVoucherDetailEntity>();
foreach (var result in details)
{
var newresult = new GLVoucherDetailEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.RefId = refid;
newresult.Description = result.Description;
newresult.DebitAccount = result.DebitAccount;
newresult.CreditAccount = result.CreditAccount;
newresult.Amount = result.Amount;
newresult.AmountOC = result.AmountOC;
newresult.BudgetSourceId = result.BudgetSource == null ? null : result.BudgetSource.BudgetSourceID.ToString();
newresult.BudgetChapterCode = result.BudgetChapterCode;
newresult.BudgetKindItemCode = result.BudgetKindItemCode;
newresult.BudgetSubKindItemCode = result.BudgetSubKindItemCode;
newresult.BudgetItemCode = result.BudgetItemCode;
newresult.BudgetSubItemCode = result.BudgetSubItemCode;
newresult.MethodDistributeId = result.MethodDistributeID;
newresult.CashWithDrawTypeId = ConvertCash.ConvertCash(result.CashWithDrawTypeID);
newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString();
//newresult.CreditAccountingObjectId = result.AccountingObject1 == null ? null : result.AccountingObject1.AccountingObjectID.ToString();
newresult.ActivityId = result.Activity == null ? null : result.Activity.ActivityID.ToString();
newresult.ProjectId = result.Project == null ? null : result.Project.ProjectID.ToString();
newresult.ProjectActivityId = result.Project1 == null ? null : result.Project1.ProjectID.ToString();
newresult.ProjectExpenseId = result.ProjectExpense == null ? null : result.ProjectExpense.ProjectExpenseID.ToString();
newresult.TaskId = result.Task == null ? null : result.Task.TaskID.ToString();
newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString();
// newresult.Approved = result.Approved;
// newresult.ParentRefDetailId = result.ParentRefDetailID.ToString();
newresult.SortOrder = result.SortOrder;
newresult.BudgetDetailItemCode = result.BudgetDetailItemCode;
//newresult.OrgRefNo = result.OrgRefNo;
//newresult.OrgRefDate = result.OrgRefDate;
//newresult.BankAccount = result.BankAccount;
newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString();
newresult.ProjectExpenseEAId = result.ProjectExpense1 == null ? null : result.ProjectExpense1.ProjectExpenseID.ToString();
newresult.ProjectActivityEAId = result.Project2 == null ? null : result.Project2.ProjectID.ToString();
newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode;
//newresult.TopicId = result.Topic == null ? null : result.Topic.TopicID.ToString();
//newresult.BudgetExpenseId = result.BudgetExpense == null ? null : result.BudgetExpense.BudgetExpenseID.ToString();
lstDetailEntities.Add(newresult);
}
return(lstDetailEntities);
}
/// <summary>
/// Takes the specified f a depreciation detail entity.
/// </summary>
/// <param name="glVoucherDetailEntity">The f a depreciation detail entity.</param>
/// <returns></returns>
private static object[] Take(GLVoucherDetailEntity glVoucherDetailEntity)
{
return(new object[]
{
"@RefDetailID", glVoucherDetailEntity.RefDetailId,
"@RefID", glVoucherDetailEntity.RefId,
"@Description", glVoucherDetailEntity.Description,
"@DebitAccount", glVoucherDetailEntity.DebitAccount,
"@CreditAccount", glVoucherDetailEntity.CreditAccount,
"@Amount", glVoucherDetailEntity.Amount,
"@AmountOC", glVoucherDetailEntity.AmountOC,
"@BudgetSourceID", glVoucherDetailEntity.BudgetSourceId,
"@BudgetChapterCode", glVoucherDetailEntity.BudgetChapterCode,
"@BudgetKindItemCode", glVoucherDetailEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", glVoucherDetailEntity.BudgetSubKindItemCode,
"@BudgetItemCode", glVoucherDetailEntity.BudgetItemCode,
"@BudgetSubItemCode", glVoucherDetailEntity.BudgetSubItemCode,
"@MethodDistributeID", glVoucherDetailEntity.MethodDistributeId,
"@CashWithDrawTypeID", glVoucherDetailEntity.CashWithDrawTypeId,
"@AccountingObjectID", glVoucherDetailEntity.AccountingObjectId,
"@CreditAccountingObjectID", glVoucherDetailEntity.CreditAccountingObjectId,
"@ActivityID", glVoucherDetailEntity.ActivityId,
"@ProjectID", glVoucherDetailEntity.ProjectId,
"@ProjectActivityID", glVoucherDetailEntity.ProjectActivityId,
"@ProjectExpenseID", glVoucherDetailEntity.ProjectExpenseId,
"@TaskID", glVoucherDetailEntity.TaskId,
"@ListItemID", glVoucherDetailEntity.ListItemId,
"@Approved", glVoucherDetailEntity.Approved,
"@ParentRefDetailID", glVoucherDetailEntity.ParentRefDetailId,
"@SortOrder", glVoucherDetailEntity.SortOrder,
"@BudgetDetailItemCode", glVoucherDetailEntity.BudgetDetailItemCode,
"@OrgRefNo", glVoucherDetailEntity.OrgRefNo,
"@OrgRefDate", glVoucherDetailEntity.OrgRefDate,
"@BankAccount", glVoucherDetailEntity.BankId,
"@FundStructureID", glVoucherDetailEntity.FundStructureId,
"@ProjectExpenseEAID", glVoucherDetailEntity.ProjectExpenseEAId,
"@ProjectActivityEAID", glVoucherDetailEntity.ProjectActivityEAId,
"@BudgetProvideCode", glVoucherDetailEntity.BudgetProvideCode,
"@TopicID", glVoucherDetailEntity.TopicId,
"@BudgetExpenseID", glVoucherDetailEntity.BudgetExpenseId,
"@ContractID", glVoucherDetailEntity.ContractId,
"@CapitalPlanID", glVoucherDetailEntity.CapitalPlanId,
"@AutoBusinessID", glVoucherDetailEntity.AutoBusinessID,
});
}
/// <summary>
/// Inserts the fa armortization detail.
/// </summary>
/// <param name="glVoucherDetail">The f a armortization detail.</param>
/// <returns></returns>
/// <exception cref="NotImplementedException"></exception>
public string InsertGLVoucherDetail(GLVoucherDetailEntity glVoucherDetail)
{
const string sql = @"uspInsert_GLVoucherDetail";
return(Db.Insert(sql, true, Take(glVoucherDetail)));
}
