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