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