//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); }
//GetEventCategoryByMainCategory public EventCategory GetEventCategoryByMainCategory(long maincategory_id, long event_id) { DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.CATEGORIES, "GETEVENTCATEGORYBYMAINCATEGORY", new object[] { maincategory_id, event_id }, CachingExpirationTime.Hours_01); EventCategory ec = CacheRepository.Get(dco) as EventCategory; if (ec != null) { return(ec); } ec = dataContext.spEventCategory_ByMainCategory(event_id, maincategory_id).FirstOrDefault(); if (ec != null) { dco.Data = ec; CacheRepository.Add(dco); } return(ec); }
//AddCategoryChildToEventCategory private void AddCategoryChildToEventCategory(Event evnt, CategoriesMap cm) { EventCategory evnt_cat = dataContext.EventCategories.SingleOrDefault(EC => EC.Event_ID == evnt.ID && EC.MainCategory_ID == cm.MainCategory_ID && EC.Category_ID == cm.Category_ID); if (evnt_cat == null) { evnt_cat = new EventCategory(); dataContext.EventCategories.InsertOnSubmit(evnt_cat); } evnt_cat.Category_ID = cm.Category_ID; evnt_cat.MainCategory_ID = cm.MainCategory_ID; evnt_cat.IsActive = true; evnt_cat.LastUpdate = DateTime.Now; evnt_cat.Owner_ID = AppHelper.CurrentUser.ID; evnt_cat.Event_ID = evnt.ID; evnt_cat.Descr = cm.FullCategory; //evnt_cat.FullCategory; evnt_cat.Priority = cm.Priority; evnt.EventCategories.Add(evnt_cat); }
//GetFullEventCategoryLink public string GetFullEventCategoryLink(long eventcategory_id) { DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "FULLCATEGORYLINK_EC", new object[] { eventcategory_id }, CachingExpirationTime.Days_01); string result = CacheRepository.Get(dco) as string; if (!String.IsNullOrEmpty(result)) { return(result); } EventCategory ec = dataContext.spSelect_EventCategory(eventcategory_id).FirstOrDefault(); if (ec == null) { return("---"); } result = ec.FullCategoryLink; if (!string.IsNullOrEmpty(result)) { dco.Data = result; CacheRepository.Add(dco); } return(result); }
//MergingCategoriesMap public JsonExecuteResult MergingCategoriesMap(long cm_from, long cm_to) { if (cm_from == cm_to) return new JsonExecuteResult(JsonExecuteResultTypes.ERROR, "Please select different source and destination categories."); try { using (TransactionScope ts = new TransactionScope()) { CategoriesMap From = dataContext.CategoriesMaps.SingleOrDefault(CM => CM.ID == cm_from); CategoriesMap To = dataContext.CategoriesMaps.SingleOrDefault(CM => CM.ID == cm_to); if (From == null || To == null) return new JsonExecuteResult(JsonExecuteResultTypes.ERROR, String.Format("The {0} category doesn't exists", (From == null) ? "source" : "destination")); List<CategoriesMap> catmaps = new List<CategoriesMap>(); List<Event> events = (from A in dataContext.Auctions where A.EventCategory.CategoriesMap.ID == cm_from select A.Event).Distinct<Event>().ToList(); if (events.Count() == 0) return new JsonExecuteResult(JsonExecuteResultTypes.ERROR, "The are no auctions in the source category for moving to a destination category"); EventCategory ec; List<Auction> auctions; foreach (Event evnt in events) { ec = evnt.EventCategories.SingleOrDefault(EC => EC.MainCategory_ID == To.MainCategory_ID && EC.Category_ID == To.Category_ID); if (ec == null) { ec = new EventCategory(); ec.Category_ID = To.Category_ID; ec.MainCategory_ID = To.MainCategory_ID; ec.IsActive = true; ec.LastUpdate = DateTime.Now; ec.Owner_ID = AppHelper.CurrentUser.ID; dataContext.EventCategories.InsertOnSubmit(ec); evnt.EventCategories.Add(ec); } auctions = (from A in dataContext.Auctions where A.EventCategory.Category_ID == From.Category_ID && A.EventCategory.MainCategory_ID == From.MainCategory_ID && A.Event_ID == evnt.ID select A).ToList(); auctions.ForEach(A => A.EventCategory = ec); } GeneralRepository.SubmitChanges(dataContext); ts.Complete(); } } catch (Exception ex) { return new JsonExecuteResult(JsonExecuteResultTypes.ERROR, ex.Message); } return new JsonExecuteResult(JsonExecuteResultTypes.SUCCESS); }
//AddCategoryChildToEventCategory private void AddCategoryChildToEventCategory(Event evnt, CategoriesMap cm) { EventCategory evnt_cat = dataContext.EventCategories.SingleOrDefault(EC => EC.Event_ID == evnt.ID && EC.MainCategory_ID == cm.MainCategory_ID && EC.Category_ID == cm.Category_ID); if (evnt_cat == null) { evnt_cat = new EventCategory(); dataContext.EventCategories.InsertOnSubmit(evnt_cat); } evnt_cat.Category_ID = cm.Category_ID; evnt_cat.MainCategory_ID = cm.MainCategory_ID; evnt_cat.IsActive = true; evnt_cat.LastUpdate = DateTime.Now; evnt_cat.Owner_ID = AppHelper.CurrentUser.ID; evnt_cat.Event_ID = evnt.ID; evnt_cat.Descr = cm.FullCategory; //evnt_cat.FullCategory; evnt_cat.Priority = cm.Priority; evnt.EventCategories.Add(evnt_cat); }
//UpdateDOW public bool UpdateDOW(DOWForm info) { Auction old = (info.OldAuction_ID.HasValue) ? GetAuction(info.OldAuction_ID.Value) : null; bool IsCopy = (info.OldAuction_ID.HasValue && old != null); Event evnt = dataContext.Events.Where(E => E.ID == 0).FirstOrDefault(); bool IsNew = false; try { Auction auction = GetAuction(info.ID); if (IsNew = (auction == null)) { auction = new Auction(); dataContext.Auctions.InsertOnSubmit(auction); auction.NotifiedOn = DateTime.Now; } auction.AuctionType_ID = (byte)Consts.AuctionType.DealOfTheWeek; auction.Event_ID = 0; auction.Owner_ID = info.Owner_ID.HasValue ? info.Owner_ID.Value : AppHelper.CurrentUser.ID; auction.CommissionRate_ID = info.CommissionRate_ID; auction.OldAuction_ID = (!IsCopy) ? info.OldAuction_ID : old.ID; auction.Price = info.Price.Value; auction.Reserve = info.Price; auction.Status = info.Status_ID; auction.Title = info.Title; auction.Shipping = info.Shipping; auction.Description = info.Description; auction.Addendum = info.Addendum; info.MainCategory_ID = IsCopy ? old.EventCategory.MainCategory_ID : 0; EventCategory ec = dataContext.EventCategories.Where(EC => EC.Event_ID == 0 && EC.MainCategory_ID == info.MainCategory_ID && EC.Category_ID == info.Category_ID).FirstOrDefault(); if (ec == null) { ec = new EventCategory(); ec.Event_ID = 0; ec.MainCategory_ID = info.MainCategory_ID; ec.IsActive = false; ec.Owner_ID = AppHelper.CurrentUser.ID; ec.Category_ID = info.Category_ID; ec.Priority = 1; ec.LastUpdate = DateTime.Now; dataContext.EventCategories.InsertOnSubmit(ec); } auction.EventCategory = ec; auction.Cost = 0; auction.StartDate = evnt.DateStart; auction.EndDate = evnt.DateEnd; auction.Quantity = 1; auction.Estimate = String.Empty; auction.ListedStep = 0; auction.Priority = 1; auction.LOA = false; auction.PulledOut = false; auction.IsUnsold = false; auction.IsCatalog = false; auction.IsPrinted = false; auction.CopyNotes = String.Empty; auction.PhotoNotes = String.Empty; auction.LastUpdate = DateTime.Now; auction.IsBold = false; auction.IsFeatured = false; auction.IsPhotographed = false; auction.IsInLayout = false; auction.IsLimitDisabled = false; if (IsCopy && IsNew) { List<Image> imgs = dataContext.Images.Where(I => I.Auction_ID == auction.ID).ToList(); if (imgs != null && imgs.Count() > 0) dataContext.Images.DeleteAllOnSubmit(imgs); } GeneralRepository.SubmitChanges(dataContext); if (IsCopy && old.Images.Count() > 0 && IsNew) { Image i1; foreach (Image i2 in old.Images) { i1 = (!IsNew) ? auction.Images.FirstOrDefault(I => I.PicturePath == i2.PicturePath) : null; if (i1 != null) continue; i1 = i1 ?? new Image(); i1.Auction_ID = auction.ID; i1.Default = i2.Default; i1.PicturePath = i2.PicturePath; i1.ThumbNailPath = i2.ThumbNailPath; i1.LargePath = i2.LargePath; i1.Order = i2.Order; i1.UploadedFileName = i2.UploadedFileName; i1.isChecked = i2.isChecked; dataContext.Images.InsertOnSubmit(i1); auction.Images.Add(i1); } GeneralRepository.SubmitChanges(dataContext); } if (IsCopy && !DiffMethods.CopyImages(old.ID, auction.ID)) Logger.LogException(new Exception("Images don't exist for auction " + old.ID.ToString())); if (IsNew) { if (IsCopy && old.Event_ID > 0) AddConsignment(auction.Owner_ID, old.Event_ID); else AddConsignment(auction.Owner_ID, auction.Event_ID); MoveImagesToAction(auction.ID); } } catch (ChangeConflictException cce) { Logger.LogException(cce); throw cce; } catch (Exception ex) { Logger.LogException(ex); throw ex; } return true; }