public List <BAWithDrawDetailPurchaseEntity> BAWithDrawDetailPurchases(List <BAWithDrawDetailPurchase> details, string refid)
{
List <BAWithDrawDetailPurchaseEntity> lstDetailEntities = new List <BAWithDrawDetailPurchaseEntity>();
foreach (var result in details)
{
var newresult = new BAWithDrawDetailPurchaseEntity();
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.InvType = result.InvType;
newresult.InvDate = result.InvDate;
newresult.InvSeries = result.InvSeries;
newresult.InvNo = result.InvNo;
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.FundId = result.FundID.ToString();
newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString();
newresult.ExpiryDate = result.ExpiryDate;
newresult.LotNo = result.LotNo;
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.ProjectActivityEAId = result.Project2 == null ? null : result.Project2.ProjectID.ToString();
//newresult.BudgetExpenseId = result.BudgetExpens;
//newresult.BankID = result.bank;
lstDetailEntities.Add(newresult);
}
return(lstDetailEntities);
}
/// <summary>
/// Takes the specified bADeposit.
/// </summary>
/// <param name="bAWithDrawDetailPurchaseEntity">The b a with draw detail purchase entity.</param>
/// <returns></returns>
private object[] Take(BAWithDrawDetailPurchaseEntity bAWithDrawDetailPurchaseEntity)
{
return(new object[]
{
"@RefDetailID", bAWithDrawDetailPurchaseEntity.RefDetailId,
"@RefID", bAWithDrawDetailPurchaseEntity.RefId,
"@InventoryItemID", bAWithDrawDetailPurchaseEntity.InventoryItemId,
"@Description", bAWithDrawDetailPurchaseEntity.Description,
"@StockID", bAWithDrawDetailPurchaseEntity.StockId,
"@DebitAccount", bAWithDrawDetailPurchaseEntity.DebitAccount,
"@CreditAccount", bAWithDrawDetailPurchaseEntity.CreditAccount,
"@Unit", bAWithDrawDetailPurchaseEntity.Unit,
"@Quantity", bAWithDrawDetailPurchaseEntity.Quantity,
"@UnitPrice", bAWithDrawDetailPurchaseEntity.UnitPrice,
"@QuantityConvert", bAWithDrawDetailPurchaseEntity.QuantityConvert,
"@UnitPriceConvert", bAWithDrawDetailPurchaseEntity.UnitPriceConvert,
"@Amount", bAWithDrawDetailPurchaseEntity.Amount,
"@TaxRate", bAWithDrawDetailPurchaseEntity.TaxRate,
"@TaxAmount", bAWithDrawDetailPurchaseEntity.TaxAmount,
"@TaxAccount", bAWithDrawDetailPurchaseEntity.TaxAccount,
"@InvType", bAWithDrawDetailPurchaseEntity.InvType,
"@InvDate", bAWithDrawDetailPurchaseEntity.InvDate,
"@InvSeries", bAWithDrawDetailPurchaseEntity.InvSeries,
"@InvNo", bAWithDrawDetailPurchaseEntity.InvNo,
"@PurchasePurposeID", bAWithDrawDetailPurchaseEntity.PurchasePurposeId,
"@FreightAmount", bAWithDrawDetailPurchaseEntity.FreightAmount,
"@InwardAmount", bAWithDrawDetailPurchaseEntity.InwardAmount,
"@BudgetSourceID", bAWithDrawDetailPurchaseEntity.BudgetSourceId,
"@BudgetChapterCode", bAWithDrawDetailPurchaseEntity.BudgetChapterCode,
"@BudgetKindItemCode", bAWithDrawDetailPurchaseEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", bAWithDrawDetailPurchaseEntity.BudgetSubKindItemCode,
"@BudgetItemCode", bAWithDrawDetailPurchaseEntity.BudgetItemCode,
"@BudgetSubItemCode", bAWithDrawDetailPurchaseEntity.BudgetSubItemCode,
"@MethodDistributeID", bAWithDrawDetailPurchaseEntity.MethodDistributeId,
"@CashWithdrawTypeID", bAWithDrawDetailPurchaseEntity.CashWithdrawTypeId,
"@AccountingObjectID", bAWithDrawDetailPurchaseEntity.AccountingObjectId,
"@ActivityID", bAWithDrawDetailPurchaseEntity.ActivityId,
"@ProjectID", bAWithDrawDetailPurchaseEntity.ProjectId,
"@ProjectActivityID", bAWithDrawDetailPurchaseEntity.ProjectActivityId,
"@FundID", bAWithDrawDetailPurchaseEntity.FundId,
"@ListItemID", bAWithDrawDetailPurchaseEntity.ListItemId,
"@ExpiryDate", bAWithDrawDetailPurchaseEntity.ExpiryDate,
"@LotNo", bAWithDrawDetailPurchaseEntity.LotNo,
"@SortOrder", bAWithDrawDetailPurchaseEntity.SortOrder,
"@BudgetDetailItemCode", bAWithDrawDetailPurchaseEntity.BudgetDetailItemCode,
"@InvoiceTypeCode", bAWithDrawDetailPurchaseEntity.InvoiceTypeCode,
"@OrgRefNo", bAWithDrawDetailPurchaseEntity.OrgRefNo,
"@OrgRefDate", bAWithDrawDetailPurchaseEntity.OrgRefDate,
"@FundStructureID", bAWithDrawDetailPurchaseEntity.FundStructureId,
"@ProjectActivityEAID", bAWithDrawDetailPurchaseEntity.ProjectActivityEAId,
"@BudgetExpenseID", bAWithDrawDetailPurchaseEntity.BudgetExpenseId,
"@BankID", bAWithDrawDetailPurchaseEntity.BankId,
});
}
/// <summary>
/// Inserts the bADeposit detail.
/// </summary>
/// <param name="bAWithDrawDetailPurchase">The bADeposit detail.</param>
/// <returns></returns>
public string InsertBAWithDrawDetailPurchaseEntity(BAWithDrawDetailPurchaseEntity bAWithDrawDetailPurchase)
{
const string sql = @"uspInsert_BAWithDrawDetailPurchase";
return(Db.Insert(sql, true, Take(bAWithDrawDetailPurchase)));
}
