internal OIUserMatchFilterEntity GetUserMatchFilterById(int UserId, int FilterId) { OIUserMatchFilterEntity results = new OIUserMatchFilterEntity(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "OI.GetUserMatchFilterById"; sproc.StoredProceduresParameter.Add(GetParam("@UserId", UserId.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@FilterId", FilterId.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { OIUserMatchFilterAdapter ta = new OIUserMatchFilterAdapter(); foreach (DataRow rw in dt.Rows) { results = ta.AdaptItem(rw); } } } catch (Exception) { throw; } return(results); }
internal List <OIUserMatchFilterEntity> GetUserMatchFilterList(int UserId) { List <OIUserMatchFilterEntity> results = new List <OIUserMatchFilterEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "OI.GetUserMatchFilterList"; sproc.StoredProceduresParameter.Add(GetParam("@UserId", UserId.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { results = new OIUserMatchFilterAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results); }