// DB Changes (MP-716)
internal OIUserSessionFilterEntity OIGetUserSessionFilterText(int UserID)
{
OIUserSessionFilterEntity result = new OIUserSessionFilterEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.GetUserSessionFilterText";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
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)
{
result = new OIUserSessionFilterAdapter().Adapt(dt).FirstOrDefault();
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(result);
}
internal OIUserSessionFilterEntity GetUserSessionFilterByUserId(int UserID)
{
OIUserSessionFilterEntity results = new OIUserSessionFilterEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.GetUserSessionFilterByUserId";
StoredProceduresParameterEntity param = new StoredProceduresParameterEntity();
param.ParameterName = "@UserId";
param.ParameterValue = UserID.ToString();
sproc.StoredProceduresParameter.Add(param);
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
results = new OIUserSessionFilterAdapter().Adapt(dt).FirstOrDefault();
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(results);
}
