/// <summary> /// Takes the specified c a payment detail entity. /// </summary> /// <param name="cAPaymentDetailEntity">The c a payment detail entity.</param> /// <returns>System.Object[].</returns> private static object[] Take(CAPaymentDetailPurchaseEntity cAPaymentDetailEntity) { return(new object[] { "@RefDetailID", cAPaymentDetailEntity.RefDetailId, "@RefID", cAPaymentDetailEntity.RefId, "@InventoryItemID", cAPaymentDetailEntity.InventoryItemId, "@Description", cAPaymentDetailEntity.Description, "@StockID", cAPaymentDetailEntity.StockId, "@DebitAccount", cAPaymentDetailEntity.DebitAccount, "@CreditAccount", cAPaymentDetailEntity.CreditAccount, "@Unit", cAPaymentDetailEntity.Unit, "@Quantity", cAPaymentDetailEntity.Quantity, "@QuantityConvert", cAPaymentDetailEntity.QuantityConvert, "@UnitPrice", cAPaymentDetailEntity.UnitPrice, "@UnitPriceConvert", cAPaymentDetailEntity.UnitPriceConvert, "@Amount", cAPaymentDetailEntity.Amount, "@InvType", cAPaymentDetailEntity.InvType, "@InvDate", cAPaymentDetailEntity.InvDate, "@InvSeries", cAPaymentDetailEntity.InvSeries, "@InvNo", cAPaymentDetailEntity.InvNo, "@TaxRate", cAPaymentDetailEntity.TaxRate, "@TaxAmount", cAPaymentDetailEntity.TaxAmount, "@TaxAccount", cAPaymentDetailEntity.TaxAccount, "@PurchasePurposeID", cAPaymentDetailEntity.PurchasePurposeId, "@FreightAmount", cAPaymentDetailEntity.FreightAmount, "@InwardAmount", cAPaymentDetailEntity.InwardAmount, "@BudgetSourceID", cAPaymentDetailEntity.BudgetSourceId, "@BudgetChapterCode", cAPaymentDetailEntity.BudgetChapterCode, "@BudgetKindItemCode", cAPaymentDetailEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", cAPaymentDetailEntity.BudgetSubKindItemCode, "@BudgetItemCode", cAPaymentDetailEntity.BudgetItemCode, "@BudgetSubItemCode", cAPaymentDetailEntity.BudgetSubItemCode, "@MethodDistributeID", cAPaymentDetailEntity.MethodDistributeId, "@CashWithdrawTypeID", cAPaymentDetailEntity.CashWithdrawTypeId, "@AccountingObjectID", cAPaymentDetailEntity.AccountingObjectId, "@ActivityID", cAPaymentDetailEntity.ActivityId, "@ProjectID", cAPaymentDetailEntity.ProjectId, "@ProjectActivityID", cAPaymentDetailEntity.ProjectActivityId, "@ProjectExpenseID", cAPaymentDetailEntity.ProjectExpenseId, "@ListItemID", cAPaymentDetailEntity.ListItemId, "@ExpiryDate", cAPaymentDetailEntity.ExpiryDate, "@LotNo", cAPaymentDetailEntity.LotNo, "@Approved", cAPaymentDetailEntity.Approved, "@SortOrder", cAPaymentDetailEntity.SortOrder, "@BudgetDetailItemCode", cAPaymentDetailEntity.BudgetDetailItemCode, "@InvoiceTypeCode", cAPaymentDetailEntity.InvoiceTypeCode, "@OrgRefNo", cAPaymentDetailEntity.OrgRefNo, "@OrgRefDate", cAPaymentDetailEntity.OrgRefDate, "@FundStructureID", cAPaymentDetailEntity.FundStructureId, "@ProjectExpenseEAID", cAPaymentDetailEntity.ProjectExpenseEAId, "@ProjectActivityEAID", cAPaymentDetailEntity.ProjectActivityEAId, "@BudgetExpenseID", cAPaymentDetailEntity.BudgetExpenseId, "@ContractID", cAPaymentDetailEntity.ContractId, "@CapitalPlanID", cAPaymentDetailEntity.CapitalPlanId, "@AutoBusinessID", cAPaymentDetailEntity.AutoBusinessId, "@BankID", cAPaymentDetailEntity.BankId, "@AmountExchange", cAPaymentDetailEntity.AmountExchange }); }
/// <summary> /// Inserts the ca payment detail purchase. /// </summary> /// <param name="caPaymentDetail">The ca payment detail.</param> /// <returns>System.String.</returns> public string InsertCAPaymentDetailPurchase(CAPaymentDetailPurchaseEntity caPaymentDetail) { const string procedures = @"uspInsert_CAPaymentDetailPurchase"; return(Db.Insert(procedures, true, Take(caPaymentDetail))); }
public List <CAPaymentDetailPurchaseEntity> CAPaymentDetailPurchases(List <CAPaymentDetailPurchase> details, string refid) { List <CAPaymentDetailPurchaseEntity> lstDetailEntities = new List <CAPaymentDetailPurchaseEntity>(); foreach (var result in details) { var newresult = new CAPaymentDetailPurchaseEntity(); newresult.RefDetailId = result.RefDetailID.ToString(); newresult.RefId = refid; newresult.InventoryItemId = result.InventoryItem == null ? null : result.InventoryItem.InventoryItemID.ToString(); newresult.Description = result.Description; newresult.StockId = result.Stock == null ? null : result.Stock.StockID.ToString(); newresult.DebitAccount = result.DebitAccount; newresult.CreditAccount = result.CreditAccount; newresult.Unit = result.Unit; newresult.Quantity = result.Quantity; newresult.QuantityConvert = result.QuantityConvert; newresult.UnitPrice = result.UnitPrice; newresult.UnitPriceConvert = result.UnitPriceConvert; newresult.Amount = result.Amount; newresult.InvType = result.InvType; newresult.InvDate = result.InvDate; newresult.InvSeries = result.InvSeries; newresult.InvNo = result.InvNo; newresult.TaxRate = result.TaxRate; newresult.TaxAmount = result.TaxAmount; newresult.TaxAccount = result.TaxAccount; newresult.PurchasePurposeId = result.PurchasePurpose == null ? null : result.PurchasePurpose.PurchasePurposeID.ToString(); newresult.FreightAmount = result.FreightAmount; newresult.InwardAmount = result.InwardAmount; 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.Project == null ? null : result.Project.ProjectID.ToString(); newresult.ProjectExpenseId = result.ProjectExpense == null ? null : result.ProjectExpense.ProjectExpenseID.ToString(); newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString(); newresult.ExpiryDate = result.ExpiryDate; newresult.LotNo = result.LotNo; newresult.Approved = result.Approved; newresult.SortOrder = result.SortOrder; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; newresult.InvoiceTypeCode = result.InvoiceTypeCode; newresult.OrgRefNo = result.OrgRefNo; newresult.OrgRefDate = result.OrgRefDate; 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.BudgetExpenseId = result.BudgetExpense; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }