public List <Budget_ContentOnPage> SelectByOID(Guid guidContentOID)
        {
            List <Budget_ContentOnPage> ContentOnPageList = null;

            try
            {
                string         sSQL     = "SELECT * FROM ContentOnPage WHERE ContentOID=@ContentOID";
                SqlParameter[] sqlParam = new SqlParameter[1];
                sqlParam[0]       = new SqlParameter("@ContentOID", SqlDbType.UniqueIdentifier);
                sqlParam[0].Value = guidContentOID;
                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    ContentOnPageList = new List <Budget_ContentOnPage>();
                    Budget_ContentOnPage content = null;
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        content                = new Budget_ContentOnPage();
                        content.ContentOID     = new Guid(ds.Tables[0].Rows[i]["ContentOID"].ToString());
                        content.Culture        = ds.Tables[0].Rows[i]["Culture"].ToString();
                        content.CategoriesCode = ds.Tables[0].Rows[i]["ContentOnPage"].ToString();
                        content.ContentValue   = ds.Tables[0].Rows[i]["ContentValue"].ToString();
                        ContentOnPageList.Add(content);
                    }
                }
            }
            catch (Exception ex) { }
            return(ContentOnPageList);
        }
        public Budget_ContentOnPage getContentOnPage(string sOnPage, string sCulture)
        {
            Budget_ContentOnPage content = null;

            try
            {
                string         sSQL     = "SELECT * FROM ContentOnPage WHERE ContentOnPage=@ContentOnPage AND Culture=@Culture";
                SqlParameter[] sqlParam = new SqlParameter[2];
                sqlParam[0]       = new SqlParameter("@ContentOnPage", SqlDbType.NVarChar);
                sqlParam[0].Value = sOnPage;
                sqlParam[1]       = new SqlParameter("@Culture", SqlDbType.NVarChar);
                sqlParam[1].Value = sCulture;
                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    content                = new Budget_ContentOnPage();
                    content.ContentOID     = new Guid(ds.Tables[0].Rows[0]["ContentOID"].ToString());
                    content.Culture        = ds.Tables[0].Rows[0]["Culture"].ToString();
                    content.CategoriesCode = ds.Tables[0].Rows[0]["ContentOnPage"].ToString();
                    content.ContentValue   = ds.Tables[0].Rows[0]["ContentValue"].ToString();
                }
            }
            catch (Exception ex) { }
            return(content);
        }
        public List <Budget_ContentOnPage> SelectAll()
        {
            List <Budget_ContentOnPage> ContentOnPageList = null;

            try
            {
                string sSQL = "SELECT * FROM ContentOnPage";

                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    ContentOnPageList = new List <Budget_ContentOnPage>();
                    Budget_ContentOnPage content = null;
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        content                = new Budget_ContentOnPage();
                        content.ContentOID     = new Guid(ds.Tables[0].Rows[i]["ContentOID"].ToString());
                        content.Culture        = ds.Tables[0].Rows[i]["Culture"].ToString();
                        content.CategoriesCode = ds.Tables[0].Rows[i]["ContentOnPage"].ToString();
                        content.ContentValue   = ds.Tables[0].Rows[i]["ContentValue"].ToString();
                        ContentOnPageList.Add(content);
                    }
                }
            }
            catch (Exception ex) { }
            return(ContentOnPageList);
        }