//GetByCriterias
public IEnumerable<AuctionShort> GetByCriterias(AuctionFilterParams filter)
{
int? totalrecords = 0;
var pageindex = (filter.page > 0) ? filter.page - 1 : 0;
var ash = (!filter.SeachType.HasValue)
? GetByCriterias(filter.Lot, filter.Title, (int) filter.Sortby,
filter.Orderby == Consts.OrderByValues.descending, filter.Event_ID.Value, pageindex, filter.PageSize,
out totalrecords)
: GetByCriterias(filter, (int) filter.Sortby, filter.Orderby == Consts.OrderByValues.descending,
pageindex, filter.PageSize, out totalrecords);
return new PagedList<AuctionShort>(ash, pageindex, filter.PageSize,
totalrecords.HasValue ? totalrecords.Value : 0);
}
//GetAuctionListForSeller
public IEnumerable<AuctionShort> GetAuctionListForSeller(AuctionFilterParams filter, long user_id)
{
int? totalrecords = 0;
var pageindex = (filter.page > 0) ? filter.page - 1 : 0;
dataContext.CommandTimeout = 600000;
var ash =
(from p in
dataContext.spAuction_View_Search(filter.Event_ID, filter.Type == "l" ? filter.Lot : String.Empty,
filter.Type == "t" || filter.Type == "td" ? filter.Title : String.Empty,
filter.Type == "d" || filter.Type == "td" ? filter.Description : String.Empty,
filter.SelectedCategory, user_id, (int) filter.Sortby - 1, (byte) filter.Orderby == 2, pageindex,
filter.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"
});
return new PagedList<AuctionShort>(ash.ToList(), pageindex, filter.PageSize,
totalrecords.HasValue ? totalrecords.Value : 0);
}
public ActionResult pConsignedItemsPast(long user_id, AuctionFilterParams param, int page, int viewmode, int imageviewmode)
{
ViewData["IsPastGrid"] = true;
return View("pAuctionGrid", pConsignedItems(param, user_id));
}
//GetByCriterias (advanced)
private List<AuctionShort> GetByCriterias(AuctionFilterParams filter, int sortby, bool ordrby, int pageindex,
int pagesize, out int? totalrecord)
{
filter.Title = String.IsNullOrEmpty(filter.Title) ? String.Empty : filter.Title.Replace(" ", "%");
filter.Description = String.IsNullOrEmpty(filter.Description)
? String.Empty
: filter.Description.Replace(" ", "%");
var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONLISTS, "GETBYCRITERIAS",
new object[]
{
filter.Event_ID, filter.Type == "l" ? filter.Lot : String.Empty,
filter.Type == "t" || filter.Type == "td" ? filter.Title : String.Empty,
filter.Type == "d" || filter.Type == "td" ? filter.Description : String.Empty,
filter.SelectedCategory, -1, sortby - 1, ordrby,
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(filter.Event_ID, filter.Type == "l" ? filter.Lot : String.Empty,
filter.Type == "t" || filter.Type == "td" ? filter.Title : String.Empty,
filter.Type == "d" || filter.Type == "td" ? filter.Description : String.Empty,
filter.SelectedCategory, -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;
}
//pConsignedItems
private object pConsignedItems(AuctionFilterParams param, long user_id)
{
SetFilterParams(param);
ViewData["PageActionPath"] = "ConsignedItems";
ViewData["IsUserRegisteredForEvent"] = Consts.IsAllUsersCanSeeBids;
ViewData["IsShownOpenBidOne"] = Consts.IsShownOpenBidOne;
return AuctionRepository.GetAuctionListForSeller(param, user_id);
}
public ActionResult pConsignedItemsSearch(long user_id, AuctionFilterParams param)
{
List<Event> evnts = EventRepository.GetConsingedEvents(AppHelper.CurrentUser.ID);
List<SelectListItem> sl = new List<SelectListItem>();
sl.Add(new SelectListItem() { Selected = !param.Event_ID.HasValue || -1 == param.Event_ID.Value, Value = "-1", Text = "Search All Auctions" });
foreach (Event evnt in evnts)
sl.Add(new SelectListItem() { Selected = param.Event_ID.HasValue && evnt.ID == param.Event_ID.Value, Text = evnt.Title, Value = evnt.ID.ToString() });
ViewData["AllEvents"] = sl;
return View("pConsignedItemsSearch", param);
}
public ActionResult pSearchResultPast(bool iscurrent, AuctionFilterParams param, int page, int viewmode, int imageviewmode)
{
ViewData["IsPastGrid"] = true;
return View("pAuctionGrid", pSearch(param));
}
//pSearch
private object pSearch(AuctionFilterParams param)
{
SetFilterParams(param);
ViewData["PageActionPath"] = "SearchResult";
ViewData["IsUserRegisteredForEvent"] = Consts.IsAllUsersCanSeeBids;
ViewData["IsShownOpenBidOne"] = Consts.IsShownOpenBidOne;
return AuctionRepository.GetByCriterias(param);
}
[ChildActionOnly] //, ActionOutputCache(Consts.CachingTime_01day)
public ActionResult pAdvancedSearch(long eventid, AuctionFilterParams param)
{
List<IEvent> evnts = new List<IEvent>(EventRepository.GetPastedEventsList());
if (evnts.Count > 0 && evnts[0].ID != eventid) evnts.Insert(0, EventRepository.GetEventByID(eventid));
List<SelectListItem> sl = new List<SelectListItem>();
sl.Add(new SelectListItem() { Selected = !param.Event_ID.HasValue || -1 == param.Event_ID.Value, Value = "-1", Text = "Search All Auctions" });
foreach (Event evnt in evnts)
sl.Add(new SelectListItem() { Selected = param.Event_ID.HasValue && evnt.ID == param.Event_ID.Value, Text = evnt.Title, Value = evnt.ID.ToString() });
ViewData["AllEvents"] = sl;
List<SelectListItem> cl = new List<SelectListItem>();
cl.Add(new SelectListItem() { Selected = !param.SelectedCategory.HasValue || -1 == param.SelectedCategory.Value, Value = "-1", Text = "All Categories" });
foreach (IdTitle item in CategoryRepository.GetListForCategory(eventid))
cl.Add(new SelectListItem() { Selected = param.SelectedCategory.HasValue && param.SelectedCategory.Value==item.ID, Text = item.Title, Value = item.ID.ToString() });
ViewData["CategoriesList"] = cl;
return View("pAdvancedSearch", param);
}
