public static List <Business.MainTag> Load(int?parentId, int?level)
{
string key = "MainTags";
if (parentId.HasValue)
{
key += "p" + parentId.Value.ToString();
}
if (level.HasValue)
{
key += "l" + level.Value.ToString();
}
QuickCacheHandler cacheHandler = new QuickCacheHandler(key);
cacheHandler.AlternateCacheMinutes = 60;
cacheHandler.ItemPriority = System.Web.Caching.CacheItemPriority.BelowNormal;
List <Business.MainTag> list = cacheHandler.Get() as List <Business.MainTag>;
if (list != null)
{
return(list);
}
list = new List <Business.MainTag>();
SqlDataReader sqlReader = null;
try
{
sqlReader = GetReader(parentId, level);
if (sqlReader != null)
{
while (sqlReader.Read())
{
Business.MainTag item = new Business.MainTag();
FillObject(item, sqlReader);
list.Add(item);
}
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
cacheHandler.Insert(list);
return(list);
}
public static List <Business.CountryName> Load(string langCode)
{
QuickCacheHandler cacheHandler = new QuickCacheHandler("CountryNames" + langCode);
cacheHandler.AlternateCacheMinutes = 60;
cacheHandler.ItemPriority = System.Web.Caching.CacheItemPriority.BelowNormal;
List <Business.CountryName> list = cacheHandler.Get() as List <Business.CountryName>;
if (list != null)
{
return(list);
}
list = new List <Business.CountryName>();
SqlDataReader sqlReader = null;
try
{
sqlReader = GetReader(langCode);
if (sqlReader != null)
{
while (sqlReader.Read())
{
Business.CountryName item = new Business.CountryName();
FillObject(item, sqlReader);
list.Add(item);
}
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
cacheHandler.Insert(list);
return(list);
}
public static void Insert(Guid userID, string userNickname, UserActivityWhat activityWhat, Guid?targetObjectID, Guid?detailObjectID, string text, bool?onlyVisibleForAdmin)
{
if (!Business.DataAccessConfiguration.UserActivityIsActivityActiv(activityWhat))
{
return;
}
string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["CSBoosterConnectionString"].ConnectionString;
SqlConnection Conn = new SqlConnection(strConn);
try
{
SqlCommand GetData = new SqlCommand();
GetData.Connection = Conn;
GetData.CommandType = CommandType.StoredProcedure;
GetData.CommandText = "hisp_UserActivity_Insert";
GetData.Parameters.AddWithValue("@USR_ID", userID);
if (!string.IsNullOrEmpty(userNickname) && userNickname.Length > 0)
{
GetData.Parameters.AddWithValue("@USR_Nickname", userNickname);
}
GetData.Parameters.AddWithValue("@USA_WHAT", (int)activityWhat);
GetData.Parameters.AddWithValue("@USA_Type", (int)GetTypeDependOnWhat(activityWhat));
GetData.Parameters.AddWithValue("@USA_ValidUntilMinutes", Business.DataAccessConfiguration.UserActivityValidUntil(activityWhat));
if (targetObjectID != null)
{
GetData.Parameters.AddWithValue("@USA_Target_OBJ_ID", targetObjectID.Value);
}
if (detailObjectID != null)
{
GetData.Parameters.AddWithValue("@USA_Detail_OBJ_ID", detailObjectID.Value);
}
if (!string.IsNullOrEmpty(text))
{
GetData.Parameters.AddWithValue("@USA_Text", text.CutRight(256));
}
if (onlyVisibleForAdmin != null)
{
GetData.Parameters.AddWithValue("@USA_OnlyVisibleForAdmin", onlyVisibleForAdmin.Value.ToSqlBit());
}
Conn.Open();
GetData.ExecuteNonQuery();
Conn.Close();
QuickCacheHandler.RemoveCache("UserActivity" + userID.ToString());
}
catch
{
if (Conn.State != ConnectionState.Closed)
{
Conn.Close();
}
// do nothing da nicht lebenswichtig
}
}
public static Business.UserActivityList <Business.UserActivity> Load(Business.UserActivityParameters paras)
{
StringBuilder key = new StringBuilder("UserActivity" + paras.Udc.UserID.ToString());
if (paras.WithAdminData)
{
key.Append("WAD");
}
if (paras.Amount > 0 && paras.Amount <= Business.DataAccessConfiguration.UserActivityMaximalAmount())
{
key.Append(paras.Amount.ToString());
}
else
{
key.Append(Business.DataAccessConfiguration.UserActivityMaximalAmount().ToString());
}
QuickCacheHandler cacheHandler = new QuickCacheHandler(key.ToString());
cacheHandler.AlternateCacheMinutes = 2;
cacheHandler.ItemPriority = System.Web.Caching.CacheItemPriority.Default;
Business.UserActivityList <Business.UserActivity> list = cacheHandler.Get() as Business.UserActivityList <Business.UserActivity>;
if (list != null)
{
return(list);
}
list = new Business.UserActivityList <Business.UserActivity>(paras);
SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CSBoosterConnectionString"].ConnectionString);
SqlDataReader sqlReader = null;
try
{
SqlCommand GetData = new SqlCommand();
GetData.Connection = Conn;
GetData.CommandType = CommandType.StoredProcedure;
//if (paras.ObjectType == ObjectType.Community)
//{
// GetData.CommandText = "hisp_UserActivity_Community_Load";
// GetData.Parameters.AddWithValue("@USR_ID", paras.Udc.UserId.ToGuid());
// GetData.Parameters.AddWithValue("@CTY_ID", paras.ObjectID);
//}
//else
//{
GetData.CommandText = "hisp_UserActivity_User_Load";
GetData.Parameters.AddWithValue("@USR_ID", paras.Udc.UserID);
//}
if (paras.WithAdminData)
{
GetData.Parameters.AddWithValue("@WithAdminData", 1);
}
if (paras.UserActivityType != null)
{
GetData.Parameters.AddWithValue("@USA_Type", (int)paras.UserActivityType.Value);
}
if (paras.Amount > 0 && paras.Amount <= Business.DataAccessConfiguration.UserActivityMaximalAmount())
{
GetData.Parameters.AddWithValue("@Amount", paras.Amount);
}
else
{
GetData.Parameters.AddWithValue("@Amount", Business.DataAccessConfiguration.UserActivityMaximalAmount());
}
Conn.Open();
sqlReader = GetData.ExecuteReader(CommandBehavior.CloseConnection);
while (sqlReader.Read())
{
Business.UserActivity item = new Business.UserActivity(sqlReader["USA_ID"].ToString().ToGuid(), (UserActivityWhat)sqlReader["USA_What"].ToString().ToInt32(0));
item.UserID = sqlReader["USR_ID"].ToString().ToGuid();
item.UserNickname = sqlReader["USR_Nickname"].ToString();
item.Date = Convert.ToDateTime(sqlReader["USA_Date"]);
if (sqlReader["USA_Target_OBJ_ID"] != DBNull.Value)
{
item.TargetObjectID = sqlReader["USA_Target_OBJ_ID"].ToString().ToGuid();
}
if (sqlReader["USA_Target_OBJ_Type"] != DBNull.Value)
{
item.TargetObjectType = Convert.ToInt32(sqlReader["USA_Target_OBJ_Type"]);
}
item.TargetObjectText = sqlReader["USA_Target_OBJ_Text"].ToString();
if (sqlReader["USA_Detail_OBJ_ID"] != DBNull.Value)
{
item.DetailObjectID = sqlReader["USA_Detail_OBJ_ID"].ToString().ToGuid();
}
if (sqlReader["USA_Detail_OBJ_Type"] != DBNull.Value)
{
item.DetailObjectType = Convert.ToInt32(sqlReader["USA_Detail_OBJ_Type"]);
}
if (item.ActivityWhat == UserActivityWhat.DoNowThis && sqlReader["USA_Text"] != DBNull.Value)
{
item.DetailObjectText = sqlReader["USA_Text"].ToString();
}
else
{
item.DetailObjectText = sqlReader["USA_Detail_OBJ_Text"].ToString();
}
item.OnlyVisibleForAdmin = Convert.ToBoolean(sqlReader["USA_OnlyVisibleForAdmin"]);
list.Add(item);
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
paras.ItemTotal = list.Count;
cacheHandler.Insert(list);
return(list);
}
public static Business.DataObjectList <T> Load <T>(Business.QuickParameters paras) where T : Business.DataObject, new()
{
if (!paras.Amount.HasValue)
{
if (paras.ObjectType > 0)
{
paras.Amount = Helper.GetObjectType(paras.ObjectType).DefaultLoadAmount;
}
else
{
T type = new T();
if (type.ObjectType > 0)
{
paras.Amount = Helper.GetObjectType(type.ObjectType).DefaultLoadAmount;
}
else
{
paras.Amount = 1000;
}
}
}
QuickCacheHandler cacheHandler = new QuickCacheHandler(paras, typeof(T).ToString());
Business.DataObjectList <T> list = (Business.DataObjectList <T>)cacheHandler.Get();
if (list == null)
{
list = new Business.DataObjectList <T>(paras);
SqlDataReader sqlReader = null;
try
{
if (paras is Business.QuickParametersFriends)
{
sqlReader = DataObjectsHelper.GetReaderAllFriends((Business.QuickParametersFriends)paras);
}
else if (paras is Business.QuickParametersUser && ((Business.QuickParametersUser)paras).ForObjectType.HasValue)
{
sqlReader = DataObjectsHelper.GetReaderAllBest((Business.QuickParametersUser)paras);
}
else if (paras is Business.QuickParametersUser && ((Business.QuickParametersUser)paras).LoadVisits.HasValue)
{
sqlReader = DataObjectsHelper.GetReaderAllVisits((Business.QuickParametersUser)paras);
}
else if (paras is Business.QuickParametersTag)
{
sqlReader = DataObjectsHelper.GetReaderAllTags((Business.QuickParametersTag)paras);
}
else
{
sqlReader = DataObjectsHelper.GetReaderAll <T>(paras, null);
}
int rank = 0;
list.PageTotal = paras.PageTotal;
list.ItemTotal = paras.ItemTotal;
list.PageNumber = paras.PageNumber;
while (sqlReader.Read())
{
rank++;
T item = new T();
item.UserDataContext = paras.Udc;
item.FillObject(sqlReader);
list.Add(item);
}
if (rank > 0 && list.ItemTotal == 0 && paras.DisablePaging.HasValue && paras.DisablePaging.Value)
{
list.PageTotal = 1;
list.ItemTotal = rank;;
list.PageNumber = 1;
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
if (!string.IsNullOrEmpty(paras.GeneralSearch) && list.PageNumber == 1)
{
_4screen.CSB.Extensions.Business.TrackingManager.TrackEventSearch(paras.GeneralSearch, list.ItemTotal, paras.ObjectType);
}
}
cacheHandler.Insert(list);
}
return(list);
}
