public Task CreateIncomeCategory(string name)
{
var parameters = new
{
Name = name
};
return(_databaseAccessor.ExecuteProcedureAsync("sp_AddIncomeCategory", parameters));
}
public Task DeleteAccountById(int id)
{
var parameters = new
{
Id = id
};
return(_databaseAccessor.ExecuteProcedureAsync("sp_DeleteAccount_ById", parameters));
}
public Task CreateExpenseSubcategory(string name, int categoryId)
{
var parameters = new
{
Name = name,
CategoryId = categoryId
};
return(_databaseAccessor.ExecuteProcedureAsync("sp_AddExpenseSubcategory", parameters));
}
public Task CreateTransfer(int sourceAccountId, int destinationAccountId, decimal amount, DateTime createDate)
{
var parameters = new
{
SourceAccountId = sourceAccountId,
DestinationAccountId = destinationAccountId,
Amount = amount,
CreateDate = createDate
};
return(_databaseAccessor.ExecuteProcedureAsync("sp_AddTransfer", parameters));
}
public Task CreateExpense(string description, decimal amount, int expenseCategoryId, int expenseSubcategoryId, int accountId, DateTime createDate, DateTime?modifyDate = null)
{
var parameters = new
{
Description = description,
Amount = amount,
ExpenseCategoryId = expenseCategoryId,
ExpenseSubcategoryId = expenseSubcategoryId,
AccountId = accountId,
CreateDate = createDate,
ModifyDate = modifyDate
};
return(_databaseAccessor.ExecuteProcedureAsync("sp_AddExpense", parameters));
}
public Task CreateUser(string username, string salt, string passwordHash)
{
var parameters = new
{
Username = username,
Salt = salt,
PasswordHash = passwordHash
};
return(_databaseAccessor.ExecuteProcedureAsync("sp_AddNewUser", parameters));
}