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