public string DeleteBABankTransfer(BABankTransferEntity bABankTransfer)
{
const string sql = @"uspDelete_BABankTransfer";
object[] parms = { "@RefID", bABankTransfer.RefId };
return(Db.Delete(sql, true, parms));
}
public List <BABankTransferEntity> GetBABankTransfers(string connectionString)
{
List <BABankTransferEntity> buentity = new List <BABankTransferEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BABankTransferDetails.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.BABankTransfers.ToList();
var fixedasset = context.FixedAssets.ToList();
var inventoryitems = context.InventoryItems.ToList();
var stocks = context.Stocks.ToList();
//Detail
var parallel = context.BABankTransferDetailParallels.ToList();
foreach (var result in resultcontext)
{
var newresult = new BABankTransferEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.ParalellRefNo = result.ParalellRefNo;
newresult.JournalMemo = result.JournalMemo;
newresult.TotalAmount = result.TotalAmount;
newresult.Posted = result.Posted;
newresult.PostVersion = result.PostVersion;
newresult.EditVersion = result.EditVersion;
newresult.CurrencyCode = result.CCY == null ? null : result.CCY.CurrencyID;
newresult.ExchangeRate = result.ExchangeRate ?? 0;
newresult.TotalAmountOC = result.TotalAmountOC;
newresult.BABankTransferDetails = result.BABankTransferDetails.Count <= 0 ? null : BABankTransferDetails(result.BABankTransferDetails.ToList(), result.RefID.ToString());
newresult.BABankTransferDetailParallels = result.BABankTransferDetailParallels.Count <= 0 ? null : BABankTransferDetailParallels(result.BABankTransferDetailParallels.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
private static object[] Take(BABankTransferEntity bABankTransferEntity)
{
return(new object[]
{
"@RefID", bABankTransferEntity.RefId,
"@RefType", bABankTransferEntity.RefType,
"@RefDate", bABankTransferEntity.RefDate,
"@PostedDate", bABankTransferEntity.PostedDate,
"@RefNo", bABankTransferEntity.RefNo,
"@ParalellRefNo", bABankTransferEntity.ParalellRefNo,
"@JournalMemo", bABankTransferEntity.JournalMemo,
"@TotalAmount", bABankTransferEntity.TotalAmount,
"@Posted", bABankTransferEntity.Posted,
"@PostVersion", bABankTransferEntity.PostVersion,
"@EditVersion", bABankTransferEntity.EditVersion,
"@CurrencyCode", bABankTransferEntity.CurrencyCode,
"@ExchangeRate", bABankTransferEntity.ExchangeRate,
"@TotalAmountOC", bABankTransferEntity.TotalAmountOC,
});
}
public string UpdateBABankTransfer(BABankTransferEntity bABankTransfer)
{
const string sql = @"uspUpdate_BABankTransfer";
return(Db.Update(sql, true, Take(bABankTransfer)));
}
public string InsertBABankTransfer(BABankTransferEntity bABankTransfer)
{
const string sql = @"uspInsert_BABankTransfer";
return(Db.Insert(sql, true, Take(bABankTransfer)));
}
