internal ICollection <IInstrument> LoadInstruments(Market m)
{
List <IInstrument> lst = new List <IInstrument>();
InstrumentMapper im = new InstrumentMapper(mapperHelper.context);
List <IDataParameter> parameters = new List <IDataParameter>();
parameters.Add(new SqlParameter("@id", m.code));
using (IDataReader rd = mapperHelper.ExecuteReader("select isin, mrktcode, description from Instrument where mrktcode=@id", parameters))
{
while (rd.Read())
{
Instrument i = new Instrument
{
isin = rd.IsDBNull(0) ? default : rd.GetString(0),
mrktcode = rd.IsDBNull(1) ? default : rd.GetInt32(1),
description = rd.IsDBNull(2) ? default : rd.GetString(2),
instrumentMarket = m
};
lst.Add(new InstrumentProxy(i, mapperHelper.context));
}
}
return(lst);
}
internal IList <IPosition> LoadPositions(IPortfolio p)
{
List <IPosition> lst = new List <IPosition>();
InstrumentMapper im = new InstrumentMapper(mapperHelper.context);
List <IDataParameter> parameters = new List <IDataParameter>();
parameters.Add(new SqlParameter("@id", p.name));
using (IDataReader rd = mapperHelper.ExecuteReader("select isin, name, quantity from Position where name=@id", parameters))
{
while (rd.Read())
{
Position pos = new Position
{
quantity = rd.IsDBNull(2) ? default : rd.GetInt32(2),
name = rd.IsDBNull(1) ? default : rd.GetString(1),
isin = rd.IsDBNull(0) ? default : rd.GetString(0),
Instrument = im.Read(rd.IsDBNull(0) ? default : rd.GetString(0)),
Portfolio = p
};
lst.Add(pos);
}
}
return(lst);
}
internal IInstrument LoadInstruments(Position p)
{
InstrumentMapper im = new InstrumentMapper(mapperHelper.context);
List <IDataParameter> parameters = new List <IDataParameter>();
parameters.Add(new SqlParameter("@id", p.isin));
using (IDataReader rd = mapperHelper.ExecuteReader("select isin from Instrument where isin=@id", parameters))
{
if (rd.Read())
{
return(im.Read(rd.IsDBNull(0) ? default : rd.GetString(0)));
}
}
return(null);
}
public InstrumentRepository(IContext ctx)
{
context = ctx;
mapper = new InstrumentMapper(ctx);
}
