public List <BADepositDetailSaleEntity> BADepositDetailSales(List <BADepositDetailSale> details, string refid) { List <BADepositDetailSaleEntity> lstDetailEntities = new List <BADepositDetailSaleEntity>(); foreach (var result in details) { var newresult = new BADepositDetailSaleEntity(); 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.UnitPrice = result.UnitPrice; newresult.QuantityConvert = result.QuantityConvert; newresult.UnitPriceConvert = result.UnitPriceConvert; newresult.Amount = result.Amount; newresult.TaxRate = result.TaxRate; newresult.TaxAmount = result.TaxAmount; newresult.TaxAccount = result.TaxAccount; newresult.OutwardPrice = result.OutwardPrice; newresult.OutwardAmount = result.OutwardAmount; newresult.InventoryAccount = result.InventoryAccount; newresult.COGSAccount = result.COGSAccount; 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.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString(); newresult.ConfrontingRefId = result.ConfrontingRefID.ToString(); newresult.ConfrontingRefNo = result.ConfrontingRefNo; newresult.ExpiryDate = result.ExpiryDate; newresult.LotNo = result.LotNo; newresult.SortOrder = result.SortOrder; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; 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.DiscountRate = result.DiscountRate; newresult.DiscountAmount = result.DiscountAmount; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
/// <summary> /// Takes the specified bADeposit. /// </summary> /// <param name="bADepositDetailSaleEntity">The b a deposit detail sale entity.</param> /// <returns></returns> private static object[] Take(BADepositDetailSaleEntity bADepositDetailSaleEntity) { return(new object[] { "@RefDetailID", bADepositDetailSaleEntity.RefDetailId, "@RefID", bADepositDetailSaleEntity.RefId, "@InventoryItemID", bADepositDetailSaleEntity.InventoryItemId, "@Description", bADepositDetailSaleEntity.Description, "@StockID", bADepositDetailSaleEntity.StockId, "@DebitAccount", bADepositDetailSaleEntity.DebitAccount, "@CreditAccount", bADepositDetailSaleEntity.CreditAccount, "@Unit", bADepositDetailSaleEntity.Unit, "@Quantity", bADepositDetailSaleEntity.Quantity, "@UnitPrice", bADepositDetailSaleEntity.UnitPrice, "@QuantityConvert", bADepositDetailSaleEntity.QuantityConvert, "@UnitPriceConvert", bADepositDetailSaleEntity.UnitPriceConvert, "@Amount", bADepositDetailSaleEntity.Amount, "@TaxRate", bADepositDetailSaleEntity.TaxRate, "@TaxAmount", bADepositDetailSaleEntity.TaxAmount, "@TaxAccount", bADepositDetailSaleEntity.TaxAccount, "@OutwardPrice", bADepositDetailSaleEntity.OutwardPrice, "@OutwardAmount", bADepositDetailSaleEntity.OutwardAmount, "@InventoryAccount", bADepositDetailSaleEntity.InventoryAccount, "@COGSAccount", bADepositDetailSaleEntity.COGSAccount, "@BudgetSourceID", bADepositDetailSaleEntity.BudgetSourceId, "@BudgetChapterCode", bADepositDetailSaleEntity.BudgetChapterCode, "@BudgetKindItemCode", bADepositDetailSaleEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", bADepositDetailSaleEntity.BudgetSubKindItemCode, "@BudgetItemCode", bADepositDetailSaleEntity.BudgetItemCode, "@BudgetSubItemCode", bADepositDetailSaleEntity.BudgetSubItemCode, "@MethodDistributeID", bADepositDetailSaleEntity.MethodDistributeId, "@CashWithdrawTypeID", bADepositDetailSaleEntity.CashWithdrawTypeId, "@AccountingObjectID", bADepositDetailSaleEntity.AccountingObjectId, "@ActivityID", bADepositDetailSaleEntity.ActivityId, "@ProjectID", bADepositDetailSaleEntity.ProjectId, "@ProjectActivityID", bADepositDetailSaleEntity.ProjectActivityId, "@ProjectExpenseID", bADepositDetailSaleEntity.ProjectExpenseId, "@ListItemID", bADepositDetailSaleEntity.ListItemId, "@ConfrontingRefID", bADepositDetailSaleEntity.ConfrontingRefId, "@ConfrontingRefNo", bADepositDetailSaleEntity.ConfrontingRefNo, "@ExpiryDate", bADepositDetailSaleEntity.ExpiryDate, "@LotNo", bADepositDetailSaleEntity.LotNo, "@SortOrder", bADepositDetailSaleEntity.SortOrder, "@BudgetDetailItemCode", bADepositDetailSaleEntity.BudgetDetailItemCode, "@FundStructureID", bADepositDetailSaleEntity.FundStructureId, "@ProjectExpenseEAID", bADepositDetailSaleEntity.ProjectExpenseEAId, "@ProjectActivityEAID", bADepositDetailSaleEntity.ProjectActivityEAId, "@DiscountRate", bADepositDetailSaleEntity.DiscountRate, "@DiscountAmount", bADepositDetailSaleEntity.DiscountAmount }); }
/// <summary> /// Inserts the bADeposit detail. /// </summary> /// <param name="bADepositDetailSale">The bADeposit detail.</param> /// <returns></returns> public string InsertBADepositDetailSale(BADepositDetailSaleEntity bADepositDetailSale) { const string sql = @"uspInsert_BADepositDetailSale"; return(Db.Insert(sql, true, Take(bADepositDetailSale))); }