public async Task <CheckingWithdrawal> AddCheckingWithdrawalAsync(CheckingWithdrawal withdrawal)
{
var inserted = await connection.InsertAsync(withdrawal);
//withdrawal.IsNew = false;
return(withdrawal);
}
public async Task DeleteCheckingWithdrawalAsync(CheckingWithdrawal withdrawal)
{
if (context.CheckingWithdrawal.Any(w => w.id == withdrawal.id))
{
await Task.Run(() => context.CheckingWithdrawal.Attach(withdrawal));
await Task.Run(() => context.Entry(withdrawal).State = Microsoft.EntityFrameworkCore.EntityState.Deleted);
if (withdrawal.checkingAccount != null)
{
await Task.Run(() => context.Entry(withdrawal.checkingAccount).State = Microsoft.EntityFrameworkCore.EntityState.Modified);
}
}
}
public async Task UpdateCheckingWithdrawalAsync(CheckingWithdrawal withdrawal)
{
if (context.CheckingWithdrawal.Any(c => c.id == withdrawal.id))
{
await Task.Run(() => context.CheckingWithdrawal.Attach(withdrawal));
await Task.Run(() => context.Entry(withdrawal).State = Microsoft.EntityFrameworkCore.EntityState.Modified);
if (withdrawal.checkingAccount != null)
{
await Task.Run(() => context.Entry(withdrawal.checkingAccount).State = Microsoft.EntityFrameworkCore.EntityState.Modified);
}
}
else
{
throw new Exception("Unable to locate existing Checking Withdrawal record with provided Primary Key value");
}
}
public async Task <CheckingWithdrawal> AddCheckingWithdrawalAsync(CheckingWithdrawal withdrawal)
{
if (!context.CheckingWithdrawal.Any(w => w.id == withdrawal.id))
{
await Task.Run(() => context.CheckingWithdrawal.Add(withdrawal));
await Task.Run(() => context.Entry(withdrawal.checkingAccount).State = Microsoft.EntityFrameworkCore.EntityState.Modified);
if (withdrawal.budgetExpense != null)
{
await Task.Run(() => context.Entry(withdrawal.budgetExpense).State = Microsoft.EntityFrameworkCore.EntityState.Unchanged);
}
}
else
{
throw new Exception("A withdrawal record already exists with the same Primary Key value");
}
return(withdrawal);
}
public async Task PopulateVMAsync(CheckingWithdrawal withdrawal)
{
this.model = withdrawal;
this.accountModel = withdrawal.checkingAccount;
this.ItemId = this.model.id;
this.ItemType = AccountItemType.Withdrawals;
this.ItemAmount = model.transactionAmount;
this.EndingBalance = model.endingBalance;
this.ItemDescription = model.payToTheOrderOf;
this.PayToTheOrderOf = this.model.payToTheOrderOf;
this.TransactionDate = model.transactionDate > DateTime.MinValue ? model.transactionDate : DateTime.Now;
this.ItemDate = this.TransactionDate;
this.TransactionAmount = model.transactionAmount;
this.ObjectColorCode = this.model.ColorCode;
this.BudgetItemId = model.budgetExpenseId;
//await LoadBudgetData();
}
async Task <CheckingWithdrawalViewModel> AddCheckingWithdrawalAsync()
{
CheckingWithdrawalViewModel vm = new CheckingWithdrawalViewModel(this.dbFilePath);
vm.IsNew = true;
vm.CanEdit = true;
vm.CanDelete = false;
vm.ItemType = AccountRegisterItemViewModel.AccountItemType.Withdrawals;
CheckingWithdrawal withdrawal = new CheckingWithdrawal();
withdrawal.checkingAccount = model as CheckingAccount;
withdrawal.checkingAccountId = model.id;
withdrawal.transactionDate = DateTime.Now;
await vm.PopulateVMAsync(withdrawal);
//this.AccountRegister.Add(vm);
//await GroupAccountItemsAsync();
//this.SelectedRegisterItem = vm;
return(vm);
}
public async Task UpdateCheckingWithdrawalAsync(CheckingWithdrawal withdrawal)
{
var updated = await connection.UpdateAsync(withdrawal);
}
public async Task DeleteCheckingWithdrawalAsync(CheckingWithdrawal withdrawal)
{
var deleted = await connection.DeleteAsync(withdrawal);
}
public void Put(int id, [FromBody] CheckingWithdrawal item)
{
throw new NotImplementedException();
}