Exemple #1
0
        /// <summary>
        /// returns all the children for the specified news type.
        /// </summary>
        /// <param name="parent"></param>
        /// <returns></returns>
        public IQueryable <NewsType> GetTypes(string parent)
        {
            int parentId = -1;

            NewsType _parent = GetType(parent);

            if (_parent != null)
            {
                parentId = _parent.TypeId;
            }

            return(from newsType in GetTypes()
                   where
                   newsType.ParentId == parentId
                   orderby newsType.Ranking descending
                   select newsType);
        }
Exemple #2
0
 partial void DeleteNewsType(NewsType instance);
Exemple #3
0
 partial void UpdateNewsType(NewsType instance);
Exemple #4
0
 partial void InsertNewsType(NewsType instance);
Exemple #5
0
        public int AddNewsType(string Name, Status Status, HttpPostedFile Image, string Description, int?ParentId,
                               short?ThumbWidth, short?ThumbHeight, short?MediumWidth, short?MediumHeight, short?LargeWidth, short?LargeHeight, int?TemplateId,
                               int?Permission)
        {
            if (GetType(Name) != null)
            {
                return(-1);
            }

            NewsType type = new NewsType
            {
                Name         = Name,
                UniqueName   = StringUtils.ToURL(Name),
                Status       = (byte)Status,
                Description  = Description,
                ParentId     = ParentId,
                ThumbWidth   = ThumbWidth,
                ThumbHeight  = ThumbHeight,
                MediumWidth  = MediumWidth,
                MediumHeight = MediumHeight,
                LargeWidth   = LargeWidth,
                LargeHeight  = LargeHeight,
                DateCreated  = DateTime.Now,
                LastModified = DateTime.Now,
                TemplateId   = TemplateId,
                Ranking      = 0,
                UserRating   = 0,
                Views        = 0,
                Permission   = Permission
            };

            NewsTypesData.NewsTypes.InsertOnSubmit(type);
            NewsTypesData.SubmitChanges();

            if (Image != null && Image.ContentLength > 0)
            {
                string ImageName = Path.GetFileNameWithoutExtension(Image.FileName);
                ImageName = string.Format("{0}_{1}{2}", ImageName, type.TypeId,
                                          Path.GetExtension(Image.FileName));

                string path = WebContext.Server.MapPath(Path.Combine(WebContext.StartDir, Folders.NewsTypesFolder));

                if (!Directory.Exists(path))
                {
                    Directory.CreateDirectory(path);
                }

                path = Path.Combine(path, ImageName);

                Image.SaveAs(path);

                if (ThumbWidth > 0 && ThumbHeight > 0)
                {
                    ImageUtils.CropImage(path, path, (int)ThumbWidth, (int)ThumbHeight, ImageUtils.AnchorPosition.Default);
                }

                type.Image = ImageName;

                NewsTypesData.SubmitChanges();
            }
            return(type.TypeId);
        }
Exemple #6
0
        /// <summary>
        /// change the ranking for the current record and updates the other ones accordingly.
        /// </summary>
        /// <param name="id"></param>
        /// <param name="d"></param>
        /// <param name="ss"></param>
        /// <param name="pid"></param>
        /// <returns></returns>
        public void UpdateRanking(int id, int d, int ss, int?pid)
        {
            if ((d != 1) && (d != -1))
            {
                throw new Exception("Direction value incorrect");
            }
            IQueryable <New>      allNews  = null;
            IQueryable <NewsType> allTypes = null;

            if (pid.HasValue && pid.Value > 0)
            {
                NewsManager nMgr           = new NewsManager();
                New         selectedRecord = nMgr.NewsData.News.SingleOrDefault(x => x.NewsId == id);
                if (selectedRecord == null)
                {
                    throw new Exception("Record not found");
                }
                allNews = from newsTypeView in nMgr.NewsData.News
                          where
                          newsTypeView.NewsType == pid
                          select newsTypeView;
                // increasing priority
                if (d == -1)
                {
                    //select all where priority > currentPriority and limiting results to maximum the stepsize
                    var recordsToUpdate = (from s in allNews
                                           where s.Ranking > selectedRecord.Ranking
                                           orderby s.Ranking
                                           select s).Take(ss);
                    if (recordsToUpdate.Count() > 0)
                    {
                        int maxPriority = Convert.ToInt32(recordsToUpdate.Max(x => x.Ranking));
                        foreach (var s in recordsToUpdate)
                        {
                            s.Ranking--;
                        }
                        selectedRecord.Ranking = maxPriority;
                        nMgr.Save();
                    }
                }
                // lowering priority
                if (d == 1)
                {
                    if (selectedRecord == null)
                    {
                        throw new Exception("Record not found");
                    }
                    //select all where priority < currentPriority and limiting results to maximum the stepsize
                    var recordsToUpdate = (from s in allNews
                                           where s.Ranking < selectedRecord.Ranking
                                           orderby s.Ranking descending
                                           select s).Take(ss);
                    if (recordsToUpdate.Count() > 0)
                    {
                        int minimumPriority = Convert.ToInt32(recordsToUpdate.Min(x => x.Ranking));
                        foreach (var s in recordsToUpdate)
                        {
                            s.Ranking++;
                        }
                        selectedRecord.Ranking = minimumPriority;
                        nMgr.Save();
                    }
                }
            }
            else
            {
                NewsType selectedRecord = GetType(id);
                allTypes = from newsType in GetTypes()
                           where
                           newsType.ParentId == 12
                           select newsType;
                if (selectedRecord == null)
                {
                    throw new Exception("Record not found");
                }
                // increasing priority
                if (d == -1)
                {
                    //select all where priority > currentPriority and limiting results to maximum the stepsize
                    var recordsToUpdate = (from s in allTypes
                                           where s.Ranking > selectedRecord.Ranking
                                           orderby s.Ranking
                                           select s).Take(ss);
                    if (recordsToUpdate.Count() > 0)
                    {
                        int maxPriority = Convert.ToInt32(recordsToUpdate.Max(x => x.Ranking));
                        foreach (var s in recordsToUpdate)
                        {
                            s.Ranking--;
                        }
                        selectedRecord.Ranking = maxPriority;
                        this.Save();
                    }
                }
                // lowering priority
                if (d == 1)
                {
                    //select all where priority < currentPriority and limiting results to maximum the stepsize
                    var recordsToUpdate = (from s in allTypes
                                           where s.Ranking < selectedRecord.Ranking
                                           orderby s.Ranking descending
                                           select s).Take(ss);
                    if (recordsToUpdate.Count() > 0)
                    {
                        int minimumPriority = Convert.ToInt32(recordsToUpdate.Min(x => x.Ranking));
                        foreach (var s in recordsToUpdate)
                        {
                            s.Ranking++;
                        }
                        selectedRecord.Ranking = minimumPriority;
                        this.Save();
                    }
                }
            }
        }