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