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