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);
}
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);
}
public ClientRepository(IContext ctx)
{
context = ctx;
mapper = new ClientMapper(ctx);
}