public override IList <IVtOverdraft> GetOverdraftList()
{
var sqlString = BslSqlGenerator.GetOverdraftListSqlString();
var dbc = _db.GetSqlStringCommand(sqlString);
dbc.CommandType = CommandType.Text;
var overdraftList = new List <IVtOverdraft>();
using (var dataReader = _db.ExecuteReader(dbc))
{
while (dataReader.Read())
{
overdraftList.Add(PopulateOverdraftFromDataRecord(dataReader));
}
}
return(overdraftList);
}
public override IList <IVtClient> GetClientList()
{
var sqlString = BslSqlGenerator.GetClientListSqlString();
var dbc = _db.GetSqlStringCommand(sqlString);
dbc.CommandType = CommandType.Text;
var list = new List <IVtClient>();
using (var dataReader = _db.ExecuteReader(dbc))
{
while (dataReader.Read())
{
list.Add(PopulateIVtClientFromDataRecord(dataReader));
}
dataReader.Close();
}
return(list);
}
