public object updateTransactions(TransactionEditDto transactionEditDto)
{
string sql = "update transaction set transactionName=@transactionName, transactionAmount=@transactionAmount, transactionNote=@transactionNote, transactionDate=@transactionDate, categoryId=@categoryId where transactionId=@transactionId";
MySqlCommand updateTransaction = new MySqlCommand(sql);
updateTransaction.Parameters.AddWithValue("@transactionName", transactionEditDto.transactionName);
updateTransaction.Parameters.AddWithValue("@transactionAmount", transactionEditDto.transactionAmount);
updateTransaction.Parameters.AddWithValue("@transactionNote", transactionEditDto.transactionNote);
updateTransaction.Parameters.AddWithValue("@transactionDate", transactionEditDto.transactionDate);
updateTransaction.Parameters.AddWithValue("@categoryId", transactionEditDto.categoryId);
updateTransaction.Parameters.AddWithValue("@transactionId", transactionEditDto.transactionId);
int row = dBAccess.executeQuery(updateTransaction);
if (row < 0)
{
throw new Exception();
}
else
{
SuccessResponse successResponse = new SuccessResponse();
return(successResponse);
}
}
public EditTransaction(TransactionHome transactionHome, TransactionEditDto transactionEdit)
{
InitializeComponent();
transactionController = new TransactionController(transactionService);
categoryController = new CategoryController(categoryService);
_transactionHome = transactionHome;
// this.FormClosing += new FormClosingEventHandler(this.EditTransactionClosing);
this.transactionEditDto = transactionEdit;
transactionName.Text = transactionEdit.transactionName;
transactionAmount.Text = (transactionEdit.transactionAmount).ToString();
transactionNote.Text = transactionEdit.transactionNote;
dateTimePicker1.Value = transactionEdit.transactionDate;
this.transactionId = int.Parse(transactionEdit.transactionId);
MySqlDataReader reader = categoryController.getAllCategories();
while (reader.Read())
{
comboBox1.Items.Add(new KeyValuePair <string, int>(reader["categoryName"].ToString(), reader.GetInt32("categoryId")));
comboBox1.DisplayMember = "key";
comboBox1.ValueMember = "value";
}
reader.Close();
comboBox1.Text = transactionEdit.categoryName;
}
public async Task CreateOrUpdateTransaction(TransactionEditDto input)
{
if (input.Id.HasValue)
{
await UpdateTransactionAsync(input);
}
else
{
await InsertTransactionAsync(input);
}
}
private async Task UpdateTransactionAsync(TransactionEditDto input)
{
var tenantId = AbpSession.TenantId;
var transaction = await _transactionRepository.FirstOrDefaultAsync(t => t.Id == input.Id && t.Account.TenantId == tenantId);
input.MapTo(transaction);
await CurrentUnitOfWork.SaveChangesAsync();
await UpdateTransactionsBalanceInAccountAsync(input.AccountId);
}
/// <summary>
/// The copy transaction async.
/// </summary>
/// <param name="input">
/// The input.
/// </param>
/// <returns>
/// The <see cref="Task"/>.
/// </returns>
public async Task CopyTransactionAsync(Abp.Application.Services.Dto.EntityDto <Guid> input)
{
var baseTransaction = await this._transactionRepository.FirstOrDefaultAsync(t => t.Id == input.Id);
var transctionDto = new TransactionEditDto();
baseTransaction.MapTo(transctionDto);
transctionDto.Id = null;
transctionDto.TransactionTime = DateTime.UtcNow;
await CreateOrUpdateTransaction(transctionDto);
}
private async Task UpdateTransactionAsync(TransactionEditDto input)
{
var tenantId = AbpSession.TenantId;
var transaction = await _transactionRepository.FirstOrDefaultAsync(t => t.Id == input.Id && t.Account.TenantId == tenantId);
ObjectMapper.Map(input, transaction);
await CurrentUnitOfWork.SaveChangesAsync();
await UpdateTransactionsBalanceInAccountAsync(input.AccountId);
await SendNotificationAsync(transaction.Id, NotificationTypes.UpdateTransaction).ConfigureAwait(false);
}
private async Task InsertTransactionAsync(TransactionEditDto input, bool isTransfer = false)
{
var transaction = ObjectMapper.Map <Transaction>(input);
transaction.Balance = 0;
transaction.IsTransferred = isTransfer;
var transactionId = await _transactionRepository.InsertAndGetIdAsync(transaction);
await CurrentUnitOfWork.SaveChangesAsync();
await UpdateTransactionsBalanceInAccountAsync(input.AccountId);
await SendNotificationAsync(transactionId, NotificationTypes.NewTransaction).ConfigureAwait(false);
}
private async Task InsertTransactionAsync(TransactionEditDto input, bool isTranfer = false)
{
var transaction = input.MapTo <Transaction>();
transaction.Balance = 0;
transaction.IsTransferred = isTranfer;
var transactionId = await _transactionRepository.InsertAndGetIdAsync(transaction);
await CurrentUnitOfWork.SaveChangesAsync();
await UpdateTransactionsBalanceInAccountAsync(input.AccountId);
await this.SendNotificationAsync(transactionId);
}
public async Task TransferAsync(TransferEditDto input)
{
// make sure expense
if (input.Amount > 0)
{
input.Amount *= -1;
}
var sentTransaction = new TransactionEditDto()
{
Amount = input.Amount,
AccountId = input.AccountId,
CategoryId = input.CategoryId,
Description = input.Description,
TransactionTime = input.TransactionTime
};
await InsertTransactionAsync(sentTransaction, true);
// make sure income
if (input.ToAmount < 0)
{
input.ToAmount *= -1;
}
var senderAccount = await this._accountRepository.FirstOrDefaultAsync(a => a.Id == input.AccountId);
var receivedTransaction = new TransactionEditDto()
{
Amount = input.ToAmount,
AccountId = input.ToAccountId,
CategoryId = input.CategoryId,
Description = $"Received from {senderAccount.Name}",
TransactionTime = input.TransactionTime
};
await InsertTransactionAsync(receivedTransaction, true);
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string name = this.dataGridView1.CurrentRow.Cells["transactionName"].Value.ToString();
string id = this.dataGridView1.CurrentRow.Cells["transactionId"].Value.ToString();
string categoryName = this.dataGridView1.CurrentRow.Cells["categoryName"].Value.ToString();
double amount = double.Parse(this.dataGridView1.CurrentRow.Cells["transactionAmount"].Value.ToString());
int categoryId = int.Parse(this.dataGridView1.CurrentRow.Cells["categoryId"].Value.ToString());
string note = this.dataGridView1.CurrentRow.Cells["transactionNote"].Value.ToString();
DateTime date = Convert.ToDateTime(dataGridView1.CurrentRow.Cells["transactionDate"].Value.ToString());
TransactionEditDto transactionEditDto = new TransactionEditDto();
transactionEditDto.transactionId = id;
transactionEditDto.categoryId = categoryId;
transactionEditDto.transactionAmount = amount;
transactionEditDto.transactionNote = note;
transactionEditDto.transactionName = name;
transactionEditDto.transactionDate = date;
transactionEditDto.categoryName = categoryName;
EditTransaction editTransaction = new EditTransaction(this, transactionEditDto);
editTransaction.Show();
}
public object updateTransactions(TransactionEditDto transactionEditDto)
{
object response = transactionService.updateTransactions(transactionEditDto);
return(response);
}
