public List <BUTransferDetailPurchaseEntity> BUTransferDetailPurchases(List <BUTransferDetailPurchase> details, string refid) { List <BUTransferDetailPurchaseEntity> lstDetailEntities = new List <BUTransferDetailPurchaseEntity>(); foreach (var result in details) { var newresult = new BUTransferDetailPurchaseEntity(); 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.TaxRate = Convert.ToInt32(result.TaxRate ?? 0); newresult.TaxAmount = result.TaxAmount; 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.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.ExpiryDate = result.ExpiryDate; newresult.LotNo = result.LotNo; newresult.Approved = result.Approved; newresult.SortOrder = result.SortOrder; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; 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.Project1 == null ? null : result.Project1.ProjectID.ToString(); newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode; newresult.TopicId = result.Topic == null ? null : result.Topic.TopicID.ToString(); //newresult.CreateDate = result.CreateDate; //newresult.BudgetExpenseID = result.BudgetExpenseID; //newresult.BankID = result.BankID; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
private static object[] Take(BUTransferDetailPurchaseEntity bUTransferDetailPurchaseEntity) { return(new object[] { "@RefDetailID", bUTransferDetailPurchaseEntity.RefDetailId, "@RefID", bUTransferDetailPurchaseEntity.RefId, "@InventoryItemID", bUTransferDetailPurchaseEntity.InventoryItemId, "@Description", bUTransferDetailPurchaseEntity.Description, "@StockID", bUTransferDetailPurchaseEntity.StockId, "@DebitAccount", bUTransferDetailPurchaseEntity.DebitAccount, "@CreditAccount", bUTransferDetailPurchaseEntity.CreditAccount, "@Unit", bUTransferDetailPurchaseEntity.Unit, "@Quantity", bUTransferDetailPurchaseEntity.Quantity, "@QuantityConvert", bUTransferDetailPurchaseEntity.QuantityConvert, "@UnitPrice", bUTransferDetailPurchaseEntity.UnitPrice, "@UnitPriceConvert", bUTransferDetailPurchaseEntity.UnitPriceConvert, "@Amount", bUTransferDetailPurchaseEntity.Amount, "@TaxRate", bUTransferDetailPurchaseEntity.TaxRate, "@TaxAmount", bUTransferDetailPurchaseEntity.TaxAmount, "@FreightAmount", bUTransferDetailPurchaseEntity.FreightAmount, "@InwardAmount", bUTransferDetailPurchaseEntity.InwardAmount, "@BudgetSourceID", bUTransferDetailPurchaseEntity.BudgetSourceId, "@BudgetChapterCode", bUTransferDetailPurchaseEntity.BudgetChapterCode, "@BudgetKindItemCode", bUTransferDetailPurchaseEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", bUTransferDetailPurchaseEntity.BudgetSubKindItemCode, "@BudgetItemCode", bUTransferDetailPurchaseEntity.BudgetItemCode, "@BudgetSubItemCode", bUTransferDetailPurchaseEntity.BudgetSubItemCode, "@MethodDistributeID", bUTransferDetailPurchaseEntity.MethodDistributeId, "@CashWithdrawTypeId", bUTransferDetailPurchaseEntity.CashWithdrawTypeId, "@AccountingObjectID", bUTransferDetailPurchaseEntity.AccountingObjectId, "@ActivityID", bUTransferDetailPurchaseEntity.ActivityId, "@ProjectID", bUTransferDetailPurchaseEntity.ProjectId, "@ProjectActivityID", bUTransferDetailPurchaseEntity.ProjectActivityId, "@ProjectExpenseID", bUTransferDetailPurchaseEntity.ProjectExpenseId, "@TaskID", bUTransferDetailPurchaseEntity.TaskId, "@ListItemID", bUTransferDetailPurchaseEntity.ListItemId, "@ExpiryDate", bUTransferDetailPurchaseEntity.ExpiryDate, "@LotNo", bUTransferDetailPurchaseEntity.LotNo, "@Approved", bUTransferDetailPurchaseEntity.Approved, "@SortOrder", bUTransferDetailPurchaseEntity.SortOrder, "@BudgetDetailItemCode", bUTransferDetailPurchaseEntity.BudgetDetailItemCode, "@OrgRefNo", bUTransferDetailPurchaseEntity.OrgRefNo, "@OrgRefDate", bUTransferDetailPurchaseEntity.OrgRefDate, "@FundStructureID", bUTransferDetailPurchaseEntity.FundStructureId, "@ProjectExpenseEAID", bUTransferDetailPurchaseEntity.ProjectExpenseEAId, "@ProjectActivityEAID", bUTransferDetailPurchaseEntity.ProjectActivityEAId, "@BudgetProvideCode", bUTransferDetailPurchaseEntity.BudgetProvideCode, "@TopicID", bUTransferDetailPurchaseEntity.TopicId, "@CreateDate", bUTransferDetailPurchaseEntity.CreateDate, "@BankID", bUTransferDetailPurchaseEntity.BankId, "@BudgetExpenseID", bUTransferDetailPurchaseEntity.BudgetExpenseId, }); }
/// <summary> /// Inserts the bu plan receipt detail. /// </summary> /// <param name="bUTransferDetail">The b u commitment adjustment detail.</param> /// <returns>System.String.</returns> public string InsertBUTransferDetailPurchase(BUTransferDetailPurchaseEntity bUTransferDetailPurchase) { const string procedures = @"uspInsert_BUTransferDetailPurchase"; return(Db.Insert(procedures, true, Take(bUTransferDetailPurchase))); }