public ActionResult GetPieces(int page)
        {
            if (Session["AdminUser"] == null)
            {
                return(RedirectToAction("Login", "User"));
            }
            var result        = db.GetPiecsList(page);
            var lastPage      = db.LastPageNumber();
            var brandList     = new BLL_Brand().GetAllBrand();
            var deviceList    = new BLL_Device().GetAllDevice();
            var pieceTypeList = new BLL_PieceType().GetAllPieceType();
            var finalPieces   = new List <FinalPiece>();

            foreach (var piece in result)
            {
                FinalPiece p = new FinalPiece();
                p.ID            = piece.ID;
                p.BrandId       = piece.BrandId;
                p.BrandName     = brandList.FirstOrDefault(b => b.ID == piece.BrandId)?.EnglishName;
                p.DeviceId      = piece.DeviceId;
                p.DeviceName    = deviceList.FirstOrDefault(d => d.ID == piece.DeviceId)?.EnglishName;
                p.PieceTypeId   = piece.PieceTypeId;
                p.PieceTypeName = pieceTypeList.FirstOrDefault(d => d.ID == piece.PieceTypeId)?.PersianName;
                p.Price         = piece.Price;
                p.FileName      = piece.FileName;
                //p.Date = piece.Date.ToString("yyyy/MM/dd");
                p.Date     = PublicFunction.ConvertMiladiToShamsi(piece.CreateDate);
                p.IsSlider = piece.IsSlider;
                finalPieces.Add(p);
            }
            object finalResult = new Tuple <List <FinalPiece>, int, int, List <Brand>, List <Device>, List <Piecetype> >(finalPieces, page, lastPage, brandList, deviceList, pieceTypeList);

            return(Json(finalResult));
        }