public List <FAIncrementDecrementDetailEntity> FAIncrementDecrementDetailsFromSAInvoices(List <SAInvoiceDetailFixedAsset> details, string refid) { List <FAIncrementDecrementDetailEntity> lstDetailEntities = new List <FAIncrementDecrementDetailEntity>(); foreach (var result in details) { var newresult = new FAIncrementDecrementDetailEntity(); newresult.RefDetailId = result.RefDetailID.ToString(); newresult.RefId = refid; newresult.FixedAssetId = result.FixedAsset == null ? null : result.FixedAsset.FixedAssetID.ToString(); newresult.Description = result.Description; //newresult.DepartmentId = result.Department == null ? null : result.Department.DepartmentID.ToString(); newresult.DebitAccount = result.DebitAccount; newresult.CreditAccount = result.CreditAccount; newresult.Amount = result.Amount; 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.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.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString(); //newresult.Approved = result.Approved; newresult.SortOrder = result.SortOrder; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString(); //newresult.BankId = result.BankAccount == null ? null : banks.FirstOrDefault(x => x.BankAccount == result.BankAccount).BankInfoID.ToString(); newresult.ProjectExpenseEAId = result.ProjectExpense1 == null ? null : result.ProjectExpense1.ProjectExpenseID.ToString(); newresult.ProjectActivityEAId = result.Project2 == null ? null : result.Project2.ProjectID.ToString(); //newresult.DecreaseReasonId = result.DecreaseReasonID; //newresult.BudgetExpenseId = result.BudgetExpense; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
/// <summary> /// Takes the specified bADeposit. /// </summary> /// <param name="fAIncrementDecrementDetail">The bADeposit.</param> /// <returns></returns> private object[] Take(FAIncrementDecrementDetailEntity fAIncrementDecrementDetail) { return(new object[] { "@RefDetailID", fAIncrementDecrementDetail.RefDetailId, "@RefID", fAIncrementDecrementDetail.RefId, "@FixedAssetID", fAIncrementDecrementDetail.FixedAssetId, "@Description", fAIncrementDecrementDetail.Description, "@DepartmentID", fAIncrementDecrementDetail.DepartmentId, "@DebitAccount", fAIncrementDecrementDetail.DebitAccount, "@CreditAccount", fAIncrementDecrementDetail.CreditAccount, "@Amount", fAIncrementDecrementDetail.Amount, "@BudgetSourceID", fAIncrementDecrementDetail.BudgetSourceId, "@BudgetChapterCode", fAIncrementDecrementDetail.BudgetChapterCode, "@BudgetKindItemCode", fAIncrementDecrementDetail.BudgetKindItemCode, "@BudgetSubKindItemCode", fAIncrementDecrementDetail.BudgetSubKindItemCode, "@BudgetItemCode", fAIncrementDecrementDetail.BudgetItemCode, "@BudgetSubItemCode", fAIncrementDecrementDetail.BudgetSubItemCode, "@MethodDistributeID", fAIncrementDecrementDetail.MethodDistributeId, "@CashWithDrawTypeID", fAIncrementDecrementDetail.CashWithDrawTypeId, "@AccountingObjectID", fAIncrementDecrementDetail.AccountingObjectId, "@ActivityID", fAIncrementDecrementDetail.ActivityId, "@ProjectID", fAIncrementDecrementDetail.ProjectId, "@ProjectActivityID", fAIncrementDecrementDetail.ProjectActivityId, "@ListItemID", fAIncrementDecrementDetail.ListItemId, "@Approved", fAIncrementDecrementDetail.Approved, "@SortOrder", fAIncrementDecrementDetail.SortOrder, "@BudgetDetailItemCode", fAIncrementDecrementDetail.BudgetDetailItemCode, "@FundStructureID", fAIncrementDecrementDetail.FundStructureId, "@BankID", fAIncrementDecrementDetail.BankId, "@ProjectExpenseEAID", fAIncrementDecrementDetail.ProjectExpenseEAId, "@ProjectActivityEAID", fAIncrementDecrementDetail.ProjectActivityEAId, "@DecreaseReasonID", fAIncrementDecrementDetail.DecreaseReasonId, "@BudgetExpenseID", fAIncrementDecrementDetail.BudgetExpenseId, "@Quantity", fAIncrementDecrementDetail.Quantity, }); }
/// <summary> /// Inserts the bADeposit detail. /// </summary> /// <param name="fAIncrementDecrementDetail">The bADeposit detail.</param> /// <returns></returns> public string InsertFAIncrementDecrementDetail(FAIncrementDecrementDetailEntity fAIncrementDecrementDetail) { const string sql = @"uspInsert_FAIncrementDecrementDetail"; return(Db.Insert(sql, true, Take(fAIncrementDecrementDetail))); }