/// <summary>
/// Deletes the bu transfer by bu plan withdraw reference identifier.
/// </summary>
/// <param name="buPlanWithdrawRefId">The bu plan withdraw reference identifier.</param>
/// <returns></returns>
public string DeleteBUTransferByBUPlanWithdrawRefId(BUTransferEntity buPlanWithdrawRefId)
{
const string procedures = @"uspDelete_BUTransferDetail_ByBUPlanWithdrawRefID";
object[] parms = { "@BUPlanWithdrawRefID", buPlanWithdrawRefId.BUPlanWithdrawRefId };
return(Db.Delete(procedures, true, parms));
}
/// <summary>
/// Deletes the bu plan receipt.
/// </summary>
/// <param name="bUTransfer">The b u commitment adjustment.</param>
/// <returns>System.String.</returns>
public string DeleteBUTransfer(BUTransferEntity bUTransfer)
{
const string procedures = @"uspDelete_BUTransfer";
object[] parms = { "@RefId", bUTransfer.RefId };
return(Db.Delete(procedures, true, parms));
}
/// <summary>
/// Takes the specified b u transfer entity.
/// </summary>
/// <param name="bUTransferEntity">The b u transfer entity.</param>
/// <returns>System.Object[].</returns>
private static object[] Take(BUTransferEntity bUTransferEntity)
{
return(new object[]
{
"@RefID", bUTransferEntity.RefId,
"@RefType", bUTransferEntity.RefType,
"@RefDate", bUTransferEntity.RefDate,
"@PostedDate", bUTransferEntity.PostedDate,
"@RefNo", bUTransferEntity.RefNo,
"@CurrencyCode", bUTransferEntity.CurrencyCode,
"@ExchangeRate", bUTransferEntity.ExchangeRate,
"@ParalellRefNo", bUTransferEntity.ParalellRefNo,
"@JournalMemo", bUTransferEntity.JournalMemo,
"@TargetProgramID", bUTransferEntity.TargetProgramId,
"@BankInfoID", bUTransferEntity.BankInfoId,
"@AccountingObjectID", bUTransferEntity.AccountingObjectId,
"@AccountingObjectName", bUTransferEntity.AccountingObjectName,
"@AccountingObjectAddress", bUTransferEntity.AccountingObjectAddress,
"@AccountingObjectBankAccount", bUTransferEntity.AccountingObjectBankAccount,
"@AccountingObjectBankName", bUTransferEntity.AccountingObjectBankName,
"@DocumentIncluded", bUTransferEntity.DocumentIncluded,
"@InwardStockRefNo", bUTransferEntity.InwardStockRefNo,
"@WithdrawRefDate", bUTransferEntity.WithdrawRefDate,
"@WithdrawRefNo", bUTransferEntity.WithdrawRefNo,
"@IncrementRefNo", bUTransferEntity.IncrementRefNo,
"@TotalAmount", bUTransferEntity.TotalAmount,
"@TotalAmountOC", bUTransferEntity.TotalAmountOC,
"@TotalTaxAmount", bUTransferEntity.TotalTaxAmount,
"@TotalFreightAmount", bUTransferEntity.TotalFreightAmount,
"@TotalInwardAmount", bUTransferEntity.TotalInwardAmount,
"@Posted", bUTransferEntity.Posted,
"@PostVersion", bUTransferEntity.PostVersion,
"@EditVersion", bUTransferEntity.EditVersion,
"@RefOrder", bUTransferEntity.RefOrder,
"@GLVouchersRefID", bUTransferEntity.gLVouchersRefId,
"@RelationRefID", bUTransferEntity.RelationRefId,
"@BUCommitmentRequestID", bUTransferEntity.BUCommitmentRequestId,
"@TotalFixedAssetAmount", bUTransferEntity.TotalFixedAssetAmount,
"@BUPlanWithdrawRefId", bUTransferEntity.BUPlanWithdrawRefId
});
}
/// <summary>
/// Updates the bu plan receipt.
/// </summary>
/// <param name="bUTransfer">The b u commitment adjustment.</param>
/// <returns>System.String.</returns>
public string UpdateBUTransfer(BUTransferEntity bUTransfer)
{
const string procedures = @"uspUpdate_BUTransfer";
return(Db.Update(procedures, true, Take(bUTransfer)));
}
/// <summary>
/// Inserts the bu plan receipt.
/// </summary>
/// <param name="bUTransfer">The b u commitment adjustment.</param>
/// <returns>System.String.</returns>
public string InsertBUTransfer(BUTransferEntity bUTransfer)
{
const string procedures = @"uspInsert_BUTransfer";
return(Db.Insert(procedures, true, Take(bUTransfer)));
}
public List <BUTransferEntity> GetBUTransfers(string connectionString)
{
List <BUTransferEntity> buentity = new List <BUTransferEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BUTransferDetails.ToList();
var projects = context.Projects.ToList();
var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
var funds = context.Funds.ToList();
var fundstructures = context.FundStructures.ToList();
var budgetproviders = context.BudgetProvidences.ToList();
var accountingobject = context.AccountingObjects.ToList();
var projectexpenses = context.ProjectExpenses.ToList();
var activity = context.Activities.ToList();
var tasks = context.Tasks.ToList();
var topics = context.Topics.ToList();
banks = context.BankInfoes.ToList();
var department = context.Departments.ToList();
var resultcontext = context.BUTransfers.ToList();
var fixedasset = context.FixedAssets.ToList();
var inventoryitems = context.InventoryItems.ToList();
var stocks = context.Stocks.ToList();
//Detail
var parallel = context.BUTransferDetailParallels.ToList();
var detailfixedassets = context.BUTransferDetailFixedAssets.ToList();
var purchases = context.BUTransferDetailPurchases.ToList();
foreach (var result in resultcontext)
{
var newresult = new BUTransferEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.CurrencyCode = result.CCY == null ? null : result.CCY.CurrencyID;
newresult.ExchangeRate = result.ExchangeRate ?? 0;
newresult.ParalellRefNo = result.ParalellRefNo;
newresult.JournalMemo = result.JournalMemo;
newresult.TargetProgramId = result.Project == null ? null : result.Project.ProjectID.ToString();
newresult.BankInfoId = result.BankInfo.BankInfoID.ToString();
newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString();
newresult.AccountingObjectName = result.AccountingObjectName;
newresult.AccountingObjectAddress = result.AccountingObjectAddress;
newresult.AccountingObjectBankAccount = result.AccountingObjectBankAccount;
newresult.AccountingObjectBankName = result.AccountingObjectBankName;
newresult.DocumentIncluded = result.DocumentIncluded;
newresult.InwardStockRefNo = result.InwardStockRefNo;
newresult.WithdrawRefDate = result.WithdrawRefDate;
newresult.WithdrawRefNo = result.WithdrawRefNo;
newresult.IncrementRefNo = result.IncrementRefNo;
newresult.TotalAmount = result.TotalAmount;
newresult.TotalAmountOC = result.TotalAmountOC;
newresult.TotalTaxAmount = result.TotalTaxAmount;
newresult.TotalFreightAmount = result.TotalFreightAmount;
newresult.TotalInwardAmount = result.TotalInwardAmount;
newresult.Posted = result.Posted;
newresult.PostVersion = result.PostVersion;
newresult.EditVersion = result.EditVersion;
newresult.RefOrder = result.RefOrder;
newresult.RelationRefId = result.RelationRefID.ToString();
newresult.BUCommitmentRequestId = result.BUCommitmentRequestID.ToString();
newresult.TotalFixedAssetAmount = result.TotalFixedAssetAmount;
//newresult.BUPlanWithdrawRefId = result.BUCommitmentRequestID;
//newresult.LinkRefNo = result.RefNo;
//newresult.gLVouchersRefId = result.v;
newresult.BUTransferDetails = result.BUTransferDetails.Count <= 0 ? null : BUTransferDetails(result.BUTransferDetails.ToList(), result.RefID.ToString());
newresult.BUTransferDetailParallels = result.BUTransferDetailParallels.Count <= 0 ? null : BUTransferDetailParallels(result.BUTransferDetailParallels.ToList(), result.RefID.ToString());
newresult.BUTransferDetailFixedAssets = result.BUTransferDetailFixedAssets.Count <= 0 ? null : BUTransferDetailFixedAssets(result.BUTransferDetailFixedAssets.ToList(), result.RefID.ToString());
newresult.BUTransferDetailPurchases = result.BUTransferDetailPurchases.Count <= 0 ? null : BUTransferDetailPurchases(result.BUTransferDetailPurchases.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
