示例#1
0
        public List <CLayer.StaticPage> GetAllWidget()
        {
            DataTable dt = Connection.GetTable("staticpage_GetAllForWidget");
            List <CLayer.StaticPage> result = new List <CLayer.StaticPage>();

            CLayer.StaticPage t;

            foreach (DataRow dr in dt.Rows)
            {
                t          = new CLayer.StaticPage();
                t.PageId   = Connection.ToLong(dr["PageId"]);
                t.City     = Connection.ToString(dr["City"]);
                t.Location = Connection.ToString(dr["Location"]);
                //      t.PageTitle = Connection.ToString(dr["PageTitle"]);
                t.Image       = Connection.ToString(dr["Image"]);
                t.RootFolder  = Connection.ToString(dr["RootFolder"]);
                t.Description = Connection.ToString(dr["Description"]);
                t.Description = CLayer.HtmlRemoval.StripTagsRegex(t.Description);
                if (t.Description.Length > 100)
                {
                    t.Description = t.Description.Substring(0, 100) + "..";
                }
                //         tm = Connection.ToDate(dr["LastUpdate"]);
                //        if (tm == DateTime.Now)
                //              t.LastUpdate = "";
                //        else
                //           t.LastUpdate = tm.ToShortDateString();
                result.Add(t);
            }
            return(result);
        }
 public ActionResult Delete(long?PageId)
 {
     try
     {
         string                 fileName = "";
         CLayer.StaticPage      dt       = BLayer.StaticPage.GetPage(PageId.Value);
         Models.StaticPageModel data     = new Models.StaticPageModel();
         data.Image      = dt.Image;
         data.RootFolder = dt.RootFolder;
         data.FileName   = dt.FileName;
         fileName        = System.IO.Path.GetFileName(dt.Image);
         if (System.IO.Directory.Exists(Server.MapPath("~/Files/SEO/")))
         {
             var path1 = System.IO.Path.Combine(Server.MapPath("~/Files/SEO/"), fileName);
             if (System.IO.File.Exists(path1))
             {
                 System.IO.File.Delete(path1);
             }
         }
         var path3 = System.IO.Path.Combine(Server.MapPath("~/" + dt.RootFolder), dt.FileName);
         if (System.IO.File.Exists(path3))
         {
             System.IO.File.Delete(path3);
         }
         BLayer.StaticPage.Delete(PageId.Value);
     }
     catch (Exception ex)
     {
         Common.LogHandler.HandleError(ex);
     }
     return(RedirectToAction("Index"));
 }
示例#3
0
        public List <CLayer.StaticPage> GetAll()
        {
            string    sql = "Select * From staticpage";
            DataTable dt  = Connection.GetSQLTable(sql);
            List <CLayer.StaticPage> result = new List <CLayer.StaticPage>();

            CLayer.StaticPage t;
            DateTime          tm;

            foreach (DataRow dr in dt.Rows)
            {
                t           = new CLayer.StaticPage();
                t.PageId    = Connection.ToLong(dr["PageId"]);
                t.City      = Connection.ToString(dr["City"]);
                t.Location  = Connection.ToString(dr["Location"]);
                t.PageTitle = Connection.ToString(dr["PageTitle"]);
                tm          = Connection.ToDate(dr["LastUpdate"]);
                if (tm == DateTime.Now)
                {
                    t.LastUpdate = "";
                }
                else
                {
                    t.LastUpdate = tm.ToShortDateString();
                }
                //t.City = Connection.ToString(dr["City"]);
                //t.City = Connection.ToString(dr["City"]);
                //t.City = Connection.ToString(dr["City"]);
                //t.City = Connection.ToString(dr["City"]);
                result.Add(t);
            }
            return(result);
        }
示例#4
0
        public long SaveProperty(CLayer.StaticPage data)
        {
            List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();

            param.Add(Connection.GetParameter("pPageId", DataPlug.DataType._BigInt, data.PageId));
            param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._Varchar, data.PropertyId));
            object obj = Connection.ExecuteQueryScalar("staticpageProperty_Save", param);

            return(Connection.ToLong(obj));
        }
 public ActionResult ClearFile(string ClrPIds)
 {
     string[] s = ClrPIds.Split(',');
     foreach (string PageId in s)
     {
         long id = Convert.ToInt32(PageId);
         CLayer.StaticPage dt = BLayer.StaticPage.GetPage(id);
         var path4            = System.IO.Path.Combine(Server.MapPath("~/" + dt.RootFolder), dt.FileName);
         if (System.IO.File.Exists(path4))
         {
             System.IO.File.Delete(path4);
         }
     }
     return(RedirectToAction("Index"));
 }
示例#6
0
 public async Task <ActionResult> Remove(long PropertyId, long PageId, string Destination, Models.StaticHtmlPageModel model)
 {
     try
     {
         CLayer.StaticPage dt = BLayer.StaticPage.GetPage(PageId);
         BLayer.StaticPage.RemoveStaticProperty(PropertyId);
         model.PageTitle   = dt.PageTitle;
         model.Destination = Destination;
         model.City        = Destination;
         return(await Search(model));
     }
     catch (Exception ex)
     {
         Common.LogHandler.HandleError(ex);
         return(Redirect("~/ErrorPage"));
     }
 }
示例#7
0
        public ActionResult Index(long PageId)
        {
            Models.StaticHtmlPageModel data = new Models.StaticHtmlPageModel();
            data.PageId = PageId;
            CLayer.StaticPage          obj     = BLayer.StaticPage.GetPage(PageId);
            List <CLayer.SearchResult> dtlist1 = BLayer.Property.GetStaticPagePrpty(PageId);

            data.PropertyList = dtlist1;
            string url = Request.Url.AbsoluteUri;

            data.PageTitle    = obj.PageTitle;
            data.Description  = obj.Description;
            data.Image        = obj.Image;
            data.ShowInWidget = obj.ShowInWidget;
            data.Location     = obj.Location;
            data.City         = obj.City;
            return(View(data));
        }
示例#8
0
        public async Task <ActionResult> AddProperty(IEnumerable <int> Propertyselected, Models.StaticHtmlPageModel model)
        {
            long PageId = model.PageId;

            if (Propertyselected != null)
            {
                foreach (var PropertyId in Propertyselected)
                {
                    CLayer.StaticPage dt = new CLayer.StaticPage();
                    dt.PropertyId = PropertyId;
                    dt.PageId     = PageId;
                    BLayer.StaticPage.SaveProperty(dt);
                }
            }

            return(await Search(model));

            //return RedirectToAction("Index", new { PageId = model.PageId });
        }
        public ActionResult EditPage(long Id)
        {
            Models.StaticPageModel data = new Models.StaticPageModel();
            data.PageId = Id;
            CLayer.StaticPage dt = BLayer.StaticPage.GetPage(Id);
            if (dt == null)
            {
                return(RedirectToAction("NewPage"));
            }

            data.PageTitle    = dt.PageTitle;
            data.Description  = dt.Description;
            data.FileName     = dt.FileName;
            data.ShowInWidget = dt.ShowInWidget;
            data.Location     = dt.Location;
            data.City         = dt.City;
            data.Image        = dt.Image;
            data.RootFolder   = dt.RootFolder;
            return(View("_Edit", data));
        }
示例#10
0
        public long Save(CLayer.StaticPage data)
        {
            List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();

            param.Add(Connection.GetParameter("pPageId", DataPlug.DataType._BigInt, data.PageId));
            param.Add(Connection.GetParameter("pCity", DataPlug.DataType._Varchar, data.City));

            param.Add(Connection.GetParameter("pLocation", DataPlug.DataType._Varchar, data.Location));
            param.Add(Connection.GetParameter("pImage", DataPlug.DataType._Varchar, data.Image));
            param.Add(Connection.GetParameter("pFilename", DataPlug.DataType._Varchar, data.FileName));
            param.Add(Connection.GetParameter("pDescription", DataPlug.DataType._Varchar, data.Description));
            param.Add(Connection.GetParameter("pShowInWidget", DataPlug.DataType._Bool, data.ShowInWidget));
            param.Add(Connection.GetParameter("pRootFolder", DataPlug.DataType._Varchar, data.RootFolder));
            param.Add(Connection.GetParameter("pPageTitle", DataPlug.DataType._Varchar, data.PageTitle));
            object obj = Connection.ExecuteQueryScalar("staticpage_Save", param);

            return(Connection.ToLong(obj));
            // B2
            //staticpage_Save
            // pDescription VARCHAR(3000),pShownInWidget BOOL,pRootFolder VARCHAR(255),pPageTitle VARCHAR(500)
        }
示例#11
0
        //
        // GET: /Admin/PropertyAdd/

        public async Task <ActionResult> Index(long PageId)
        {
            Models.StaticHtmlPageModel data = new Models.StaticHtmlPageModel();
            data.PageId = PageId;
            CLayer.StaticPage dt = BLayer.StaticPage.GetPage(PageId);
            data.PageTitle   = dt.PageTitle;
            data.Location    = dt.Location;
            data.City        = dt.City;
            data.PageTitle   = dt.PageTitle;
            data.Destination = dt.City;
            List <CLayer.SearchResult> dtlist1 = BLayer.Property.GetAllPrptyStatic();
            SearchResults result = await SearchFilter(data);

            data.PropertyList = result.Results;
            List <CLayer.SearchResult> dtlist2 = BLayer.Property.GetStaticPagePrpty(PageId);

            data.MaxCount    = result.TotalRows;
            data.PropertyAdd = dtlist2;
            data.MaxCount    = result.TotalRows;
            data.CurrentPage = 1;
            return(View(data));
        }
示例#12
0
        public CLayer.StaticPage GetPage(long pageId)
        {
            string    sql = "Select * From staticpage Where PageId=" + pageId.ToString();
            DataTable dt  = Connection.GetSQLTable(sql);

            CLayer.StaticPage result = null;
            if (dt.Rows.Count > 0)
            {
                DataRow dr = dt.Rows[0];
                result             = new CLayer.StaticPage();
                result.PageId      = Connection.ToLong(dr["PageId"]);
                result.City        = Connection.ToString(dr["City"]);
                result.Location    = Connection.ToString(dr["Location"]);
                result.PageTitle   = Connection.ToString(dr["PageTitle"]);
                result.Description = Connection.ToString(dr["Description"]);

                result.FileName = Connection.ToString(dr["FileName"]);
                result.Image    = Connection.ToString(dr["Image"]);

                result.ShowInWidget = Connection.ToBoolean(dr["ShowInWidget"]);
                result.RootFolder   = Connection.ToString(dr["RootFolder"]);
            }
            return(result);
        }
        public ActionResult Save(Models.StaticPageModel data)
        {
            try
            {
                CLayer.StaticPage sp       = new CLayer.StaticPage();
                string            fileName = "";


                if (data.ImageFile != null && data.ImageFile.ContentLength > 0)
                {
                    int      Sizevalue             = Convert.ToInt32(ConfigurationManager.AppSettings.Get("FileUploadSizeInMB"));
                    int      MaxContentLength      = 1024 * 1024 * Sizevalue; //3 MB
                    string[] AllowedFileExtensions = new string[] { ".jpg", ".gif", ".png", ".jpeg" };
                    if (!AllowedFileExtensions.Contains(data.ImageFile.FileName.Substring(data.ImageFile.FileName.LastIndexOf('.'))))
                    {
                        ModelState.AddModelError(string.Empty, "Please use files of type: " + string.Join(", ", AllowedFileExtensions));
                        return(View("_Edit", data));
                    }
                    else if (data.ImageFile.ContentLength > MaxContentLength)
                    {
                        ModelState.AddModelError(string.Empty, "Your file is too large, maximum allowed size is: " + MaxContentLength + " MB");
                        return(View("_Edit", data));
                    }
                    else
                    {
                        fileName = System.IO.Path.GetFileName(data.ImageFile.FileName); //uploaded file from UI

                        if (!System.IO.Directory.Exists(Server.MapPath("~/Files/Temp/")))
                        {
                            System.IO.Directory.CreateDirectory(Server.MapPath("~/Files/Temp/"));
                        }
                        //System.IO.Directory.CreateDirectory(Server.MapPath("~/Files/Temp/"+ data.RootFolder +"/"));


                        var path = System.IO.Path.Combine(Server.MapPath("~/Files/Temp/"), fileName);
                        data.ImageFile.SaveAs(path);


                        int   maxHeight = Convert.ToInt32(ConfigurationManager.AppSettings.Get("MaxImgHeight"));
                        Image tempimage = Image.FromFile(path);

                        Image resized = Common.Utils.ScaleImage(tempimage, maxHeight);

                        if (!System.IO.Directory.Exists(Server.MapPath("~/Files/SEO/")))
                        {
                            System.IO.Directory.CreateDirectory(Server.MapPath("~/Files/SEO/"));
                        }
                        var path2 = System.IO.Path.Combine(Server.MapPath("~/Files/SEO/"), fileName);

                        //ImageCodecInfo
                        //System.Drawing.Imaging.ImageCodecInfo jgpEncoder = GetEncoder(System.Drawing.Imaging.ImageFormat.Jpeg);
                        //System.Drawing.Imaging.Encoder myEncoder = System.Drawing.Imaging.Encoder.Quality;
                        //System.Drawing.Imaging.EncoderParameters myEncoderParameters = new System.Drawing.Imaging.EncoderParameters();
                        //System.Drawing.Imaging.EncoderParameter myEncoderParameter = new System.Drawing.Imaging.EncoderParameter(myEncoder,50L);
                        //myEncoderParameters.Param[0] = myEncoderParameter;

                        resized.Save(path2, System.Drawing.Imaging.ImageFormat.Jpeg);
                        try
                        {
                            resized.Dispose();
                            tempimage.Dispose();
                            if (System.IO.File.Exists(path))
                            {
                                System.IO.File.Delete(path);
                            }
                        }
                        catch { }
                    } //else part
                }     //image file check
                if (data.PageId > 0)
                {
                    if (fileName == "")
                    {
                        CLayer.StaticPage ss = BLayer.StaticPage.GetPage(data.PageId);
                        fileName = ss.Image;
                    }
                }//update call

                sp.Image        = fileName;
                sp.PageId       = data.PageId;
                sp.PageTitle    = data.PageTitle;
                sp.RootFolder   = FixPath(data.RootFolder);
                sp.ShowInWidget = data.ShowInWidget;
                sp.Location     = data.Location;
                sp.Description  = data.Description;
                sp.City         = data.City;
                sp.FileName     = FixFile(data.FileName);
                BLayer.StaticPage.Save(sp);
            }
            catch (Exception ex)
            {
                Common.LogHandler.HandleError(ex);
            }
            return(RedirectToAction("Index"));
        }
示例#14
0
 public static long SaveProperty(CLayer.StaticPage data)
 {
     DataLayer.StaticPage st = new DataLayer.StaticPage();
     return(st.SaveProperty(data));
 }