using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections; 

namespace infoExpediters.Admin
{
    public class Admin
    {
        // Insert / Update page content (Home page/ about us page/ blog page)
        public int InsertBBcodeData(string description, string pagename, string HTMLText)
        {
            int status;
            String strCon = System.Configuration.ConfigurationManager.AppSettings["DB_CONNECTION"];
            using (SqlConnection conn = new SqlConnection(strCon))
            {
                SqlCommand cmd = new SqlCommand("Insert_Update_Content", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@PageName", pagename);
                cmd.Parameters.AddWithValue("@HTMLCode", HTMLText);
                cmd.Parameters.AddWithValue("@description", description);
                cmd.Parameters.AddWithValue("@Status", 0);
                cmd.Parameters["@Status"].Direction = ParameterDirection.Output;
                conn.Open();
                cmd.ExecuteNonQuery();
                conn.Close();
                status = int.Parse(cmd.Parameters["@Status"].Value.ToString());
            }
            return status;
        }
    }
}