private void AddWithoutCheck(DataCacheObject obj) { CacheItemPolicy policy = new CacheItemPolicy(); policy.AbsoluteExpiration = DateTime.Now + TimeSpan.FromSeconds(obj.CacheTime); lock (Cache) Cache.Add(new CacheItem(GetKey(obj), obj.Data), policy); }
public void Add(DataCacheObject obj) { if (Contains(obj)) { Remove(obj); } AddWithoutCheck(obj); }
public void Update(DataCacheObject obj) { if (!Contains(obj)) { return; } UpdateWithoutCheck(obj); }
public void Remove(DataCacheObject obj) { if (!Contains(obj)) { return; } Cache.Remove(GetKey(obj)); }
private void AddWithoutCheck(DataCacheObject obj) { CacheItemPolicy policy = new CacheItemPolicy(); policy.AbsoluteExpiration = DateTime.Now + TimeSpan.FromSeconds(obj.CacheTime); lock (Cache) Cache.Add(new CacheItem(GetKey(obj), obj.Data), policy); }
public void ClearARP(int id) { ICacheDataProvider cacheRepository; if (Consts.DataCachingTechnology == DataCacheTechnology.MEMORYOBJECT) cacheRepository = new CacheDataProvider(); else cacheRepository = new AppFabricCacheProviderSystemRegions(Consts.ProductName); DataCacheObject dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONS, "GETAUCTIONDETAILRESULTPAST", new object[] { id }); cacheRepository.Remove(dco); Logger.LogInfo("[Cache removed: " + DataCacheType.RESOURCE + "_" + DataCacheRegions.AUCTIONS + "_GETAUCTIONDETAILRESULTPAST" + "_" + id + "]"); }
//Add public void Add(DataCacheObject obj) { if (Contains(obj)) { Remove(obj); } DataCache dc = GetDataCache(obj.Type.ToString()); dc.Put(GetKey(obj), obj.Data, TimeSpan.FromSeconds(obj.CacheTime)); }
//Remove public void Remove(DataCacheObject obj) { if (!Contains(obj)) { return; } DataCache dc = GetDataCache(obj.Type.ToString()); dc.Remove(GetKey(obj)); }
//Put public void Put(DataCacheObject obj) { try{ DataCache dc = GetDataCache(obj.Type.ToString()); dc.Put(GetKey(obj), obj.Data, TimeSpan.FromSeconds(obj.CacheTime)); } catch (Exception ex) { Logger.LogException("APPFABRICCACHEPROVIDERSYSTEMREGIONS_PUT", ex); } }
public void Put(DataCacheObject obj) { if (!Contains(obj)) { AddWithoutCheck(obj); } else { UpdateWithoutCheck(obj); } }
//GetByCriterias private List<AuctionShort> GetByCriterias(string lot, string title, int sortby, bool ordrby, long event_id, int pageindex, int pagesize, out int? totalrecord) { title = String.IsNullOrEmpty(title) ? String.Empty : title.Replace(" ", "%"); var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONLISTS, "GETBYCRITERIAS", new object[] {lot, title, sortby, ordrby, event_id, pageindex, pagesize}, CachingExpirationTime.Seconds_30); var result = CacheRepository.Get(dco) as TableViewResult; if (result != null && result.TotalRecords > 0) { totalrecord = result.TotalRecords; return result.Records; } result = new TableViewResult(); totalrecord = 0; dataContext.CommandTimeout = 600000; result.Records = (from p in dataContext.spAuction_View_Search(event_id, lot, title, String.Empty, -1, -1, sortby - 1, ordrby, pageindex, pagesize, ref totalrecord) select new AuctionShort { Bids = p.Bids.GetValueOrDefault(0), CurrentBid = p.CurrentBid.GetValueOrDefault(0), Estimate = p.Estimate, IsBold = p.IsBold.GetValueOrDefault(false), IsFeatured = p.IsFeatured.GetValueOrDefault(false), IsUnsoldOrPulledOut = p.IsUnsold.GetValueOrDefault(false) || p.IsPulledOut.GetValueOrDefault(false), LinkParams = new LinkParams { ID = p.Auction_ID.GetValueOrDefault(0), EventTitle = p.EventTitle, MainCategoryTitle = p.MainCategoryTitle, CategoryTitle = p.CategoryTitle }, Lot = p.Lot.HasValue ? p.Lot.Value : (short) 0, Price = p.Price.GetValueOrDefault(0), PriceRealized = p.PriceRealized.GetValueOrDefault(0), PulledOut = p.IsPulledOut.GetValueOrDefault(false), Status = p.AuctionStatus.GetValueOrDefault(0), ThumbnailPath = p.ThumbnailPath, Title = p.Title, UnsoldOrPulledOut = p.IsUnsold.GetValueOrDefault(false) ? "UNSOLD" : "WITHDRAWN" }).ToList(); result.TotalRecords = totalrecord.GetValueOrDefault(0); if (result.TotalRecords > 0) { dco.Data = result; CacheRepository.Add(dco); } return result.Records; }
public void Put(DataCacheObject obj) { try { DataCache dc = GetDataCache(obj.Type.ToString()); dc.Put(GetKey(obj), obj.Data, TimeSpan.FromSeconds(obj.CacheTime), obj.Region); } catch (Exception ex) { Logger.LogException(obj.Method, ex); } }
//Get public object Get(DataCacheObject obj) { try { DataCache dc = GetDataCache(obj.Type.ToString()); return(dc.Get(GetKey(obj))); } catch (Exception ex) { Logger.LogException("APPFABRICCACHEPROVIDERSYSTEMREGIONS_GET", ex); return(null); } }
//Update public void Update(DataCacheObject obj) { DataCache dc = GetDataCache(obj.Type.ToString()); if (!Contains(obj)) { return; } DataCacheItem dci = dc.GetCacheItem(GetKey(obj)); dc.Put(GetKey(obj), obj.Data, dci.Version, dci.Timeout); }
//Get public object Get(DataCacheObject obj) { try { DataCache dc = GetDataCache(obj.Type.ToString()); return dc.Get(GetKey(obj)); } catch(Exception ex) { Logger.LogException("APPFABRICCACHEPROVIDERSYSTEMREGIONS_GET", ex); return null; } }
//GetCurrent() public Event GetCurrent() { DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "GETCURRENT", null, CachingExpirationTime.Hours_01); Event evnt = CacheRepository.Get(dco) as Event; if (evnt != null) return evnt; evnt = dataContext.spEvent_Current().FirstOrDefault(); if (evnt != null) { dco.Data = evnt; CacheRepository.Add(dco); } return evnt; }
public object Get(DataCacheObject obj) { try { DataCache dc = GetDataCache(obj.Type.ToString()); return dc.Get(GetKey(obj), obj.Region); } catch (DataCacheException ex) { Logger.LogException(obj.Method, ex); } return null; }
public List<DataCacheObject> AllCache() { List<DataCacheObject> result = new List<DataCacheObject>(); DataCacheObject dco; foreach (var c in Cache) { dco = new DataCacheObject(); dco.Data = c.Value; dco.Method = c.Key; result.Add(dco); } return result; }
public void Add(DataCacheObject obj) { try { if (Contains(obj)) Remove(obj); DataCache dc = GetDataCache(obj.Type.ToString()); dc.Put(GetKey(obj), obj.Data, TimeSpan.FromSeconds(obj.CacheTime), obj.Region); } catch (DataCacheException ex) { Logger.LogException(obj.Method, ex); } }
public object Get(DataCacheObject obj) { try { DataCache dc = GetDataCache(obj.Type.ToString()); return(dc.Get(GetKey(obj), obj.Region)); } catch (DataCacheException ex) { Logger.LogException(obj.Method, ex); } return(null); }
//Add public void Add(DataCacheObject obj) { try { if (Contains(obj)) Remove(obj); DataCache dc = GetDataCache(obj.Type.ToString()); dc.Put(GetKey(obj), obj.Data, TimeSpan.FromSeconds(obj.CacheTime)); } catch (Exception ex) { Logger.LogException("APPFABRICCACHEPROVIDERSYSTEMREGIONS_ADD", ex); } }
//GetPastedEventsList public List<Event> GetPastedEventsList() { DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "GETPASTEDEVENTSLIST", new object[] { }, CachingExpirationTime.Hours_01); List<Event> result = CacheRepository.Get(dco) as List<Event>; if (result != null) return result; result = dataContext.spEvent_PastList().ToList(); if (result.Any()) { dco.Data = result; CacheRepository.Add(dco); } return result; }
public List <DataCacheObject> AllCache() { List <DataCacheObject> result = new List <DataCacheObject>(); DataCacheObject dco; foreach (var c in Cache) { dco = new DataCacheObject(); dco.Data = c.Value; dco.Method = c.Key; result.Add(dco); } return(result); }
//GetCountries public List<Country> GetCountries() { var dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.COUNTRIES, "GETCOUNTRIES", new object[] { }, CachingExpirationTime.Days_01); var result = _cacheRepository.Get(dco) as List<Country>; if (result != null) return result; result = _dataContext.spCountry_List().ToList(); if (result.Any()) { dco.Data = result; _cacheRepository.Add(dco); } return result; }
//GetConsignment public Consignment GetConsignment(long consignment_id) { DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.INVOICES, "GETCONSIGNMENT", new object[] { consignment_id }, CachingExpirationTime.Hours_01); Consignment result = CacheRepository.Get(dco) as Consignment; if (result != null) return result; result = dataContext.spSelect_Consignment(consignment_id).FirstOrDefault(); if (result != null) { dco.Data = result; CacheRepository.Add(dco); } return result; }
//GetUserInvoice public UserInvoice GetUserInvoice(long userinvoice_id) { DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.INVOICES, "GETUSERINVOICE", new object[] { userinvoice_id }, CachingExpirationTime.Hours_01); UserInvoice ui = CacheRepository.Get(dco) as UserInvoice; if (ui != null) return ui; ui = dataContext.spSelect_UserInvoices(userinvoice_id).FirstOrDefault(); if (ui != null) { dco.Data = ui; CacheRepository.Add(dco); } return ui; }
//GetCountry public Country GetCountry(long countryID) { var dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.COUNTRIES, "GETCOUNTRY", new object[] { countryID }, CachingExpirationTime.Days_01); var result = _cacheRepository.Get(dco) as Country; if (result != null) return result; result = _dataContext.spCountry_List().FirstOrDefault(t => t.ID == countryID); if (result != null) { dco.Data = result; _cacheRepository.Add(dco); } return result; }
//GetTopBidForItem public BidCurrent GetTopBidForItem(long auction_id, bool fromcache = true) { DataCacheObject dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.BIDS, "GETTOPBIDFORITEM", new object[] { auction_id }, CachingExpirationTime.Hours_01); BidCurrent result = CacheRepository.Get(dco) as BidCurrent; if (result != null && fromcache) return new BidCurrent(result); dataContext.CommandTimeout = 600000; result = dataContext.spBid_WinningBid(auction_id).FirstOrDefault(); if (result != null) { dco.Data = result; CacheRepository.Add(dco); } return result != null ? new BidCurrent(result) : null; }
public void Put(DataCacheObject obj) { DataCacheItem dci = new DataCacheItem(); try { DataCache dc = GetDataCache(obj.Type.ToString()); dc.Put(GetKey(obj), obj.Data, TimeSpan.FromSeconds(obj.CacheTime), obj.Region); } catch (DataCacheException ex) { Logger.LogException(obj.Method + " ~ " + String.Format("cached_value:{0}; new_value:{1}", dci.Value, obj.Data), ex); } }
//GetStates public List<State> GetStates(long? countryID) { var dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.STATES, "GETSTATES", new object[] { countryID.GetValueOrDefault(0) }, CachingExpirationTime.Days_01); var result = _cacheRepository.Get(dco) as List<State>; if (result != null) return result; result = _dataContext.spState_List(countryID).ToList(); if (result.Any()) { dco.Data = result; _cacheRepository.Add(dco); } return result; }
//GetEventByID public Event GetEventByID(long event_id) { DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "GETEVENTBYID", new object[] { event_id }, CachingExpirationTime.Hours_01); Event evnt = CacheRepository.Get(dco) as Event; if (evnt != null) return evnt; evnt = dataContext.spSelect_Event(event_id).SingleOrDefault(); if (evnt != null) { dco.Data = evnt; CacheRepository.Add(dco); } return evnt; }
//Remove public void Remove(DataCacheObject obj) { try{ if (!Contains(obj)) { return; } DataCache dc = GetDataCache(obj.Type.ToString()); dc.Remove(GetKey(obj)); } catch (Exception ex) { Logger.LogException("APPFABRICCACHEPROVIDERSYSTEMREGIONS_REMOVE", ex); } }
//GetAuctionImages public List<Image> GetAuctionImages(long auctionID) { var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.IMAGES, "GETAUCTIONIMAGES", new object[] { auctionID }, CachingExpirationTime.Minutes_30); var result = _cacheRepository.Get(dco) as List<Image>; if (result != null && result.Any()) return result; _dataContext.CommandTimeout = 600000; result = _dataContext.spAuction_GetAuctionImages(auctionID).ToList(); if (result.Any()) { dco.Data = result; _cacheRepository.Add(dco); } return result; }
public void Add(DataCacheObject obj) { try { if (Contains(obj)) { Remove(obj); } DataCache dc = GetDataCache(obj.Type.ToString()); dc.Add(GetKey(obj), obj.Data, TimeSpan.FromSeconds(obj.CacheTime), obj.Region); } catch (Exception ex) { Logger.LogException(obj.Method, ex); } }
//Update public void Update(DataCacheObject obj) { try{ DataCache dc = GetDataCache(obj.Type.ToString()); if (!Contains(obj)) { return; } DataCacheItem dci = dc.GetCacheItem(GetKey(obj)); dc.Put(GetKey(obj), obj.Data, dci.Version, dci.Timeout); } catch (Exception ex) { Logger.LogException("APPFABRICCACHEPROVIDERSYSTEMREGIONS_UPDATE", ex); } }
public void Remove(DataCacheObject obj) { try { if (!Contains(obj)) { return; } DataCache dc = GetDataCache(obj.Type.ToString()); dc.Remove(GetKey(obj), obj.Region); } catch (DataCacheException ex) { Logger.LogException(obj.Method, ex); } }
public void Update(DataCacheObject obj) { try { if (!Contains(obj)) { return; } DataCache dc = GetDataCache(obj.Type.ToString()); DataCacheItem dci = dc.GetCacheItem(GetKey(obj), obj.Region); dc.Put(GetKey(obj), obj.Data, dci.Timeout, obj.Region); } catch (Exception ex) { Logger.LogException(obj.Method, ex); } }
public void Update(DataCacheObject obj) { DataCacheItem dci = new DataCacheItem(); try { DataCache dc = GetDataCache(obj.Type.ToString()); if (!Contains(obj)) { return; } dci = dc.GetCacheItem(GetKey(obj), obj.Region); dc.Put(GetKey(obj), obj.Data, dci.Version, dci.Timeout, obj.Region); } catch (DataCacheException ex) { Logger.LogException(obj.Method + " ~ " + String.Format("cached_value:{0}; new_value:{1}", dci.Value, obj.Data), ex); } }
//RemoveUserFromCache public void RemoveUserFromCache(long user_id, string email) { User usr = GetUser(user_id, true); RemoveUserObjectCache(user_id); DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.USERS, "GETREGISTERINFO", new object[] { user_id }); CacheRepository.Remove(dco); if (usr != null) { dco.Method = "GETADDRESSCARD"; dco.Params = new object[] {usr.Billing_AddressCard_ID}; CacheRepository.Remove(dco); } if (usr != null && usr.Shipping_AddressCard_ID.HasValue) { dco.Method = "GETADDRESSCARD"; dco.Params = new object[] { usr.Shipping_AddressCard_ID.GetValueOrDefault(0) }; CacheRepository.Remove(dco); } dco.Method = "GETUSERBYEMAIL"; dco.Params = new object[] {email}; CacheRepository.Remove(dco); }
//GetUserReferences public UserReference GetUserReferences(long userreference_id) { DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.USERS, "GETUSERREFERENCES", new object[] { userreference_id }, CachingExpirationTime.Minutes_30); UserReference result = CacheRepository.Get(dco) as UserReference; if (result != null) return result; result = dataContext.UserReferences.Where(ur => ur.IDReference == userreference_id).SingleOrDefault(); if (result != null) { dco.Data = result; CacheRepository.Add(dco); } return result; }
//GetRegisterInfo public RegisterInfo GetRegisterInfo(long user_id) { DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.USERS, "GETREGISTERINFO", new object[] { user_id }, CachingExpirationTime.Minutes_30); RegisterInfo info = CacheRepository.Get(dco) as RegisterInfo; if (info != null) return info; info = new RegisterInfo(); IUser user = GetUser(user_id, true); if (user == null) return null; info.ID = user.ID; info.Login = user.Login; info.Email = user.Email; info.ConfirmEmail = user.Email; info.Password = user.Password; info.ConfirmPassword = user.Password; info.RecieveNewsUpdates = user.RecieveNewsUpdates.GetValueOrDefault(false); info.RecieveWeeklySpecials = user.RecieveWeeklySpecials.GetValueOrDefault(false); info.Fax = user.Fax; info.BillingLikeShipping = user.BillingLikeShipping; info.MobilePhone = user.MobilePhone; info.TaxpayerID = user.TaxpayerID; info.EbayID = user.EbayID; info.DayPhone = user.DayPhone; info.EveningPhone = user.EveningPhone; info.EbayFeedback = user.EbayFeedback; info.IsModifyed = user.IsModifyed; IAddressCard BillingCard = user.Billing_AddressCard_ID != null ? GetAddressCard(user.Billing_AddressCard_ID.GetValueOrDefault(-1), true) : new AddressCard(); info.BillingFirstName = BillingCard.FirstName; info.BillingLastName = BillingCard.LastName; info.BillingMIName = BillingCard.MiddleName; info.BillingAddress1 = BillingCard.Address1; info.BillingAddress2 = BillingCard.Address2; info.BillingCity = BillingCard.City; info.BillingZip = BillingCard.Zip; info.BillingState = BillingCard.State; info.BillingPhone = BillingCard.HomePhone; info.BillingCountry = BillingCard.Country_ID; info.BillingCompany = BillingCard.Company; info.BillingInternationalState = BillingCard.InternationalState; IAddressCard ShippingCard = user.Shipping_AddressCard_ID != null ? GetAddressCard(user.Shipping_AddressCard_ID.GetValueOrDefault(-1), true) : new AddressCard(); info.ShippingFirstName = ShippingCard.FirstName; info.ShippingLastName = ShippingCard.LastName; info.ShippingMIName = ShippingCard.MiddleName; info.ShippingAddress1 = ShippingCard.Address1; info.ShippingAddress2 = ShippingCard.Address2; info.ShippingCity = ShippingCard.City; info.ShippingZip = ShippingCard.Zip; info.ShippingState = ShippingCard.State; info.ShippingWorkPhone = ShippingCard.WorkPhone; info.ShippingPhone = ShippingCard.HomePhone; info.ShippingCountry = ShippingCard.Country_ID; info.ShippingInternationalState = ShippingCard.InternationalState; IUserReference Reference1 = user.IDUserReference1.HasValue ? GetUserReferences(user.IDUserReference1.GetValueOrDefault(-1)) : new UserReference(); info.Reference1AuctionHouse = Reference1.AuctionHouse; info.Reference1LastBidPlaced = Reference1.LastBidPlaced; info.Reference1PhoneNumber = Reference1.PhoneNumber; IUserReference Reference2 = user.IDUserReference2.HasValue ? GetUserReferences(user.IDUserReference2.GetValueOrDefault(-1)) : new UserReference(); info.Reference2AuctionHouse = Reference2.AuctionHouse; info.Reference2LastBidPlaced = Reference2.LastBidPlaced; info.Reference2PhoneNumber = Reference2.PhoneNumber; dco.Data = info; CacheRepository.Add(dco); return info; }
//GetAddressCard public AddressCard GetAddressCard(long addresscard_id, bool iscache) { DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.USERS, "GETADDRESSCARD", new object[] { addresscard_id }, CachingExpirationTime.Minutes_30); AddressCard result = CacheRepository.Get(dco) as AddressCard; if (result != null && iscache) return result; result = dataContext.spSelect_AddressCard(addresscard_id).SingleOrDefault(); if (result != null) { dco.Data = result; CacheRepository.Add(dco); } return result; }
//GetUser public User GetUser(long user_id, bool iscache) { DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.USERS, "GETUSER", new object[] { user_id }, CachingExpirationTime.Minutes_10); User result = CacheRepository.Get(dco) as User; if (result != null && iscache) return result; result = dataContext.spSelect_User(user_id, null, null, null, null, null).SingleOrDefault(); if (result != null) { dco.Data = result; CacheRepository.Add(dco); } return result; }
private void UpdateWithoutCheck(DataCacheObject obj) { lock (Cache) Cache[GetKey(obj)] = obj.Data; }
public bool Contains(DataCacheObject obj) { return(Get(obj) != null); }
private BidWatchCurrent GetBidWatch(long user_id, long auction_id, bool iscache) { var dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.WATCHLISTS, "GETBIDWATCH", new object[] {user_id, auction_id}, CachingExpirationTime.Days_01); var result = CacheRepository.Get(dco) as BidWatchCurrent; if (result != null && iscache) return result; result = dataContext.spSelect_BidWatchCurrent(auction_id, user_id).FirstOrDefault(); if (result != null) { dco.Data = result; CacheRepository.Add(dco); } return result; }
private AuctionResult GetAuctionResult(long auction_id) { var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONS, "GETAUCTIONRESULT", new object[] {auction_id}, CachingExpirationTime.Minutes_01); var result = CacheRepository.Get(dco) as AuctionResult; if (result != null) return result; result = dataContext.spSelect_AuctionResults(auction_id).FirstOrDefault(); if (result != null) { dco.Data = result; CacheRepository.Add(dco); } return result; }
//RemoveAuctionCash public void RemoveAuctionCache(long auctionID) { var auction = dataContext.Auctions.SingleOrDefault(a => a.ID == auctionID); if (auction == null) return; var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONS, "GETAUCTIONDETAIL", new object[] {auction.ID}); CacheRepository.Remove(dco); dco.Method = "GETAUCTIONDETAILRESULTPAST"; CacheRepository.Remove(dco); dco.Method = "GETAUCTIONDETAILRESULT"; CacheRepository.Remove(dco); dco.Data = new object[] {auction.Event_ID}; dco.Method = "GETAUCTIONUPDATES"; CacheRepository.Remove(dco); dco.Region = DataCacheRegions.IMAGES; dco.Method = "GETAUCTIONIMAGES"; CacheRepository.Remove(dco); CacheRepository.Remove(new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.CATEGORIES, "GETCATEGORIESMENU", new object[] {0})); CacheRepository.Remove(new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.CATEGORIES, "GETCATEGORIESMENU", new object[] {auction.Event_ID})); dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONS, "GETAUCTIONDETAIL", new object[] {auction.ID, auction.Event_ID}); CacheRepository.Remove(dco); }
//Get public object Get(DataCacheObject obj) { DataCache dc = GetDataCache(obj.Type.ToString()); return(dc.Get(GetKey(obj))); }
private string GetKey(DataCacheObject obj) { return(String.Format("{0}{1}", obj.Method, GetKeyByParams(obj.Params))); }
public bool Contains(DataCacheObject obj) { return(Cache.Contains(GetKey(obj))); }
private List<AuctionShort> GetProductsForTag(long eventID, long tagID, bool ispast, int sort, bool ordrby, int pageindex, int pagesize, out int? totalrecords) { var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONLISTS, "GETPRODUCTSFORTAG", new object[] {eventID, tagID, ispast, sort, ordrby, pageindex, pagesize}, CachingExpirationTime.Seconds_30); var result = CacheRepository.Get(dco) as TableViewResult; if (result != null && result.TotalRecords > 0) { totalrecords = result.TotalRecords; return result.Records; } result = new TableViewResult(); totalrecords = 0; dataContext.CommandTimeout = 600000; result.Records = (from p in dataContext.spAuction_View_Tag(eventID, tagID, ispast ? 2 : 1, sort, ordrby, pageindex, pagesize, ref totalrecords) select new AuctionShort { Bids = p.Bids.GetValueOrDefault(0), CurrentBid = p.CurrentBid.GetValueOrDefault(0), Estimate = p.Estimate, IsBold = p.IsBold.GetValueOrDefault(false), IsFeatured = p.IsFeatured.GetValueOrDefault(false), IsUnsoldOrPulledOut = p.IsUnsold.GetValueOrDefault(false) || p.IsPulledOut.GetValueOrDefault(false), LinkParams = new LinkParams { ID = p.Auction_ID.GetValueOrDefault(0), EventTitle = p.EventTitle, MainCategoryTitle = p.MainCategoryTitle, CategoryTitle = p.CategoryTitle }, Lot = p.Lot.HasValue ? p.Lot.Value : (short) 0, Price = p.Price.GetValueOrDefault(0), PriceRealized = p.PriceRealized.GetValueOrDefault(0), PulledOut = p.IsPulledOut.GetValueOrDefault(false), Status = p.AuctionStatus.GetValueOrDefault(0), ThumbnailPath = p.ThumbnailPath, Title = p.Title, UnsoldOrPulledOut = p.IsUnsold.GetValueOrDefault(false) ? "UNSOLD" : "WITHDRAWN" }).ToList(); result.TotalRecords = totalrecords.GetValueOrDefault(0); if (result.TotalRecords > 0) { dco.Data = result; CacheRepository.Add(dco); } return result.Records; }
//Put public void Put(DataCacheObject obj) { DataCache dc = GetDataCache(obj.Type.ToString()); dc.Put(GetKey(obj), obj.Data, TimeSpan.FromSeconds(obj.CacheTime)); }
//GetUserByEmail public User GetUserByEmail(string email, bool iscache) { email = email.ToLower().Trim(); DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.USERS, "GETUSERBYEMAIL", new object[] { email }, CachingExpirationTime.Minutes_30); User result = CacheRepository.Get(dco) as User; if (result != null && iscache) return result; //result = dataContext.Users.Where(U => U.Email == email).SingleOrDefault(); result = dataContext.spSelect_User(null, null, null, null, null, email).SingleOrDefault(); if (result != null) { dco.Data = result; CacheRepository.Add(dco); } return result; }
//GetAuctionDetailResultPast public AuctionShort GetAuctionDetailResultPast(long auction_id) { var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONS, "GETAUCTIONDETAILRESULTPAST", new object[] {auction_id}, CachingExpirationTime.Days_01); var result = CacheRepository.Get(dco) as AuctionShort; if (result != null) return result; result = GetAuctionDetailResult(auction_id, false); if (result != null) { dco.Data = result; CacheRepository.Add(dco); } return result; }
public object Get(DataCacheObject obj) { return(Cache.Get(GetKey(obj))); }
//GetAuctionResult //UpdateAuctionBiddingResult public void UpdateAuctionBiddingResult(long auction_id, long user_id, decimal currentbid, decimal maxbid) { try { var ar = GetAuctionResult(auction_id); if (ar == null) { ar = new AuctionResult(); dataContext.AuctionResults.InsertOnSubmit(ar); ar.Auction_ID = auction_id; ar.User_ID = user_id; ar.CurrentBid = 0; ar.MaxBid = 0; ar.Bids = 0; SubmitChanges(); CacheRepository.Put(new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONS, "GETAUCTIONRESULT", new object[] {auction_id}, CachingExpirationTime.Minutes_01, ar)); } ar.Auction_ID = auction_id; ar.User_ID = user_id; ar.CurrentBid = currentbid; ar.MaxBid = maxbid; ar.Bids = dataContext.spBid_LogCount(auction_id).FirstOrDefault().LogCount.GetValueOrDefault(0); dataContext.spUpdate_AuctionResults(ar.ID, ar.Auction_ID, ar.User_ID, ar.CurrentBid, ar.Bids, ar.MaxBid); var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONS, "GETAUCTIONRESULT", new object[] {auction_id}, CachingExpirationTime.Minutes_01, ar); CacheRepository.Put(dco); dco.Method = "GETAUCTIONDETAILRESULT"; var result = CacheRepository.Get(dco) as AuctionShort; if (result != null) { result.Bids = ar.Bids; result.CurrentBid = ar.CurrentBid; dco.Data = result; CacheRepository.Put(dco); } } catch (Exception ex) { Logger.LogException( String.Format("[auction_id={0}; user={1}; cb={2}; maxbid={3}", auction_id, user_id, currentbid, maxbid), ex); } }
//GetKey private string GetKey(DataCacheObject obj) { return(String.Format("{0}_{1}_{2}{3}", obj.Type, obj.Region, obj.Method, GetKeyByParams(obj.Params))); }