Ejemplo n.º 1
0
        /// <summary>
        /// Saves the page to the DB
        /// </summary>
        /// <param name="p"></param>
        public static void SavePage(CMS.Page p)
        {
            if (p.PageID == 0)
            {
                //this is an insert
                p.PageGuid = System.Guid.NewGuid();

                //configure the URL from the title
                p.PageUrl = TransformTitleToUrl(p.Title);
            }

            //gotta make sure the URL's not already in there
            //the SiteMapProvider doesn't like it
            CMS.Page pCheck       = new Page("PageURL", p.PageUrl);
            int      existingUrls = new SubSonic.Query(Page.Schema).WHERE(Page.Columns.PageUrl, p.PageUrl).GetRecordCount();

            if (existingUrls > 0)
            {
                existingUrls++;
                p.PageUrl = p.PageUrl.Replace(".aspx", "_" + existingUrls.ToString() + ".aspx");
            }

            //save it
            p.Save(System.Web.HttpContext.Current.User.Identity.Name);
        }
 protected void btnDelete_Click(object sender, EventArgs e)
 {
     SubSonic.Query q = new SubSonic.Query("CSK_Coupons");
     q.QueryType = SubSonic.QueryType.Delete;
     q.AddWhere("couponCode", txtCouponCode.Text);
     q.Execute();
     Response.Redirect(Request.Url.PathAndQuery, true);
 }
Ejemplo n.º 3
0
        /// <summary>
        /// Saves the page to the DB
        /// </summary>
        /// <param name="p"></param>
        public static void SavePage(CMS.Page p)
        {
            if (p.PageID==0) {
                //this is an insert
                p.PageGuid = System.Guid.NewGuid();

                //configure the URL from the title
                p.PageUrl = TransformTitleToUrl(p.Title);

                //gotta make sure the URL's not already in there
                //the SiteMapProvider doesn't like it
                CMS.Page pCheck = new Page("PageURL", p.PageUrl);
                int existingUrls = new SubSonic.Query(Page.Schema).WHERE(Page.Columns.PageUrl, p.PageUrl).GetRecordCount();
                if (existingUrls>0) {
                    existingUrls++;
                    p.PageUrl = p.PageUrl.Replace(".aspx", "_" + existingUrls.ToString() + ".aspx");
                }
            }

            //save it
            p.Save(System.Web.HttpContext.Current.User.Identity.Name);
        }