BlogEngine.Core.Providers.DbBlogProvider.InsertPage C# (CSharp) Method

        public override void InsertPage(Page page)
        {
            using (var conn = this.CreateConnection())
            {
                if (conn.HasConnection)
                {
                    var sqlQuery = string.Format("INSERT INTO {0}Pages (BlogID, PageID, Title, Description, PageContent, DateCreated, DateModified, Keywords, IsPublished, IsFrontPage, Parent, ShowInList, Slug, IsDeleted) VALUES ({1}blogid, {1}id, {1}title, {1}desc, {1}content, {1}created, {1}modified, {1}keywords, {1}ispublished, {1}isfrontpage, {1}parent, {1}showinlist, {1}slug, {1}isdeleted)", this.tablePrefix, this.parmPrefix);

                    using (var cmd = conn.CreateTextCommand(sqlQuery))
                    {

                        var parms = cmd.Parameters;
                        parms.Add(conn.CreateParameter(FormatParamName("blogid"), Blog.CurrentInstance.Id.ToString()));
                        parms.Add(conn.CreateParameter(FormatParamName("id"), page.Id.ToString()));
                        parms.Add(conn.CreateParameter(FormatParamName("title"), page.Title));
                        parms.Add(conn.CreateParameter(FormatParamName("desc"), page.Description));
                        parms.Add(conn.CreateParameter(FormatParamName("content"), page.Content));
                        parms.Add(conn.CreateParameter(FormatParamName("created"), page.DateCreated.AddHours(-BlogSettings.Instance.Timezone)));
                        parms.Add(conn.CreateParameter(FormatParamName("modified"),
                                                                    (page.DateModified == new DateTime() ? DateTime.Now : page.DateModified.AddHours(-BlogSettings.Instance.Timezone))));
                        parms.Add(conn.CreateParameter(FormatParamName("keywords"), page.Keywords));
                        parms.Add(conn.CreateParameter(FormatParamName("ispublished"), page.IsPublished));
                        parms.Add(conn.CreateParameter(FormatParamName("isfrontpage"), page.IsFrontPage));
                        parms.Add(conn.CreateParameter(FormatParamName("parent"), page.Parent.ToString()));
                        parms.Add(conn.CreateParameter(FormatParamName("showinlist"), page.ShowInList));
                        parms.Add(conn.CreateParameter(FormatParamName("slug"), page.Slug));
                        parms.Add(conn.CreateParameter(FormatParamName("isdeleted"), page.IsDeleted));

                        cmd.ExecuteNonQuery();
                    }
                }
            }
        }