internal ICollection <IDailyReg> LoadDailyRegs(IInstrument i) { List <IDailyReg> lst = new List <IDailyReg>(); DailyRegMapper drm = new DailyRegMapper(mapperHelper.context); List <IDataParameter> parameters = new List <IDataParameter>(); parameters.Add(new SqlParameter("@id", i.isin)); using (IDataReader rd = mapperHelper.ExecuteReader("select isin,minval ,openingval, maxval,closingval, dailydate from DailyReg where isin=@id", parameters)) { while (rd.Read()) { DailyReg dr = new DailyReg { isin = rd.IsDBNull(0) ? default : rd.GetString(0), minval = rd.IsDBNull(1) ? default : rd.GetDecimal(1), openingval = rd.IsDBNull(2) ? default : rd.GetDecimal(2), maxval = rd.IsDBNull(3) ? default : rd.GetDecimal(3), closingval = rd.IsDBNull(4) ? default : rd.GetDecimal(4), dailydate = rd.IsDBNull(5) ? default : rd.GetDateTime(5), instrument = i }; lst.Add(dr); } } return(lst); }
internal IPortfolio LoadPortfolios(IPosition p) { PortfolioMapper pm = new PortfolioMapper(mapperHelper.context); List <IDataParameter> parameters = new List <IDataParameter>(); parameters.Add(new SqlParameter("@id", p.name)); using (IDataReader rd = mapperHelper.ExecuteReader("select name, totalval from Portfolio where name=@id", parameters)) { if (rd.Read()) { return(pm.Read(rd.IsDBNull(0) ? default : rd.GetString(0))); } } return(null); }
internal ICollection <IEmail> LoadEmails(IClient c) { List <IEmail> lst = new List <IEmail>(); EmailMapper em = new EmailMapper(mapperHelper.context); List <IDataParameter> parameters = new List <IDataParameter>(); parameters.Add(new SqlParameter("@nif", c.nif)); using (IDataReader rd = mapperHelper.ExecuteReader("select code from Client_Email where nif=@nif", parameters)) { while (rd.Read()) { lst.Add(em.Read(rd.IsDBNull(0) ? default : rd.GetInt32(0))); } } return(lst); }
internal IClient LoadClient(IPortfolio p) { ClientMapper cm = new ClientMapper(mapperHelper.context); List <IDataParameter> parameters = new List <IDataParameter>(); decimal nif = decimal.Parse(p.name.Split('_')[0]); parameters.Add(new SqlParameter("@id", nif)); using (IDataReader rd = mapperHelper.ExecuteReader("select nif, ncc, name from Client where nif=@id", parameters)) { if (rd.Read()) { return(cm.Read(rd.IsDBNull(0) ? default : rd.GetDecimal(0))); } } return(null); }
internal ICollection <IDailyMarket> LoadDailyMarkets(Market m) { List <IDailyMarket> lst = new List <IDailyMarket>(); List <IDataParameter> parameters = new List <IDataParameter>(); parameters.Add(new SqlParameter("@id", m.code)); using (IDataReader rd = mapperHelper.ExecuteReader("select idxmrkt, dailyvar, idxopeningval, code, date from dailymarket where code=@id", parameters)) { while (rd.Read()) { DailyMarket dm = new DailyMarket { code = rd.IsDBNull(3) ? default : rd.GetInt32(3), dailyvar = rd.IsDBNull(1) ? default : rd.GetDecimal(1), date = rd.IsDBNull(4) ? default : rd.GetDateTime(4), idxmrkt = rd.IsDBNull(0) ? default : rd.GetDecimal(0), idxopeningval = rd.IsDBNull(2) ? default : rd.GetDecimal(2), market = m }; lst.Add(dm); } } return(lst); }
internal IClient LoadClient(IPhone p) { ClientMapper cm = new ClientMapper(mapperHelper.context); List <IDataParameter> parameters = new List <IDataParameter>(); parameters.Add(new SqlParameter("@id", p.code)); using (IDataReader rd = mapperHelper.ExecuteReader("select nif from Phone where code=@id", parameters)) { if (rd.Read()) { return(cm.Read(rd.IsDBNull(0) ? default : rd.GetInt32(0))); } } return(null); }