public HitblUserSettingsUstCollection FetchByQuery(Query qry) { HitblUserSettingsUstCollection coll = new HitblUserSettingsUstCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public HitblUserSettingsUstCollection FetchAll() { HitblUserSettingsUstCollection coll = new HitblUserSettingsUstCollection(); Query qry = new Query(HitblUserSettingsUst.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
private void GetUserSettings() { if (_CurrentCommunity != null) { Query qry = new Query(HitblUserSettingsUst.Schema); qry.AddWhere(HitblUserSettingsUst.Columns.UsrCurrentCommunityId, Comparison.Equals, _CurrentCommunity.CtyId); qry.AddWhere(HitblUserSettingsUst.Columns.UsrId, Comparison.Equals, _UserId); IDataReader idr = null; try { idr = qry.ExecuteReader(); HitblUserSettingsUstCollection UserSettingsUSTCollection = new HitblUserSettingsUstCollection(); UserSettingsUSTCollection.Load(idr); idr.Close(); if (UserSettingsUSTCollection.Count > 0) { _UserSettings = (HitblUserSettingsUst)UserSettingsUSTCollection[0]; } else { _UserSettings = new HitblUserSettingsUst(); _UserSettings.UsrCurrentCommunityId = _CurrentCommunity.CtyId; _UserSettings.UsrCurrentLang = _CurrLang; _UserSettings.UsrId = _UserId; if (_CurrentPage != null) { _UserSettings.UsrCurrentPageId = _CurrentPage.PagId; } _UserSettings.Save(); } } finally { if (idr != null && !idr.IsClosed) { idr.Close(); } } } }
public HitblUserSettingsUstCollection FetchByID(object UsrId) { HitblUserSettingsUstCollection coll = new HitblUserSettingsUstCollection().Where("USR_ID", UsrId).Load(); return(coll); }