public override Account Get(Int64 id)
{
try
{
using (var cmd = DbConnection().CreateCommand())
{
cmd.CommandText = $"SELECT * FROM {tableName} WHERE Id=@Id ";
cmd.Parameters.AddWithValue("@Id", id);
var reader = cmd.ExecuteReader();
if (reader.Read())
{
var statementEntryRepository = new StatementEntryRepository();
return(new Account
{
Id = reader.GetFieldValue <Int64>("Id"),
BranchNumber = reader.GetFieldValue <string>("BranchNumber"),
AccountNumber = reader.GetFieldValue <string>("AccountNumber"),
ClientTaxId = reader.GetFieldValue <string>("ClientTaxId"),
Balance = reader.GetFieldValue <double>("Balance"),
LastBalanceUpdate = DateTimeExtension.FromUnixTimeStamp(reader.GetFieldValue <Int64>("LastBalanceUpdate")),
StatementEntries = statementEntryRepository.GetByAccountId(id)
});
}
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public Account GetByBranchNumberAndAccountNumber(string branchNumber, string accountNumber)
{
try
{
using (var cmd = DbConnection().CreateCommand())
{
cmd.CommandText = $"SELECT * FROM {tableName} WHERE BranchNumber=@BranchNumber AND AccountNumber=@AccountNumber ";
cmd.Parameters.AddWithValue("@BranchNumber", branchNumber);
cmd.Parameters.AddWithValue("@AccountNumber", accountNumber);
var reader = cmd.ExecuteReader();
if (reader.Read())
{
return(new Account
{
Id = reader.GetFieldValue <int>("Id"),
BranchNumber = reader.GetFieldValue <string>("BranchNumber"),
AccountNumber = reader.GetFieldValue <string>("AccountNumber"),
ClientTaxId = reader.GetFieldValue <string>("ClientTaxId"),
Balance = reader.GetFieldValue <double>("Balance"),
LastBalanceUpdate = DateTimeExtension.FromUnixTimeStamp(reader.GetFieldValue <int>("LastBalanceUpdate"))
});
}
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
private static StatementEntry ToEntity(DbDataReader reader)
{
return(new StatementEntry
{
Id = reader.GetFieldValue <Int64>("Id"),
AccountId = reader.GetFieldValue <Int64>("AccountId"),
Date = DateTimeExtension.FromUnixTimeStamp(reader.GetFieldValue <Int64>("EntryDate")),
MovementType = (MovementType)reader.GetFieldValue <int>("MovementType"),
Value = reader.GetFieldValue <double>("Value"),
});
}
