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