public async Task <ActionResult <string> > Add([FromBody] Fnb fnb)
{
var exist = await dbHelper.IsFnbExistAsync(fnb.Name);
if (exist)
{
return($"{fnb.Name} already exist");
}
else
{
var r = await dbHelper.AddFnbAsync(fnb);
return(r.Message);
}
}
public string AddFnb(Fnb fnb)
{
try
{
using (var db = new LiteDatabase(conString))
{
var data = db.GetCollection <Fnb>();
var id = data.Insert(fnb);
return($"'{fnb.Name}' added with ID '{id.AsString}'");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string UpdateFnb(int id, Fnb fnb)
{
try
{
using (var db = new LiteDatabase(conString))
{
var data = db.GetCollection <Fnb>();
var succ = data.Update(id, fnb);
return(succ ? "Success" : "Failed");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public async Task <string> AddFnbAsync(string fnbName, FnbType fnbType)
{
try
{
Fnb fnb = new Fnb
{
Name = fnbName,
FnbType = fnbType
};
var resp = await client.PostAsJsonAsync($"api/fnb/add", fnb);
return(await resp.Content.ReadAsStringAsync());
}
catch (Exception ex)
{
return(ex.Message);
}
}
public async Task <Fnb> GetFnbByIdAsync(int id)
{
try
{
Fnb fnb = null;
string sql = $"SELECT * FROM fnb WHERE id = @id;";
using (MySqlConnection connection = new MySqlConnection(this.dbConString))
{
await connection.OpenAsync();
using (MySqlCommand cmd = new MySqlCommand(sql, connection))
{
cmd.Parameters.AddWithValue("@id", id);
using (var reader = await cmd.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
fnb = new Fnb
{
Id = int.Parse(GetStringValue(reader["id"])),
Name = GetStringValue(reader["name"]),
FnbType = (FnbType)int.Parse(GetStringValue(reader["fnb_type"])),
CreatedTime = GetDateTimeValue(reader["created_time"]).Value.ToLocalTime(),
};
}
}
}
}
return(fnb);
}
catch (Exception ex)
{
//LOGGER.LogDbException(ex);
return(null);
}
}
public async Task <List <Fnb> > ListAllFnbAsync()
{
try
{
List <Fnb> fnbList = new List <Fnb>();
string sql = "SELECT * FROM fnb;";
using (MySqlConnection connection = new MySqlConnection(dbConString))
{
await connection.OpenAsync();
using (MySqlCommand cmd = new MySqlCommand(sql, connection))
{
using (var reader = await cmd.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
var fnb = new Fnb
{
Id = int.Parse(GetStringValue(reader["id"])),
Name = GetStringValue(reader["name"]),
FnbType = (FnbType)int.Parse(GetStringValue(reader["fnb_type"])),
CreatedTime = GetDateTimeValue(reader["created_time"]).Value.ToLocalTime(),
};
fnbList.Add(fnb);
}
}
}
}
return(fnbList);
}
catch (Exception ex)
{
//LOGGER.LogDbException(ex);
return(new List <Fnb>());
}
}
public async Task <DbCommitResponse> AddFnbAsync(Fnb fnb)
{
try
{
DbCommitResponse resp = null;
string query =
"INSERT into fnb (name, fnb_type) VALUES " +
"(@a, @b);";
using (MySqlConnection connection = new MySqlConnection(this.dbConString))
{
await connection.OpenAsync();
using (MySqlCommand cmd = new MySqlCommand(query, connection))
{
cmd.Parameters.AddWithValue("@a", fnb.Name);
cmd.Parameters.AddWithValue("@b", fnb.FnbType);
resp = new DbCommitResponse
{
IsSuccess = true,
Message = $"{await cmd.ExecuteNonQueryAsync()} record successfully created"
};
}
}
return(resp);
}
catch (Exception ex)
{
return(new DbCommitResponse
{
IsSuccess = false,
Message = ex.Message
});
}
}
public IBank GetBank(string _bank)
{
IBank Ibank;
switch (_bank.ToLower())
{
case "absa":
Ibank = new Absa();
break;
case "fnb":
Ibank = new Fnb();
break;
// Extend banks here
default:
/*
* Log this so we know users from unsupported banks who would like their banks to be added in the future
*/
throw new Exception("Insupported bank");
}
return(Ibank);
}
