public void SaveBankDetails(BankAccDetail bankDet)
{
var query = $@"
INSERT INTO [dbo].[BankDetails](AccountNum, AccountBalance, BankCode, AccountStatus)
VALUES
('{bankDet.AccountNum}', {bankDet.AccountBalance.ToString("F").Replace(',', '.')}, {(int)bankDet.BankCode}, {(int)bankDet.AccStatus})";
using (var conn = getConnection())
{
if (isConnectionValid(conn))
{
try
{
using (var command = new SqlCommand())
{
command.CommandText = query;
command.CommandType = CommandType.Text;
command.Connection = conn;
conn.Open();
command.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new ExceptionLogger(this.logger, "Could not sve the Bank Account.", ex);
}
finally
{
conn.Close();
}
}
}
}
public void AddBankAccount([FromBody] BankAccDetail bankDet)
{
this.bankService.SaveBankDetail(bankDet);
}
public List <BankAccDetail> GetBankDetails(string whereClause = "")
{
List <BankAccDetail> bankAccounts = new List <BankAccDetail>();
var query = "SELECT * FROM [dbo].[BankDetails]";
if (!whereClause.IsNullOrEmpty())
{
query += $" {whereClause}";
}
using (var conn = getConnection())
{
if (isConnectionValid(conn))
{
try
{
using (var command = new SqlCommand())
{
command.CommandText = query;
command.CommandType = CommandType.Text;
command.Connection = conn;
conn.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var accNum = reader[0].ToString();
var balance = reader[1].ToString();
var bCode = reader[2].ToString();
var accStatus = reader[3].ToString();
double castBalance;
if (!double.TryParse(balance, out castBalance))
{
throw new ExceptionLogger(this.logger, $"Could not parse balance into a double.");
}
var bankDet = new BankAccDetail()
{
AccountBalance = castBalance,
AccountNum = accNum,
AccStatus = (AccountStatus)accStatus.ToString().GetEnum(typeof(AccountStatus)),
BankCode = (BankCode)bCode.ToString().GetEnum(typeof(BankCode))
};
bankAccounts.Add(bankDet);
}
}
}
}
catch (Exception ex)
{
throw new ExceptionLogger(this.logger, "Could not load the Bank Accounts.", ex);
}
finally
{
conn.Close();
}
}
}
return(bankAccounts);
}
public void SaveBankDetail(BankAccDetail bankDet)
{
this.dbService.SaveBankDetails(bankDet);
}
