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