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); }