public List <TProfile> Select() { DataTable dtProfile = _objConnectionFactory.ExecuteStoredProcedureQuery("spSelectProfile"); TProfile objProfile = null; List <TProfile> lstProfile = new List <TProfile>(); foreach (DataRow row in dtProfile.Rows) { objProfile = new TProfile(row); _objConnectionFactory.AddParameter("@pIdProfile", objProfile.IdProfile); DataTable dtProfileRestriction = _objConnectionFactory.ExecuteStoredProcedureQuery("spSelectProfileRestrictionForProfile"); TRestriction objRestriction = null; foreach (DataRow item in dtProfileRestriction.Rows) { objRestriction = new TRestriction(item); objProfile.Restrictions.Add(objRestriction); objRestriction = null; } lstProfile.Add(objProfile); objProfile = null; } return(lstProfile); }
public TProfile Select(int id) { _objConnectionFactory.AddParameter("@pIdProfile", id); DataTable dtProfile = _objConnectionFactory.ExecuteStoredProcedureQuery("spSelectProfileById"); TProfile objProfile = null; if (dtProfile.Rows.Count > 0) { objProfile = new TProfile(dtProfile.Rows[0]); _objConnectionFactory.AddParameter("@pIdProfile", objProfile.IdProfile); DataTable dtProfileRestriction = _objConnectionFactory.ExecuteStoredProcedureQuery("spSelectProfileRestrictionForProfile"); TRestriction objRestriction = null; foreach (DataRow item in dtProfileRestriction.Rows) { objRestriction = new TRestriction(item); objProfile.Restrictions.Add(objRestriction); objRestriction = null; } } return(objProfile); }