/// <summary>
/// Creates a fixed account in the database from the given FixedAccountDataStruct
/// </summary>
/// <param name="sQLiteCore"></param>
/// <param name="fixedAccountDataStruct"></param>
/// <returns></returns>
public static bool CreateNewFixedAccount(this ISQLiteCore sQLiteCore, FixedAccountDataStruct fixedAccountDataStruct)
{
bool ret = false;
using (IDbConnection conn = new SQLiteConnection(sQLiteCore._GetConnectionString()))
{
conn.Open();
CommandDefinition commandDefinition = new CommandDefinition($"INSERT INTO bm_fixCore values ({fixedAccountDataStruct.AccNo}, '{fixedAccountDataStruct.FName}'," +
$" '{fixedAccountDataStruct.LName}', '{fixedAccountDataStruct.FixedAmount.ToString(System.Globalization.CultureInfo.InvariantCulture)}'," +
$" '{fixedAccountDataStruct.MaturityAmount.ToString(System.Globalization.CultureInfo.InvariantCulture)}', '{fixedAccountDataStruct.MaturityDate}', '{fixedAccountDataStruct.InterestRate.ToString(System.Globalization.CultureInfo.InvariantCulture)}', " +
$"'{fixedAccountDataStruct.FixedAccountCreationDate}');");
ret = conn.Execute(commandDefinition) > 0; // infected cell , first create a new entry in bm_fileCore table
CommandDefinition commandDefinitionUpdateHasFixed = new CommandDefinition($"UPDATE bm_accCore SET HasFixedAcc='True' WHERE AccNum={fixedAccountDataStruct.AccNo};");
ret = conn.Execute(commandDefinitionUpdateHasFixed) > 0; // then update the value of HasFixedAcc to ture in bm_accCore table
conn.Close();
}
return(ret);
}
/// <summary>
/// Returns true if a new fixed deposite account creation is successful
/// </summary>
/// <param name="fetchAccountInfo"></param>
/// <param name="fixedAccountDataStruct"></param>
/// <returns></returns>
public static bool CreateNewFixedAccount(this IFetchAccountInfo fetchAccountInfo, FixedAccountDataStruct fixedAccountDataStruct)
{
return(_sQLiteCore.CreateNewFixedAccount(fixedAccountDataStruct));
}
