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