public bool InsertTransaction(out string msg)
{
msg = String.Empty;
decimal?availableBalance = AccountDebit.CalculateAvailableBalance();
if (!availableBalance.HasValue)
{
msg = "No available balance!";
return(false);
}
if (availableBalance < Amount)
{
msg = "No enough funds!";
return(false);
}
try
{
//Create SqlConnection
using (SqlConnection con = new SqlConnection(Common.connectionString))
{
using (SqlCommand cmd = new SqlCommand("dbo.InsertTransaction", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TransactionTypeId", TransactionTypeId);
cmd.Parameters.AddWithValue("@UserId", UserId);
cmd.Parameters.AddWithValue("@EntryDate", DateTime.Now);
cmd.Parameters.AddWithValue("@Date", Date);
cmd.Parameters.AddWithValue("@Currency", Currency);
cmd.Parameters.AddWithValue("@AccountIdDebit", AccountDebitId);
cmd.Parameters.AddWithValue("@AccountIdCredit", AccountCreditId);
cmd.Parameters.AddWithValue("@Fee", Fee);
cmd.Parameters.AddWithValue("@Amount", Amount);
cmd.Parameters.AddWithValue("@Description", Description);
con.Open();
cmd.ExecuteNonQuery();
return(true);
}
}
}
catch (Exception ex)
{
msg = ex.Message;
return(false);
}
}
public static string SavingDebit(this AccountDebit accountDebit)
{
//lógica de negócio
return(accountDebit.TransactionFormat());
}
public static string DebitSavingsAccount(this AccountDebit accountDebit)
{
// Business logic for savings account debit.
return(accountDebit.FormatsTransaction());
}
public static string DebitCurrentAccount(this AccountDebit accountDebit)
{
// Business logic for current account debit.
return(accountDebit.FormatsTransaction());
}
