//GetAllowedCategoriesForTheEvent
public List <EventCategoryDetail> GetAllowedCategoriesForTheEvent(long event_id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "GETALLOWEDCATEGORIESFORTHEEVENT", new object[] { event_id }, CachingExpirationTime.Days_01);
List <EventCategoryDetail> result = CacheRepository.Get(dco) as List <EventCategoryDetail>;
if (result != null && result.Any())
{
return(result);
}
result = (from p in dataContext.spEventCategory_ListForEvent(event_id)
select new EventCategoryDetail
{
EventCategory_ID = p.EventCategory_ID,
Category_ID = p.Category_ID,
CategoryDescription = p.CategoryDescription,
CategoryTitle = p.CategoryTitle,
CategoryMap_ID = p.CategoryMap_ID,
IsActive = p.IsActive,
Event_ID = p.Event_ID,
IsTaxable = p.IsTaxable
}).ToList();
if (result.Any())
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetBidWatchForUser
public List <UserBidWatch> GetBidWatchForUser(long user_id, long event_id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.WATCHLISTS, "GETBIDWATCHFORUSER", new object[] { user_id, event_id }, CachingExpirationTime.Seconds_15);
List <UserBidWatch> result = CacheRepository.Get(dco) as List <UserBidWatch>;
if (result != null && result.Any())
{
return(result);
}
dataContext.CommandTimeout = 600000;
result = (from p in dataContext.spBid_View_BidWatch(user_id, event_id)
select new UserBidWatch
{
AuctionStatus = p.AuctionStatus.GetValueOrDefault(1),
Amount = p.Amount.GetValueOrDefault(0),
CurrentBid = p.CurrentBid.GetValueOrDefault(0),
HighBidder = p.HighBidder,
Quantity = p.Quantity,
Bids = p.Bids.GetValueOrDefault(0),
MaxBid = p.MaxBid.GetValueOrDefault(0),
Option = p.IsWatch.GetValueOrDefault(0),
LinkParams = new LinkParams {
ID = p.Auction_ID, Lot = p.Lot.GetValueOrDefault(0), Title = p.Title, EventTitle = p.EventTitle, CategoryTitle = p.CategoryTitle, MainCategoryTitle = p.MainCategoryTitle
}
}).ToList();
if (result.Any())
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetEventCategoryDetail
public EventCategoryDetail GetEventCategoryDetail(long eventcategory_id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "GETEVENTCATEGORYDETAIL", new object[] { eventcategory_id }, CachingExpirationTime.Days_01);
EventCategoryDetail result = CacheRepository.Get(dco) as EventCategoryDetail;
if (result != null)
{
return(result);
}
result = (from p in dataContext.spEventCategory_Detail(eventcategory_id)
select new EventCategoryDetail
{
EventCategory_ID = p.EventCategory_ID,
Category_ID = p.Category_ID,
CategoryDescription = p.CategoryDescription,
CategoryTitle = p.CategoryTitle,
CategoryMap_ID = p.CategoryMap_ID,
IsActive = p.IsActive,
Event_ID = p.Event_ID,
IsTaxable = p.IsTaxable
}).FirstOrDefault();
if (result != null)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetUpcomingList
public List <Event> GetUpcomingList(bool?IsAdmin)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "GETUPCOMINGLIST", new object[] { IsAdmin }, CachingExpirationTime.Hours_01);
List <Event> result = CacheRepository.Get(dco) as List <Event>;
if (result != null && result.Count() > 0)
{
return(result);
}
result = (IsAdmin.HasValue && IsAdmin.Value ?
(from E in dataContext.Events
where E.ID != 0
orderby E.Ordinary ascending, E.DateEnd descending
select E) :
(from E in dataContext.Events
where E.IsViewable && E.DateEnd > DateTime.Now.AddDays(-45) && E.ID != 0
orderby E.Ordinary ascending, E.DateEnd descending
select E)).ToList();
if (result.Count() > 0)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetCategoriesMenu
public string GetCategoriesMenu(long?event_id, bool onlyLeafs)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.CATEGORIES,
"GETCATEGORIESMENU",
new object[] { event_id.GetValueOrDefault(0) },
CachingExpirationTime.Hours_01);
string res = CacheRepository.Get(dco) as string;
if (!String.IsNullOrEmpty(res))
{
return(res);
}
StringBuilder sb = new StringBuilder();
FileInfo fi =
new FileInfo(System.Web.HttpContext.Current.Server.MapPath(@"~\Templates\Different\CategoriesMenu.txt"));
if (!fi.Exists)
{
res = GetCategoriesMenuByEvent(event_id, onlyLeafs);
}
else
{
TextReader fileReader =
new StreamReader(System.Web.HttpContext.Current.Server.MapPath(@"~\Templates\Different\CategoriesMenu.txt"));
sb.Append(fileReader.ReadToEnd());
fileReader.Close();
res = (sb.Length > 0) ? sb.ToString() : GetCategoriesMenuByEvent(event_id, onlyLeafs);
}
if (!String.IsNullOrEmpty(res))
{
dco.Data = res;
CacheRepository.Add(dco);
}
return(res);
}
//RemoveEventCash
public void RemoveEventCache(long event_id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "GETCURRENT");
CacheRepository.Remove(dco);
dco.Method = "GETEVENTBYID";
dco.Params = new object[] { event_id };
CacheRepository.Remove(dco);
dco.Method = "GETEVENTDETAIL";
CacheRepository.Remove(dco);
dco.Method = "GETUPCOMINGLIST";
dco.Params = new object[] { true };
CacheRepository.Remove(dco);
dco.Method = "GETUPCOMINGLIST";
dco.Params = new object[] { false };
CacheRepository.Remove(dco);
dco.Method = "GETFUTUREEVENTS";
dco.Params = new object[] { };
CacheRepository.Remove(dco);
dco.Method = "GETEVENTCATEGORYBYID";
dco.Params = new object[] { event_id };
CacheRepository.Remove(dco);
dco.Method = "GETALLOWEDCATEGORIESFORTHEEVENT";
CacheRepository.Remove(dco);
dco.Region = DataCacheRegions.CATEGORIES;
dco.Method = "GETCATEGORIESMAPTREEPREVIEW";
CacheRepository.Remove(dco);
dco.Method = "GETCATEGORIESMAPTREE";
dco.Params = new object[] { event_id, false };
CacheRepository.Remove(dco);
dco.Params = new object[] { event_id, true };
CacheRepository.Remove(dco);
}
//GetConsignmentTotals
public UICInvoice GetConsignmentTotals(long consignment_id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.INVOICES, "GETCONSIGNMENTTOTALS",
new object[] { consignment_id }, CachingExpirationTime.Hours_01);
UICInvoice result = CacheRepository.Get(dco) as UICInvoice;
if (result != null)
{
return(result);
}
int?totalamount = 0;
result =
(from p in
dataContext.spInvoice_View_ConsignorStatements(consignment_id, null, null, null, 0, 1, ref totalamount)
select new UICInvoice
{
AmountDue = p.ADue.GetValueOrDefault(0),
AmountPaid = p.APaid.GetValueOrDefault(0),
TotalCost = p.TotalCost.GetValueOrDefault(0)
}).FirstOrDefault();
if (result != null)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetEventDetals
public EventDetail GetEventDetail(long?event_id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "GETEVENTDETAIL", new object[] { event_id }, CachingExpirationTime.Hours_01);
EventDetail result = CacheRepository.Get(dco) as EventDetail;
if (result != null)
{
return(result);
}
result = (from p in dataContext.spEvent_Detail(event_id)
select new EventDetail
{
BuyerFee = p.BuyerFee,
DateEnd = p.DateEnd,
DateStart = p.DateStart,
Description = p.Description,
ID = p.Event_ID,
IsClickable = p.IsClickable,
IsCurrent = p.IsCurrent,
IsPrivate = p.IsPrivate.GetValueOrDefault(false),
IsViewable = p.IsViewable,
RegisterRequired = p.RegisterRequired,
Ordinary = p.Ordinary,
Title = p.Title
}).FirstOrDefault();
if (result != null)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetProductsForTag
//GetProductsForTag
public List <AuctionSales> GetProductsForSales(long eventID)
{
var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONLISTS, "GETPRODUCTSFORSALES",
new object[] { eventID }, CachingExpirationTime.Seconds_30);
var result = CacheRepository.Get(dco) as List <AuctionSales>;
if (result != null && result.Any())
{
return(result);
}
dataContext.CommandTimeout = 600000;
result = (from p in dataContext.spAuction_View_Sales(eventID)
select new AuctionSales
{
LinkParams =
new LinkParams
{
ID = p.Auction_ID,
EventTitle = p.EventTitle,
MainCategoryTitle = p.MainCategoryTitle,
CategoryTitle = p.CategoryTitle
},
Lot = p.Lot.HasValue ? p.Lot.Value : (short)0,
Price = p.Price,
ThumbnailPath = p.ThumbnailPath,
Title = p.Title,
Estimate = p.Estimate
}).ToList();
if (result.Any())
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetStateByCode
public State GetStateByCode(string code)
{
var dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.STATES, "GETSTATEBYCODE",
new object[] { code }, CachingExpirationTime.Days_01);
var result = _cacheRepository.Get(dco) as State;
try
{
if (result != null)
{
return(result);
}
result = _dataContext.spState_List(null).FirstOrDefault(t => t.Code.ToLower() == code.ToLower());
if (result == null)
{
result = _dataContext.States.FirstOrDefault(t => t.ID == 0);
}
if (result != null)
{
dco.Data = result;
_cacheRepository.Add(dco);
}
}
catch (Exception ex)
{
Logger.LogException("[code=" + code + "]", ex);
}
return(result);
}
//GetBidHistory
public List <BiddingHistory> GetBidHistory(long auction_id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.BIDS, "GETBIDHISTORY", new object[] { auction_id }, CachingExpirationTime.Days_01);
List <BiddingHistory> result = CacheRepository.Get(dco) as List <BiddingHistory>;
if (result != null && result.Count() > 0)
{
return(result);
}
dataContext.CommandTimeout = 600000;
result = (from p in dataContext.spBid_BidsHistory(auction_id)
select new BiddingHistory
{
Login = p.Bidder,
Amount = p.Bid.GetValueOrDefault(0),
DateMade = p.DateMade.GetValueOrDefault(DateTime.MinValue),
IsWinner = p.IsWinner.GetValueOrDefault(false)
}).ToList();
if (result.Count() > 0)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetTopBidsForMultipleItem
public List <BidCurrent> GetBidsForMultipleItem(long auction_id, byte iswinner, int quantity, bool fromcache)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.BIDS, "GETBIDSFORMULTIPLEITEM", new object[] { auction_id, iswinner }, CachingExpirationTime.Hours_01);
List <BidCurrent> result = CacheRepository.Get(dco) as List <BidCurrent>;
if (result != null && fromcache)
{
return(result);
}
result = (from p in dataContext.spBid_BidsForMultipleItem(auction_id, iswinner, quantity)
select new BidCurrent
{
Amount = p.Amount,
Auction_ID = p.Auction_ID,
Bidder = p.Bidder,
Comments = p.Comments,
DateMade = p.DateMade,
ID = p.ID,
IP = p.IP,
IsActive = p.IsActive,
IsProxy = p.IsProxy,
ItemNumber = p.ItemNumber,
MaxBid = p.MaxBid,
Quantity = p.Quantity,
User_ID = p.User_ID
}).ToList();
if (result.Any())
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetStateByCode
public State GetStateByCode(string code)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.STATES, "GETSTATEBYCODE", new object[] { code }, CachingExpirationTime.Days_01);
State result = CacheRepository.Get(dco) as State;
try
{
if (result != null)
{
return(result);
}
result = GetStateList(null).FirstOrDefault(S => S.Code.ToLower() == code.ToLower());
if (result == null)
{
result = dataContext.States.Where(S => S.ID == 0).FirstOrDefault();
}
else
{
dco.Data = result;
CacheRepository.Add(dco);
}
}
catch (Exception ex)
{
Vauction.Utils.Lib.Logger.LogException("[code=" + code + "]", ex);
}
return(result);
}
//GetBidWatchForUser
public List <UserBidWatch> GetBidWatchForUser(long userID, long eventID)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.BIDS, "GETBIDWATCHFORUSER", new object[] { userID, eventID }, CachingExpirationTime.Seconds_15);
List <UserBidWatch> result = CacheRepository.Get(dco) as List <UserBidWatch>;
if (result != null && result.Any())
{
return(result);
}
dataContext.CommandTimeout = 600000;
result = (from p in dataContext.spBid_BidWatch(userID, eventID)
select new UserBidWatch
{
Amount = p.Amount.GetValueOrDefault(0),
CurrentBid_1 = p.CurrentBid_1,
CurrentBid_2 = p.CurrentBid_2,
HighBidder_1 = p.HighBidder_1,
HighBidder_2 = p.HighBidder_2,
Quantity = p.WinQuantity.GetValueOrDefault(0) > 0 ? p.WinQuantity.GetValueOrDefault(0) : p.BidQuantity,
MaxBid = p.MaxBid.GetValueOrDefault(0),
Option = (byte)(p.Amount.GetValueOrDefault(-1) == -1 ? 2 : (p.WinQuantity.GetValueOrDefault(0) == 0 ? 0 : 1)),
LinkParams = new LinkParams {
ID = p.Auction_ID.GetValueOrDefault(0), Lot = p.Lot.GetValueOrDefault(0), Title = p.Title
},
Cost = p.Cost.GetValueOrDefault(1)
}).ToList();
if (result.Any())
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetAuctionUpdates
public List <AuctionUpdate> GetAuctionUpdates(long event_id)
{
var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONS, "GETAUCTIONUPDATES",
new object[] { event_id }, CachingExpirationTime.Hours_01);
var result = CacheRepository.Get(dco) as List <AuctionUpdate>;
if (result != null && result.Count() > 0)
{
return(result);
}
result = (from p in dataContext.spAuction_Updates(event_id)
select new AuctionUpdate
{
Lot = p.Lot.HasValue ? p.Lot.Value : (short)0,
Title = p.Title,
Addendum = p.Addendum,
IsPulledOut = p.IsPulledOut,
LinkParams =
new LinkParams
{
ID = p.Auction_ID,
EventTitle = p.EventTitle,
MainCategoryTitle = p.MainCategoryTitle,
CategoryTitle = p.CategoryTitle
}
}).ToList();
if (result.Count() > 0)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetAuctionDetailResult
public AuctionShort GetAuctionDetailResult(long auction_id, bool iscaching)
{
var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONS, "GETAUCTIONDETAILRESULT",
new object[] { auction_id }, CachingExpirationTime.Minutes_01);
var result = CacheRepository.Get(dco) as AuctionShort;
if (result != null && iscaching)
{
return(result);
}
dataContext.CommandTimeout = 600000;
result = (from a in dataContext.spAuction_View_DetailResult(auction_id)
select new AuctionShort
{
Bids = a.Bids,
CurrentBid = a.CurrentBid,
Estimate = a.Estimate,
IsUnsoldOrPulledOut = a.IsUnsold,
Price = a.Price,
PriceRealized = a.PriceRealized,
EndDate = a.EventDateEnd
}).FirstOrDefault();
if (result != null)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetEventCategoryDetailById
public EventCategoryDetail GetEventCategoryDetail(long eventcategory_id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.CATEGORIES, "GETEVENTCATEGORYDETAIL",
new object[] { eventcategory_id }, CachingExpirationTime.Hours_01);
EventCategoryDetail ecd = CacheRepository.Get(dco) as EventCategoryDetail;
if (ecd != null)
{
return(ecd);
}
ecd = (from p in dataContext.spCategory_View_EventCategoriesDetail(eventcategory_id)
select new EventCategoryDetail
{
DateEnd = p.DateEnd,
IsCurrent = p.IsCurrent,
IsClickable = p.IsClickable,
Step = p.CloseStep,
LinkParams = new LinkParams {
EventCategory_ID = p.EventCategory_ID, Event_ID = p.Event_ID, MainCategory_ID = p.MainCategory_ID, Category_ID = p.Category_ID, EventTitle = p.EventTitle, MainCategoryTitle = p.MainCategoryTitle, CategoryTitle = p.CategoryTitle
},
}).SingleOrDefault();
if (ecd != null)
{
dco.Data = ecd;
CacheRepository.Add(dco);
}
return(ecd);
}
//GetConsignmentDetailsByConsignmentID
public List <ConsignmentDetail> GetConsignmentDetailsByConsignmentID(long consignmentID)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.INVOICES, "GETCONSIGNMENTDETAILSBYCONSIGNMENTID",
new object[] { consignmentID }, CachingExpirationTime.Hours_01);
List <ConsignmentDetail> result = CacheRepository.Get(dco) as List <ConsignmentDetail>;
if (result != null && result.Any())
{
return(result);
}
result = (from p in dataContext.spInvoice_View_GetConsignmentByConsignments(consignmentID)
select new ConsignmentDetail
{
Consignment_ID = p.Consignment_ID,
Invoice_ID = p.Invoice_ID.GetValueOrDefault(0),
Reserve = p.Reserve.GetValueOrDefault(0),
Cost = p.Cost,
Amount = p.Amount,
LinkParams = new LinkParams {
EventTitle = p.EventTitle, MainCategoryTitle = p.MainCategoryTitle, CategoryTitle = p.CategoryTitle, Lot = p.Lot.HasValue ? p.Lot.Value : (short)0, Title = p.Title, ID = p.Auction_ID
},
CommissionRate = p.CommRate
}).ToList();
if (result.Any())
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//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);
}
//ClearUserCache
public void ClearUserCache(long user_id)
{
User user = GetUser(user_id, true);
DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.USERS, "GETUSER", new object[] { user.ID }, CachingExpirationTime.Hours_01, user);
CacheRepository.Remove(dco);
dco.Params = new object[] { user.Login.ToLower() }; CacheRepository.Remove(dco);
dco.Method = "GETUSERBYEMAIL";
dco.Params = new object[] { user.Email.ToLower() };
CacheRepository.Remove(dco);
}
//RemoveEventCacheForListing
public void RemoveEventCacheForListing(long event_id)
{
var dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.CATEGORIES, "GETCATEGORIESMAPTREEPREVIEW", new object[] { event_id });
CacheRepository.Remove(dco);
dco.Method = "GETCATEGORIESMAPTREE";
dco.Params = new object[] { event_id, true };
CacheRepository.Remove(dco);
dco.Params = new object[] { event_id, false };
CacheRepository.Remove(dco);
}
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);
}
//UpdateUser
private void UpdateUserCache(User user)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.USERS, "GETUSER", new object[] { user.ID }, CachingExpirationTime.Hours_01, user);
CacheRepository.Put(dco);
dco.Params = new object[] { user.Login.ToLower() };
CacheRepository.Put(dco);
dco.Method = "GETUSERBYEMAIL";
dco.Params = new object[] { user.Email.ToLower() };
CacheRepository.Put(dco);
//CacheRepository.Update(CacheDataKeys.USER_GETUSER, user, new object[] { user.ID });
//CacheRepository.Update(CacheDataKeys.USER_GETUSER, user, new object[] { user.Login.ToLower() });
//CacheRepository.Update(CacheDataKeys.USER_GETUSERBYEMAIL, user, new object[] { });
}
//GetCountryByID
public Country GetCountryByID(long ID)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.COUNTRIES, "GETCOUNTRYBYID", new object[] { ID }, CachingExpirationTime.Days_01);
Country result = CacheRepository.Get(dco) as Country;
if (result != null)
{
return(result);
}
result = GetCountryList().Where(c => c.ID == ID).FirstOrDefault();
if (result != null)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetListPage
public List <Country> GetCountryList()
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.COUNTRIES, "GETCOUNTRYLIST", new object[] { }, CachingExpirationTime.Days_01);
List <Country> result = CacheRepository.Get(dco) as List <Country>;
if (result != null && result.Count() > 0)
{
return(result);
}
result = dataContext.spCountry_List().ToList();
if (result.Count() > 0)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetStateList
public List <State> GetStateList(long?country_id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.STATES, "GETSTATELIST", new object[] { country_id }, CachingExpirationTime.Days_01);
List <State> result = CacheRepository.Get(dco) as List <State>;
if (result != null && result.Count() > 0)
{
return(result);
}
result = dataContext.spState_List(country_id).ToList();
if (result.Count() > 0)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetEventCategoryById
public EventCategory GetEventCategoryById(long id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "GETEVENTCATEGORYBYID", new object[] { id }, CachingExpirationTime.Days_01);
EventCategory result = CacheRepository.Get(dco) as EventCategory;
if (result != null)
{
return(result);
}
result = dataContext.spSelect_EventCategory(id).FirstOrDefault();
if (result != null)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetVariables
private List <Variable> GetVariables()
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.COUNTRIES, "GETVARIABLES", new object[] { }, CachingExpirationTime.Days_01);
List <Variable> result = CacheRepository.Get(dco) as List <Variable>;
if (result != null)
{
return(result);
}
result = dataContext.spSelect_Variable().ToList();
if (result.Count() > 0)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//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);
}
//GetCategoryMapById
public CategoriesMap GetCategoryMapById(long id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.CATEGORIES, "GETCATEGORYMAPBYID", new object[] { id }, CachingExpirationTime.Days_01);
CategoriesMap result = CacheRepository.Get(dco) as CategoriesMap;
if (result != null)
{
return(result);
}
result = dataContext.spSelect_CategoriesMap(id).FirstOrDefault();
if (result != null)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
