/// <summary>
/// Registers a transaction in the database from the TransferInfoStruct
/// </summary>
/// <param name="sQLiteCore"></param>
/// <param name="transferInfoStruct"></param>
/// <returns></returns>
public static bool RegisterTransaction(this ISQLiteCore sQLiteCore, TransferInfoStruct transferInfoStruct)
{
bool ret = false;
using (IDbConnection conn = new SQLiteConnection(sQLiteCore._GetConnectionString()))
{
conn.Open();
CommandDefinition commandDefinition = new CommandDefinition($"INSERT INTO bm_transferCore values ({transferInfoStruct.AccNo}, '{transferInfoStruct.PersonNo}'," +
$" '{transferInfoStruct.TransactionType.TransactionTypeToString()}', '{transferInfoStruct.TransferDate}', '{transferInfoStruct.TransferAmout.ToString(System.Globalization.CultureInfo.InvariantCulture)}'," +
$" '{transferInfoStruct.TransferBalanceAfter.ToString(System.Globalization.CultureInfo.InvariantCulture)}');");
ret = conn.Execute(commandDefinition) > 0;
conn.Close();
}
return(ret);
}
/// <summary>
/// Returns true if transtaction is successfully registered in the db
/// </summary>
/// <param name="fetchAccountInfo"></param>
/// <param name="transferInfoStruct"></param>
/// <returns></returns>
public static bool RegisterTranstation(this IFetchAccountInfo fetchAccountInfo, TransferInfoStruct transferInfoStruct)
{
return(_sQLiteCore.RegisterTransaction(transferInfoStruct));
}
