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