internal UserPreferenceEntity GetUserPreferenceById(int id) { UserPreferenceEntity results = new UserPreferenceEntity(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetUserPreferenceById"; sproc.StoredProceduresParameter.Add(GetParam("@PreferenceID", id.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { UserPreferenceAdapter ta = new UserPreferenceAdapter(); foreach (DataRow rw in dt.Rows) { results = ta.AdaptItem(rw, dt); } } } catch (Exception) { throw; } return(results); }
internal List <UserPreferenceEntity> GetActiveUserPreference() { List <UserPreferenceEntity> results = new List <UserPreferenceEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetActiveUserPreference"; DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { UserPreferenceAdapter ta = new UserPreferenceAdapter(); foreach (DataRow rw in dt.Rows) { results = ta.Adapt(dt); } } } catch (Exception) { throw; } return(results); }
internal List <UserPreferenceEntity> GetUserPreference(int CredentialId) { List <UserPreferenceEntity> results = new List <UserPreferenceEntity>(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetUserPreference"; sproc.StoredProceduresParameter.Add(GetParam("@CredentialId", CredentialId.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.ReadWrite.ToString()); if (dt != null && dt.Rows.Count > 0) { results = new UserPreferenceAdapter().Adapt(dt); } } catch (Exception) { throw; } return(results); }