//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))); }